Recursive CTE required "WITH RECURSIVE" in MySQL

[killswtch]

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.