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 - + CAST ( - -
99 AS REAL ) ) / - + 7, 35 + + 55 AS col1
[Diff] (-expected|+actual)
- -1794
- 90
+ -1793.1428 90
at test_files/sqlite/random/expr/slt_good_42.slt:12794
```
Datafusion:
```sql
> SELECT DISTINCT - ( 43 ) * 42 + - + NULLIF ( + 90, - 49 - + CAST ( - - 99
AS REAL ) ) / - + 7, 35 + + 55 AS col1;
+----------------------------------------------------------------------------------------------+------+
| (- Int64(43)) * Int64(42) + (- nullif(Int64(90),Int64(-49) - (-
Int64(-99)))) / (- Int64(7)) | col1 |
+----------------------------------------------------------------------------------------------+------+
| -1793.1428
| 90 |
+----------------------------------------------------------------------------------------------+------+
```
duckdb and postgres:
```sql
D SELECT DISTINCT - ( 43 ) * 42 + - + NULLIF ( + 90, - 49 - + CAST ( - - 99
AS REAL ) ) / - + 7, 35 + + 55 AS col1;
┌────────────────────────────────────────────────────────────────────────────────┬───────┐
│ ((-43 * 42) + (-(+("nullif"(+(90), (-49 - +(CAST(99 AS FLOAT)))))) /
-(+(7)))) │ col1 │
│ double
│ int32 │
├────────────────────────────────────────────────────────────────────────────────┼───────┤
│
-1793.142857142857 │ 90 │
└────────────────────────────────────────────────────────────────────────────────┴───────┘
``
--
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
