This is an automated email from the ASF dual-hosted git repository.
alamb pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion-testing.git
The following commit(s) were added to refs/heads/main by this push:
new 307079b Update expected output for coalsece short-circuit (#12)
307079b is described below
commit 307079bf7929b62d06864662b3aecfb2e1340c81
Author: Andrew Lamb <[email protected]>
AuthorDate: Wed Sep 10 08:38:09 2025 -0700
Update expected output for coalsece short-circuit (#12)
---
data/sqlite/random/expr/slt_good_0.slt | 6 +++---
data/sqlite/random/expr/slt_good_10.slt | 20 ++++++++++----------
data/sqlite/random/expr/slt_good_100.slt | 8 +++-----
data/sqlite/random/expr/slt_good_101.slt | 6 +++---
data/sqlite/random/expr/slt_good_102.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_104.slt | 8 ++++----
data/sqlite/random/expr/slt_good_105.slt | 18 +++++++++---------
data/sqlite/random/expr/slt_good_106.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_107.slt | 6 +++---
data/sqlite/random/expr/slt_good_108.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_110.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_111.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_112.slt | 14 +++++++-------
data/sqlite/random/expr/slt_good_113.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_116.slt | 6 +++---
data/sqlite/random/expr/slt_good_118.slt | 6 +++---
data/sqlite/random/expr/slt_good_119.slt | 8 ++++----
data/sqlite/random/expr/slt_good_12.slt | 8 ++++----
data/sqlite/random/expr/slt_good_13.slt | 26 ++++++++++++--------------
data/sqlite/random/expr/slt_good_14.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_16.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_17.slt | 6 +++---
data/sqlite/random/expr/slt_good_22.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_23.slt | 16 ++++++----------
data/sqlite/random/expr/slt_good_24.slt | 6 +++---
data/sqlite/random/expr/slt_good_25.slt | 25 +++++++++++++------------
data/sqlite/random/expr/slt_good_26.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_27.slt | 14 ++++++--------
data/sqlite/random/expr/slt_good_28.slt | 6 +++---
data/sqlite/random/expr/slt_good_29.slt | 26 ++++++++++++--------------
data/sqlite/random/expr/slt_good_3.slt | 6 +++---
data/sqlite/random/expr/slt_good_30.slt | 6 +++---
data/sqlite/random/expr/slt_good_31.slt | 19 ++++++++++---------
data/sqlite/random/expr/slt_good_33.slt | 18 +++++++++---------
data/sqlite/random/expr/slt_good_34.slt | 6 +++---
data/sqlite/random/expr/slt_good_36.slt | 6 +++---
data/sqlite/random/expr/slt_good_38.slt | 6 +++---
data/sqlite/random/expr/slt_good_39.slt | 6 +++---
data/sqlite/random/expr/slt_good_41.slt | 6 +++---
data/sqlite/random/expr/slt_good_44.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_45.slt | 6 +++---
data/sqlite/random/expr/slt_good_47.slt | 6 +++---
data/sqlite/random/expr/slt_good_49.slt | 6 +++---
data/sqlite/random/expr/slt_good_5.slt | 6 +++---
data/sqlite/random/expr/slt_good_50.slt | 6 +++---
data/sqlite/random/expr/slt_good_55.slt | 6 +++---
data/sqlite/random/expr/slt_good_56.slt | 18 +++++++++---------
data/sqlite/random/expr/slt_good_57.slt | 8 +++-----
data/sqlite/random/expr/slt_good_58.slt | 8 ++++----
data/sqlite/random/expr/slt_good_6.slt | 18 +++++++++---------
data/sqlite/random/expr/slt_good_61.slt | 6 +++---
data/sqlite/random/expr/slt_good_62.slt | 6 +++---
data/sqlite/random/expr/slt_good_63.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_64.slt | 6 +++---
data/sqlite/random/expr/slt_good_66.slt | 6 +++---
data/sqlite/random/expr/slt_good_67.slt | 26 ++++++++++++--------------
data/sqlite/random/expr/slt_good_68.slt | 8 +++-----
data/sqlite/random/expr/slt_good_69.slt | 6 +++---
data/sqlite/random/expr/slt_good_7.slt | 6 +++---
data/sqlite/random/expr/slt_good_72.slt | 8 +++-----
data/sqlite/random/expr/slt_good_75.slt | 6 +++---
data/sqlite/random/expr/slt_good_78.slt | 6 +++---
data/sqlite/random/expr/slt_good_79.slt | 6 +++---
data/sqlite/random/expr/slt_good_8.slt | 6 +++---
data/sqlite/random/expr/slt_good_80.slt | 6 +++---
data/sqlite/random/expr/slt_good_81.slt | 20 ++++++++++----------
data/sqlite/random/expr/slt_good_82.slt | 20 ++++++++++----------
data/sqlite/random/expr/slt_good_83.slt | 12 ++++++------
data/sqlite/random/expr/slt_good_84.slt | 23 ++++++++++++-----------
data/sqlite/random/expr/slt_good_85.slt | 14 +++++++-------
data/sqlite/random/expr/slt_good_89.slt | 6 +++---
data/sqlite/random/expr/slt_good_92.slt | 23 ++++++++++++-----------
data/sqlite/random/expr/slt_good_93.slt | 14 ++++++--------
data/sqlite/random/expr/slt_good_94.slt | 6 +++---
data/sqlite/random/expr/slt_good_97.slt | 14 ++++++--------
data/sqlite/random/groupby/slt_good_12.slt | 4 ++--
data/sqlite/random/groupby/slt_good_4.slt | 8 ++++----
data/sqlite/random/groupby/slt_good_7.slt | 10 +++++-----
78 files changed, 406 insertions(+), 426 deletions(-)
diff --git a/data/sqlite/random/expr/slt_good_0.slt
b/data/sqlite/random/expr/slt_good_0.slt
index 4476209..894108f 100644
--- a/data/sqlite/random/expr/slt_good_0.slt
+++ b/data/sqlite/random/expr/slt_good_0.slt
@@ -20520,10 +20520,10 @@ SELECT ALL + 23 / 28 * - - COUNT ( + + 10 ) * + 12
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 0
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3927
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 f82afe8..9e1920f 100644
--- a/data/sqlite/random/expr/slt_good_10.slt
+++ b/data/sqlite/random/expr/slt_good_10.slt
@@ -37288,11 +37288,11 @@ SELECT DISTINCT 87 * + 75 * - 22 AS col0
----
-143550
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -29
-# Datafusion - Expected - -900
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-7077
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 @@ SELECT ALL CAST ( NULL AS INTEGER ) + 53 * 66 * - +
COUNT ( * ) * + - 26 + 19
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -45
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8381
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 @@ SELECT - 68 - 41
----
-109
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9427
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 5cc53a4..5cd9697 100644
--- a/data/sqlite/random/expr/slt_good_100.slt
+++ b/data/sqlite/random/expr/slt_good_100.slt
@@ -14291,12 +14291,10 @@ SELECT ALL - 3 * CASE COUNT ( ALL 77 ) WHEN + + 69 +
+ + 75 + + 10 THEN 29 / 18
----
NULL
-# 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
+query I rowsort label-2709
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 0bf64aa..95d78bc 100644
--- a/data/sqlite/random/expr/slt_good_101.slt
+++ b/data/sqlite/random/expr/slt_good_101.slt
@@ -33945,10 +33945,10 @@ SELECT ALL - SUM ( 31 ) AS col1
----
-31
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 48
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-6449
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 99d0ec2..61f3bed 100644
--- a/data/sqlite/random/expr/slt_good_102.slt
+++ b/data/sqlite/random/expr/slt_good_102.slt
@@ -23926,10 +23926,10 @@ SELECT 18 / - + 37 + + 0
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 11
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4533
SELECT COUNT ( * ) * + COALESCE ( NULLIF ( + + 11, + CAST ( NULL AS INTEGER )
), - - 93, + + 92 / - + 82 * - MIN ( ( + 32 ) ) / - 0 + 61, - 69 )
+----
+11
query I rowsort
SELECT + 6 + + + 34
@@ -51534,10 +51534,10 @@ SELECT COUNT ( ALL 83 ) * - MAX ( 76 ) * 25 * - 92 +
COALESCE ( + 70 + - COUNT (
----
174884
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 3920
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9785
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 7519bfb..01d73f6 100644
--- a/data/sqlite/random/expr/slt_good_104.slt
+++ b/data/sqlite/random/expr/slt_good_104.slt
@@ -3691,11 +3691,11 @@ SELECT DISTINCT + 57 * COUNT ( * )
----
57
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -1750
-# Datafusion - Expected - -70
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-687
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
diff --git a/data/sqlite/random/expr/slt_good_105.slt
b/data/sqlite/random/expr/slt_good_105.slt
index 0631040..b4c634c 100644
--- a/data/sqlite/random/expr/slt_good_105.slt
+++ b/data/sqlite/random/expr/slt_good_105.slt
@@ -2698,10 +2698,10 @@ SELECT + ( - 1 ) AS col0
----
-1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 38
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort
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 @@ SELECT DISTINCT + + COUNT ( - 26 ) AS col2
----
1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -41
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3760
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 @@ SELECT 39 * + 97 * 8 + - + 26 * + 41
----
29198
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -1329
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4296
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 dd7fa35..c184f38 100644
--- a/data/sqlite/random/expr/slt_good_106.slt
+++ b/data/sqlite/random/expr/slt_good_106.slt
@@ -27502,10 +27502,10 @@ SELECT + 97, ( - + COUNT ( * ) ) AS col1
97
-1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 75
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5238
SELECT - NULLIF ( + 24, 53 ) + - COALESCE ( + 40, + 7 / 55 / + + 0 ) + + 43 +
+ 96
+----
+75
query I rowsort
SELECT ALL + ( 89 ) AS col1
@@ -44430,10 +44430,10 @@ SELECT - CAST ( + 77 AS INTEGER ) * + 73 AS col2, 38
* + 19 * - 57 col0
-5621
-41154
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -900
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8457
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 7aa8822..8c9a012 100644
--- a/data/sqlite/random/expr/slt_good_107.slt
+++ b/data/sqlite/random/expr/slt_good_107.slt
@@ -8427,10 +8427,10 @@ SELECT SUM ( - - 1 ) + + CAST ( NULL AS INTEGER ) - 38
+ + - 12 * + - 37 * SUM (
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 2530
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1604
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 e66e8ce..22c38aa 100644
--- a/data/sqlite/random/expr/slt_good_108.slt
+++ b/data/sqlite/random/expr/slt_good_108.slt
@@ -38979,10 +38979,10 @@ SELECT - CASE + COUNT ( - + 71 ) WHEN - - COUNT ( * )
+ 71 + + 62 * + COUNT ( *
----
-1890
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 86
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7425
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 @@ SELECT + 10, COUNT ( DISTINCT - 82 ) AS col2
10
1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -2052
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7486
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_110.slt
b/data/sqlite/random/expr/slt_good_110.slt
index c1ea8e8..b707531 100644
--- a/data/sqlite/random/expr/slt_good_110.slt
+++ b/data/sqlite/random/expr/slt_good_110.slt
@@ -17069,10 +17069,10 @@ SELECT CAST ( NULL AS INTEGER ) * + 24 / + 75
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -89
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3234
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 @@ SELECT 88 + 69
----
157
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 1810
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5267
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 4907500..ac34f4c 100644
--- a/data/sqlite/random/expr/slt_good_111.slt
+++ b/data/sqlite/random/expr/slt_good_111.slt
@@ -25200,10 +25200,10 @@ SELECT DISTINCT - 23 + + CASE 75 WHEN 89 / + ( + CASE
+ 21 WHEN + 26 + - CAST (
----
-168
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -1
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4804
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 @@ SELECT - 27 + ( - 72 ) col0
----
-99
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 4281
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5818
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 3eea878..37359a6 100644
--- a/data/sqlite/random/expr/slt_good_112.slt
+++ b/data/sqlite/random/expr/slt_good_112.slt
@@ -4996,10 +4996,10 @@ SELECT DISTINCT + 26 - - 58 AS col0
----
84
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -12
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-940
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 @@ SELECT ALL ( + 49 ) - COUNT ( * ) + - 95 col2
----
-47
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -92
-# Datafusion - Expected - 19
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-1705
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 830b81d..d7d8c09 100644
--- a/data/sqlite/random/expr/slt_good_113.slt
+++ b/data/sqlite/random/expr/slt_good_113.slt
@@ -44725,10 +44725,10 @@ SELECT 9 * + + COUNT ( 96 ) AS col0
----
9
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 0
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8501
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 @@ SELECT + 53 + + + 52 * - 50 AS col0
----
-2547
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -48
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9730
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 984fac1..1a3b003 100644
--- a/data/sqlite/random/expr/slt_good_116.slt
+++ b/data/sqlite/random/expr/slt_good_116.slt
@@ -6351,10 +6351,10 @@ SELECT + + 0 * + - 2 AS col0
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -84
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1199
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 f557e89..bdaa3d4 100644
--- a/data/sqlite/random/expr/slt_good_118.slt
+++ b/data/sqlite/random/expr/slt_good_118.slt
@@ -16422,10 +16422,10 @@ SELECT ALL - + ( + 40 ) col1
----
-40
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 8194
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3130
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 a50fc2e..66c2c95 100644
--- a/data/sqlite/random/expr/slt_good_119.slt
+++ b/data/sqlite/random/expr/slt_good_119.slt
@@ -10485,11 +10485,11 @@ SELECT ALL 43 * 52 - - - COUNT ( * ) + + 10 + - COUNT
( * ) * - 31 + + 3
----
2279
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -48657
-# Datafusion - Expected - -946
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-1991
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 2b58744..fb235cc 100644
--- a/data/sqlite/random/expr/slt_good_12.slt
+++ b/data/sqlite/random/expr/slt_good_12.slt
@@ -24855,11 +24855,11 @@ SELECT ALL + + COUNT ( * ) / - 94
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -52
-# Datafusion - Expected - -133
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-4720
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 e0f486e..6d254b2 100644
--- a/data/sqlite/random/expr/slt_good_13.slt
+++ b/data/sqlite/random/expr/slt_good_13.slt
@@ -24178,10 +24178,10 @@ SELECT DISTINCT - CAST ( - 71 AS INTEGER ) * NULLIF (
COUNT ( * ), + ( ( 78 ) )
----
20
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 62
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4645
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 @@ SELECT - 29 + 65 + - 28 + + 57 AS col2
----
65
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 10
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4664
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,12 +34908,10 @@ SELECT - - 13 * 21 * - COUNT ( * ) AS col0
----
-273
-# 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
+query I rowsort label-6714
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
@@ -39775,10 +39773,10 @@ SELECT ALL 86 * - MIN ( 85 ) AS col1
----
-7310
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7650
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 2d1fe00..3eb7c96 100644
--- a/data/sqlite/random/expr/slt_good_14.slt
+++ b/data/sqlite/random/expr/slt_good_14.slt
@@ -2669,10 +2669,10 @@ SELECT ALL 96 + 86
----
182
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-500
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 @@ SELECT DISTINCT 42 + + + 4 * CAST ( NULL AS INTEGER )
AS col2
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 151
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1202
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 4bed7e8..82d206c 100644
--- a/data/sqlite/random/expr/slt_good_16.slt
+++ b/data/sqlite/random/expr/slt_good_16.slt
@@ -13389,10 +13389,10 @@ SELECT DISTINCT 22 AS col1, 45 * 8 * 43 AS col0
22
15480
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -975
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-2534
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 @@ SELECT - - 92 * + 81 + + 45 AS col0
----
7497
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 92
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-6603
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 3dfb129..e8c7b8d 100644
--- a/data/sqlite/random/expr/slt_good_17.slt
+++ b/data/sqlite/random/expr/slt_good_17.slt
@@ -28321,10 +28321,10 @@ SELECT DISTINCT + 4 * - NULLIF ( + 96, + - 56 ) * 85
+ NULLIF ( - 65, 39 ) AS co
----
-32705
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 26
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5381
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_22.slt
b/data/sqlite/random/expr/slt_good_22.slt
index 3cbc2eb..e5f6d77 100644
--- a/data/sqlite/random/expr/slt_good_22.slt
+++ b/data/sqlite/random/expr/slt_good_22.slt
@@ -30131,10 +30131,10 @@ SELECT - 45 + 35 * - - 85
----
2930
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 91
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5742
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 @@ SELECT DISTINCT + 69 AS col1, + 44 - + - COUNT ( * )
+ - 80 * AVG ( ALL 93 ) * 4
69
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 61
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7302
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 6f1b0a5..2254f8f 100644
--- a/data/sqlite/random/expr/slt_good_23.slt
+++ b/data/sqlite/random/expr/slt_good_23.slt
@@ -8069,12 +8069,10 @@ SELECT ALL - SUM ( ALL + 66 )
----
-66
-# 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
+query I rowsort label-1532
SELECT COALESCE ( COUNT ( * ), - 92 / 0 + - - 43 )
+----
+1
query II rowsort
SELECT ( + + 77 ) + - ( + + 87 ) AS col1, 73
@@ -23895,12 +23893,10 @@ SELECT ALL COALESCE ( + 72, - 96 / 58 + 85 ) * +
COUNT ( * ) * - + 42 * + + 93 A
-281232
-253
-# 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
+query I rowsort label-4541
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 7f38da1..5590c1b 100644
--- a/data/sqlite/random/expr/slt_good_24.slt
+++ b/data/sqlite/random/expr/slt_good_24.slt
@@ -19855,10 +19855,10 @@ SELECT ALL 67 * + ( + + ( 12 ) ) * - MIN ( + CAST ( +
23 AS INTEGER ) ) + - COUN
----
-18493
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 27
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3793
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 110bf62..13fc4b0 100644
--- a/data/sqlite/random/expr/slt_good_25.slt
+++ b/data/sqlite/random/expr/slt_good_25.slt
@@ -2131,10 +2131,13 @@ SELECT DISTINCT - SUM ( ALL - - 71 ) AS col0
----
-71
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 9
-query error DataFusion error: Arrow error: Divide by zero error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-399
SELECT DISTINCT - COALESCE ( - - 13, + - AVG ( - 78 ) / - - 11, 23 / 0 ) + + +
22
+----
+9
query I rowsort
SELECT ALL + ( + 12 ) + - - 67 AS col0
@@ -21279,13 +21282,11 @@ SELECT ALL 57 * - ( - 56 ) + - - 28 + 35 + 7 * + + 5
----
3290
-# 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
+query II rowsort label-4071
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
@@ -50981,10 +50982,10 @@ SELECT ALL + MAX ( + - 78 ) * 27
----
-2106
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9743
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 cb56f06..58d48e9 100644
--- a/data/sqlite/random/expr/slt_good_26.slt
+++ b/data/sqlite/random/expr/slt_good_26.slt
@@ -7453,10 +7453,10 @@ SELECT COUNT ( * ), - 32 - + - CAST ( + ( - 9 ) AS
INTEGER ) col2
1
-41
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -5914
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1418
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 @@ SELECT DISTINCT COUNT ( * ) * + 31 + 59 + 53 * 20 + -
24 * - 53 + - CAST ( NULL
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4457
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 dce96ae..a86bf61 100644
--- a/data/sqlite/random/expr/slt_good_27.slt
+++ b/data/sqlite/random/expr/slt_good_27.slt
@@ -10430,10 +10430,10 @@ SELECT ALL + 23 / 28 * - - COUNT ( + + 10 ) * + 12
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 0
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1994
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,12 +52223,10 @@ SELECT + + 20 - + 77 AS col0
----
-57
-# Postgresql - Postgres error: db error: ERROR: division by zero
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -38
-skipif postgres
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9987
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 5d5d2b7..4d81eca 100644
--- a/data/sqlite/random/expr/slt_good_28.slt
+++ b/data/sqlite/random/expr/slt_good_28.slt
@@ -41683,10 +41683,10 @@ SELECT ALL COUNT ( 35 ) AS col1
----
1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -45
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7968
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 5dd5499..5f62563 100644
--- a/data/sqlite/random/expr/slt_good_29.slt
+++ b/data/sqlite/random/expr/slt_good_29.slt
@@ -25271,10 +25271,10 @@ SELECT DISTINCT - CAST ( - 71 AS INTEGER ) * NULLIF (
COUNT ( * ), + ( ( 78 ) )
----
20
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 62
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4887
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 @@ SELECT - 29 + 65 + - 28 + + 57 AS col2
----
65
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 10
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4906
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,12 +37036,10 @@ SELECT - - 13 * 21 * - COUNT ( * ) AS col0
----
-273
-# 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
+query I rowsort label-7164
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
@@ -42284,10 +42282,10 @@ SELECT ALL 86 * - MIN ( 85 ) AS col1
----
-7310
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8176
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 260abbe..e1c80e8 100644
--- a/data/sqlite/random/expr/slt_good_3.slt
+++ b/data/sqlite/random/expr/slt_good_3.slt
@@ -28029,10 +28029,10 @@ SELECT 52 * - - 28 AS col2
----
1456
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 3524
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5329
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 c182de6..cb961f4 100644
--- a/data/sqlite/random/expr/slt_good_30.slt
+++ b/data/sqlite/random/expr/slt_good_30.slt
@@ -24909,10 +24909,10 @@ SELECT ALL 67 * + ( + + ( 12 ) ) * - MIN ( + CAST ( +
23 AS INTEGER ) ) + - COUN
----
-18493
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 27
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4776
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 f4a8d26..229bb9c 100644
--- a/data/sqlite/random/expr/slt_good_31.slt
+++ b/data/sqlite/random/expr/slt_good_31.slt
@@ -8602,10 +8602,13 @@ SELECT DISTINCT - SUM ( ALL - - 71 ) AS col0
----
-71
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 9
-query error DataFusion error: Arrow error: Divide by zero error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-1640
SELECT DISTINCT - COALESCE ( - - 13, + - AVG ( - 78 ) / - - 11, 23 / 0 ) + + +
22
+----
+9
query I rowsort
SELECT ALL + ( + 12 ) + - - 67 AS col0
@@ -28235,13 +28238,11 @@ SELECT ALL 57 * - ( - 56 ) + - - 28 + 35 + 7 * + + 5
----
3290
-# 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
+query II rowsort label-5410
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 417f79b..cb1e27f 100644
--- a/data/sqlite/random/expr/slt_good_33.slt
+++ b/data/sqlite/random/expr/slt_good_33.slt
@@ -6252,10 +6252,10 @@ SELECT ALL + MAX ( + - 78 ) * 27
----
-2106
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1190
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 @@ SELECT COUNT ( * ), - 32 - + - CAST ( + ( - 9 ) AS
INTEGER ) col2
1
-41
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -5914
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-2901
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 @@ SELECT DISTINCT COUNT ( * ) * + 31 + 59 + 53 * 20 + -
24 * - 53 + - CAST ( NULL
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5979
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 b4c4a0a..67db2c7 100644
--- a/data/sqlite/random/expr/slt_good_34.slt
+++ b/data/sqlite/random/expr/slt_good_34.slt
@@ -44626,10 +44626,10 @@ SELECT ( + ( CAST ( - 0 AS INTEGER ) ) ) AS col2
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -69
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8487
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 d592f6c..429d3a6 100644
--- a/data/sqlite/random/expr/slt_good_36.slt
+++ b/data/sqlite/random/expr/slt_good_36.slt
@@ -43607,10 +43607,10 @@ SELECT + + 91 / + COALESCE ( + 14, 62 * - 40 ) + - 51
----
-45
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -85
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8323
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 a93b1e1..92664da 100644
--- a/data/sqlite/random/expr/slt_good_38.slt
+++ b/data/sqlite/random/expr/slt_good_38.slt
@@ -2596,10 +2596,10 @@ SELECT - 18 + 33 AS col0
----
15
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 42
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-488
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 7e0cbf2..d1d337d 100644
--- a/data/sqlite/random/expr/slt_good_39.slt
+++ b/data/sqlite/random/expr/slt_good_39.slt
@@ -47283,10 +47283,10 @@ SELECT ALL 46 * 15 AS col1
----
690
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 390188
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9020
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_41.slt
b/data/sqlite/random/expr/slt_good_41.slt
index 5e35523..c7037ca 100644
--- a/data/sqlite/random/expr/slt_good_41.slt
+++ b/data/sqlite/random/expr/slt_good_41.slt
@@ -42674,10 +42674,10 @@ SELECT ALL NULLIF ( + ( - + ( - 35 ) ), + NULLIF ( -
+ 34, - 4 ) * + - 50 ) + (
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
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -62527
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8139
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 92f5f79..6051b88 100644
--- a/data/sqlite/random/expr/slt_good_44.slt
+++ b/data/sqlite/random/expr/slt_good_44.slt
@@ -16154,10 +16154,10 @@ SELECT 27, + 61 col0
27
61
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -2630
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3089
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 @@ SELECT + COUNT ( * ) + + 76 AS col0
----
77
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -4788
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4060
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 c9f59c0..a920d7d 100644
--- a/data/sqlite/random/expr/slt_good_45.slt
+++ b/data/sqlite/random/expr/slt_good_45.slt
@@ -18011,10 +18011,10 @@ SELECT ALL 62 + + 15 AS col0
----
77
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 52
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3419
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 cb5734c..37e2f29 100644
--- a/data/sqlite/random/expr/slt_good_47.slt
+++ b/data/sqlite/random/expr/slt_good_47.slt
@@ -48039,10 +48039,10 @@ SELECT + 78 AS col1, - 9 AS col0
78
-9
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -612
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9161
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 df8e5c0..4d20235 100644
--- a/data/sqlite/random/expr/slt_good_49.slt
+++ b/data/sqlite/random/expr/slt_good_49.slt
@@ -37850,10 +37850,10 @@ SELECT ALL 68 * 82 col0
----
5576
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -86240
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7205
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 c1e1c0f..0f7fe9e 100644
--- a/data/sqlite/random/expr/slt_good_5.slt
+++ b/data/sqlite/random/expr/slt_good_5.slt
@@ -51278,10 +51278,10 @@ SELECT 64 * + - 73 + 82 AS col1
----
-4590
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -14
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9743
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 f923774..0ec424a 100644
--- a/data/sqlite/random/expr/slt_good_50.slt
+++ b/data/sqlite/random/expr/slt_good_50.slt
@@ -31836,10 +31836,10 @@ SELECT - + 92 * - + 42 * 69 * + 45 AS col1
----
11997720
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -20
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-6070
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 206d08b..50ea41e 100644
--- a/data/sqlite/random/expr/slt_good_55.slt
+++ b/data/sqlite/random/expr/slt_good_55.slt
@@ -39171,10 +39171,10 @@ SELECT ALL + - 36 / - CASE NULLIF ( - - 17, + 77 + -
COUNT ( * ) + - + 99 + + CO
----
3
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -46
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7464
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 6390ec9..6239de4 100644
--- a/data/sqlite/random/expr/slt_good_56.slt
+++ b/data/sqlite/random/expr/slt_good_56.slt
@@ -7822,10 +7822,10 @@ SELECT ALL + 35 AS col2, - 86 * + + 90
35
-7740
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 3398
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1487
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 @@ SELECT ALL - ( - MAX ( DISTINCT 3 ) ) - - 26 col1
----
29
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 79
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1546
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 @@ SELECT DISTINCT 33 / - ( + 27 ) + + - MIN ( + 45 )
col1
----
-46
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7413
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, + ( [...]
+----
+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 a29f348..a42f84c 100644
--- a/data/sqlite/random/expr/slt_good_57.slt
+++ b/data/sqlite/random/expr/slt_good_57.slt
@@ -47250,12 +47250,10 @@ SELECT ( + COUNT ( * ) ) * + 56
----
56
-# 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
+query I rowsort label-9006
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 b3e0a52..d83fdd5 100644
--- a/data/sqlite/random/expr/slt_good_58.slt
+++ b/data/sqlite/random/expr/slt_good_58.slt
@@ -16810,11 +16810,11 @@ SELECT DISTINCT CASE WHEN NOT ( NULL ) IS NULL AND
NULL NOT BETWEEN + + 72 AND (
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 68
-# Datafusion - Expected - 1
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-3203
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 a863560..835044a 100644
--- a/data/sqlite/random/expr/slt_good_6.slt
+++ b/data/sqlite/random/expr/slt_good_6.slt
@@ -9179,10 +9179,10 @@ SELECT DISTINCT - 61 - - MIN ( + - 5 )
----
-66
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 3828
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1736
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 @@ SELECT ALL - 87 + - 60
----
-147
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -127
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-2550
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 @@ SELECT + 32 * + 48 - - COUNT ( * )
----
1537
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -15
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9804
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_61.slt
b/data/sqlite/random/expr/slt_good_61.slt
index d15a501..b01cc05 100644
--- a/data/sqlite/random/expr/slt_good_61.slt
+++ b/data/sqlite/random/expr/slt_good_61.slt
@@ -15909,10 +15909,10 @@ SELECT DISTINCT MAX ( + 94 ) AS col1
----
94
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -22
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3026
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 5b27582..8aa60df 100644
--- a/data/sqlite/random/expr/slt_good_62.slt
+++ b/data/sqlite/random/expr/slt_good_62.slt
@@ -21891,10 +21891,10 @@ SELECT ALL 77 - + 86 AS col0, - 17 * + - COALESCE ( +
+ 59, 16 + 33 )
-9
1003
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4169
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 4a5774a..38c72ac 100644
--- a/data/sqlite/random/expr/slt_good_63.slt
+++ b/data/sqlite/random/expr/slt_good_63.slt
@@ -24087,10 +24087,10 @@ SELECT + 65 + 42 AS col2, + 37 AS col0
107
37
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 1218
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4567
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 @@ SELECT CAST ( NULL AS INTEGER ) * + COUNT ( * ) * + -
43 * 66 + - 51
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -1534
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9973
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 65429b7..d3a9bfa 100644
--- a/data/sqlite/random/expr/slt_good_64.slt
+++ b/data/sqlite/random/expr/slt_good_64.slt
@@ -6022,10 +6022,10 @@ SELECT + + CAST ( + + 81 AS INTEGER )
----
81
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 6114
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1141
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 1abd107..3d45774 100644
--- a/data/sqlite/random/expr/slt_good_66.slt
+++ b/data/sqlite/random/expr/slt_good_66.slt
@@ -2258,10 +2258,10 @@ SELECT ( + 77 ) + - 58 AS col1
----
19
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -3344
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-420
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 f8e541b..7366cf6 100644
--- a/data/sqlite/random/expr/slt_good_67.slt
+++ b/data/sqlite/random/expr/slt_good_67.slt
@@ -986,13 +986,11 @@ SELECT + CASE - COUNT ( * ) WHEN + + 45 THEN - + 79 END +
- MAX ( ALL - 82 ) AS
----
NULL
-# 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
+query II rowsort label-180
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
@@ -19684,11 +19682,11 @@ SELECT - 93 + 12
----
-81
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -80
-# Datafusion - Expected - -1
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-3744
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
@@ -23813,11 +23811,11 @@ SELECT - 8 * + - COUNT ( * ) * COUNT ( * ) AS col0
----
8
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -83
-# Datafusion - Expected - 322056
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-4521
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 a12df57..73db0b8 100644
--- a/data/sqlite/random/expr/slt_good_68.slt
+++ b/data/sqlite/random/expr/slt_good_68.slt
@@ -6358,12 +6358,10 @@ SELECT ALL 7 * 96 AS col2
----
672
-# 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
+query I rowsort label-1205
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 57e6668..cb35dbf 100644
--- a/data/sqlite/random/expr/slt_good_69.slt
+++ b/data/sqlite/random/expr/slt_good_69.slt
@@ -30800,10 +30800,10 @@ SELECT + 0 + CASE + - ( - 57 ) WHEN - - 99 THEN NULL
WHEN + 15 THEN 98 ELSE + CO
----
-232
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -77
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5864
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 90b141a..d66d788 100644
--- a/data/sqlite/random/expr/slt_good_7.slt
+++ b/data/sqlite/random/expr/slt_good_7.slt
@@ -27781,10 +27781,10 @@ SELECT - 23 * - 76
----
1748
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5282
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 af07f77..6fece06 100644
--- a/data/sqlite/random/expr/slt_good_72.slt
+++ b/data/sqlite/random/expr/slt_good_72.slt
@@ -43719,12 +43719,10 @@ SELECT - 64 * + 28 - 58
----
-1850
-# 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
+query I rowsort label-8329
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 c48f176..cbdfcc4 100644
--- a/data/sqlite/random/expr/slt_good_75.slt
+++ b/data/sqlite/random/expr/slt_good_75.slt
@@ -46078,10 +46078,10 @@ SELECT - COUNT ( * ) / - ( + 77 ) + + 58 col1
----
58
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -111
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8769
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_78.slt
b/data/sqlite/random/expr/slt_good_78.slt
index 01cbff1..f9c04c6 100644
--- a/data/sqlite/random/expr/slt_good_78.slt
+++ b/data/sqlite/random/expr/slt_good_78.slt
@@ -6891,10 +6891,10 @@ SELECT ALL + COUNT ( * ) + - 78 + - 89
----
-166
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 36
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1307
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 b704641..3b6cd7a 100644
--- a/data/sqlite/random/expr/slt_good_79.slt
+++ b/data/sqlite/random/expr/slt_good_79.slt
@@ -34126,10 +34126,10 @@ SELECT ALL + 23 * + 35 + COUNT ( * )
----
806
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 3197
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-6501
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 903e919..4e30958 100644
--- a/data/sqlite/random/expr/slt_good_8.slt
+++ b/data/sqlite/random/expr/slt_good_8.slt
@@ -47910,10 +47910,10 @@ SELECT + NULLIF ( 36, 58 ) AS col0
----
36
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 2132
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9094
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 1df89bb..5cfea3e 100644
--- a/data/sqlite/random/expr/slt_good_80.slt
+++ b/data/sqlite/random/expr/slt_good_80.slt
@@ -14872,10 +14872,10 @@ SELECT + 63 / - 40, - COUNT ( * ) * - - 64 col0
-1
-64
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 1
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-2832
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 6b0ce97..572efdf 100644
--- a/data/sqlite/random/expr/slt_good_81.slt
+++ b/data/sqlite/random/expr/slt_good_81.slt
@@ -17184,11 +17184,11 @@ SELECT + - 94 * + 68 * 60 col1
----
-383520
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 37
-# Datafusion - Expected - -592
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-3273
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 @@ SELECT ALL + + NULLIF ( + + COUNT ( * ), 1 + COUNT (
ALL - 96 + + 60 ) * - COUNT
----
85
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 966
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-3474
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 @@ SELECT - COUNT ( DISTINCT - 56 )
----
-1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -9676
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-4237
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 585b6ef..90133e9 100644
--- a/data/sqlite/random/expr/slt_good_82.slt
+++ b/data/sqlite/random/expr/slt_good_82.slt
@@ -2589,11 +2589,11 @@ SELECT 12 / - 38 * 50 * - - 69 * 1
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -5742
-# Datafusion - Expected - 22
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-494
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 @@ SELECT - 1 * + + ( - - 60 ) * - - 96 + + - 61
----
-5821
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -7
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8766
SELECT - COALESCE ( 7, + - 51 * 69 / 93 / + 0, + 25 * + - MAX ( - - 27 ) ) AS
col0
+----
+-7
query I rowsort
SELECT - 71 * - - 24
@@ -46365,10 +46365,10 @@ SELECT - COUNT ( * ) + + + COALESCE ( - CAST ( CASE
16 WHEN - COUNT ( * ) * - -
----
-1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-8830
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 d97e919..ecb9242 100644
--- a/data/sqlite/random/expr/slt_good_83.slt
+++ b/data/sqlite/random/expr/slt_good_83.slt
@@ -8763,10 +8763,10 @@ SELECT DISTINCT 25 * + - COUNT ( * ) + + 27 col0
----
2
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 309
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-1663
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 @@ SELECT DISTINCT CASE - 3 WHEN + 62 * 53 THEN NULL
WHEN - 68 THEN + - AVG ( + 56
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -77
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-6064
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 599660b..c2c42cc 100644
--- a/data/sqlite/random/expr/slt_good_84.slt
+++ b/data/sqlite/random/expr/slt_good_84.slt
@@ -12025,10 +12025,10 @@ SELECT + 99 / 70 - - 47
----
48
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 5344
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-2285
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,12 +31569,13 @@ SELECT + 27 + - 59
----
-32
-# 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
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-5996
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
@@ -49887,10 +49888,10 @@ SELECT DISTINCT + 13 * + + COUNT ( * ) AS col2
----
13
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9484
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 WH [...]
+----
+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 77da884..b2a0708 100644
--- a/data/sqlite/random/expr/slt_good_85.slt
+++ b/data/sqlite/random/expr/slt_good_85.slt
@@ -473,10 +473,10 @@ SELECT - 19 + - 5, + 37 AS col2
-24
37
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -84
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-84
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 @@ SELECT DISTINCT 78 + 40 + + - 73 AS col2
----
45
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -132
-# Datafusion - Expected - 97
-query error DataFusion error: Arrow error: Divide by zero error
+query II rowsort label-9148
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_89.slt
b/data/sqlite/random/expr/slt_good_89.slt
index c97b3e3..3804ea4 100644
--- a/data/sqlite/random/expr/slt_good_89.slt
+++ b/data/sqlite/random/expr/slt_good_89.slt
@@ -40035,10 +40035,10 @@ SELECT 14 AS col2, - COALESCE ( 57, - + 11 ) col0
14
-57
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 363955750
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7632
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 b0922bc..bbf4d16 100644
--- a/data/sqlite/random/expr/slt_good_92.slt
+++ b/data/sqlite/random/expr/slt_good_92.slt
@@ -615,10 +615,13 @@ SELECT COALESCE ( 77, - 41 + - 30 ) AS col0
----
77
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 2477
-query error DataFusion error: Arrow error: Divide by zero error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-112
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 ( * )
@@ -3494,10 +3497,10 @@ SELECT ALL + 20 + + 0
----
20
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -28
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-664
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 )
@@ -4598,12 +4601,10 @@ SELECT 5 * + 79 / 39 * COUNT ( * ) * 87
----
870
-# Postgresql - Postgres error: db error: ERROR: division by zero
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 6030
-skipif postgres
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-872
SELECT ALL CASE + 34 WHEN - 40 / + + 39 + + COUNT ( * ) THEN - - COUNT ( - +
48 ) ELSE + - ( + COALESCE ( + - CAST ( NULL AS INTEGER ), + COUNT ( ALL + 85 )
+ - + 67, COALESCE ( + - CASE COUNT ( * ) WHEN COUNT ( * ) THEN - 65 ELSE - - 6
/ + + 0 END, 48, COUNT ( * ) ) * + 83 + ( 47 ) ) ) - - COUNT ( * ) END * 90 AS
col0
+----
+6030
query II rowsort
SELECT - 76 AS col0, - 43 * + 16 AS col2
diff --git a/data/sqlite/random/expr/slt_good_93.slt
b/data/sqlite/random/expr/slt_good_93.slt
index fff84b5..7bf263d 100644
--- a/data/sqlite/random/expr/slt_good_93.slt
+++ b/data/sqlite/random/expr/slt_good_93.slt
@@ -18277,12 +18277,10 @@ SELECT + + 86 * 11
----
946
-# 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
+query I rowsort label-3473
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
@@ -27332,10 +27330,10 @@ SELECT DISTINCT + 63 * + 16 AS col0
----
1008
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 43
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5199
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 84e0d85..8029981 100644
--- a/data/sqlite/random/expr/slt_good_94.slt
+++ b/data/sqlite/random/expr/slt_good_94.slt
@@ -30656,10 +30656,10 @@ SELECT DISTINCT + 0 * 23
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 0
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5829
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_97.slt
b/data/sqlite/random/expr/slt_good_97.slt
index 60f8199..0d88425 100644
--- a/data/sqlite/random/expr/slt_good_97.slt
+++ b/data/sqlite/random/expr/slt_good_97.slt
@@ -31152,10 +31152,10 @@ SELECT DISTINCT 83 * - 90 AS col2
----
-7470
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -15
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5918
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,12 +41464,10 @@ SELECT 84 * + COUNT ( * ) col0
----
84
-# 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
+query I rowsort label-7875
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 5879d28..c2d51f2 100644
--- a/data/sqlite/random/groupby/slt_good_12.slt
+++ b/data/sqlite/random/groupby/slt_good_12.slt
@@ -30763,9 +30763,9 @@ query I rowsort label-5030
SELECT ALL - COUNT ( * ) + + col1 * 8 FROM tab0 GROUP BY col1 HAVING 69 IS NULL
----
-# Datafusion - Datafusion expected results:
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-5031
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 1d13ff2..99de764 100644
--- a/data/sqlite/random/groupby/slt_good_4.slt
+++ b/data/sqlite/random/groupby/slt_good_4.slt
@@ -49826,11 +49826,11 @@ SELECT - 10 * tab1.col2 AS col1 FROM tab1 GROUP BY
tab1.col2
-710
-80
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 0
-# Datafusion - Expected - 6561
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-7566
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 3570b48..0f8d069 100644
--- a/data/sqlite/random/groupby/slt_good_7.slt
+++ b/data/sqlite/random/groupby/slt_good_7.slt
@@ -66230,12 +66230,12 @@ query I rowsort
SELECT tab0.col0 FROM tab0 GROUP BY tab0.col0 HAVING NOT NULL = NULL
----
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -2025
-# Datafusion - Expected - -5041
-# Datafusion - Expected - -64
-query error DataFusion error: Arrow error: Divide by zero error
+query I rowsort label-9997
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
