Skip to content

Conversation

Mytherin
Copy link
Collaborator

Implements #8952

This PR implements support for qualified identifiers in the EXCLUDE clause, i.e.:

SELECT * EXCLUDE (tbl.col) FROM tbl;

Fully qualified identifiers are supported (i.e. db.schema.tbl.col). Any non-provided identifiers are considered as "matching all", i.e. i matches all columns named i, tbl.i matches all columns named i within tables named tbl, etc.

In order to preserve backwards compatibility, unqualified identifiers are serialized using the old case_insensitive_set. Only qualified identifiers are serialized using the qualified_column_set.

@Tishj
Copy link
Contributor

Tishj commented Sep 19, 2024

An open PR has made an attempt at implementing this #11150

@duckdb-draftbot duckdb-draftbot marked this pull request as draft September 19, 2024 21:02
@Mytherin Mytherin marked this pull request as ready for review September 19, 2024 21:03
@duckdb-draftbot duckdb-draftbot marked this pull request as draft September 20, 2024 07:41
@Mytherin Mytherin marked this pull request as ready for review September 20, 2024 07:41
@duckdb-draftbot duckdb-draftbot marked this pull request as draft September 20, 2024 10:40
@Mytherin Mytherin marked this pull request as ready for review September 20, 2024 10:40
@Mytherin Mytherin merged commit 5a213fb into duckdb:feature Sep 20, 2024
40 checks passed
@Mytherin Mytherin deleted the qualifiedexclude branch December 8, 2024 06:53
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants