davidlghellin opened a new issue, #18867: URL: https://github.com/apache/datafusion/issues/18867
### Describe the bug The value median is not correct ### To Reproduce in datafusion-cli 51 ```sql SELECT median(n) FROM (SELECT 0 AS n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9); ``` <img width="1174" height="176" alt="Image" src="https://github.com/user-attachments/assets/cdb09a9a-461e-489b-8082-eeb6edf77a3d"; /> ### Expected behavior same value of percentile 50 in datafusion-cli 51 ```sql SELECT percentile_cont(n,0.5) FROM (SELECT 0 AS n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9); ``` <img width="1169" height="182" alt="Image" src="https://github.com/user-attachments/assets/21af29e1-724d-47c9-bcbc-c92f274db1c9"; /> ### Additional context testing ibis tests in Sail and add agg funtion related to https://github.com/lakehq/sail/issues/1072 -- 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]
