我已更新到MariaDB 10.2.20以使用CTE.仍会获得“无法识别的语句类型". (靠近)在phpMyAdmin中 [英] I updated to MariaDB 10.2.20 to use CTE. Still getting "Unrecognized Statement type. (near WITH) in phpMyAdmin

问题描述

我想使用CTE，所以我更新到了MariaDB 10.2.20. phpMyAdmin在使用"WITH"时出现错误.

I am wanting to use CTE so I updated to MariaDB 10.2.20. phpMyAdmin is giving an error on the use of "WITH".

我无法找到此版本不支持"WITH"的原因.

I am not able to find why "WITH" is not supported in this version.

从10.2.1开始的MariaDB¶ 通用表表达式WITH是在MariaDB 10.2.1中引入的.

MariaDB starting with 10.2.1¶ Common Table Expression WITH was introduced in MariaDB 10.2.1.

从10.2.2开始的MariaDB 自MariaDB 10.2.2起已支持递归WITH.

MariaDB starting with 10.2.2 Recursive WITH has been supported since MariaDB 10.2.2.

https://mariadb.com/kb/en/library/with/

推荐答案

它似乎是phpMyAdmin中的错误，请参阅此自2017年8月以来的错误: https://github.com/phpmyadmin/phpmyadmin/issues/13616

It looks like a bug in phpMyAdmin, see this open bug since August 2017: https://github.com/phpmyadmin/phpmyadmin/issues/13616

这篇关于我已更新到MariaDB 10.2.20以使用CTE.仍会获得“无法识别的语句类型". (靠近)在phpMyAdmin中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！