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
820 stars 183 forks source link

Support `WITHOUT ROWID` for `CREATE TABLE` in SQLite #2141

Closed 1ilit closed 1 month ago

1ilit commented 1 month ago

Support WITHOUT ROWID after the table definition according to https://www.sqlite.org/lang_createtable.html

Database Engine SQLite

To Reproduce -the SQL that be parsed

CREATE TABLE visits (url TEXT) WITHOUT ROWID;

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

Expected behavior Not throw a syntax error