A valid SQL query returned 'Schema error: ...' (SQLancer) #11635
Description
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 #11030