search

taozhi8833998 / node-sql-parser

Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList and convert it back to SQL
https://taozhi8833998.github.io/node-sql-parser/
Apache License 2.0
755 stars 172 forks source link

Parsing CAST function in MySQL #1929

Closed 1ilit closed 1 month ago

1ilit commented 1 month ago

Describe the bug Throws SyntaxError when parsing CAST()

Database Engine MySQL

To Reproduce -the SQL that be parsed

CREATE TABLE some_table (
    col JSON,
    KEY `idx_col` ((CAST(`col` AS CHAR(12) ARRAY)))
);

-the node-sql-parser version v5.1.0 -the node version v18.20.3

Expected behavior Produce ast

Additional context Minimal reproducible example: https://stackblitz.com/edit/stackblitz-starters-9dpxty?file=index.js