Phoenix500526 commented on issue #9924: URL: https://github.com/apache/datafusion/issues/9924#issuecomment-6679646481
I checked the original examples: `COUNT(*) IGNORE NULLS` now correctly errors after #18441. ```SQL > select count(*) IGNORE NULLS from (values (1), (null), (2)); Error during planning: [IGNORE | RESPECT] NULLS are not permitted for count ``` And after #25711, order-insensitive aggregates simply ignore ORDER BY. I also found an `APPROX_MEDIAN` ordering bug during my verification, and opened #27157 to track it separately. I also submitted PR #27159 to fix it. We can close this issue now or after #27159 is merged. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
