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
823 stars 184 forks source link

Parser throws a syntax error when TEXT has a size in MySQL #2099

Closed 1ilit closed 2 months ago

1ilit commented 2 months ago

Describe the bug Throws syntax error when a field with type TEXT has a size

Database Engine MySQL

To Reproduce -the SQL that be parsed

CREATE TABLE `ys_map_info` (`detail` TEXT(65535));

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

Expected behavior Output ast