Friede80 commented on issue #15134:
URL: https://github.com/apache/datafusion/issues/15134#issuecomment-2715769216

   sqllogictest demonstrating the issue:
   ```
   statement ok
   CREATE TABLE t1 (x INT, y INT);
   
   statement ok
   INSERT INTO t1 VALUES (3, 3), (3, 3), (1, 1);
   
   statement ok
   CREATE TABLE t3 (y BIGINT, z BIGINT);
   
   statement ok
   INSERT INTO t3 VALUES (20, 20), (40, 40);
   
   statement ok
   CREATE VIEW v1 AS
   SELECT y FROM t1 UNION ALL SELECT y FROM t3;
   
   
   query I
   SELECT * FROM v1;
   ----
   3
   3
   1
   20
   40
   ```
   
   ```
   External error: query failed: DataFusion error: type_coercion
   caused by
   Schema error: No field named t1.y. Did you mean 'y'?.
   [SQL] SELECT * FROM v1;
   ```


-- 
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: github-unsubscr...@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to