The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

WITH RECURSIVE not working

Hi, Im trying to run a query in phpmyadmin with "WITH", after updating mariadb to 10.2.13, but i get an error Static analysis:

1 errors were found during analysis.

Unrecognized statement type. (near "WITH" at position 0)

SQL query: Documentation

WITH CTE as ( select * from ost_help_topic c where c.topic_pid = 1 union all select * from CTE p, ost_help_topic c where c.topic_pid = p.topic_id and c.topic_pid <> c.topic_id ) select * from CTE

MySQL said: Documentation

  1. 1146 - Table 'tktd.CTE' doesn't exist

I run also some other queries and i get the "Unrecognized statement type. (near "WITH" at position 0)" all the time. In official site of mariadb, it says that after 10.2, WITH can be used in queries.

Regards George

Answer Answered by Ian Gilfillan in this comment.

Looks like a problem with phpMyAdmin, see this bug.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.