search

sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.11k stars 500 forks source link

Recursive CTE required "WITH RECURSIVE" in MySQL #727

Open killswtch opened 1 month ago

killswtch commented 1 month ago

The WITH clause for CTEs needs to be able to support recursive CTEs under MySQL by using the WITH RECURSIVE syntax. Without the RECURSIVE keyword, self-referencing CTEs will fail with a "Table 'xxx' doesn't exist" error. There is a similar ticket for this for Postgres.