google / google/googlesql

EXCEPT DISTINCT parsed to EXCEPT ALL

Open
#83 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
C++
Stars
2.6k
Forks
260
PR merge metrics
No merged PRs in 30d

Description

The latest ZetaSQL (2021.09.1) doesn't handle EXCEPT DISTINCT properly.

Assume we have some Query 'Q1' (as String) that contains EXCEPT DISTINCT.
We parse Q1 via ZetaSQL and format it again to get a String again. This String is a new Query 'Q2'

Expected resulted: Both Q1 and Q2 have EXCEPT DISTINCT.
Current result: Q1 has EXCEPT DISTINCT, Q2 has EXCEPT ALL.

See https://github.com/google/zetasql/pull/82 for fix.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.