Update for revert of coalesce / nvl (#15)
diff --git a/data/sqlite/random/expr/slt_good_0.slt b/data/sqlite/random/expr/slt_good_0.slt
index 894108f..4476209 100644
--- a/data/sqlite/random/expr/slt_good_0.slt
+++ b/data/sqlite/random/expr/slt_good_0.slt
@@ -20520,10 +20520,10 @@
----
0
-query I rowsort label-3927
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 0
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + CAST ( - 13 AS INTEGER ) / COALESCE ( - + 14, + - NULLIF ( - COUNT ( * ), 19 * - - NULLIF ( 12, + MIN ( ALL - - ( + - 11 ) ) ) / + - 4 + - 84 + + 36 - - 57 + - + 68 * NULLIF ( + 57, + 45 ) ) * + 24 / CAST ( - 0 AS INTEGER ) / + 90, - 93 ) col0
-----
-0
query I rowsort
SELECT ALL - 41 AS col2
diff --git a/data/sqlite/random/expr/slt_good_10.slt b/data/sqlite/random/expr/slt_good_10.slt
index 9e1920f..f82afe8 100644
--- a/data/sqlite/random/expr/slt_good_10.slt
+++ b/data/sqlite/random/expr/slt_good_10.slt
@@ -37288,11 +37288,11 @@
----
-143550
-query II rowsort label-7077
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -29
+# Datafusion - Expected - -900
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 10 + COALESCE ( + - 39, - + ( COUNT ( * ) ) * + + MAX ( DISTINCT - 64 ) * + ( + 56 ) / + 0 ), - 60 * - - 15 AS col2
-----
--29
--900
query I rowsort
SELECT - COALESCE ( CASE 20 WHEN - 1 THEN + 14 * - + 5 + 29 ELSE NULL END, + 78 ) AS col2
@@ -44097,10 +44097,10 @@
----
NULL
-query I rowsort label-8381
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -45
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - - COALESCE ( - 45, NULLIF ( + 94, + - 92 - - - 61 + 19 * COUNT ( * ) * + - 36 * - 64 / - + 67 * ( + 58 ) / COUNT ( DISTINCT - CAST ( NULL AS INTEGER ) ) ) * + 59, + 63 )
-----
--45
query I rowsort label-8382
SELECT - - 84 * - 45 * - - CASE - 72 WHEN 91 THEN COUNT ( * ) WHEN + 31 THEN NULL ELSE NULL END AS col0
@@ -49579,10 +49579,10 @@
----
-109
-query I rowsort label-9427
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT CASE - 92 WHEN - - 20 * - 46 + - - 8 THEN - 70 WHEN + ( - 2 ) THEN 73 - + - CAST ( 51 AS INTEGER ) + + + 53 WHEN - 59 THEN CAST ( ( 23 ) AS INTEGER ) * 82 WHEN MIN ( 80 ) / COALESCE ( - 4, - COUNT ( * ) / 0 ) + 72 / 9 THEN 36 * 81 + + 0 * 78 END + 43 AS col2
-----
-NULL
query I rowsort label-9428
SELECT CAST ( NULL AS INTEGER ) - + - COALESCE ( 4, MIN ( 32 ) ) + MAX ( - 73 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_100.slt b/data/sqlite/random/expr/slt_good_100.slt
index 5cd9697..5cc53a4 100644
--- a/data/sqlite/random/expr/slt_good_100.slt
+++ b/data/sqlite/random/expr/slt_good_100.slt
@@ -14291,10 +14291,12 @@
----
NULL
-query I rowsort label-2709
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -59
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 59 * - COALESCE ( COUNT ( ALL + 82 ), + - 11 * 98 / 0 + COUNT ( * ) + - - 11 + + - 96 + - ( + MIN ( DISTINCT 82 ) ) * + 86 * + 11 ) + - + 0
-----
--59
query II rowsort
SELECT - - 71 AS col0, - 48 + - 75
diff --git a/data/sqlite/random/expr/slt_good_101.slt b/data/sqlite/random/expr/slt_good_101.slt
index 95d78bc..0bf64aa 100644
--- a/data/sqlite/random/expr/slt_good_101.slt
+++ b/data/sqlite/random/expr/slt_good_101.slt
@@ -33945,10 +33945,10 @@
----
-31
-query I rowsort label-6449
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 48
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL COUNT ( * ) - COALESCE ( - 47, - - 92 + - MAX ( 52 ) / - - CAST ( + - 0 AS INTEGER ) + + 50 )
-----
-48
query II rowsort label-6450
SELECT COUNT ( * ) * + 48, 64 AS col2
diff --git a/data/sqlite/random/expr/slt_good_102.slt b/data/sqlite/random/expr/slt_good_102.slt
index b9cf5db..99d0ec2 100644
--- a/data/sqlite/random/expr/slt_good_102.slt
+++ b/data/sqlite/random/expr/slt_good_102.slt
@@ -1089,10 +1089,10 @@
----
NULL
-query I rowsort label-197
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL CASE - 6 WHEN + 70 + ( 81 ) THEN NULL WHEN COALESCE ( - 22, - + COALESCE ( - 64, + 65 / 49 + - + 62, - - NULLIF ( + 57, COUNT ( ALL - CASE 58 WHEN + 17 - 80 THEN 72 * - 40 + 54 * + 58 WHEN - CAST ( NULL AS INTEGER ) THEN NULL WHEN - 59 + 45 / + COALESCE ( 54 / 88, CAST ( NULL AS INTEGER ) * - 22 + - 58 * + 98 ) THEN - 18 / 20 ELSE NULL END ) * 3 ) ) * - MAX ( DISTINCT + 46 * - 27 ), AVG ( ALL 22 ) ) THEN NULL WHEN 23 THEN 42 - + MAX ( 52 ) END
-----
-NULL
query I rowsort label-198
SELECT ALL + SUM ( ALL - 42 ) * - CAST ( + - 2 AS INTEGER ) + - CAST ( NULL AS INTEGER ) + - ( 63 ) AS col0
@@ -23926,10 +23926,10 @@
----
0
-query I rowsort label-4533
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 11
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COUNT ( * ) * + COALESCE ( NULLIF ( + + 11, + CAST ( NULL AS INTEGER ) ), - - 93, + + 92 / - + 82 * - MIN ( ( + 32 ) ) / - 0 + 61, - 69 )
-----
-11
query I rowsort
SELECT + 6 + + + 34
@@ -46837,10 +46837,10 @@
----
1096
-query I rowsort label-8891
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 17080
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + ( MIN ( DISTINCT - - 35 ) ) * 61 * + COALESCE ( + 8, - COUNT ( * ) * CASE + CASE - 31 WHEN + - 75 + - 71 - - - 9 * + COUNT ( * ) THEN COALESCE ( - - ( - ( + - MAX ( DISTINCT + 38 ) ) ), + 94 + + 55, - - 99 ) ELSE 12 * 40 + - CAST ( - - 25 AS INTEGER ) - + 46 + + 66 + - 89 * 8 * 56 END WHEN - 25 + CAST ( - COUNT ( * ) AS INTEGER ) THEN NULL WHEN + 3 * ( ( 39 ) / 0 ) THEN - 14 WHEN 11 * COUNT ( * ) THEN NULL END, 58 / - COUNT ( * ) )
-----
-17080
query I rowsort
SELECT + + 94 * - - 71 * - 20 * + - 62
@@ -51534,10 +51534,10 @@
----
174884
-query I rowsort label-9785
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 3920
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( + ( COALESCE ( + 56, + MIN ( + 30 ) - ( ( + NULLIF ( - COUNT ( * ), + 14 / ( - 15 / + 55 ) ) ) ) ) ), COALESCE ( + 88, 84 * - 17 ) + 71 ) * 70
-----
-3920
query I rowsort
SELECT 10 * + 36
diff --git a/data/sqlite/random/expr/slt_good_104.slt b/data/sqlite/random/expr/slt_good_104.slt
index 9e2c394..7519bfb 100644
--- a/data/sqlite/random/expr/slt_good_104.slt
+++ b/data/sqlite/random/expr/slt_good_104.slt
@@ -3691,11 +3691,11 @@
----
57
-query II rowsort label-687
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -1750
+# Datafusion - Expected - -70
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 35 * + 50 AS col0, COALESCE ( - + 70, + 20 / - 71 / - 0, - - 12 ) * MIN ( 1 )
-----
--1750
--70
query I rowsort label-688
SELECT - MIN ( + 75 ) * + 8 + + 76 * 50
@@ -25906,10 +25906,10 @@
----
154919
-query I rowsort label-4929
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 102
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT COALESCE ( - - 3, - + NULLIF ( + 67, - 48 / 0 ) + - 86 + 74 * - 16, - 52 + + 63 / + + MAX ( DISTINCT + + 45 ) - 58 ) * + 34 AS col0
-----
-102
query I rowsort label-4930
SELECT ALL + - ( + 87 ) - + MIN ( DISTINCT - 34 ) + - + COALESCE ( + - 62, - 67 ) AS col2
diff --git a/data/sqlite/random/expr/slt_good_105.slt b/data/sqlite/random/expr/slt_good_105.slt
index b4c634c..0631040 100644
--- a/data/sqlite/random/expr/slt_good_105.slt
+++ b/data/sqlite/random/expr/slt_good_105.slt
@@ -2698,10 +2698,10 @@
----
-1
-query I rowsort
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 38
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + NULLIF ( + + ( + 38 ), - + COALESCE ( + 11, + 34 / - 0, - 63 ) - + 47 + 12 * - + 7 )
-----
-38
query I rowsort label-503
SELECT ALL + MIN ( + 96 )
@@ -19836,10 +19836,10 @@
----
1
-query I rowsort label-3760
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -41
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 71 - - 46 * 29 / - COALESCE ( ( COALESCE ( 77, - COUNT ( * ) / - 0, - 75 ) ), + COUNT ( * ) ) + MIN ( ALL + 47 )
-----
--41
query I rowsort label-3761
SELECT - MIN ( + 11 ) * - - 37 * + 95
@@ -22635,10 +22635,10 @@
----
29198
-query I rowsort label-4296
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -1329
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( + + 28, + 71 + 63 * - MAX ( DISTINCT - 71 ) * + COUNT ( * ), - 82, + 2 - SUM ( 88 ), 58 / - NULLIF ( + COUNT ( * ) / 65, 99 + 62 ) ) + - 59 * 23 AS col2
-----
--1329
query I rowsort label-4297
SELECT ALL - CAST ( + + 34 AS INTEGER ) AS col2
diff --git a/data/sqlite/random/expr/slt_good_106.slt b/data/sqlite/random/expr/slt_good_106.slt
index c184f38..726d486 100644
--- a/data/sqlite/random/expr/slt_good_106.slt
+++ b/data/sqlite/random/expr/slt_good_106.slt
@@ -27502,10 +27502,10 @@
97
-1
-query I rowsort label-5238
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 75
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - NULLIF ( + 24, 53 ) + - COALESCE ( + 40, + 7 / 55 / + + 0 ) + + 43 + + 96
-----
-75
query I rowsort
SELECT ALL + ( 89 ) AS col1
@@ -44430,10 +44430,12 @@
-5621
-41154
-query I rowsort label-8457
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -900
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 2 + + COALESCE ( - NULLIF ( - - 41, 83 * - CASE + 0 WHEN + 30 + - 96 THEN - 16 + - 11 + + MIN ( ALL - 73 ) / 72 / - - 18 WHEN + 35 THEN + - 98 + + + 89 END + - 14 + - - 12 + - 79 + - + 23 * + 52 ), + 70 / + + 0 ) * + + 22
-----
--900
query I rowsort
SELECT ALL + 29 * - - 48 AS col1
diff --git a/data/sqlite/random/expr/slt_good_107.slt b/data/sqlite/random/expr/slt_good_107.slt
index 8c9a012..7aa8822 100644
--- a/data/sqlite/random/expr/slt_good_107.slt
+++ b/data/sqlite/random/expr/slt_good_107.slt
@@ -8427,10 +8427,10 @@
----
NULL
-query I rowsort label-1604
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 2530
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 22 + - CAST ( + + COALESCE ( - 69, + AVG ( DISTINCT + 99 ) / 80, 30 + - COALESCE ( 3, + 51, + - 7 + NULLIF ( + 51, + 48 * - CASE - 44 WHEN - 56 + 40 THEN NULL WHEN - 53 / + - CAST ( - + 0 AS INTEGER ) / + + 34 THEN NULL ELSE - + 63 END ) ) ) AS INTEGER ) * - CASE + COUNT ( * ) WHEN - 98 * - CAST ( NULL AS INTEGER ) THEN NULL ELSE - - 41 / + ( + 30 ) + - 92 - - + 90 END + 44 * 54 + 63 AS col0
-----
-2530
# Datafusion - Datafusion expected results:
# Datafusion - Expected - 38
diff --git a/data/sqlite/random/expr/slt_good_108.slt b/data/sqlite/random/expr/slt_good_108.slt
index 22c38aa..e66e8ce 100644
--- a/data/sqlite/random/expr/slt_good_108.slt
+++ b/data/sqlite/random/expr/slt_good_108.slt
@@ -38979,10 +38979,10 @@
----
-1890
-query I rowsort label-7425
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 86
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + + COALESCE ( - - 86, - 45 + - - MAX ( 49 ), - - 81 / - 0 + - + 47 + + - 65 ) AS col1
-----
-86
query II rowsort label-7426
SELECT + - CAST ( NULL AS INTEGER ) / + 95 * 83, 55 AS col0
@@ -39307,10 +39307,10 @@
10
1
-query I rowsort label-7486
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -2052
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - COALESCE ( - - 57, 1 * - + 82, COUNT ( * ) / + 58 / 0 + - COUNT ( * ) + - 3 ) * + 36
-----
--2052
query I rowsort
SELECT 80 * - 21
diff --git a/data/sqlite/random/expr/slt_good_11.slt b/data/sqlite/random/expr/slt_good_11.slt
index 553c498..6d9dd10 100644
--- a/data/sqlite/random/expr/slt_good_11.slt
+++ b/data/sqlite/random/expr/slt_good_11.slt
@@ -17338,10 +17338,10 @@
----
-38
-query I rowsort label-3292
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -31
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - COALESCE ( + ( - - 31 ), + 76 + + 81 + - 94 + COUNT ( * ) * 2 + + NULLIF ( 61, - 84 / 0 + - + CASE + 97 WHEN 39 THEN NULL ELSE - - ( + 62 ) END + 67 / - COUNT ( * ) ) * - 54 / + COUNT ( * ), 5 ) col0
-----
--31
query I rowsort
SELECT 83 * 89 AS col2
diff --git a/data/sqlite/random/expr/slt_good_110.slt b/data/sqlite/random/expr/slt_good_110.slt
index b707531..c1ea8e8 100644
--- a/data/sqlite/random/expr/slt_good_110.slt
+++ b/data/sqlite/random/expr/slt_good_110.slt
@@ -17069,10 +17069,10 @@
----
NULL
-query I rowsort label-3234
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -89
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( CAST ( 89 AS INTEGER ), - NULLIF ( + 29, - 22 / MIN ( ALL - 11 / 75 ) ) )
-----
--89
query I rowsort label-3235
SELECT 44 - + SUM ( - 27 ) * 4
@@ -27703,10 +27703,10 @@
----
157
-query I rowsort label-5267
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 1810
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - NULLIF ( - + 40, 92 ) * 43 - + - COALESCE ( 90, + 61, + 2 / 19 / 0 * + + 44, 19 / - 6 * - + 23 )
-----
-1810
query I rowsort
SELECT - 77 + - 18
diff --git a/data/sqlite/random/expr/slt_good_111.slt b/data/sqlite/random/expr/slt_good_111.slt
index ac34f4c..4907500 100644
--- a/data/sqlite/random/expr/slt_good_111.slt
+++ b/data/sqlite/random/expr/slt_good_111.slt
@@ -25200,10 +25200,10 @@
----
-168
-query I rowsort label-4804
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -1
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - COALESCE ( + MIN ( DISTINCT + - COALESCE ( - + 1, + 80 / + + 0 + 53, - - ( + ( CAST ( + 65 AS INTEGER ) ) ) / 70 + 41 ) ), - 80 )
-----
--1
query II rowsort
SELECT ALL - 94 AS col2, + 5 AS col0
@@ -30556,10 +30556,10 @@
----
-99
-query I rowsort label-5818
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 4281
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + MAX ( DISTINCT - - 81 ) * + SUM ( ALL + 52 ) + COALESCE ( + 69, + 94, + ( - 40 ) / - 0 )
-----
-4281
query I rowsort label-5819
SELECT + SUM ( - 37 ) AS col2
diff --git a/data/sqlite/random/expr/slt_good_112.slt b/data/sqlite/random/expr/slt_good_112.slt
index 37359a6..3eea878 100644
--- a/data/sqlite/random/expr/slt_good_112.slt
+++ b/data/sqlite/random/expr/slt_good_112.slt
@@ -4996,10 +4996,10 @@
----
84
-query I rowsort label-940
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -12
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - COALESCE ( + 12, - 86 + + + MAX ( DISTINCT - - 99 ) + 7 + + 9 * + - 96, NULLIF ( + - CASE + 9 WHEN CASE 50 WHEN + 13 THEN - 78 END * + 55 THEN - 54 * + + ( + COUNT ( DISTINCT 7 ) ) END, 62 * - - COUNT ( * ) / + 0 + + COUNT ( * ) - - + COUNT ( * ) ) * - 7 ) AS col1
-----
--12
query II rowsort label-941
SELECT - + 55 * - - COUNT ( * ) AS col2, 24 + - + 54 AS col0
@@ -9000,11 +9000,11 @@
----
-47
-query II rowsort label-1705
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -92
+# Datafusion - Expected - 19
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - 92 AS col1, ( 19 ) + - COALESCE ( + 0, - + 27 + 47 * - 58, + 53 / - 0 ) col0
-----
--92
-19
query I rowsort
SELECT - 90 * - 73 * 79 AS col0
diff --git a/data/sqlite/random/expr/slt_good_113.slt b/data/sqlite/random/expr/slt_good_113.slt
index d7d8c09..830b81d 100644
--- a/data/sqlite/random/expr/slt_good_113.slt
+++ b/data/sqlite/random/expr/slt_good_113.slt
@@ -44725,10 +44725,10 @@
----
9
-query I rowsort label-8501
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 0
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( + + COUNT ( * ), - CAST ( + 3 AS INTEGER ), 72 / + 0 + + 63 + - 51 ) / + 33 AS col2
-----
-0
query I rowsort
SELECT - + 86 col1
@@ -51194,10 +51194,10 @@
----
-2547
-query I rowsort label-9730
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -48
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - COALESCE ( - - 57, MAX ( ALL - + 87 ) / 0 + + 93 * - 93 ) + - 7 + - 53 / + ( + + 86 ) * SUM ( + 8 ) + + 16
-----
--48
query I rowsort label-9731
SELECT ALL CAST ( NULL AS INTEGER ) + - 81 AS col1
diff --git a/data/sqlite/random/expr/slt_good_116.slt b/data/sqlite/random/expr/slt_good_116.slt
index 1a3b003..984fac1 100644
--- a/data/sqlite/random/expr/slt_good_116.slt
+++ b/data/sqlite/random/expr/slt_good_116.slt
@@ -6351,10 +6351,10 @@
----
0
-query I rowsort label-1199
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -84
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL CASE COALESCE ( + 92, - + NULLIF ( - MAX ( ALL + + 46 ), ( - 85 ) + + COALESCE ( 54, + COUNT ( * ) * + - 42 ) ) * ( + - COUNT ( * ) ), + + 66 - + 75 * - COUNT ( * ) + ( 64 ) * + - COUNT ( * ), + 91 + COUNT ( * ) + + COALESCE ( + 2, - CAST ( NULL AS INTEGER ) * + - 21 + 39 ) / + 0 * - - 85 ) WHEN - 23 THEN NULL WHEN + - 51 THEN + COUNT ( * ) ELSE - 84 END
-----
--84
query I rowsort label-1200
SELECT DISTINCT + ( - - 56 ) / + 89 + ( + 38 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_118.slt b/data/sqlite/random/expr/slt_good_118.slt
index bdaa3d4..f557e89 100644
--- a/data/sqlite/random/expr/slt_good_118.slt
+++ b/data/sqlite/random/expr/slt_good_118.slt
@@ -16422,10 +16422,10 @@
----
-40
-query I rowsort label-3130
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 8194
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + 94 * 88 + - COALESCE ( 78, 15 / MIN ( + 0 ), - 21, - 46 ) col0
-----
-8194
query II rowsort
SELECT DISTINCT - - 93 col2, + 8
diff --git a/data/sqlite/random/expr/slt_good_119.slt b/data/sqlite/random/expr/slt_good_119.slt
index 66c2c95..a50fc2e 100644
--- a/data/sqlite/random/expr/slt_good_119.slt
+++ b/data/sqlite/random/expr/slt_good_119.slt
@@ -10485,11 +10485,11 @@
----
2279
-query II rowsort label-1991
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -48657
+# Datafusion - Expected - -946
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 26 * + - ( - + 22 ) * - 85 + - + COALESCE ( 37, + CASE + 12 WHEN - COUNT ( * ) + + 13 - CASE - 72 WHEN 57 * + COALESCE ( + 65, COUNT ( + 64 ), - 3 / - - NULLIF ( - + 0, - - 48 ) - + 70 * + - MAX ( - 41 ) + + 80 ) / 85 THEN + 41 + - 44 * - - 98 * 86 ELSE NULL END THEN + + 25 ELSE + 57 END + + + 30, - + 93, 55 ), - 22 * + + 43 AS col0
-----
--48657
--946
query II rowsort
SELECT + 10 AS col1, 68 AS col2
diff --git a/data/sqlite/random/expr/slt_good_12.slt b/data/sqlite/random/expr/slt_good_12.slt
index 11fb2f8..2b58744 100644
--- a/data/sqlite/random/expr/slt_good_12.slt
+++ b/data/sqlite/random/expr/slt_good_12.slt
@@ -1486,10 +1486,12 @@
----
NULL
-query I rowsort label-276
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - - 96 * 11 * + CASE WHEN NOT + 84 NOT BETWEEN 27 / 0 AND COALESCE ( + 61, + AVG ( 81 ) / + 39 + COUNT ( * ) ) THEN - 69 WHEN NULL > ( - 15 ) THEN NULL ELSE NULL END AS col2
-----
-NULL
query I rowsort
SELECT + - 90 + ( + 59 ) + 0
@@ -24853,11 +24855,11 @@
----
0
-query II rowsort label-4720
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -52
+# Datafusion - Expected - -133
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 52 AS col0, - COALESCE ( + 46, 13 / - + 0 ) + - ( 18 ) - - - 69 AS col2
-----
--52
--133
query I rowsort label-4721
SELECT - + ( 7 ) * + + 37 * + COUNT ( * ) AS col2
diff --git a/data/sqlite/random/expr/slt_good_13.slt b/data/sqlite/random/expr/slt_good_13.slt
index 6d254b2..e0f486e 100644
--- a/data/sqlite/random/expr/slt_good_13.slt
+++ b/data/sqlite/random/expr/slt_good_13.slt
@@ -24178,10 +24178,10 @@
----
20
-query I rowsort label-4645
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 62
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + 62, + 24 / ( 55 / COALESCE ( 85, - 80, COUNT ( ALL ( + COALESCE ( 26, 4 / 63 ) ) ) + 43 * + 55 ) ) )
-----
-62
query I rowsort label-4646
SELECT NULLIF ( + CAST ( - COUNT ( * ) AS INTEGER ), + CAST ( + 80 AS INTEGER ) * + 60 + - ( 86 ) * 99 )
@@ -24273,10 +24273,10 @@
----
65
-query I rowsort label-4664
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 10
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + 64, - + 6 / NULLIF ( - 46 / 72, - 38 * - 6 ), 36 ) - 54 AS col2
-----
-10
query I rowsort
SELECT + 93 * COALESCE ( + 23, - ( - 73 ), + 7 * + 26, + 21 ) col2
@@ -34908,10 +34908,12 @@
----
-273
-query I rowsort label-6714
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -1
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COUNT ( * ) / 6 * - + 57 + - COALESCE ( + ( COUNT ( * ) ), 13 * COALESCE ( 26 / - CASE 96 WHEN - 16 * 40 THEN NULL ELSE 65 / 84 END, NULLIF ( - 24, + ( - 17 ) ) * 48 ) + - 30, 65 )
-----
--1
query I rowsort
SELECT DISTINCT - 2 * 63
@@ -39773,10 +39775,10 @@
----
-7310
-query I rowsort label-7650
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COUNT ( * ) * - 17 + COUNT ( * ) + - - 44 + + CASE + 61 WHEN - 36 * - 67 / 73 + CASE 23 WHEN - + COUNT ( * ) THEN NULL WHEN - - 0 THEN 23 * + NULLIF ( 1, - - 44 ) + + 27 END + - COUNT ( 42 ) + + 92 + - + COALESCE ( + + 96, 48 * 73 / + 0 * 21 * + 21 ) THEN NULL WHEN 62 THEN + 14 END * 49
-----
-NULL
query I rowsort
SELECT 82 * + 51
diff --git a/data/sqlite/random/expr/slt_good_14.slt b/data/sqlite/random/expr/slt_good_14.slt
index 3eb7c96..2d1fe00 100644
--- a/data/sqlite/random/expr/slt_good_14.slt
+++ b/data/sqlite/random/expr/slt_good_14.slt
@@ -2669,10 +2669,10 @@
----
182
-query I rowsort label-500
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT 88 / - + CASE - COALESCE ( - + 47, - COUNT ( * ) / - + CAST ( + + 0 AS INTEGER ) * - + 61 * + 30 ) WHEN - 64 THEN NULL WHEN + 74 THEN - 53 + + + 21 * - 70 END
-----
-NULL
query I rowsort
SELECT 59 - 98 + + + 37 + 73 * 52 AS col1
@@ -6381,10 +6381,10 @@
----
NULL
-query I rowsort label-1202
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 151
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + ( 66 ), 45 + + - 81 - + COUNT ( * ) / + 0 ) + + 44 - + 71 / 79 + - - 41
-----
-151
query I rowsort
SELECT - + 13 * + 50 + - 28 AS col1
diff --git a/data/sqlite/random/expr/slt_good_16.slt b/data/sqlite/random/expr/slt_good_16.slt
index 82d206c..4bed7e8 100644
--- a/data/sqlite/random/expr/slt_good_16.slt
+++ b/data/sqlite/random/expr/slt_good_16.slt
@@ -13389,10 +13389,10 @@
22
15480
-query I rowsort label-2534
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -975
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL COALESCE ( - 39, - + 27 + ( 91 ), + + 66 / 0 ) * 25
-----
--975
query I rowsort label-2535
SELECT COALESCE ( - + 42, + 88 * - - CASE + COUNT ( * ) WHEN - 89 THEN 51 WHEN CASE CAST ( NULL AS INTEGER ) WHEN 48 THEN - 95 ELSE 66 * ( 31 ) END + 73 THEN - 90 END, - 42 ) + + 24
@@ -34859,10 +34859,10 @@
----
7497
-query I rowsort label-6603
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 92
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( 92, + 8 + + + 36 / + + 0 + + 99 )
-----
-92
query I rowsort label-6604
SELECT ALL + MIN ( - 69 ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_17.slt b/data/sqlite/random/expr/slt_good_17.slt
index e8c7b8d..3dfb129 100644
--- a/data/sqlite/random/expr/slt_good_17.slt
+++ b/data/sqlite/random/expr/slt_good_17.slt
@@ -28321,10 +28321,10 @@
----
-32705
-query I rowsort label-5381
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 26
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + COALESCE ( 26, - - 19 + - + 7 / - - 47 / + COUNT ( - ( CAST ( NULL AS INTEGER ) ) / 69 ) )
-----
-26
query I rowsort label-5382
SELECT + ( - NULLIF ( - 35, - - CAST ( NULL AS INTEGER ) / - 57 / COUNT ( - 42 * 47 ) ) ) col0
diff --git a/data/sqlite/random/expr/slt_good_2.slt b/data/sqlite/random/expr/slt_good_2.slt
index c3062ad..169cf24 100644
--- a/data/sqlite/random/expr/slt_good_2.slt
+++ b/data/sqlite/random/expr/slt_good_2.slt
@@ -41206,10 +41206,10 @@
----
NULL
-query I rowsort label-7947
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 54
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 2 + - COALESCE ( - 56, MAX ( - 94 ), - MAX ( DISTINCT CAST ( NULL AS INTEGER ) ) * - 49 * + 36 + + 67 - - + 32 + + 1 / + 0, - COUNT ( ALL - + 57 ) )
-----
-54
query I rowsort label-7948
SELECT + COUNT ( * ) * + ( 27 )
diff --git a/data/sqlite/random/expr/slt_good_22.slt b/data/sqlite/random/expr/slt_good_22.slt
index e5f6d77..3cbc2eb 100644
--- a/data/sqlite/random/expr/slt_good_22.slt
+++ b/data/sqlite/random/expr/slt_good_22.slt
@@ -30131,10 +30131,10 @@
----
2930
-query I rowsort label-5742
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 91
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( + 91, + 86 / 49 * - - COALESCE ( 97, + 97 * - ( - - 68 ) ) * + 6 + - CAST ( NULL AS INTEGER ), - + 12 / + COUNT ( * ) / + 0 ) AS col0
-----
-91
query I rowsort label-5743
SELECT SUM ( DISTINCT ( + - CAST ( NULL AS INTEGER ) ) ) + - 10 col0
@@ -38340,10 +38340,10 @@
69
NULL
-query I rowsort label-7302
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 61
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL COALESCE ( + COALESCE ( 61, + - 42 * - 55 * - - 50 ), 18 * + 53 / + 0 + - - 88 + + + 60 / - 55 ) col2
-----
-61
query I rowsort label-7303
SELECT MAX ( - + 84 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_23.slt b/data/sqlite/random/expr/slt_good_23.slt
index 2254f8f..6f1b0a5 100644
--- a/data/sqlite/random/expr/slt_good_23.slt
+++ b/data/sqlite/random/expr/slt_good_23.slt
@@ -8069,10 +8069,12 @@
----
-66
-query I rowsort label-1532
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 1
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( COUNT ( * ), - 92 / 0 + - - 43 )
-----
-1
query II rowsort
SELECT ( + + 77 ) + - ( + + 87 ) AS col1, 73
@@ -23893,10 +23895,12 @@
-281232
-253
-query I rowsort label-4541
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT CASE + 30 WHEN + 94 + 15 * - 34 + COALESCE ( COUNT ( * ), + 61 + 96 / - + 0 ) THEN - 93 ELSE NULL END * 85
-----
-NULL
query I rowsort
SELECT 62 - + 89
diff --git a/data/sqlite/random/expr/slt_good_24.slt b/data/sqlite/random/expr/slt_good_24.slt
index 5590c1b..7f38da1 100644
--- a/data/sqlite/random/expr/slt_good_24.slt
+++ b/data/sqlite/random/expr/slt_good_24.slt
@@ -19855,10 +19855,10 @@
----
-18493
-query I rowsort label-3793
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 27
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + + COALESCE ( 27, - 62 + + 37 + - - 54 + - + 66 * + - 96 - + 23 / - - 78 / + 86 + - 50 + + - COUNT ( * ) / - 0 )
-----
-27
query I rowsort label-3794
SELECT DISTINCT + COUNT ( * ) * 27 * - 5 + - 54
diff --git a/data/sqlite/random/expr/slt_good_25.slt b/data/sqlite/random/expr/slt_good_25.slt
index 13fc4b0..110bf62 100644
--- a/data/sqlite/random/expr/slt_good_25.slt
+++ b/data/sqlite/random/expr/slt_good_25.slt
@@ -2131,13 +2131,10 @@
----
-71
-# Datafusion - Types were automatically converted from:
-# Datafusion - [Expected] [I]
-# Datafusion - [Actual ] [R]
-query R rowsort label-399
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 9
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - COALESCE ( - - 13, + - AVG ( - 78 ) / - - 11, 23 / 0 ) + + + 22
-----
-9
query I rowsort
SELECT ALL + ( + 12 ) + - - 67 AS col0
@@ -21282,11 +21279,13 @@
----
3290
-query II rowsort label-4071
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 69
+# Datafusion - Expected - -14
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + 69 AS col0, + 13 + 96 + ( - ( + 28 ) ) + - 78 / ( + COUNT ( + 91 ) ) / - + NULLIF ( 87, 92 ) + + + 95 * - COALESCE ( - - COUNT ( + ( - 70 ) ), CASE 85 WHEN + 22 * - 50 + 8 * - NULLIF ( COUNT ( * ) * 49, COALESCE ( 76, - 15 + - NULLIF ( 84, - 19 + 98 ) ) ) THEN NULL WHEN 25 THEN NULL WHEN - 15 THEN 20 * 75 ELSE NULL END + + 71, 34 / + 0 ) AS col1
-----
-69
--14
query I rowsort
SELECT DISTINCT - 42 * - 81 * 69 * + - 50 + + 10 col1
@@ -50982,10 +50981,10 @@
----
-2106
-query I rowsort label-9743
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 31 + + CASE 63 WHEN 6 THEN - + 62 - + COUNT ( * ) * 43 WHEN - 13 + - - ( - NULLIF ( - COALESCE ( + - 84, - + 97, + 7 / + 0 - - - COALESCE ( + COALESCE ( 2, + - ( - - MAX ( + 68 ) ), 24 / + - 66 ), + COUNT ( * ) ) + - AVG ( + 36 ) + + - NULLIF ( 94, 69 ) + - 78 * + ( 32 ) ), - 34 + - 41 * COUNT ( * ) ) ) + - CASE 57 WHEN + MAX ( 26 ) / 64 THEN NULL WHEN NULLIF ( - 70, 6 / 92 + + 79 * 30 ) THEN + 57 END / 51 THEN NULL END * 27
-----
-NULL
query I rowsort
SELECT DISTINCT + + 95 * - 27 - 42 AS col1
diff --git a/data/sqlite/random/expr/slt_good_26.slt b/data/sqlite/random/expr/slt_good_26.slt
index 58d48e9..cb56f06 100644
--- a/data/sqlite/random/expr/slt_good_26.slt
+++ b/data/sqlite/random/expr/slt_good_26.slt
@@ -7453,10 +7453,10 @@
1
-41
-query I rowsort label-1418
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -5914
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( - - 85, - - COALESCE ( - 11, + + CAST ( - 53 AS INTEGER ) * + COUNT ( * ) / + 9, + 21 + + SUM ( DISTINCT + 74 ), - - COALESCE ( - 48, + - 14 ) ) / + ( + 0 ) + ( 56 ) + + 17 ) + 49 + 72 * 84 / - COUNT ( * )
-----
--5914
query I rowsort label-1419
SELECT ALL MIN ( DISTINCT - - 52 )
@@ -23332,10 +23332,10 @@
----
NULL
-query I rowsort label-4457
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 69 * - SUM ( - + 40 ) + + COALESCE ( 53, - 13 + 71, - - 49 / + - NULLIF ( 0, 57 + 45 ) * 63 + + COALESCE ( 38, + 75 ) ) * - CASE 22 WHEN - 35 + - COUNT ( * ) * - COUNT ( - 53 ) THEN 72 END + ( 4 - 37 )
-----
-NULL
query I rowsort
SELECT DISTINCT + - 20 col0
diff --git a/data/sqlite/random/expr/slt_good_27.slt b/data/sqlite/random/expr/slt_good_27.slt
index a86bf61..a4914c7 100644
--- a/data/sqlite/random/expr/slt_good_27.slt
+++ b/data/sqlite/random/expr/slt_good_27.slt
@@ -10430,10 +10430,10 @@
----
0
-query I rowsort label-1994
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 0
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + CAST ( - 13 AS INTEGER ) / COALESCE ( - + 14, + - NULLIF ( - COUNT ( * ), 19 * - - NULLIF ( 12, + MIN ( ALL - - ( + - 11 ) ) ) / + - 4 + - 84 + + 36 - - 57 + - + 68 * NULLIF ( + 57, + 45 ) ) * + 24 / CAST ( - 0 AS INTEGER ) / + 90, - 93 ) col0
-----
-0
query I rowsort
SELECT ALL - 41 AS col2
@@ -52223,10 +52223,10 @@
----
-57
-query I rowsort label-9987
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -38
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - - COALESCE ( + + COALESCE ( + + COUNT ( * ), - - 40 / - ( + - NULLIF ( ( + 0 ), 63 ) ) * - 55 ), 50 + MAX ( DISTINCT + 45 ), - - 19 ) * - 38 AS col0
-----
--38
query I rowsort
SELECT + ( 4 )
diff --git a/data/sqlite/random/expr/slt_good_28.slt b/data/sqlite/random/expr/slt_good_28.slt
index 4d81eca..5d5d2b7 100644
--- a/data/sqlite/random/expr/slt_good_28.slt
+++ b/data/sqlite/random/expr/slt_good_28.slt
@@ -41683,10 +41683,10 @@
----
1
-query I rowsort label-7968
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -45
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL COALESCE ( - 15, 68 / + SUM ( + 26 / NULLIF ( + 35, - 59 ) ) + COUNT ( - 78 ), MAX ( ALL 5 ) * COUNT ( * ) ) + - 30
-----
--45
query I rowsort label-7969
SELECT ALL 98 * CAST ( 74 AS INTEGER ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_29.slt b/data/sqlite/random/expr/slt_good_29.slt
index 5f62563..5dd5499 100644
--- a/data/sqlite/random/expr/slt_good_29.slt
+++ b/data/sqlite/random/expr/slt_good_29.slt
@@ -25271,10 +25271,10 @@
----
20
-query I rowsort label-4887
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 62
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + 62, + 24 / ( 55 / COALESCE ( 85, - 80, COUNT ( ALL ( + COALESCE ( 26, 4 / 63 ) ) ) + 43 * + 55 ) ) )
-----
-62
query I rowsort label-4888
SELECT NULLIF ( + CAST ( - COUNT ( * ) AS INTEGER ), + CAST ( + 80 AS INTEGER ) * + 60 + - ( 86 ) * 99 )
@@ -25366,10 +25366,10 @@
----
65
-query I rowsort label-4906
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 10
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + 64, - + 6 / NULLIF ( - 46 / 72, - 38 * - 6 ), 36 ) - 54 AS col2
-----
-10
query I rowsort
SELECT + 93 * COALESCE ( + 23, - ( - 73 ), + 7 * + 26, + 21 ) col2
@@ -37036,10 +37036,12 @@
----
-273
-query I rowsort label-7164
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -1
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COUNT ( * ) / 6 * - + 57 + - COALESCE ( + ( COUNT ( * ) ), 13 * COALESCE ( 26 / - CASE 96 WHEN - 16 * 40 THEN NULL ELSE 65 / 84 END, NULLIF ( - 24, + ( - 17 ) ) * 48 ) + - 30, 65 )
-----
--1
query I rowsort
SELECT DISTINCT - 2 * 63
@@ -42282,10 +42284,10 @@
----
-7310
-query I rowsort label-8176
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COUNT ( * ) * - 17 + COUNT ( * ) + - - 44 + + CASE + 61 WHEN - 36 * - 67 / 73 + CASE 23 WHEN - + COUNT ( * ) THEN NULL WHEN - - 0 THEN 23 * + NULLIF ( 1, - - 44 ) + + 27 END + - COUNT ( 42 ) + + 92 + - + COALESCE ( + + 96, 48 * 73 / + 0 * 21 * + 21 ) THEN NULL WHEN 62 THEN + 14 END * 49
-----
-NULL
query I rowsort
SELECT 82 * + 51
diff --git a/data/sqlite/random/expr/slt_good_3.slt b/data/sqlite/random/expr/slt_good_3.slt
index e1c80e8..260abbe 100644
--- a/data/sqlite/random/expr/slt_good_3.slt
+++ b/data/sqlite/random/expr/slt_good_3.slt
@@ -28029,10 +28029,10 @@
----
1456
-query I rowsort label-5329
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 3524
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 26 - - COALESCE ( - - 69, + 39 * + + COALESCE ( - + 33, + 41 / - 0 ) ) + 84 * + + 42 + - 99 AS col1
-----
-3524
query I rowsort
SELECT DISTINCT 85 * + - ( - 67 )
diff --git a/data/sqlite/random/expr/slt_good_30.slt b/data/sqlite/random/expr/slt_good_30.slt
index cb961f4..c182de6 100644
--- a/data/sqlite/random/expr/slt_good_30.slt
+++ b/data/sqlite/random/expr/slt_good_30.slt
@@ -24909,10 +24909,10 @@
----
-18493
-query I rowsort label-4776
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 27
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + + COALESCE ( 27, - 62 + + 37 + - - 54 + - + 66 * + - 96 - + 23 / - - 78 / + 86 + - 50 + + - COUNT ( * ) / - 0 )
-----
-27
query I rowsort
SELECT + + 2
diff --git a/data/sqlite/random/expr/slt_good_31.slt b/data/sqlite/random/expr/slt_good_31.slt
index 229bb9c..f4a8d26 100644
--- a/data/sqlite/random/expr/slt_good_31.slt
+++ b/data/sqlite/random/expr/slt_good_31.slt
@@ -8602,13 +8602,10 @@
----
-71
-# Datafusion - Types were automatically converted from:
-# Datafusion - [Expected] [I]
-# Datafusion - [Actual ] [R]
-query R rowsort label-1640
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 9
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - COALESCE ( - - 13, + - AVG ( - 78 ) / - - 11, 23 / 0 ) + + + 22
-----
-9
query I rowsort
SELECT ALL + ( + 12 ) + - - 67 AS col0
@@ -28238,11 +28235,13 @@
----
3290
-query II rowsort label-5410
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 69
+# Datafusion - Expected - -14
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + 69 AS col0, + 13 + 96 + ( - ( + 28 ) ) + - 78 / ( + COUNT ( + 91 ) ) / - + NULLIF ( 87, 92 ) + + + 95 * - COALESCE ( - - COUNT ( + ( - 70 ) ), CASE 85 WHEN + 22 * - 50 + 8 * - NULLIF ( COUNT ( * ) * 49, COALESCE ( 76, - 15 + - NULLIF ( 84, - 19 + 98 ) ) ) THEN NULL WHEN 25 THEN NULL WHEN - 15 THEN 20 * 75 ELSE NULL END + + 71, 34 / + 0 ) AS col1
-----
-69
--14
query I rowsort
SELECT DISTINCT - 42 * - 81 * 69 * + - 50 + + 10 col1
diff --git a/data/sqlite/random/expr/slt_good_33.slt b/data/sqlite/random/expr/slt_good_33.slt
index cb1e27f..417f79b 100644
--- a/data/sqlite/random/expr/slt_good_33.slt
+++ b/data/sqlite/random/expr/slt_good_33.slt
@@ -6252,10 +6252,10 @@
----
-2106
-query I rowsort label-1190
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 31 + + CASE 63 WHEN 6 THEN - + 62 - + COUNT ( * ) * 43 WHEN - 13 + - - ( - NULLIF ( - COALESCE ( + - 84, - + 97, + 7 / + 0 - - - COALESCE ( + COALESCE ( 2, + - ( - - MAX ( + 68 ) ), 24 / + - 66 ), + COUNT ( * ) ) + - AVG ( + 36 ) + + - NULLIF ( 94, 69 ) + - 78 * + ( 32 ) ), - 34 + - 41 * COUNT ( * ) ) ) + - CASE 57 WHEN + MAX ( 26 ) / 64 THEN NULL WHEN NULLIF ( - 70, 6 / 92 + + 79 * 30 ) THEN + 57 END / 51 THEN NULL END * 27
-----
-NULL
query I rowsort
SELECT DISTINCT + + 95 * - 27 - 42 AS col1
@@ -15202,10 +15202,10 @@
1
-41
-query I rowsort label-2901
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -5914
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( - - 85, - - COALESCE ( - 11, + + CAST ( - 53 AS INTEGER ) * + COUNT ( * ) / + 9, + 21 + + SUM ( DISTINCT + 74 ), - - COALESCE ( - 48, + - 14 ) ) / + ( + 0 ) + ( 56 ) + + 17 ) + 49 + 72 * 84 / - COUNT ( * )
-----
--5914
query I rowsort label-2902
SELECT ALL MIN ( DISTINCT - - 52 )
@@ -31273,10 +31273,10 @@
----
NULL
-query I rowsort label-5979
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 69 * - SUM ( - + 40 ) + + COALESCE ( 53, - 13 + 71, - - 49 / + - NULLIF ( 0, 57 + 45 ) * 63 + + COALESCE ( 38, + 75 ) ) * - CASE 22 WHEN - 35 + - COUNT ( * ) * - COUNT ( - 53 ) THEN 72 END + ( 4 - 37 )
-----
-NULL
query I rowsort
SELECT DISTINCT + - 20 col0
diff --git a/data/sqlite/random/expr/slt_good_34.slt b/data/sqlite/random/expr/slt_good_34.slt
index 67db2c7..b4c4a0a 100644
--- a/data/sqlite/random/expr/slt_good_34.slt
+++ b/data/sqlite/random/expr/slt_good_34.slt
@@ -44626,10 +44626,10 @@
----
0
-query I rowsort label-8487
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -69
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + ( - 69 ), + 81 / - 0 ) col1
-----
--69
# Datafusion - Types were automatically converted from:
# Datafusion - [Expected] [I]
diff --git a/data/sqlite/random/expr/slt_good_36.slt b/data/sqlite/random/expr/slt_good_36.slt
index 429d3a6..d592f6c 100644
--- a/data/sqlite/random/expr/slt_good_36.slt
+++ b/data/sqlite/random/expr/slt_good_36.slt
@@ -43607,10 +43607,10 @@
----
-45
-query I rowsort label-8323
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -85
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( + 85, 77 / - + 0 )
-----
--85
query I rowsort label-8324
SELECT 39 / 79 - - ( - COUNT ( * ) ) * - CASE + 3 WHEN 44 + + COUNT ( * ) THEN NULL WHEN 61 THEN - + 37 END + + - 93
diff --git a/data/sqlite/random/expr/slt_good_38.slt b/data/sqlite/random/expr/slt_good_38.slt
index 92664da..a93b1e1 100644
--- a/data/sqlite/random/expr/slt_good_38.slt
+++ b/data/sqlite/random/expr/slt_good_38.slt
@@ -2596,10 +2596,10 @@
----
15
-query I rowsort label-488
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 42
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL COALESCE ( 42, - ( - 60 ) / ( - 0 ) + 5 / ( + 4 ) * 94 + 6 * COUNT ( * ) - - 66 * - 19 )
-----
-42
query I rowsort
SELECT - 6 + - - 30 + - 28 * - 11 AS col2
diff --git a/data/sqlite/random/expr/slt_good_39.slt b/data/sqlite/random/expr/slt_good_39.slt
index d1d337d..7e0cbf2 100644
--- a/data/sqlite/random/expr/slt_good_39.slt
+++ b/data/sqlite/random/expr/slt_good_39.slt
@@ -47283,10 +47283,10 @@
----
690
-query I rowsort label-9020
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 390188
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + CAST ( - CAST ( + 56 AS INTEGER ) AS INTEGER ) * - - 86 * - COALESCE ( + + 81, 75 / 0 ) - - 92 AS col2
-----
-390188
query I rowsort label-9021
SELECT ALL + 31 * - COUNT ( * ) * - + 6 - COUNT ( * ) / 55
diff --git a/data/sqlite/random/expr/slt_good_4.slt b/data/sqlite/random/expr/slt_good_4.slt
index cc73b2f..35e223e 100644
--- a/data/sqlite/random/expr/slt_good_4.slt
+++ b/data/sqlite/random/expr/slt_good_4.slt
@@ -35148,10 +35148,10 @@
----
-4032
-query I rowsort label-6676
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 7
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + ( - COALESCE ( + - 7, + 98 + + 54 - ( + + 36 ) / + + 0 * - NULLIF ( CASE - ( NULLIF ( + 62, - + 20 ) ) WHEN + - MAX ( - + 22 ) + 35 THEN + MIN ( 71 ) END, COUNT ( * ) + CAST ( NULL AS INTEGER ) ) / + 32, - 60 ) ) col2
-----
-7
query II rowsort
SELECT DISTINCT 99 * - 36, 19 col0
diff --git a/data/sqlite/random/expr/slt_good_41.slt b/data/sqlite/random/expr/slt_good_41.slt
index c7037ca..5e35523 100644
--- a/data/sqlite/random/expr/slt_good_41.slt
+++ b/data/sqlite/random/expr/slt_good_41.slt
@@ -42674,10 +42674,10 @@
query error DataFusion error: Error during planning: Projections require unique expression names but the expression "Int64\(89\) AS col1" at position 0 and "nullif\(\(\- nullif\(Int64\(79\), \(\- Int64\(75\)\)\)\), CAST\(NULL AS Float64\) / count\(Int64\(1\)\) AS count\(\*\)\) AS col1" at position 1 have the same name\. Consider aliasing \("AS"\) one of them\.
SELECT 89 AS col1, + NULLIF ( - NULLIF ( + 79, - + 75 ), CAST ( NULL AS FLOAT8 ) / COUNT ( * ) ) AS col1
-query I rowsort label-8139
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -62527
+query error DataFusion error: Arrow error: Divide by zero error
SELECT 12 * - - 79 * - + 66 + + 62 + CAST ( + - NULLIF ( SUM ( + - 21 ), 56 + - - 43 ) AS INTEGER ) + + - COALESCE ( + 42, + 10 / + COUNT ( * ) + - COUNT ( * ) - + + 41 + + CASE - COUNT ( * ) WHEN MIN ( DISTINCT 7 ) THEN - 37 * COUNT ( * ) ELSE 40 END / + COALESCE ( + CASE WHEN COALESCE ( - 78, + CAST ( NULL AS FLOAT8 ) - 32, ( + COUNT ( * ) ) ) IS NOT NULL THEN NULL ELSE CASE COUNT ( * ) WHEN + 15 THEN - 72 + 11 END END, 8 / + 79 ) / 93 ) AS col0
-----
--62527
query I rowsort
SELECT 75 + - 67
diff --git a/data/sqlite/random/expr/slt_good_44.slt b/data/sqlite/random/expr/slt_good_44.slt
index 6051b88..92f5f79 100644
--- a/data/sqlite/random/expr/slt_good_44.slt
+++ b/data/sqlite/random/expr/slt_good_44.slt
@@ -16154,10 +16154,10 @@
27
61
-query I rowsort label-3089
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -2630
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + COALESCE ( + + 40, + 14 + - + 93, 58, + 56 / MAX ( DISTINCT - 19 / 91 ) ) / COUNT ( * ) - 30 * 89
-----
--2630
query I rowsort
SELECT ALL + COALESCE ( - 67, - 72 + + 24 * + + COALESCE ( - + 32, - 85, - 46, 82 ) ) AS col1
@@ -21294,10 +21294,10 @@
----
77
-query I rowsort label-4060
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -4788
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 57 * + - COALESCE ( MIN ( - 84 ), - 33, + CASE - 19 WHEN COALESCE ( - 52, - 55 ) + 84 * - 36 / + 51 * + 1 THEN 70 ELSE - ( + 87 ) / 58 * - + 81 * - - 11 / - 0 END ) AS col2
-----
--4788
query I rowsort
SELECT + ( + 78 ) AS col2
diff --git a/data/sqlite/random/expr/slt_good_45.slt b/data/sqlite/random/expr/slt_good_45.slt
index a920d7d..c9f59c0 100644
--- a/data/sqlite/random/expr/slt_good_45.slt
+++ b/data/sqlite/random/expr/slt_good_45.slt
@@ -18011,10 +18011,10 @@
----
77
-query I rowsort label-3419
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 52
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT COUNT ( * ) + + COALESCE ( + 1, + ( + 47 ) / - 0 / 63 + - + COUNT ( * ), 0 ) + 50 AS col1
-----
-52
query I rowsort label-3420
SELECT ALL + COUNT ( * ) + - COUNT ( * )
diff --git a/data/sqlite/random/expr/slt_good_47.slt b/data/sqlite/random/expr/slt_good_47.slt
index 37e2f29..cb5734c 100644
--- a/data/sqlite/random/expr/slt_good_47.slt
+++ b/data/sqlite/random/expr/slt_good_47.slt
@@ -48039,10 +48039,10 @@
78
-9
-query I rowsort label-9161
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -612
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - ( COALESCE ( + 34, - 94 / - 61 * COALESCE ( + 60, - - COUNT ( * ) ) * + COUNT ( * ) + + 49 + - 61 + - 91 / NULLIF ( - 66 / 74, + 50 ), - NULLIF ( + 38, 4 * 41 ) ) ) * + 18
-----
--612
query II rowsort label-9162
SELECT ALL + MAX ( - 28 ) AS col0, - ( + 76 ) / + NULLIF ( + 96, + 79 ) * + - 46
diff --git a/data/sqlite/random/expr/slt_good_49.slt b/data/sqlite/random/expr/slt_good_49.slt
index 4d20235..df8e5c0 100644
--- a/data/sqlite/random/expr/slt_good_49.slt
+++ b/data/sqlite/random/expr/slt_good_49.slt
@@ -37850,10 +37850,10 @@
----
5576
-query I rowsort label-7205
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -86240
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( 28, - 72 + COUNT ( * ) / 0 ) * - MAX ( ALL + 70 ) * + 44 * 1
-----
--86240
query I rowsort
SELECT ALL 15 * - 9
diff --git a/data/sqlite/random/expr/slt_good_5.slt b/data/sqlite/random/expr/slt_good_5.slt
index 0f7fe9e..c1e1c0f 100644
--- a/data/sqlite/random/expr/slt_good_5.slt
+++ b/data/sqlite/random/expr/slt_good_5.slt
@@ -51278,10 +51278,10 @@
----
-4590
-query I rowsort label-9743
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -14
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( + 14, 76 + - 47, + MIN ( ALL - 17 ), - - 14 / 0 ) AS col2
-----
--14
query I rowsort label-9744
SELECT + CASE - - 17 WHEN + - 29 THEN - 23 * + + 33 + - + CAST ( - MAX ( DISTINCT + + 77 ) AS INTEGER ) * - 88 WHEN AVG ( + 76 ) + + - 37 THEN - 57 * + 60 ELSE + 35 END * - 41 - 46 + - - 66 + 96 * + 94 - + ( ( - NULLIF ( 31, - + CAST ( NULL AS INTEGER ) * + 68 ) ) )
diff --git a/data/sqlite/random/expr/slt_good_50.slt b/data/sqlite/random/expr/slt_good_50.slt
index 0ec424a..f923774 100644
--- a/data/sqlite/random/expr/slt_good_50.slt
+++ b/data/sqlite/random/expr/slt_good_50.slt
@@ -31836,10 +31836,10 @@
----
11997720
-query I rowsort label-6070
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -20
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - COALESCE ( 20, 2 / + ( - 0 ) / - + ( + 3 ) + - 85 + + + 35, - 36 * + 42 + - 23 * 45, 44 * + ( + CASE 1 WHEN + CAST ( + 99 AS INTEGER ) THEN NULL ELSE + ( + 32 ) * 74 END ) ) AS col2
-----
--20
query I rowsort label-6071
SELECT CASE + 29 WHEN + 54 + ( + 19 ) * - 60 * 97 + CAST ( NULL AS INTEGER ) THEN 12 WHEN 58 THEN - 41 - 72 * 85 ELSE NULL END
diff --git a/data/sqlite/random/expr/slt_good_55.slt b/data/sqlite/random/expr/slt_good_55.slt
index 50ea41e..206d08b 100644
--- a/data/sqlite/random/expr/slt_good_55.slt
+++ b/data/sqlite/random/expr/slt_good_55.slt
@@ -39171,10 +39171,10 @@
----
3
-query I rowsort label-7464
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -46
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COUNT ( + 72 ) + - COALESCE ( - - 47, + ( - - ( + 49 ) ) / + ( - 18 ) - - + ( COUNT ( * ) ) / 0 + - + 79 * - 9 + + + 9 * 98, - + 30 ) AS col2
-----
--46
query I rowsort label-7465
SELECT DISTINCT + + SUM ( + + 85 ) * + 1 * + COUNT ( * ) * 81
diff --git a/data/sqlite/random/expr/slt_good_56.slt b/data/sqlite/random/expr/slt_good_56.slt
index 6239de4..6390ec9 100644
--- a/data/sqlite/random/expr/slt_good_56.slt
+++ b/data/sqlite/random/expr/slt_good_56.slt
@@ -7822,10 +7822,10 @@
35
-7740
-query I rowsort label-1487
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 3398
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( 42, + - COALESCE ( - 57, - CASE - 42 WHEN - 8 / + 0 + 94 THEN NULL WHEN 83 * COUNT ( * ) THEN 31 END, COUNT ( DISTINCT 20 ) * - 62 ) + + CAST ( 67 AS INTEGER ) ) + MIN ( ALL + 43 ) * 80
-----
-3398
query I rowsort
SELECT DISTINCT + 53 * 33 AS col0
@@ -8128,10 +8128,10 @@
----
29
-query I rowsort label-1546
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 79
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - COALESCE ( - 79, 80 + + COUNT ( * ) + 76 + + 15 / + - 20 * 81 / 0 - 18, - 27 ) AS col1
-----
-79
query I rowsort
SELECT 99 + + 14
@@ -38967,10 +38967,10 @@
----
-46
-query I rowsort label-7413
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 95 / COUNT ( * ) - + COUNT ( * ) - + + 92 * + CASE - 46 WHEN + - NULLIF ( + CASE + + NULLIF ( - - 56, 80 * + 32 / + COUNT ( * ) - 80 + + 93 ) WHEN + - ( + - 15 ) + - COALESCE ( + 21, + COALESCE ( - 40, - COALESCE ( - ( + - 17 ), - 41 ) * 71 ) ) + - MIN ( 85 ) + - - COUNT ( * ) + - COALESCE ( + 42, 63 * + COUNT ( * ) + + 71 / SUM ( ALL 41 / + 51 ) + - COUNT ( DISTINCT 92 - 61 ) ) * 60 THEN 55 * + 38 + + CAST ( NULL AS INTEGER ) WHEN AVG ( DISTINCT - 29 ) THEN 46 - + 76 END, + ( - 73 ) * + 49 - 9 ) THEN 13 WHEN 78 THEN NULL END AS col0
-----
-NULL
query I rowsort
SELECT + 27 * + 75 AS col1
diff --git a/data/sqlite/random/expr/slt_good_57.slt b/data/sqlite/random/expr/slt_good_57.slt
index a42f84c..a29f348 100644
--- a/data/sqlite/random/expr/slt_good_57.slt
+++ b/data/sqlite/random/expr/slt_good_57.slt
@@ -47250,10 +47250,12 @@
----
56
-query I rowsort label-9006
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 98
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( COUNT ( * ), + 89 / + 0 ) * 72 + + 26 col0
-----
-98
query I rowsort label-9007
SELECT MAX ( - 61 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_58.slt b/data/sqlite/random/expr/slt_good_58.slt
index d83fdd5..b3e0a52 100644
--- a/data/sqlite/random/expr/slt_good_58.slt
+++ b/data/sqlite/random/expr/slt_good_58.slt
@@ -16810,11 +16810,11 @@
----
NULL
-query II rowsort label-3203
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 68
+# Datafusion - Expected - 1
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 68, + ( MAX ( ALL + 99 ) ) + + - COALESCE ( CAST ( 98 AS INTEGER ), + 20 + ( COALESCE ( 7, NULLIF ( + 74, 54 ) * 1 ) + - 20 ) / 0 ) AS col0
-----
-68
-1
query I rowsort label-3204
SELECT - - MAX ( DISTINCT 35 ) * + + ( - NULLIF ( - MIN ( CAST ( 74 AS INTEGER ) ), + 90 + ( - 45 ) * - ( + 73 ) ) )
diff --git a/data/sqlite/random/expr/slt_good_6.slt b/data/sqlite/random/expr/slt_good_6.slt
index 835044a..a863560 100644
--- a/data/sqlite/random/expr/slt_good_6.slt
+++ b/data/sqlite/random/expr/slt_good_6.slt
@@ -9179,10 +9179,10 @@
----
-66
-query I rowsort label-1736
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 3828
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + + 58, + + 21 / 56, + 1 * 99 * + COALESCE ( 93, - - 80, 87 / 0 + + ( - MAX ( + 83 ) ) ) + - 15 + - - 85 ) * 66 AS col2
-----
-3828
query I rowsort label-1737
SELECT ALL 6 * - CAST ( NULL AS INTEGER ) / - 54 * + 24
@@ -13435,10 +13435,10 @@
----
-147
-query I rowsort label-2550
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -127
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 86 - + 41 + - ( - 18 ) / + + COALESCE ( - + 68, - + 99, + COALESCE ( ( - 45 ), CAST ( - 15 AS INTEGER ) * + 7 + COUNT ( DISTINCT 7 ) ) / 0 + - 13 )
-----
--127
query I rowsort
SELECT ALL 98 * - 97 * 58 * + 25
@@ -51632,10 +51632,10 @@
----
1537
-query I rowsort label-9804
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -15
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( - - 15, + COUNT ( * ) / + 0, - 60 / 40 ) AS col2
-----
--15
query I rowsort label-9805
SELECT ALL MIN ( 77 ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_60.slt b/data/sqlite/random/expr/slt_good_60.slt
index 3ec0678..fc9eaea 100644
--- a/data/sqlite/random/expr/slt_good_60.slt
+++ b/data/sqlite/random/expr/slt_good_60.slt
@@ -17357,10 +17357,10 @@
----
-27
-query I rowsort label-3303
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 697
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( COALESCE ( 41, + COUNT ( * ), + 6 / + 0 * - - NULLIF ( - + COUNT ( * ), 14 * 27 - COUNT ( * ) ) * + 26 + + 82, - 54 ), + 64 * COUNT ( * ), - 87 / + 80 ) * 17 AS col0
-----
-697
query I rowsort
SELECT + 53 + - 21 * + + 22 col1
diff --git a/data/sqlite/random/expr/slt_good_61.slt b/data/sqlite/random/expr/slt_good_61.slt
index b01cc05..d15a501 100644
--- a/data/sqlite/random/expr/slt_good_61.slt
+++ b/data/sqlite/random/expr/slt_good_61.slt
@@ -15909,10 +15909,10 @@
----
94
-query I rowsort label-3026
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -22
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - CAST ( + + COALESCE ( 22, - 21 / 12 / - 69, COUNT ( * ) / + - 0 * - 6 + 6 ) AS INTEGER ) AS col1
-----
--22
query I rowsort
SELECT - 33 * 76
diff --git a/data/sqlite/random/expr/slt_good_62.slt b/data/sqlite/random/expr/slt_good_62.slt
index 8aa60df..5b27582 100644
--- a/data/sqlite/random/expr/slt_good_62.slt
+++ b/data/sqlite/random/expr/slt_good_62.slt
@@ -21891,10 +21891,10 @@
-9
1003
-query I rowsort label-4169
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT CASE + 43 WHEN COALESCE ( - 48, 22, - - 27 * 86 - - ( 98 ) / - 0 + - CASE - - ( + + 60 ) WHEN + + 24 THEN COALESCE ( + ( - ( + COUNT ( * ) ) ), - COALESCE ( + ( - + ( + 90 ) ), + 99 ) / - 89 * - 99 ) WHEN + 14 + 12 * - - 13 THEN NULL WHEN ( - + 27 ) + + + 80 / + - 16 THEN + 72 ELSE + COUNT ( * ) + 86 END - 76 * + 94 ) THEN 59 / - 60 END * 11 AS col2
-----
-NULL
query I rowsort label-4170
SELECT DISTINCT + 0 - + CAST ( 11 AS INTEGER ) col2
diff --git a/data/sqlite/random/expr/slt_good_63.slt b/data/sqlite/random/expr/slt_good_63.slt
index 38c72ac..4a5774a 100644
--- a/data/sqlite/random/expr/slt_good_63.slt
+++ b/data/sqlite/random/expr/slt_good_63.slt
@@ -24087,10 +24087,10 @@
107
37
-query I rowsort label-4567
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 1218
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( 87, - - ( + - 78 ) / - 0 * 81 * - + 37 ) * - 14 AS col1
-----
-1218
query I rowsort
SELECT DISTINCT - 63 * - NULLIF ( - 21, + 65 + - - 87 - - 29 ) AS col1
@@ -52429,10 +52429,10 @@
----
NULL
-query I rowsort label-9973
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -1534
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 70 * + 21 + - 13 / - + COALESCE ( - COALESCE ( + 54, + 13 + + 93 / 33 / ( 26 / 99 ) ), SUM ( DISTINCT 47 ), 29 ) * COUNT ( + 85 ) - + 64 AS col0
-----
--1534
# Datafusion - Datafusion expected results:
# Datafusion - Expected - 47
diff --git a/data/sqlite/random/expr/slt_good_64.slt b/data/sqlite/random/expr/slt_good_64.slt
index d3a9bfa..65429b7 100644
--- a/data/sqlite/random/expr/slt_good_64.slt
+++ b/data/sqlite/random/expr/slt_good_64.slt
@@ -6022,10 +6022,10 @@
----
81
-query I rowsort label-1141
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 6114
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 40 * - 12 - - MIN ( 33 ) - + - 0 + + COUNT ( * ) + - + ( + + 0 ) + + - 70 * + - COALESCE ( - CAST ( - CASE 20 WHEN + 44 THEN 60 WHEN COUNT ( * ) * + + CASE + 1 WHEN + 75 - - 95 THEN + 46 WHEN + + 5 THEN + 56 ELSE - 6 END + 0 THEN NULL END AS INTEGER ), 80, - - 95 * - - 86 + - 16 + - + 74 / - 0 ) + - + 1 / + 83
-----
-6114
query I rowsort
SELECT ALL + ( + + 99 ) * + 84
diff --git a/data/sqlite/random/expr/slt_good_66.slt b/data/sqlite/random/expr/slt_good_66.slt
index 3d45774..1abd107 100644
--- a/data/sqlite/random/expr/slt_good_66.slt
+++ b/data/sqlite/random/expr/slt_good_66.slt
@@ -2258,10 +2258,10 @@
----
19
-query I rowsort label-420
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -3344
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL - COALESCE ( - 38, + 95 / - - 0 + + ( + 6 ) ) * + COUNT ( * ) * - + 88
-----
--3344
query I rowsort label-421
SELECT + ( COUNT ( ALL + COALESCE ( - - 11, + + 19 ) ) ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_67.slt b/data/sqlite/random/expr/slt_good_67.slt
index 7366cf6..f8e541b 100644
--- a/data/sqlite/random/expr/slt_good_67.slt
+++ b/data/sqlite/random/expr/slt_good_67.slt
@@ -986,11 +986,13 @@
----
NULL
-query II rowsort label-180
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -98
+# Datafusion - Expected - -1829
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 4 + - 94, + CASE + + 25 WHEN - 56 + COUNT ( * ) - + 5 + + 47 * - 0 / + + CASE + AVG ( 34 ) WHEN - 6 * 70 + 87 * + - CAST ( NULL AS INTEGER ) THEN NULL ELSE - CAST ( 79 AS INTEGER ) END + 63 THEN NULL ELSE - ( + 31 ) * + COALESCE ( 59, 36 + + 52 ) END - 70 / - COALESCE ( - MAX ( DISTINCT 12 ) * + 51, 16 / ( - 74 * 0 ), - 56, + 87 ) col1
-----
--98
--1829
query II rowsort
SELECT + 74 * 23 AS col1, - 44 * 12 AS col0
@@ -19682,11 +19684,11 @@
----
-81
-query II rowsort label-3744
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -80
+# Datafusion - Expected - -1
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + 24 / + 50 * + - 71 + - 80 col2, + COALESCE ( 68, - 34 / + + 0 / + COUNT ( * ) + 12 * 92 ) / - 41 + 6 / + 26
-----
--80
--1
query I rowsort label-3745
SELECT ALL + 41 / + 44 + + - 91 + - 9
@@ -23811,11 +23813,11 @@
----
8
-query II rowsort label-4521
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -83
+# Datafusion - Expected - 322056
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - ( + 83 ) AS col1, 72 * + ( - - 63 ) * COALESCE ( 71, + 73 / - 0 + 8 ) col0
-----
--83
-322056
query I rowsort label-4522
SELECT - 65 * ( + SUM ( ALL 98 ) ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_68.slt b/data/sqlite/random/expr/slt_good_68.slt
index 73db0b8..a12df57 100644
--- a/data/sqlite/random/expr/slt_good_68.slt
+++ b/data/sqlite/random/expr/slt_good_68.slt
@@ -6358,10 +6358,12 @@
----
672
-query I rowsort label-1205
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -319
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + - COALESCE ( - COUNT ( * ), 8 / + 0 ) + + ( 8 ) * - 40 AS col2
-----
--319
query I rowsort label-1206
SELECT ALL - - 39 + - ( + 89 + CAST ( NULL AS INTEGER ) )
diff --git a/data/sqlite/random/expr/slt_good_69.slt b/data/sqlite/random/expr/slt_good_69.slt
index cb35dbf..57e6668 100644
--- a/data/sqlite/random/expr/slt_good_69.slt
+++ b/data/sqlite/random/expr/slt_good_69.slt
@@ -30800,10 +30800,10 @@
----
-232
-query I rowsort label-5864
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -77
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + - MIN ( 77 ), - + ( + - CASE + 57 WHEN + + 24 + + 53 + - COUNT ( * ) / + 0 * - 64 * + + COUNT ( * ) THEN NULL WHEN ( + 24 ) THEN 0 END ), - + CAST ( + 36 AS INTEGER ) - - 64 + + 91 ) AS col1
-----
--77
# Datafusion - Types were automatically converted from:
# Datafusion - [Expected] [I]
diff --git a/data/sqlite/random/expr/slt_good_7.slt b/data/sqlite/random/expr/slt_good_7.slt
index d66d788..90b141a 100644
--- a/data/sqlite/random/expr/slt_good_7.slt
+++ b/data/sqlite/random/expr/slt_good_7.slt
@@ -27781,10 +27781,10 @@
----
1748
-query I rowsort label-5282
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + CASE - 73 WHEN - + COALESCE ( + - 58, + + 42 + CASE + + 1 WHEN + - COUNT ( * ) * COUNT ( * ) THEN NULL ELSE + 67 / 0 END - ( + 11 ) * - 86 ) + 43 / - 81 THEN - 4 WHEN ( ( + ( - COUNT ( + 35 ) ) ) ) * - COALESCE ( - 99, - COALESCE ( - 85, - 6 + + 31 * 53 ) ) THEN + 64 END AS col0
-----
-NULL
query I rowsort label-5283
SELECT ALL 69 / - 16 AS col1
diff --git a/data/sqlite/random/expr/slt_good_72.slt b/data/sqlite/random/expr/slt_good_72.slt
index 6fece06..af07f77 100644
--- a/data/sqlite/random/expr/slt_good_72.slt
+++ b/data/sqlite/random/expr/slt_good_72.slt
@@ -43719,10 +43719,12 @@
----
-1850
-query I rowsort label-8329
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -42
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( + MIN ( ALL - 42 ), + 11 / + 0, + 62 ) AS col1
-----
--42
query I rowsort label-8330
SELECT CASE 13 WHEN - + 96 * + 74 / + CASE - + 92 WHEN COALESCE ( + 75, - 88 * + 14 ) THEN 95 * - 25 + - 8 WHEN + COUNT ( * ) / CASE AVG ( + + CAST ( NULL AS INTEGER ) ) WHEN - 85 THEN 80 * COALESCE ( + 97 + 82, 25 ) WHEN - 97 THEN NULL ELSE COUNT ( + 50 ) END THEN NULL WHEN 45 THEN 73 / CAST ( 27 / + 92 AS INTEGER ) + + 81 END + - 28 THEN COUNT ( * ) + - 43 ELSE 16 + - 82 END col0
diff --git a/data/sqlite/random/expr/slt_good_75.slt b/data/sqlite/random/expr/slt_good_75.slt
index cbdfcc4..c48f176 100644
--- a/data/sqlite/random/expr/slt_good_75.slt
+++ b/data/sqlite/random/expr/slt_good_75.slt
@@ -46078,10 +46078,10 @@
----
58
-query I rowsort label-8769
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -111
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 72 + - COALESCE ( - - SUM ( DISTINCT + + 39 ), 49, 5 - + + 80 + - 39 / - - ( 0 ) / + + 60 )
-----
--111
query I rowsort label-8770
SELECT SUM ( DISTINCT + - 21 ) AS col2
diff --git a/data/sqlite/random/expr/slt_good_77.slt b/data/sqlite/random/expr/slt_good_77.slt
index 5c055d8..7cc1282 100644
--- a/data/sqlite/random/expr/slt_good_77.slt
+++ b/data/sqlite/random/expr/slt_good_77.slt
@@ -40796,10 +40796,12 @@
3182
64
-query I rowsort label-7782
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -16384
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL ( + 73 ) + - + 92 * - 97 + COALESCE ( + ( + NULLIF ( + 75, - MIN ( ALL + + 53 ) ) ), + ( - CASE - - 73 WHEN COALESCE ( - + 51, - 26 ) / + 0 THEN COUNT ( * ) * 14 END ), + COUNT ( * ) / + 3, + COUNT ( ALL 73 ) ) + - 86 * ( 8 ) * + 37 AS col1
-----
--16384
query I rowsort label-7783
SELECT CAST ( NULL AS INTEGER ) + - 95 + + + 55 + - 11 AS col0
diff --git a/data/sqlite/random/expr/slt_good_78.slt b/data/sqlite/random/expr/slt_good_78.slt
index f9c04c6..01cbff1 100644
--- a/data/sqlite/random/expr/slt_good_78.slt
+++ b/data/sqlite/random/expr/slt_good_78.slt
@@ -6891,10 +6891,10 @@
----
-166
-query I rowsort label-1307
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 36
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + COUNT ( * ) + + COALESCE ( + 35, + 77 / ( - 0 ) + + 20 - COUNT ( * ) + - - 81 + + 86 ) AS col0
-----
-36
query II rowsort
SELECT ALL + 45, 62 * 55 AS col0
diff --git a/data/sqlite/random/expr/slt_good_79.slt b/data/sqlite/random/expr/slt_good_79.slt
index 3b6cd7a..b704641 100644
--- a/data/sqlite/random/expr/slt_good_79.slt
+++ b/data/sqlite/random/expr/slt_good_79.slt
@@ -34126,10 +34126,10 @@
----
806
-query I rowsort label-6501
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 3197
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + + 55 * + COALESCE ( 68, - 29 + - - 53 + ( + 4 ) / + 0 * + 31 ) + - + CASE - 71 WHEN - + 72 THEN NULL ELSE - 45 END - + - ( - + COALESCE ( 27, - 65 * + 85, + 92 ) ) * - 25 * + - COUNT ( * ) + 88 + + - COUNT ( * )
-----
-3197
query I rowsort label-6502
SELECT ALL - - 56 * + - 86 + - ( + 14 ) + COUNT ( * ) + 14 + 55 - NULLIF ( - COALESCE ( COUNT ( DISTINCT + - ( - + 38 ) ), - 62 / + COUNT ( * ) + - 55 * - COUNT ( * ) ), 4 * + 55 + - + 88 * + 17 ) / - 27 / + 15 / 8
diff --git a/data/sqlite/random/expr/slt_good_8.slt b/data/sqlite/random/expr/slt_good_8.slt
index 4e30958..903e919 100644
--- a/data/sqlite/random/expr/slt_good_8.slt
+++ b/data/sqlite/random/expr/slt_good_8.slt
@@ -47910,10 +47910,10 @@
----
36
-query I rowsort label-9094
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 2132
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - 86 * - NULLIF ( 25, - 43 * + + 91 * - 54 - + ( + 19 ) * + 44 ) - 76 + - CAST ( - + COALESCE ( + + 58, - - 9 / COUNT ( * ) * + ( + 15 ) / + 0 / - + COALESCE ( - COALESCE ( - 0, 61 * - 99 ), 15 ) + + 99 * - 43, - 28 * + 33 + + COUNT ( * ) * + 11, - 8 * + + 5 + - - 73 + 5 ) AS INTEGER ) + COUNT ( * ) * + 60 / - SUM ( 94 )
-----
-2132
query I rowsort label-9095
SELECT + COUNT ( DISTINCT 56 ) * 97 / + 41 col1
diff --git a/data/sqlite/random/expr/slt_good_80.slt b/data/sqlite/random/expr/slt_good_80.slt
index 5cfea3e..1df89bb 100644
--- a/data/sqlite/random/expr/slt_good_80.slt
+++ b/data/sqlite/random/expr/slt_good_80.slt
@@ -14872,10 +14872,10 @@
-1
-64
-query I rowsort label-2832
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 1
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - CASE - - COALESCE ( + - 32, - 41 + 89 / - + CASE - - 3 WHEN - 29 * + + SUM ( 99 ) THEN NULL ELSE + 40 / ( + 46 ) END, NULLIF ( + + 49, 56 ) * - COALESCE ( + 11, + COUNT ( * ) ) ) WHEN COUNT ( * ) THEN NULL WHEN - 87 THEN NULL ELSE + - ( - 50 ) / - - COALESCE ( + 60, + + ( CAST ( NULL AS INTEGER ) ) + 61 ) * + CAST ( 95 / - 55 + - 84 AS INTEGER ) - COUNT ( * ) END AS col0
-----
-1
query I rowsort label-2833
SELECT ALL + 4 / + 5 - + 21 col1
diff --git a/data/sqlite/random/expr/slt_good_81.slt b/data/sqlite/random/expr/slt_good_81.slt
index 572efdf..6b0ce97 100644
--- a/data/sqlite/random/expr/slt_good_81.slt
+++ b/data/sqlite/random/expr/slt_good_81.slt
@@ -17184,11 +17184,11 @@
----
-383520
-query II rowsort label-3273
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 37
+# Datafusion - Expected - -592
+query error DataFusion error: Arrow error: Divide by zero error
SELECT 37 AS col0, 8 * - COALESCE ( + 74, COUNT ( * ) * ( COALESCE ( + MAX ( DISTINCT - 51 ), - 77 + CASE + - 8 WHEN - CAST ( NULL AS INTEGER ) * - 44 THEN NULL WHEN - - COALESCE ( + + 5, - 86, + ( 67 ) ) THEN NULL ELSE + - 58 * - + NULLIF ( + 51, COUNT ( * ) ) - + COUNT ( * ) END, + 26 * - + 99 * COUNT ( * ) / - 0 + SUM ( 8 ) ) ) + + + ( - 68 ) )
-----
-37
--592
query I rowsort label-3274
SELECT + + COUNT ( * ) * 84 * - + COUNT ( * )
@@ -18213,10 +18213,10 @@
----
85
-query I rowsort label-3474
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 966
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + 42 * + COALESCE ( + 23, - MIN ( ALL 35 ) / 0, 25 + 54 ) AS col1
-----
-966
query I rowsort label-3475
SELECT ALL + MAX ( ALL - 35 ) - - 18
@@ -22204,10 +22204,10 @@
----
-1
-query I rowsort label-4237
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -9676
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 32 * 63 + + + COALESCE ( - ( + 52 ), + COALESCE ( CAST ( + 95 AS INTEGER ), 23 - - - MIN ( DISTINCT - - 25 ), + COUNT ( * ) * 43 + + - COUNT ( * ) - - 0, + ( CASE + 59 WHEN 69 THEN - 41 WHEN + 97 THEN NULL END ) * + 44 ) * - COUNT ( * ) ) + - 10 * + + COALESCE ( 12, COUNT ( * ) + - 78 * + NULLIF ( - NULLIF ( 88, + 14 + - COUNT ( * ) ) / 0, 87 + 71 ), - 86 ) * 97
-----
--9676
query I rowsort label-4238
SELECT CAST ( + 43 AS INTEGER ) / - + MIN ( DISTINCT - - 21 ) * - CASE 35 WHEN + + CAST ( NULL AS INTEGER ) THEN - 51 ELSE NULL END + 47 * + - ( - - 53 ) - - 64 AS col2
diff --git a/data/sqlite/random/expr/slt_good_82.slt b/data/sqlite/random/expr/slt_good_82.slt
index 90133e9..585b6ef 100644
--- a/data/sqlite/random/expr/slt_good_82.slt
+++ b/data/sqlite/random/expr/slt_good_82.slt
@@ -2589,11 +2589,11 @@
----
0
-query II rowsort label-494
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -5742
+# Datafusion - Expected - 22
+query error DataFusion error: Arrow error: Divide by zero error
SELECT 99 * + COALESCE ( + - 58, + COUNT ( * ) * - + 30 / + 0 - + + 93 + - 6 ), 22 AS col2
-----
--5742
-22
query I rowsort
SELECT COALESCE ( ( + 85 ), 92 ) col2
@@ -46023,10 +46023,10 @@
----
-5821
-query I rowsort label-8766
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -7
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( 7, + - 51 * 69 / 93 / + 0, + 25 * + - MAX ( - - 27 ) ) AS col0
-----
--7
query I rowsort
SELECT - 71 * - - 24
@@ -46365,10 +46365,10 @@
----
-1
-query I rowsort label-8830
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + CASE + - 26 WHEN - - 58 THEN + + 86 + + - ( - ( + COUNT ( * ) ) ) WHEN + - 59 + + COALESCE ( + 50, ( 95 ) - + CASE - CASE + 75 WHEN SUM ( + 84 ) / CAST ( COUNT ( - CAST ( NULL AS INTEGER ) ) AS INTEGER ) THEN NULL ELSE 62 - - MAX ( ALL 13 ) * 42 END WHEN - ( - 45 ) + 86 THEN NULL WHEN + 21 + 98 THEN NULL ELSE COALESCE ( 90, 3 + 6, - 33 / + 86 ) END, + AVG ( DISTINCT - 20 ) - COUNT ( * ) / - 35 ) * 79 THEN NULL END AS col1
-----
-NULL
query I rowsort
SELECT DISTINCT - + 34 * - 47 AS col0
diff --git a/data/sqlite/random/expr/slt_good_83.slt b/data/sqlite/random/expr/slt_good_83.slt
index ecb9242..d97e919 100644
--- a/data/sqlite/random/expr/slt_good_83.slt
+++ b/data/sqlite/random/expr/slt_good_83.slt
@@ -8763,10 +8763,10 @@
----
2
-query I rowsort label-1663
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 309
+query error DataFusion error: Arrow error: Divide by zero error
SELECT 50 + - COUNT ( * ) + COALESCE ( + 10, + + ( - + 9 ), - 6 / 0 * + 71 - - - 70 ) * MAX ( 26 ) AS col0
-----
-309
query I rowsort label-1664
SELECT - NULLIF ( + COUNT ( * ), 38 ) * - 22 - - 67 / + 37 * + COUNT ( * ) AS col1
@@ -31847,10 +31847,10 @@
----
NULL
-query I rowsort label-6064
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -77
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + SUM ( ALL COALESCE ( + 22, 45 * 1, - NULLIF ( + - 20, - + 73 + + - 6 + 71 ) / - 0 ) ) + - 99 + - + 7 / + 86 AS col1
-----
--77
query I rowsort
SELECT ALL 93 * 36 col0
diff --git a/data/sqlite/random/expr/slt_good_84.slt b/data/sqlite/random/expr/slt_good_84.slt
index c2c42cc..599660b 100644
--- a/data/sqlite/random/expr/slt_good_84.slt
+++ b/data/sqlite/random/expr/slt_good_84.slt
@@ -12025,10 +12025,10 @@
----
48
-query I rowsort label-2285
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 5344
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( 71, + 18 * - - COUNT ( * ) + - + 24 / 0 + + COUNT ( * ) + 70, + ( + - 60 ) ) * 74 - ( - 90 ) AS col1
-----
-5344
query I rowsort label-2286
SELECT ALL - MIN ( ALL - - 18 ) AS col0
@@ -31569,13 +31569,12 @@
----
-32
-# Datafusion - Types were automatically converted from:
-# Datafusion - [Expected] [I]
-# Datafusion - [Actual ] [R]
-query R rowsort label-5996
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 273
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + 7 * + - NULLIF ( + CAST ( - 39 AS INTEGER ), + MAX ( - 44 ) + - 44 * COUNT ( + 57 ) * COALESCE ( - - CASE CASE - 23 WHEN COUNT ( * ) + COUNT ( * ) + 91 * NULLIF ( - 76, + 71 ) THEN NULL WHEN + 71 THEN + 26 + - - COUNT ( * ) END WHEN - - AVG ( ALL + 34 ) THEN MIN ( ALL 70 ) WHEN 65 THEN 64 * 49 * + + 89 WHEN - SUM ( + 78 ) THEN NULL ELSE CAST ( COALESCE ( COUNT ( * ), 57 + 91 / 48 ) AS FLOAT8 ) * 34 + + 91 * - 37 END, - 47 / 0 ) )
-----
-273
query II rowsort label-5997
SELECT + COALESCE ( 44, 85 + - + 69 + - - 9 + + - 69 * 21 * 17, + 64 + + COUNT ( * ) ) * - - 50 + ( 36 ) AS col2, 68 / + - 96 AS col0
@@ -49888,10 +49887,10 @@
----
13
-query I rowsort label-9484
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL CASE COUNT ( * ) WHEN - COUNT ( * ) - + 34 THEN NULL WHEN - 46 * 79 / CASE 33 WHEN - 25 * - 90 THEN - ( 70 ) END * - + CASE - CAST ( MIN ( ALL 45 ) AS INTEGER ) WHEN - 99 THEN NULL WHEN + - 61 THEN NULL ELSE 1 * - 43 END + 78 + + + 52 + - COUNT ( * ) + + 45 THEN NULL ELSE + CAST ( NULL AS INTEGER ) * - 50 * + 19 * - + 60 * - + COUNT ( * ) * + 6 + - - 51 END + 13 + + COALESCE ( - - 26, ( + 64 ), CASE + 43 WHEN - 75 / - 18 + + 82 * - - 23 / + + MIN ( DISTINCT 0 ) * 36 THEN 13 WHEN 6 THEN NULL END * + 81 ) AS col2
-----
-NULL
query I rowsort
SELECT ALL + + ( - 19 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_85.slt b/data/sqlite/random/expr/slt_good_85.slt
index b2a0708..77da884 100644
--- a/data/sqlite/random/expr/slt_good_85.slt
+++ b/data/sqlite/random/expr/slt_good_85.slt
@@ -473,10 +473,10 @@
-24
37
-query I rowsort label-84
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -84
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL COALESCE ( + - 84, - COUNT ( * ) / 0, - COUNT ( * ) )
-----
--84
query I rowsort label-85
SELECT ALL + NULLIF ( 90, - 5 * + + 99 * - 95 + + 33 + 70 ) / 82 * 54 * + + 87
@@ -48059,11 +48059,11 @@
----
45
-query II rowsort label-9148
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -132
+# Datafusion - Expected - 97
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - + 94 + - COALESCE ( + + 38, + + 23 + + + ( CAST ( 97 AS INTEGER ) ) * + COUNT ( * ) / - + 0 * + - 95 ) AS col2, 97
-----
--132
-97
query I rowsort label-9149
SELECT ALL 92 + + + 48 - 33 + - 0 + 9 / - 85 * + ( + 90 ) * 44 + - - 35 AS col0
diff --git a/data/sqlite/random/expr/slt_good_88.slt b/data/sqlite/random/expr/slt_good_88.slt
index d45a76d..5ade3af 100644
--- a/data/sqlite/random/expr/slt_good_88.slt
+++ b/data/sqlite/random/expr/slt_good_88.slt
@@ -30098,10 +30098,10 @@
----
NULL
-query I rowsort label-5713
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + 15 * - 79 + CASE SUM ( ALL - ( NULLIF ( - 89, - 61 ) ) ) WHEN - CASE + 55 WHEN 76 THEN - NULLIF ( 48, CAST ( - 59 AS INTEGER ) ) + - 61 WHEN - 92 THEN + 28 WHEN 91 THEN - 9 END / + 92 THEN 52 WHEN + 93 THEN NULL WHEN COALESCE ( CAST ( 25 AS INTEGER ), 11, - NULLIF ( - NULLIF ( NULLIF ( 78, 49 / ( + 21 / 49 ) ), COUNT ( * ) ), 55 * + 28 + + SUM ( DISTINCT 87 ) * + 12 ) / COALESCE ( + 40 - + 10 * 18, ( ( - ( AVG ( 30 ) ) ) ) ) + 18, 19 ) + - 98 * 44 THEN NULL END AS col1
-----
-NULL
query I rowsort label-5714
SELECT DISTINCT 28 * 56 - ( CASE CAST ( 55 AS INTEGER ) WHEN 60 * - 24 THEN 54 WHEN - 21 THEN + 27 WHEN - 56 THEN NULL ELSE SUM ( + 77 ) END ) col1
diff --git a/data/sqlite/random/expr/slt_good_89.slt b/data/sqlite/random/expr/slt_good_89.slt
index 3804ea4..c97b3e3 100644
--- a/data/sqlite/random/expr/slt_good_89.slt
+++ b/data/sqlite/random/expr/slt_good_89.slt
@@ -40035,10 +40035,10 @@
14
-57
-query I rowsort label-7632
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 363955750
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL 82 + COUNT ( * ) + - - CASE - 71 WHEN + 8 + 26 THEN NULL ELSE 74 END * + + 10 * CAST ( 99 AS INTEGER ) * + NULLIF ( + COALESCE ( + + 54, + 10 * - 6 / 0 ), - ( - 2 ) ) * 92 - + 13 AS col0
-----
-363955750
query II rowsort
SELECT ALL - 55, + 30 AS col2
diff --git a/data/sqlite/random/expr/slt_good_92.slt b/data/sqlite/random/expr/slt_good_92.slt
index bbf4d16..feac26b 100644
--- a/data/sqlite/random/expr/slt_good_92.slt
+++ b/data/sqlite/random/expr/slt_good_92.slt
@@ -615,13 +615,10 @@
----
77
-# Datafusion - Types were automatically converted from:
-# Datafusion - [Expected] [I]
-# Datafusion - [Actual ] [R]
-query R rowsort label-112
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 2477
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL ( + COALESCE ( - COUNT ( * ), - 56, + MAX ( ALL - 85 ), NULLIF ( 10, + 41 ) ) ) * + COUNT ( * ) + + 42 * ( COUNT ( * ) - NULLIF ( - MAX ( ALL 58 ), NULLIF ( COUNT ( * ), + 47 + + 16 ) * - COALESCE ( COALESCE ( + CAST ( - 9 AS FLOAT8 ), + COUNT ( * ) / ( + 18 / 68 ), + 67 ) * + 51 - + 62, 98 * + 81 + - COUNT ( * ) ) ) ) AS col1
-----
-2477
query I rowsort label-113
SELECT - MIN ( + 59 ) + 48 / - COUNT ( * )
@@ -3497,10 +3494,10 @@
----
20
-query I rowsort label-664
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -28
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT + + 92 + - + 83 + 39 - COALESCE ( 76, + - 7 / 0 * NULLIF ( - 49, - - NULLIF ( + 57, 96 / - COUNT ( * ) + COUNT ( * ) + 14 * 69 + + 76 + 21 ) * COUNT ( * ) - 25 ) * 18 + 79 )
-----
--28
query II rowsort
SELECT ALL - 40 * + 42 AS col2, + NULLIF ( 63, - 95 )
diff --git a/data/sqlite/random/expr/slt_good_93.slt b/data/sqlite/random/expr/slt_good_93.slt
index 7bf263d..fff84b5 100644
--- a/data/sqlite/random/expr/slt_good_93.slt
+++ b/data/sqlite/random/expr/slt_good_93.slt
@@ -18277,10 +18277,12 @@
----
946
-query I rowsort label-3473
+# Postgresql - Postgres error: db error: ERROR: division by zero
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 810
+skipif postgres
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - - COALESCE ( + + 15, + 80 ) * + 51 + 45 / + COALESCE ( + + COUNT ( * ), - 79 * - ( 83 / + 0 ) )
-----
-810
query I rowsort label-3474
SELECT ALL - + COUNT ( * ) * MIN ( ALL - 95 ) AS col2
@@ -27330,10 +27332,10 @@
----
1008
-query I rowsort label-5199
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 43
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + COALESCE ( + 43, - COALESCE ( - NULLIF ( + 48, + + 21 * 8 + + + 54 ), - - COUNT ( * ), - - 84 + COUNT ( * ) ) * - 99, + 7 - 24 / 0 ) * 1 col1
-----
-43
query I rowsort
SELECT NULLIF ( - 89, - - 8 / - 32 - + + 86 ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_94.slt b/data/sqlite/random/expr/slt_good_94.slt
index 8029981..84e0d85 100644
--- a/data/sqlite/random/expr/slt_good_94.slt
+++ b/data/sqlite/random/expr/slt_good_94.slt
@@ -30656,10 +30656,10 @@
----
0
-query I rowsort label-5829
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 0
+query error DataFusion error: Arrow error: Divide by zero error
SELECT ALL + COALESCE ( - 38, + 69 * 71 / - - 0 ) / - + ( - + COALESCE ( + - 86, - COUNT ( * ) ) ) col2
-----
-0
query I rowsort
SELECT + 73 + - 25 * + 2 * + 58 AS col2
diff --git a/data/sqlite/random/expr/slt_good_96.slt b/data/sqlite/random/expr/slt_good_96.slt
index f4bf651..a9749cc 100644
--- a/data/sqlite/random/expr/slt_good_96.slt
+++ b/data/sqlite/random/expr/slt_good_96.slt
@@ -2822,10 +2822,10 @@
----
-60
-query I rowsort label-532
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -65
+query error DataFusion error: Arrow error: Divide by zero error
SELECT - COALESCE ( 65, - - NULLIF ( + 24, + - CASE - COUNT ( * ) WHEN + - CASE + 94 WHEN - 7 / 0 + - 17 - + 14 THEN 77 WHEN COALESCE ( - CAST ( NULL AS INTEGER ), 84, + 40 ) + ( 37 ) THEN - 93 * - + 8 - - 91 + + NULLIF ( 42, 80 ) ELSE NULL END THEN NULL WHEN - 16 + + - 47 + 39 * 15 * + 72 * 15 THEN + CAST ( + 81 AS INTEGER ) ELSE + ( + COALESCE ( + 62, + 95, 65 ) ) + + 27 * + 48 END * - 22 ), - 70 + 35 * - COALESCE ( - 64 * - 88 + 0 * - 13, + 20 ) )
-----
--65
query I rowsort label-533
SELECT COALESCE ( + - COUNT ( + + 40 ), 20 / - 11 + - MAX ( + 48 ) + - 8 ) + - + ( 28 )
diff --git a/data/sqlite/random/expr/slt_good_97.slt b/data/sqlite/random/expr/slt_good_97.slt
index 0d88425..6c956fb 100644
--- a/data/sqlite/random/expr/slt_good_97.slt
+++ b/data/sqlite/random/expr/slt_good_97.slt
@@ -31152,10 +31152,10 @@
----
-7470
-query I rowsort label-5918
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -15
+query error DataFusion error: Arrow error: Divide by zero error
SELECT 15 / COALESCE ( - COUNT ( DISTINCT + 23 ), - MIN ( ALL 64 ) / COUNT ( ( - 9 ) + - 30 * - CAST ( NULL AS INTEGER ) ) + + 53 * - 47 ) AS col2
-----
--15
query I rowsort label-5919
SELECT ALL COUNT ( * ) * ( - 85 ) * - 58
@@ -41464,10 +41464,10 @@
----
84
-query I rowsort label-7875
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - NULL
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT - NULLIF ( + - NULLIF ( - CASE + 86 WHEN - - 92 * SUM ( - 51 ) - + 68 + - COUNT ( * ) - - - 78 / + - 96 + + COALESCE ( + COUNT ( * ), + COUNT ( * ) * AVG ( 87 ) + 90 / + NULLIF ( 11 / 98, 46 ) ) THEN SUM ( + 14 ) * + COUNT ( * ) - 9 WHEN - 18 * 44 THEN NULL END, - 44 + - COALESCE ( + 70, + COUNT ( * ) ) ), 81 * - 9 )
-----
-NULL
query I rowsort label-7876
SELECT + 69 + SUM ( - - 28 ) * + 82
diff --git a/data/sqlite/random/groupby/slt_good_12.slt b/data/sqlite/random/groupby/slt_good_12.slt
index c2d51f2..5879d28 100644
--- a/data/sqlite/random/groupby/slt_good_12.slt
+++ b/data/sqlite/random/groupby/slt_good_12.slt
@@ -30763,9 +30763,9 @@
SELECT ALL - COUNT ( * ) + + col1 * 8 FROM tab0 GROUP BY col1 HAVING 69 IS NULL
----
-query I rowsort label-5031
+# Datafusion - Datafusion expected results:
+query error DataFusion error: Arrow error: Divide by zero error
SELECT DISTINCT CAST ( NULL AS INTEGER ) / col1 FROM tab0 WHERE NOT ( - 29 ) NOT IN ( + COALESCE ( col2, 1 / - col1 ) ) GROUP BY col1
-----
query I rowsort
SELECT + 77 * col1 FROM tab1 AS cor0 GROUP BY col1
diff --git a/data/sqlite/random/groupby/slt_good_4.slt b/data/sqlite/random/groupby/slt_good_4.slt
index 99de764..1d13ff2 100644
--- a/data/sqlite/random/groupby/slt_good_4.slt
+++ b/data/sqlite/random/groupby/slt_good_4.slt
@@ -49826,11 +49826,11 @@
-710
-80
-query I rowsort label-7566
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - 0
+# Datafusion - Expected - 6561
+query error DataFusion error: Arrow error: Divide by zero error
SELECT + tab0.col1 * COALESCE ( + tab0.col1, tab0.col1 / - tab0.col1 ) FROM tab0 GROUP BY tab0.col1
-----
-0
-6561
query I rowsort
SELECT DISTINCT + 40 AS col0 FROM tab0 GROUP BY col2
diff --git a/data/sqlite/random/groupby/slt_good_7.slt b/data/sqlite/random/groupby/slt_good_7.slt
index 0f8d069..3570b48 100644
--- a/data/sqlite/random/groupby/slt_good_7.slt
+++ b/data/sqlite/random/groupby/slt_good_7.slt
@@ -66230,12 +66230,12 @@
SELECT tab0.col0 FROM tab0 GROUP BY tab0.col0 HAVING NOT NULL = NULL
----
-query I rowsort label-9997
+# Datafusion - Datafusion expected results:
+# Datafusion - Expected - -2025
+# Datafusion - Expected - -5041
+# Datafusion - Expected - -64
+query error DataFusion error: Arrow error: Divide by zero error
SELECT COALESCE ( - cor0.col2, - cor0.col2, col2 / 0 ) * + cor0.col2 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
-----
--2025
--5041
--64
query I rowsort
SELECT DISTINCT 24 FROM tab2 AS cor0 GROUP BY cor0.col0
