You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
> SELECT COUNT(*)
FROM t1
NATURAL JOIN t60
INNER JOIN t0
ON t60.v1 = t0.v0
AND t0.v1 > t60.v1;
Internal error: Invalid join key. Expected column, found Cast(Cast { expr: Column(Column { relation: Some(Bare { table: "t60" }), name: "v0" }), data_type: Float64 }).
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
> explain verbose SELECT COUNT(*)
FROM t1
NATURAL JOIN t60
INNER JOIN t0
ON t60.v1 = t0.v0
AND t0.v1 > t60.v1;
...
initial_physical_plan | Internal error: Invalid join key. Expected column, found Cast(Cast { expr: Column(Column { relation: Some(Bare { table: "t60" }), name: "v0" }), data_type: Float64 }). |
| | This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker |
+------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Describe the bug
This query should be valid and can be executed on DuckDB, but produced an Internal Error when building initial physical plan.
Full reproducer:
Error messages
To Reproduce
No response
Expected behavior
No response
Additional context
Found by SQLancer #11030
The text was updated successfully, but these errors were encountered: