-
-
Notifications
You must be signed in to change notification settings - Fork 1.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[BUG] JSQLParser 4.7 : MySQL 8 : Cannot parse functional indices in table creation DDL #1927
Labels
Comments
ls-denis-iakovlev
changed the title
[BUG] JSQLParser 4.7 : MySQL 8 : Cannot parse functions in index creation DDL
[BUG] JSQLParser 4.7 : MySQL 8 : Cannot parse functional indecies in table creation DDL
Dec 20, 2023
ls-denis-iakovlev
changed the title
[BUG] JSQLParser 4.7 : MySQL 8 : Cannot parse functional indecies in table creation DDL
[BUG] JSQLParser 4.7 : MySQL 8 : Cannot parse functional indices in table creation DDL
Dec 20, 2023
Greetings, your example works fine without the extra-brackets: CREATE TABLE test_table (
id BIGINT NOT NULL
, name VARCHAR (255)
, PRIMARY KEY ( `id` )
, KEY my_index (LOWER (NAME))
) ENGINE = INNODB
;
|
Good day @manticore-projects, thanks for quick response! CREATE TABLE test_table (
id BIGINT NOT NULL
, name VARCHAR (255)
, description VARCHAR (255)
, PRIMARY KEY ( `id` )
, KEY my_index (description, (LOWER (NAME)))
) ENGINE = INNODB
; Here is a link This query successfully executes on MySQL 8 |
manticore-projects
added
MySQL
MySQL specific issue
DDL
DDL statement related
Sponsor needed
labels
Dec 21, 2023
Not supported yet in the Grammar and its not trivial to amend. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Failing SQL Feature:
Parsing
CREATE TABLE
DDL query failed when there is aKEY
parameter that uses functions likeLOWER
.The parsing fails with this error:
SQL Example:
Software Information:
Tips:
Please write in English and avoid Screenshots (as we can't copy and paste content from it).
MySQL 8 added a feature for functional indices: https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-functional-key-parts
The text was updated successfully, but these errors were encountered: