Abdullahsab3 commented on issue #10069: URL: https://github.com/apache/datafusion/issues/10069#issuecomment-2374742174
That might work, but I wonder how it will be inferred and whether it will cause any conflicts. Some examples that can be ambiguous on top of my head: ```sql select generate_series(1, 100), * from generate_series(10, 100) ``` This can be either (postgresql behavior): | generate\_series | generate\_series | | :--- | :--- | | 1 | 10 | | 2 | 10 | | 3 | 10 | | 1 | 11 | | 2 | 11 | | 3 | 11 | | 1 | 12 | | 2 | 12 | | 3 | 12 | | 1 | 13 | | 2 | 13 | | 3 | 13 | or ```sql +------------------------------------+----------------------------------------------+ | generate_series(Int64(1),Int64(3)) | UNNEST(generate_series(Int64(10),Int64(13))) | +------------------------------------+----------------------------------------------+ | [1, 2, 3] | 10 | | [1, 2, 3] | 11 | | [1, 2, 3] | 12 | | [1, 2, 3] | 13 | +------------------------------------+----------------------------------------------+ 4 row(s) fetched. Elapsed 0.001 seconds. ```` Also, I wonder how the results of something like this would look like 🤔: ```sql select generate_series(1, 3), array_length(generate_series(10, 11)) ``` -- 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