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

Bug in Nested Loop Join (Found by SQLancer-NoREC) #11269

Closed
2010YOUY01 opened this issue Jul 4, 2024 · 1 comment · Fixed by #11333
Closed

Bug in Nested Loop Join (Found by SQLancer-NoREC) #11269

2010YOUY01 opened this issue Jul 4, 2024 · 1 comment · Fixed by #11333
Assignees
Labels
bug Something isn't working

Comments

@2010YOUY01
Copy link
Contributor

Describe the bug

Run following statements in datafusion-cli to reproduce:

CREATE TABLE t1 (v0 BIGINT);
CREATE TABLE t2 (v0 DOUBLE); 
CREATE TABLE t3 (v0 DOUBLE); 
INSERT INTO t1 (v0) VALUES (-503661263); 
INSERT INTO t2 (v0) VALUES (-1.6635639473878496E308); 
INSERT INTO t3 (v0) VALUES (0.05112015193508901);

select t3.v0, t2.v0 from t1,t2,t3 where t3.v0 >= t1.v0;

Error Message:

Execution error: Fail to build join indices in NestedLoopJoinExec, error:Arrow error: Invalid argument error: column types must match schema types, expected Int64 but found Float64 at column index 0

To Reproduce

No response

Expected behavior

No response

Additional context

This issue seem to report similar error message, I'm not sure if they are related #9254

Found by SQLancer #11030

@2010YOUY01 2010YOUY01 added the bug Something isn't working label Jul 4, 2024
@jonahgao
Copy link
Member

jonahgao commented Jul 5, 2024

I’d like to take it.

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.

2 participants