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
750 stars 172 forks source link

Enable group by all in snowflake #1972

Closed LaizaAngrest closed 2 weeks ago

LaizaAngrest commented 2 weeks ago

Describe the bug Parse isn't working for a snowflake query with group by all

Database Engine Snowflake

To Reproduce it('should parse a query with group by all', function () { const parser = new SqlParser() const query = SELECT A, B, COUNT(*) FROM T GROUP BY ALL const parsedSql = parser.parse(query, WarehouseType.Snowflake) expect(parsedSql).toBeDefined() })