CREATE TABLE ... WITH ... SELECT not supported

[nicktobey]

Example query:

CREATE TABLE test
WITH ab AS (
    SELECT 1 as a, 2 as b
)
SELECT * from ab

Our response:

Error parsing SQL:
syntax error at position 23 near 'WITH'
CREATE TABLE test
WITH ab AS (
     ^

The MySQL documentation says this is explicitly allowed (https://dev.mysql.com/doc/refman/8.0/en/with.html) and it works in MySql.

[nicktobey]

Workaround:

CREATE TABLE test (a int, b int);
INSERT INTO test 
WITH ab AS (
    SELECT 1 as a, 2 as b
)
SELECT * from ab;

So it looks like we're able to parse WITH expressions on DML commands, we just don't also apply that to CREATE.