Skip to content

fix(sql): fix DISTINCT combined with a column alias#2982

Merged
bluestreak01 merged 1 commit intomasterfrom
fixes/distinct-column-alias
Feb 13, 2023
Merged

fix(sql): fix DISTINCT combined with a column alias#2982
bluestreak01 merged 1 commit intomasterfrom
fixes/distinct-column-alias

Conversation

@jerrinot
Copy link
Contributor

the optimized single-column happy path was overly optimistic about nested models. it was not assuming aliasing nor virtual tables.

fixes #2980

the optimized single-column happy path was overly optimistic
about nested models. it was not assuming aliasing nor virtual tables.

fixes #2980
@jerrinot jerrinot added Bug Incorrect or unexpected behavior SQL Issues or changes relating to SQL execution labels Feb 10, 2023
@jerrinot jerrinot requested a review from bziobrowski February 10, 2023 15:36
@ideoma
Copy link
Collaborator

ideoma commented Feb 10, 2023

[PR Coverage check]

😍 pass : 4 / 4 (100.00%)

file detail

path covered line new line coverage
🔵 io/questdb/griffin/SqlCodeGenerator.java 4 4 100.00%

@puzpuzpuz puzpuzpuz self-requested a review February 13, 2023 11:31
@bluestreak01 bluestreak01 merged commit f7d3780 into master Feb 13, 2023
@bluestreak01 bluestreak01 deleted the fixes/distinct-column-alias branch February 13, 2023 15:18
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Bug Incorrect or unexpected behavior SQL Issues or changes relating to SQL execution

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Error on adding distinct column alias

4 participants