MySQL - CREATE TABLE foo SELECT * FROM bar statement causes Found unparsable section error

[gdubicki]

Search before asking

• I searched the issues and found no similar issues.

What Happened

I am trying to validate some SQL scripts that create syntax like:

CREATE TABLE foo SELECT * FROM bar;

Expected Behaviour

This syntax should work as MySQL supports it.

Observed Behaviour

$ sqlfluff lint --dialect mysql my_script.sql 
== [my_script.sql] FAIL                                                                                                                                          
L:   1 | P:   1 |  PRS | Line 1, Position 1: Found unparsable section: 'CREATE
                       | TABLE foo SELECT * FROM bar;'
WARNING: Parsing errors found and dialect is set to 'mysql'. Have you configured your dialect correctly?
All Finished 📜 🎉!

How to reproduce

1. Create a my_script.sql file:

CREATE TABLE foo SELECT * FROM bar;

2. Try to lint it with:

sqlfluff lint --dialect mysql my_script.sql 

Dialect

MySQL

Version

$ sqlfluff --version
sqlfluff, version 3.0.5

...installed using pipx, Python 3.11.8.

Configuration

Default

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[gdubicki]

Yes I am willing to submit a PR!

I am generally open to that, but I am not a SQL specialist so that's why I haven't checked it.

[MarkMarine]

I'm seeing the same parsing error when using CREATE FUNCTION ...