tv42 commented on issue #8379:
URL: 
https://github.com/apache/arrow-datafusion/issues/8379#issuecomment-1847906637

   Related to this, SQLite and Postgres allow duplicate column names in 
results. From SQLite tests:
   
   ```sql
   SELECT + COUNT( * ) AS col1, - 92 - + - 47 AS col1
   ```
   
   Datafusion errors out with
   
   ```
   query failed: Error during planning: Projections require unique expression 
names but the expression "COUNT(*) AS col1" at position 0 and "Int64(-92) - 
Int64(-47) AS col1" at position 1 have the same name. Consider aliasing ("AS") 
one of them.
   ```
   
   Maybe after/as part of implementing this, Datafusion should relax that 
restriction?


-- 
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]

Reply via email to