test-suite-sql-eval icon indicating copy to clipboard operation
test-suite-sql-eval copied to clipboard

Request to Add Support for `UNION ALL` Keyword

Open vxwong opened this issue 9 months ago • 0 comments

Problem:

Would it be possible to add support for UNION ALL? Since it's quite common in sql queries.

Reproduce:

here's my gold file, btw the script works well if replacing UNION ALL with UNION:

SELECT DISTINCT country FROM singer WHERE age  >  20 UNION ALL SELECT DISTINCT country FROM singer WHERE age  >  20	concert_singer

Here's the exception:

    assert toks[idx] == 'select', "'select' not found"
AssertionError: 'select' not found

vxwong avatar May 28 '24 09:05 vxwong