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
- 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.
Answer Answered by Ian Gilfillan in this comment.
Looks like a problem with phpMyAdmin, see this bug.