Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fail to decorrelate the predicate subquery with the uppercase column name #12442

Closed
goldmedal opened this issue Sep 12, 2024 · 1 comment · Fixed by #12443
Closed

Fail to decorrelate the predicate subquery with the uppercase column name #12442

goldmedal opened this issue Sep 12, 2024 · 1 comment · Fixed by #12443
Assignees
Labels
bug Something isn't working

Comments

@goldmedal
Copy link
Contributor

Describe the bug

Consider the following case:

DataFusion CLI v41.0.0
> create table "T1"("C1" int, "C2" int);
0 row(s) fetched. 
Elapsed 0.014 seconds.

> create table "T2"("C1" int, "C3" int);
0 row(s) fetched. 
Elapsed 0.004 seconds.

> select "C1" from "T1" where not exists (select 1 from "T2" where "T1"."C1" = "T2"."C1");
Schema error: No field named __correlated_sq_1.c1. Valid fields are "T1"."C1".

It seems the filter expression doesn't handle the quoted identifier for the case-sensitive name.

To Reproduce

No response

Expected behavior

The SQL should work.

Additional context

No response

@goldmedal goldmedal added the bug Something isn't working label Sep 12, 2024
@goldmedal
Copy link
Contributor Author

take

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant