Omega359 commented on issue #13781:
URL: https://github.com/apache/datafusion/issues/13781#issuecomment-2585831002
Resolved as fixed with change 'as REAL' to 'AS FLOAT8' in sqlite test files
--
This is an automated message from the Apache Git Service.
To respond to the message, please log
Omega359 closed issue #13781: sql odd case of rounding compared to duckdb and
postgresql
URL: https://github.com/apache/datafusion/issues/13781
--
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 sp
Omega359 commented on issue #13781:
URL: https://github.com/apache/datafusion/issues/13781#issuecomment-2573381963
I suspect much of this is the same cause as #13780 - nullif typing being
incorrect and real mapping to f32 where it is not possible to represent some
integers exactly.
P
Omega359 commented on issue #13781:
URL: https://github.com/apache/datafusion/issues/13781#issuecomment-2543173280
Another version of what I think may be the same thing:
```
External error: query result mismatch:
[SQL] SELECT DISTINCT - ( 43 ) * 42 + - + NULLIF ( + 90, - 49 - + C
Omega359 opened a new issue, #13781:
URL: https://github.com/apache/datafusion/issues/13781
### Describe the bug
```
External error: query result mismatch:
[SQL] SELECT + 99 * NULLIF ( 86, - CASE WHEN NOT COUNT ( * ) BETWEEN 84 AND
54 THEN NULLIF ( - 59, COUNT ( * ) ) + CAST ( N
