Re: [I] sql result discrepency with sqlite and postgres [datafusion]

Omega359 closed issue #13779: sql result discrepency with sqlite and postgres URL: https://github.com/apache/datafusion/issues/13779 -- 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 comme

Re: [I] sql result discrepency with sqlite and postgres [datafusion]

Omega359 commented on issue #13779: URL: https://github.com/apache/datafusion/issues/13779#issuecomment-2562900593 This looks to have been fixed with #13885 ```sql DataFusion CLI v44.0.0 > SELECT ALL + + MIN ( - CAST ( + 6 AS INTEGER ) ) * CASE WHEN NULL BETWEEN - 88 AND ( - - 9

Re: [I] sql result discrepency with sqlite and postgres [datafusion]

Omega359 commented on issue #13779: URL: https://github.com/apache/datafusion/issues/13779#issuecomment-2543170448 I believe another sql that has the same cause is: ``` External error: query result mismatch: [SQL] SELECT ALL + CASE WHEN AVG ( ALL + 88 ) >= 74 + + - 95 - CASE 23 W

[I] sql result discrepency with sqlite and postgres [datafusion]

Omega359 opened a new issue, #13779: URL: https://github.com/apache/datafusion/issues/13779 ### Describe the bug sqlite random/expr/slt_good_10.slt: ```sql SELECT ALL + + MIN ( - CAST ( + 6 AS INTEGER ) ) * CASE WHEN NULL BETWEEN - 88 AND ( - - 91 ) * - AVG ( 95 ) THEN COUNT ( -