laisee commented on issue #6543:
URL: https://github.com/apache/datafusion/issues/6543#issuecomment-2716497178
Note extra use case that fails (silently) when joining 2 tables from
different data connectors with common column name. Adding here as the error may
not be detected i.e. no error code is given and 'wrong' data appears in results
e.g. `select
movies.id as "id",
movies.name,
coin.name
from
movies, coin
where
movies.id = coin.id`
This query runs Ok but data selected into result set columns 2 & 3 is from
table 'coin'. Reverse the order of "movies.name" and "coin.name" and you will
see movies 'name' data in both result set columns.
Solution is to add an alias for columns to make a unique result set by
column name.
--
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
