2010YOUY01 opened a new issue, #11635: URL: https://github.com/apache/datafusion/issues/11635
### Describe the bug The following SQL query should be valid, not it's returning an error Run in datafusion-cli: ``` /*DML*/CREATE TABLE t0(v0 BIGINT, v1 DOUBLE); /*DML*/CREATE TABLE t1(v0 BIGINT, v1 STRING); /*DML*/CREATE TABLE t5(v0 BIGINT, v1 STRING, v2 BIGINT, v3 STRING, v4 BOOLEAN); ``` ``` > SELECT * FROM t1 NATURAL JOIN t5 INNER JOIN t0 ON (t0.v1 + t5.v0) > 0 WHERE t0.v1 = t1.v0; Schema error: No field named t5.v0. Valid fields are t1.v0, t1.v1, t5.v2, t5.v3, t5.v4, "CAST(t1.v0 AS Float64)", t0.v0, t0.v1. ``` ### To Reproduce _No response_ ### Expected behavior _No response_ ### Additional context Found by SQLancer https://github.com/apache/datafusion/issues/11030 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
