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
798 stars 180 forks source link

Can we support "WITH ROLLUP"? #1956

Closed go-wxf closed 3 months ago

go-wxf commented 3 months ago

Currently If SQL contains "WITH ROLLUP", the parser will throw a exception.

Like this SQL: SELECT year, country, product, SUM(profit) AS profit FROM sales GROUP BY year, country, product WITH ROLLUP;

This is a mySQL case, will we support this in future?

BTW, very good repo, thanks for the contribution!