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 5b424ae Updates to reflect fixes via DataFusion PR #14156 (#5)
5b424ae is described below
commit 5b424aefd7f6bf198220c37f59d39dbb25b47695
Author: Bruce Ritchie <[email protected]>
AuthorDate: Sat Jan 18 07:35:40 2025 -0500
Updates to reflect fixes via DataFusion PR #14156 (#5)
* Updated slt files with latest changes including switch from skipif
Datafusion -> query error
* Marking 2 tests as skipped with DF issue # attached
* Updates to reflect fixes via DataFusion PR #14156
---
data/sqlite/random/expr/slt_good_102.slt | 16 +++---------
data/sqlite/random/expr/slt_good_104.slt | 8 ++----
data/sqlite/random/expr/slt_good_105.slt | 8 ++----
data/sqlite/random/expr/slt_good_108.slt | 8 ++----
data/sqlite/random/expr/slt_good_111.slt | 8 ++----
data/sqlite/random/expr/slt_good_113.slt | 8 ++----
data/sqlite/random/expr/slt_good_114.slt | 8 ++----
data/sqlite/random/expr/slt_good_118.slt | 11 ++++----
data/sqlite/random/expr/slt_good_12.slt | 8 ++----
data/sqlite/random/expr/slt_good_14.slt | 8 ++----
data/sqlite/random/expr/slt_good_15.slt | 8 ++----
data/sqlite/random/expr/slt_good_21.slt | 16 +++---------
data/sqlite/random/expr/slt_good_22.slt | 8 ++----
data/sqlite/random/expr/slt_good_24.slt | 16 +++---------
data/sqlite/random/expr/slt_good_28.slt | 42 ++++++++----------------------
data/sqlite/random/expr/slt_good_30.slt | 16 +++---------
data/sqlite/random/expr/slt_good_36.slt | 8 ++----
data/sqlite/random/expr/slt_good_38.slt | 10 +++----
data/sqlite/random/expr/slt_good_39.slt | 11 ++++----
data/sqlite/random/expr/slt_good_4.slt | 8 ++----
data/sqlite/random/expr/slt_good_41.slt | 22 +++++++---------
data/sqlite/random/expr/slt_good_42.slt | 8 ++----
data/sqlite/random/expr/slt_good_45.slt | 8 ++----
data/sqlite/random/expr/slt_good_46.slt | 8 ++----
data/sqlite/random/expr/slt_good_48.slt | 8 ++----
data/sqlite/random/expr/slt_good_50.slt | 8 ++----
data/sqlite/random/expr/slt_good_52.slt | 10 +++----
data/sqlite/random/expr/slt_good_53.slt | 8 ++----
data/sqlite/random/expr/slt_good_64.slt | 16 +++---------
data/sqlite/random/expr/slt_good_66.slt | 11 ++++----
data/sqlite/random/expr/slt_good_68.slt | 8 ++----
data/sqlite/random/expr/slt_good_7.slt | 13 +++++----
data/sqlite/random/expr/slt_good_72.slt | 26 +++++-------------
data/sqlite/random/expr/slt_good_73.slt | 13 +++++----
data/sqlite/random/expr/slt_good_78.slt | 8 ++----
data/sqlite/random/expr/slt_good_80.slt | 8 ++----
data/sqlite/random/expr/slt_good_81.slt | 21 ++++++---------
data/sqlite/random/expr/slt_good_82.slt | 8 ++----
data/sqlite/random/expr/slt_good_85.slt | 18 ++++---------
data/sqlite/random/expr/slt_good_88.slt | 8 ++----
data/sqlite/random/expr/slt_good_94.slt | 8 ++----
data/sqlite/random/expr/slt_good_95.slt | 8 ++----
data/sqlite/random/groupby/slt_good_11.slt | 6 +----
data/sqlite/random/groupby/slt_good_12.slt | 30 +++++++--------------
44 files changed, 154 insertions(+), 370 deletions(-)
diff --git a/data/sqlite/random/expr/slt_good_102.slt
b/data/sqlite/random/expr/slt_good_102.slt
index c93e57d..713c528 100644
--- a/data/sqlite/random/expr/slt_good_102.slt
+++ b/data/sqlite/random/expr/slt_good_102.slt
@@ -9954,14 +9954,10 @@ SELECT 5 + - + CAST ( - 61 AS INTEGER ) + 32 + - - 51 /
- - 27 + - - 71 AS col1
----
170
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -704522
-query error
+query I rowsort label-1885
SELECT - 79 * + 91 * - COUNT ( * ) * + - 2 * + - NULLIF ( - 49, - COALESCE ( -
+ 69, - COALESCE ( + COALESCE ( - 20, ( - 18 ) * + COUNT ( * ) + - 93, - CASE
51 WHEN + COUNT ( * ) + 28 THEN 0 ELSE + 29 * + CASE ( 50 ) WHEN - ( - ( CASE
WHEN NOT + 37 IS NULL THEN + COUNT ( * ) END ) ) THEN NULL WHEN - 46 + 87 * -
28 THEN 85 WHEN - COUNT ( * ) THEN NULL END END ), COUNT ( * ) - 39 ) * + 22 )
/ - COUNT ( * ) )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-704522
query I rowsort label-1886
SELECT ALL + + 25 / ( - 99 ) AS col2
@@ -28994,14 +28990,10 @@ SELECT 42 + - 52 * + 55 + - MAX ( + 17 )
----
-2835
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort
SELECT ALL 22 / - ( CASE - CASE WHEN ( NULL ) IS NULL THEN + AVG ( + 97 ) END
WHEN 65 THEN + 82 END ) AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort label-5508
SELECT ALL 26 + - - NULLIF ( 24, + + 22 ) AS col1, 80 / + COUNT ( * )
diff --git a/data/sqlite/random/expr/slt_good_104.slt
b/data/sqlite/random/expr/slt_good_104.slt
index cc09869..76a09f8 100644
--- a/data/sqlite/random/expr/slt_good_104.slt
+++ b/data/sqlite/random/expr/slt_good_104.slt
@@ -33177,14 +33177,10 @@ SELECT 7 * - 35 - - + NULLIF ( - 96, 45 )
----
-341
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-6322
SELECT - COALESCE ( 99, + 49 + - 56 * - 40 - CAST ( + + CASE - 8 WHEN + CASE
80 WHEN + + ( + 82 ) * 7 THEN NULL WHEN ( - 36 ) * 89 THEN + 14 END THEN NULL
WHEN CASE WHEN NULL IS NULL THEN + COUNT ( * ) END * - 91 THEN ( 35 ) + - CAST
( - SUM ( 62 ) AS INTEGER ) / 33 WHEN + COUNT ( * ) * - 13 + + 32 * 93 THEN +
89 + 8 END AS INTEGER ) * + 92 ) * SUM ( + 45 * CAST ( NULL AS INTEGER ) ) - (
+ 57 )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-6323
SELECT DISTINCT - MAX ( DISTINCT + 40 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_105.slt
b/data/sqlite/random/expr/slt_good_105.slt
index bbdd6bf..d129695 100644
--- a/data/sqlite/random/expr/slt_good_105.slt
+++ b/data/sqlite/random/expr/slt_good_105.slt
@@ -11739,14 +11739,10 @@ SELECT - COALESCE ( 16, - + 93, - - 18 )
----
-16
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 0
-query error
+query I rowsort label-2228
SELECT + + ( - + 22 ) / + CASE WHEN + 73 IS NOT NULL THEN + ( MAX ( 78 ) ) END
AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+0
query I rowsort
SELECT + + 88 + - 48 + + + 22
diff --git a/data/sqlite/random/expr/slt_good_108.slt
b/data/sqlite/random/expr/slt_good_108.slt
index fddb4bf..b4f01e3 100644
--- a/data/sqlite/random/expr/slt_good_108.slt
+++ b/data/sqlite/random/expr/slt_good_108.slt
@@ -31431,14 +31431,10 @@ SELECT CAST ( 71 AS INTEGER ) AS col1
----
71
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-5997
SELECT CASE WHEN + ( + 93 ) IS NULL THEN MIN ( ALL - + 0 ) ELSE NULL END / +
62 - + - 76 * COUNT ( * )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-5998
SELECT DISTINCT + CASE + COUNT ( * ) WHEN + + 17 + - + 50 THEN - 20 + + 42 -
24 ELSE NULL END / - ( 64 )
diff --git a/data/sqlite/random/expr/slt_good_111.slt
b/data/sqlite/random/expr/slt_good_111.slt
index 98ae80c..8ec085b 100644
--- a/data/sqlite/random/expr/slt_good_111.slt
+++ b/data/sqlite/random/expr/slt_good_111.slt
@@ -50418,14 +50418,10 @@ SELECT 57 / - 94 + + - 45 AS col0
----
-45
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-9613
SELECT ALL CASE - COUNT ( * ) WHEN 98 THEN - + ( + COUNT ( * ) ) - + 28 / - 3
WHEN - CASE WHEN NOT ( NULL ) > NULL THEN - COUNT ( * ) END + MIN ( ALL 78 )
THEN 78 * COALESCE ( + 15, - 42, SUM ( - 38 ) * - CAST ( - 89 AS INTEGER ), 65
+ + 73 ) END / 50 - ( + 85 + 58 / + 15 )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-9614
SELECT COALESCE ( + + ( COUNT ( * ) ), - 14 ) * + COUNT ( * ) + + - MAX (
DISTINCT - 90 ) + - 80
diff --git a/data/sqlite/random/expr/slt_good_113.slt
b/data/sqlite/random/expr/slt_good_113.slt
index 661ddcb..517c434 100644
--- a/data/sqlite/random/expr/slt_good_113.slt
+++ b/data/sqlite/random/expr/slt_good_113.slt
@@ -269,14 +269,10 @@ SELECT DISTINCT 7 - - 35 + + 93 AS col0
----
135
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 53
-query error
+query I rowsort label-43
SELECT + CASE WHEN + 60 IS NOT NULL THEN + MAX ( 53 ) ELSE NULL END col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+53
# Datafusion - Datafusion expected results:
# Datafusion - Expected - NULL
diff --git a/data/sqlite/random/expr/slt_good_114.slt
b/data/sqlite/random/expr/slt_good_114.slt
index 7005b75..03be838 100644
--- a/data/sqlite/random/expr/slt_good_114.slt
+++ b/data/sqlite/random/expr/slt_good_114.slt
@@ -7319,14 +7319,10 @@ SELECT ALL - 84 * - 13 + 61 + + COUNT ( * )
----
1154
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-1380
SELECT DISTINCT - - COUNT ( * ) * CASE WHEN NOT NULL IS NULL THEN COUNT ( + 39
) END / - - 46 + - 88 AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-1381
SELECT + CAST ( NULL AS INTEGER ) * - NULLIF ( + + 6, + NULLIF ( - COUNT ( *
), 52 ) * CAST ( + + COUNT ( ALL + - CAST ( NULL AS FLOAT8 ) ) AS INTEGER ) )
diff --git a/data/sqlite/random/expr/slt_good_118.slt
b/data/sqlite/random/expr/slt_good_118.slt
index 1fd5aa6..51de17d 100644
--- a/data/sqlite/random/expr/slt_good_118.slt
+++ b/data/sqlite/random/expr/slt_good_118.slt
@@ -52004,14 +52004,13 @@ SELECT DISTINCT COUNT ( * ) + + 67 AS col0
----
68
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-9915
SELECT DISTINCT COUNT ( * ) + + AVG ( ALL + CASE - + 89 WHEN + 71 THEN 72 WHEN
63 THEN NULL ELSE NULL END ) * COUNT ( * ) / + 78 * + + NULLIF ( + - NULLIF ( (
+ + MIN ( - NULLIF ( + + 57, - + 74 ) ) ), SUM ( ALL + 69 ) ), - 16 ) - - 47 -
SUM ( 39 ) * + COUNT ( * ) * - CASE WHEN ( NULL ) >= NULL THEN COUNT ( * ) ELSE
NULL END - 7 AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT ALL + 87 + - NULLIF ( - - 41, + 95 + 99 )
diff --git a/data/sqlite/random/expr/slt_good_12.slt
b/data/sqlite/random/expr/slt_good_12.slt
index 2a5cd0a..aec6b73 100644
--- a/data/sqlite/random/expr/slt_good_12.slt
+++ b/data/sqlite/random/expr/slt_good_12.slt
@@ -37575,14 +37575,10 @@ SELECT + COUNT ( * ) * - - ( - - 60 ) * - 83 AS col1
----
-4980
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-7168
SELECT ALL ( - CASE WHEN NOT NULL NOT BETWEEN NULL AND - 67 THEN - - SUM ( ALL
+ 29 ) END ) * 13 - 8 AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort label-7169
SELECT 69 / COUNT ( * ) * COUNT ( CASE 65 WHEN + - 48 + - + 13 THEN NULL ELSE
- 41 END ) / + COUNT ( * ) * COUNT ( * ) + 43 + COUNT ( * ) AS col1, - COUNT (
* ) + + + 81
diff --git a/data/sqlite/random/expr/slt_good_14.slt
b/data/sqlite/random/expr/slt_good_14.slt
index 340edaa..ea599b9 100644
--- a/data/sqlite/random/expr/slt_good_14.slt
+++ b/data/sqlite/random/expr/slt_good_14.slt
@@ -51688,14 +51688,10 @@ SELECT ALL COALESCE ( - 37, - 36 * 92 ) * - + 40 + 57
+ 40 + 97 * - - COALESCE (
----
-1250
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 71
-query error
+query I rowsort label-9856
SELECT DISTINCT + COALESCE ( + 71, + + 72 * CASE WHEN - 74 IS NULL THEN + MIN
( 18 ) END ) col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+71
query II rowsort label-9857
SELECT ALL ( - MIN ( 75 ) ) * - 50, + CAST ( COUNT ( * ) AS INTEGER ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_15.slt
b/data/sqlite/random/expr/slt_good_15.slt
index 7975f29..a5fe2d5 100644
--- a/data/sqlite/random/expr/slt_good_15.slt
+++ b/data/sqlite/random/expr/slt_good_15.slt
@@ -12135,14 +12135,10 @@ SELECT ALL - COUNT ( ALL - 23 )
query error DataFusion error: Error during planning: Projections require
unique expression names but the expression "\(\- min\(Int64\(\-37\)\)\) AS
col1" at position 0 and "Int64\(50\) \+ Int64\(\-83\) \+ Int64\(77\) \*
Int64\(92\) \* CAST\(Int64\(37\) AS Int32\) \* Int64\(\-83\) AS col1" at
position 1 have the same name\. Consider aliasing \("AS"\) one of them\.
SELECT - + ( MIN ( - 37 ) ) col1, 50 + + ( + ( - 83 ) ) + 77 * 92 * + CAST (
37 AS INTEGER ) * + - 83 AS col1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-2296
SELECT ALL - CAST ( NULLIF ( - CASE WHEN NOT 40 < NULL THEN MIN ( + CAST (
NULL AS INTEGER ) ) ELSE NULL END, + 50 + 18 ) AS INTEGER ) AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-2297
SELECT + + CAST ( - SUM ( ALL + 30 ) AS INTEGER ) / + 3 + ( - 45 ) + ( + 31 )
* - + 60 * 44
diff --git a/data/sqlite/random/expr/slt_good_21.slt
b/data/sqlite/random/expr/slt_good_21.slt
index bb36a94..ea8d832 100644
--- a/data/sqlite/random/expr/slt_good_21.slt
+++ b/data/sqlite/random/expr/slt_good_21.slt
@@ -1312,14 +1312,10 @@ SELECT - - 17 * 10 AS col2
----
170
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-240
SELECT DISTINCT - + 67 * + CASE + COALESCE ( + 29, 44, - - 69 ) WHEN + + COUNT
( * ) + - 7 THEN 37 * - 34 * + - ( + 7 ) * - CAST ( + - 81 AS INTEGER ) + + 66
+ SUM ( + 27 ) * - - 89 + 45 + + ( - CASE - - 69 WHEN + - 82 THEN + - 33 / 73 *
+ 2 WHEN 59 THEN - ( + + 75 ) END ) + 9 + + 47 - + CASE - 76 WHEN NULLIF ( + -
NULLIF ( + 21, - MAX ( NULLIF ( + 80, - 47 ) ) + CAST ( NULL AS INTEGER ) ), -
62 ) THEN + 25 WHEN 81 + 59 THEN + 67 + - 3 * - 59 END / + 66 / + 52 ELSE NULL
END / - NULLIF ( [...]
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-241
SELECT DISTINCT + MAX ( ALL + 44 ) AS col1
@@ -38155,14 +38151,10 @@ SELECT ALL 13 + - 52
----
-39
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 266
-query error
+query I rowsort label-7271
SELECT ALL ( 76 ) + + CAST ( + 98 AS INTEGER ) + + + CASE WHEN NOT ( ( -
NULLIF ( 79, 11 ) ) IS NULL ) THEN MIN ( DISTINCT 92 ) END
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+266
query I rowsort label-7272
SELECT DISTINCT + 87 + 32 * COUNT ( * )
diff --git a/data/sqlite/random/expr/slt_good_22.slt
b/data/sqlite/random/expr/slt_good_22.slt
index fd83987..73d55bd 100644
--- a/data/sqlite/random/expr/slt_good_22.slt
+++ b/data/sqlite/random/expr/slt_good_22.slt
@@ -28001,14 +28001,10 @@ SELECT DISTINCT - 10 / 38 * + 68 * + - COUNT ( * )
col0, + 59
0
59
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -1
-query error
+query I rowsort label-5342
SELECT - CASE WHEN NOT ( 49 ) IS NULL THEN - - COUNT ( DISTINCT - - 85 ) END
AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-1
query I rowsort label-5343
SELECT + 56 * MIN ( - - 0 ) AS col1
diff --git a/data/sqlite/random/expr/slt_good_24.slt
b/data/sqlite/random/expr/slt_good_24.slt
index a8c9c69..fa77cec 100644
--- a/data/sqlite/random/expr/slt_good_24.slt
+++ b/data/sqlite/random/expr/slt_good_24.slt
@@ -23418,14 +23418,10 @@ SELECT ALL 31 * + 46 AS col0
----
1426
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -28671357
-query error
+query I rowsort label-4488
SELECT + + 39 * + - COALESCE ( CASE WHEN NOT ( NULL ) <= NULL THEN + ( SUM (
88 ) ) END, + 53 ) * - 97 * - ( - - 13 ) * 11 AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-28671357
query I rowsort label-4489
SELECT DISTINCT 49 * COALESCE ( COUNT ( * ), 75, + 2 ) AS col1
@@ -44217,14 +44213,10 @@ SELECT ALL - 55 - SUM ( - 30 ) - - COUNT ( * )
query error DataFusion error: Error during planning: Projections require
unique expression names but the expression "Int64\(97\) / Int64\(\-78\) AS
col1" at position 0 and "Int64\(\-71\) AS col1" at position 1 have the same
name\. Consider aliasing \("AS"\) one of them\.
SELECT + 97 / + - 78 col1, - 71 AS col1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-8479
SELECT 51 * - 7 + - ( 81 ) + COUNT ( * ) + CASE WHEN NULL BETWEEN - ( - 29 )
AND NULL THEN - - COUNT ( * ) END + COUNT ( - - 5 ) * 14
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-8480
SELECT + COUNT ( + - CAST ( 73 AS FLOAT8 ) ) + - COUNT ( * )
diff --git a/data/sqlite/random/expr/slt_good_28.slt
b/data/sqlite/random/expr/slt_good_28.slt
index 1160b81..8c9e0d2 100644
--- a/data/sqlite/random/expr/slt_good_28.slt
+++ b/data/sqlite/random/expr/slt_good_28.slt
@@ -25812,14 +25812,10 @@ SELECT 29 * - 91 AS col0, + NULLIF ( + - 58, + 44 * -
+ 82 ) / - 25 + + SUM ( AL
-2639
-50
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-4948
SELECT ALL ( - CASE WHEN ( NULL ) IS NOT NULL OR NOT ( NOT + 56 IS NOT NULL )
THEN SUM ( - 80 ) END ) * CASE 85 WHEN AVG ( + 8 ) + + 0 THEN NULL WHEN - SUM (
DISTINCT 60 ) THEN 19 WHEN - COUNT ( * ) THEN NULL ELSE + CASE - ( + 55 ) WHEN
2 THEN 6 * 94 ELSE NULL END - - 48 END - 31
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-4949
SELECT - 95 - MIN ( 81 ) col2
@@ -27812,14 +27808,10 @@ SELECT MIN ( DISTINCT + + 92 ) * + 20 / - + 1 AS col1
----
-1840
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-5325
SELECT - CASE WHEN NOT - 80 IS NOT NULL THEN - - COUNT ( * ) ELSE NULL END / +
SUM ( DISTINCT + 29 ) + 75 + - - 5
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-5326
SELECT + SUM ( - + CAST ( NULL AS INTEGER ) ) AS col1
@@ -34431,14 +34423,10 @@ SELECT ALL + 41 - - 58 / + 81
----
41
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-6594
SELECT ALL 90 * CASE WHEN NOT NULL NOT IN ( 11, 8, 56, + 47 ) THEN + MIN ( 59
) END * + + 26 * 51 * + CASE + COUNT ( * ) WHEN + ( - 28 ) / - 83 THEN 78 WHEN
46 * COALESCE ( SUM ( + 65 ) * + 66, + 45 ) + ( + 11 + - ( + COUNT ( * ) ) )
THEN NULL END + 43 AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
# Datafusion - Datafusion expected results:
# Datafusion - Expected - 18
@@ -42358,14 +42346,10 @@ SELECT + 17 + SUM ( DISTINCT - 65 ), 43 AS col2
-48
43
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-8117
SELECT + CASE - + COUNT ( * ) WHEN 24 THEN NULL WHEN + + 26 * 70 * + ( NULLIF
( + SUM ( ALL 16 ), 10 + CASE WHEN NOT - 21 IS NULL THEN + COUNT ( * ) END *
MIN ( ALL + CAST ( NULL AS INTEGER ) * + 67 ) ) ) - COUNT ( * ) * + 1 THEN + 70
+ - 27 ELSE NULL END col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort label-8118
SELECT DISTINCT + ( MAX ( DISTINCT + 28 ) ), 95 AS col1
@@ -44977,15 +44961,11 @@ SELECT + - ( - 49 ) col2
----
49
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 1
-# Datafusion - Expected - 12
-query error
+query II rowsort label-8614
SELECT + CASE COUNT ( * ) WHEN + NULLIF ( - + 75, + CASE WHEN NULL < 98 THEN +
COUNT ( * ) ELSE NULL END * + 46 + - 28 ) + + 3 THEN NULL WHEN - + 90 * - ( + -
32 ) * 72 THEN 14 ELSE - - 1 END, 12 AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+1
+12
query I rowsort label-8615
SELECT - + 10 + - 40 + - 68 * + COUNT ( ALL 97 ) * - 6 AS col2
diff --git a/data/sqlite/random/expr/slt_good_30.slt
b/data/sqlite/random/expr/slt_good_30.slt
index e9de71e..3ab9ef9 100644
--- a/data/sqlite/random/expr/slt_good_30.slt
+++ b/data/sqlite/random/expr/slt_good_30.slt
@@ -28630,14 +28630,10 @@ SELECT ALL 31 * + 46 AS col0
----
1426
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -28671357
-query error
+query I rowsort label-5503
SELECT + + 39 * + - COALESCE ( CASE WHEN NOT ( NULL ) <= NULL THEN + ( SUM (
88 ) ) END, + 53 ) * - 97 * - ( - - 13 ) * 11 AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-28671357
query I rowsort
SELECT ALL + 46
@@ -50236,14 +50232,10 @@ SELECT ALL - 55 - SUM ( - 30 ) - - COUNT ( * )
query error DataFusion error: Error during planning: Projections require
unique expression names but the expression "Int64\(97\) / Int64\(\-78\) AS
col1" at position 0 and "Int64\(\-71\) AS col1" at position 1 have the same
name\. Consider aliasing \("AS"\) one of them\.
SELECT + 97 / + - 78 col1, - 71 AS col1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-9656
SELECT 51 * - 7 + - ( 81 ) + COUNT ( * ) + CASE WHEN NULL BETWEEN - ( - 29 )
AND NULL THEN - - COUNT ( * ) END + COUNT ( - - 5 ) * 14
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-9657
SELECT + COUNT ( + - CAST ( 73 AS FLOAT8 ) ) + - COUNT ( * )
diff --git a/data/sqlite/random/expr/slt_good_36.slt
b/data/sqlite/random/expr/slt_good_36.slt
index bc6d30a..46fbb15 100644
--- a/data/sqlite/random/expr/slt_good_36.slt
+++ b/data/sqlite/random/expr/slt_good_36.slt
@@ -20717,14 +20717,10 @@ SELECT + 86 * - - MAX ( DISTINCT 46 ) * + - 26
----
-102856
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 99
-query error
+query I rowsort label-3958
SELECT + CASE WHEN NOT ( NULL ) IS NOT NULL THEN + MAX ( DISTINCT + + 99 ) END
AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+99
query I rowsort
SELECT DISTINCT 15 * - 2 + - - 39 + + 93
diff --git a/data/sqlite/random/expr/slt_good_38.slt
b/data/sqlite/random/expr/slt_good_38.slt
index a0ce199..125a612 100644
--- a/data/sqlite/random/expr/slt_good_38.slt
+++ b/data/sqlite/random/expr/slt_good_38.slt
@@ -43108,15 +43108,11 @@ SELECT ALL CAST ( NULL AS INTEGER ) AS col2, - 85 AS
col1
NULL
-85
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 30
-# Datafusion - Expected - 3135
-query error
+query II rowsort label-8221
SELECT 30 AS col2, - COUNT ( * ) * + 55 * + 57 * + NULLIF ( + CASE WHEN NOT (
+ 13 ) IS NULL THEN - COUNT ( * ) END, - 53 )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+30
+3135
query I rowsort
SELECT ALL + 55 * 43
diff --git a/data/sqlite/random/expr/slt_good_39.slt
b/data/sqlite/random/expr/slt_good_39.slt
index 2d87bfb..fb2ff7b 100644
--- a/data/sqlite/random/expr/slt_good_39.slt
+++ b/data/sqlite/random/expr/slt_good_39.slt
@@ -351,14 +351,13 @@ SELECT 82 * + + 8 * + 80 + + 9
----
52489
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-60
SELECT + - 46 / COALESCE ( + 42, + COALESCE ( - COUNT ( * ), 89 ) / + ( 80 ) +
67 - - - 17 / - + 35 * + 91 * + 22, - 40 ) + - 10 * CASE WHEN NULL > NULL THEN
+ AVG ( ALL 60 ) END AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT DISTINCT 5 * + 72 * - + 12 * 78
diff --git a/data/sqlite/random/expr/slt_good_4.slt
b/data/sqlite/random/expr/slt_good_4.slt
index 0922985..8f86c85 100644
--- a/data/sqlite/random/expr/slt_good_4.slt
+++ b/data/sqlite/random/expr/slt_good_4.slt
@@ -15991,14 +15991,10 @@ SELECT DISTINCT CASE 40 WHEN - 15 THEN NULL ELSE - 79
+ + COUNT ( * ) END / 53 *
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -1
-query error
+query I rowsort label-3042
SELECT ALL ( - COUNT ( * ) ) * - CASE WHEN - 38 IS NOT NULL THEN ( - COUNT ( *
) ) ELSE NULL END AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-1
# Datafusion - Datafusion expected results:
# Datafusion - Expected - 43
diff --git a/data/sqlite/random/expr/slt_good_41.slt
b/data/sqlite/random/expr/slt_good_41.slt
index 25bdb6d..873bc6a 100644
--- a/data/sqlite/random/expr/slt_good_41.slt
+++ b/data/sqlite/random/expr/slt_good_41.slt
@@ -4259,14 +4259,13 @@ SELECT CAST ( - 65 AS INTEGER ) * - COALESCE ( - CAST (
NULL AS INTEGER ), 11, +
----
715
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-808
SELECT ALL CAST ( NULL AS INTEGER ) + + CASE WHEN NOT 22 >= 79 + + 76 THEN MIN
( - 62 ) END * - NULLIF ( 59, + AVG ( ALL 10 ) ) AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-809
SELECT ALL - 26 + - 51 + + 26 * - - CAST ( NULL AS INTEGER ) * + CAST ( NULL
AS INTEGER ) - + CAST ( - ( 94 ) + + 54 / + 80 AS INTEGER ) AS col2
@@ -36679,14 +36678,13 @@ SELECT 99 + - 58 AS col0
----
41
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-7005
SELECT ALL + 5 + + ( + 85 ) - - CASE WHEN NOT ( NULL ) BETWEEN 24 AND + + CAST
( NULL AS INTEGER ) THEN COUNT ( + - 60 ) END * + - 53 * + 84 + - - CAST ( NULL
AS INTEGER ) + AVG ( - 57 ) - + COUNT ( * ) + + - 92 - - 88 / - + 74 * - + 91 *
- ( + 24 )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort label-7006
SELECT DISTINCT 90 + - - 81, - 60 * + + COUNT ( * ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_42.slt
b/data/sqlite/random/expr/slt_good_42.slt
index 1befa01..a551f35 100644
--- a/data/sqlite/random/expr/slt_good_42.slt
+++ b/data/sqlite/random/expr/slt_good_42.slt
@@ -51661,14 +51661,10 @@ SELECT DISTINCT + ( - - COUNT ( * ) ) col0
----
1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 99
-query error
+query I rowsort label-9893
SELECT + CASE WHEN NOT ( NULL ) IS NOT NULL THEN + MAX ( DISTINCT + + 99 ) END
AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+99
query I rowsort
SELECT ALL + 62 col1
diff --git a/data/sqlite/random/expr/slt_good_45.slt
b/data/sqlite/random/expr/slt_good_45.slt
index 3777e99..1c6ec4d 100644
--- a/data/sqlite/random/expr/slt_good_45.slt
+++ b/data/sqlite/random/expr/slt_good_45.slt
@@ -11338,14 +11338,10 @@ SELECT ALL 78 + + - COUNT ( - ( 4 ) ) * + 48 * + 21 +
- 22
----
-952
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-2150
SELECT + ( - 56 ) * - CASE WHEN NOT - 7 NOT IN ( + + 75 ) THEN SUM ( ALL - 79
) ELSE NULL END
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-2151
SELECT + CAST ( + 75 AS INTEGER ) + + - 38 AS col2
diff --git a/data/sqlite/random/expr/slt_good_46.slt
b/data/sqlite/random/expr/slt_good_46.slt
index 1806b96..8d7371b 100644
--- a/data/sqlite/random/expr/slt_good_46.slt
+++ b/data/sqlite/random/expr/slt_good_46.slt
@@ -29747,14 +29747,10 @@ SELECT ALL + ( ( 23 ) ) + - 23 * + + 21
----
-460
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -242
-query error
+query I rowsort label-5678
SELECT DISTINCT - 70 + + CASE WHEN NOT ( NULLIF ( + CAST ( + 14 AS INTEGER ),
+ 21 ) ) IS NULL THEN MAX ( - 96 ) ELSE NULL END + - + 76
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-242
query I rowsort label-5679
SELECT 23 * - - MIN ( - 27 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_48.slt
b/data/sqlite/random/expr/slt_good_48.slt
index c1b0c0f..62ec582 100644
--- a/data/sqlite/random/expr/slt_good_48.slt
+++ b/data/sqlite/random/expr/slt_good_48.slt
@@ -46218,14 +46218,10 @@ SELECT - 20 * - 17 + + - NULLIF ( 25, 37 / + 28 * 17
) * 55 * 61 * + ( - MIN ( +
----
-4025561
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-8830
SELECT ALL CASE WHEN 47 IS NULL THEN - - MAX ( ALL - 69 ) END
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT ALL NULLIF ( - COALESCE ( + 7, + - 10 ), + - COALESCE ( 82, 1 / + - 11
) )
diff --git a/data/sqlite/random/expr/slt_good_50.slt
b/data/sqlite/random/expr/slt_good_50.slt
index 7d44249..d1038ea 100644
--- a/data/sqlite/random/expr/slt_good_50.slt
+++ b/data/sqlite/random/expr/slt_good_50.slt
@@ -48133,14 +48133,10 @@ SELECT - 4 * - 61 AS col0
----
244
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-9177
SELECT CASE WHEN - 62 BETWEEN + 16 + + 55 AND + CASE + COALESCE ( 88, 74 * 1,
+ CAST ( NULL AS INTEGER ) / COUNT ( * ) ) WHEN COUNT ( 21 ) THEN 40 * CAST ( -
24 AS INTEGER ) ELSE NULL END THEN COUNT ( ALL + 78 ) ELSE NULL END AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-9178
SELECT + + 17 / 76 + + ( + 33 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_52.slt
b/data/sqlite/random/expr/slt_good_52.slt
index 14b459b..58dd9a2 100644
--- a/data/sqlite/random/expr/slt_good_52.slt
+++ b/data/sqlite/random/expr/slt_good_52.slt
@@ -19328,15 +19328,11 @@ SELECT - - 48 * + COUNT ( * ) - + 40 + - COUNT ( * )
+ - + 90 AS col2
----
-83
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-# Datafusion - Expected - 591360
-query error
+query II rowsort label-3688
SELECT - 95 / 75 / CAST ( NULL AS INTEGER ) + + 33 - - 46 * - - CASE WHEN NOT
- 7 = NULL THEN COUNT ( * ) END + - - 13 * + 58 AS col2, 11 * - + 56 * 48 * -
20 AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
+591360
query I rowsort
SELECT + 35 * 89 * 80 * - - 30 + - 89
diff --git a/data/sqlite/random/expr/slt_good_53.slt
b/data/sqlite/random/expr/slt_good_53.slt
index 2bc82bf..40bcec0 100644
--- a/data/sqlite/random/expr/slt_good_53.slt
+++ b/data/sqlite/random/expr/slt_good_53.slt
@@ -43678,14 +43678,10 @@ SELECT + NULLIF ( - 97, + 30 + + 63 ) AS col1
----
-97
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -5488
-query error
+query I rowsort label-8328
SELECT + + 92 * - 60 + - - COALESCE ( - ( CAST ( - 32 AS INTEGER ) ), - + CAST
( + ( - NULLIF ( + SUM ( DISTINCT + 60 ), CASE - 64 WHEN - CASE WHEN NULL >= (
NULL ) THEN MAX ( 91 ) END THEN 12 / + 23 WHEN - 68 THEN NULL END ) ) AS
INTEGER ), + 35 ) col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-5488
# Datafusion - Types were automatically converted from:
# Datafusion - [Expected] [I]
diff --git a/data/sqlite/random/expr/slt_good_64.slt
b/data/sqlite/random/expr/slt_good_64.slt
index 91494ec..87b4ebc 100644
--- a/data/sqlite/random/expr/slt_good_64.slt
+++ b/data/sqlite/random/expr/slt_good_64.slt
@@ -16396,14 +16396,10 @@ SELECT MIN ( + CAST ( NULL AS INTEGER ) ) * 33
----
NULL
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-3123
SELECT ALL MAX ( DISTINCT 27 ) * - CASE WHEN ( NULL ) BETWEEN - CAST ( - 86 AS
INTEGER ) AND + 46 + + 97 THEN COUNT ( * ) END * - 66 AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-3124
SELECT ALL 67 + - + COUNT ( ALL - 18 )
@@ -46236,14 +46232,10 @@ SELECT - MAX ( ALL - 53 ) * - COALESCE ( + + 68, - +
MAX ( ALL - 10 ) ) + - + (
----
-3604
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-8805
SELECT + CASE WHEN 22 BETWEEN - + 84 AND NULL THEN + MAX ( - + 39 ) END * + -
49 + + CAST ( + - 39 AS INTEGER ) AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-8806
SELECT ALL - 23 * + 17 * + COUNT ( * ) + - 93 + - 22 + - 29 + + 24 * 70 * - 24
col0
diff --git a/data/sqlite/random/expr/slt_good_66.slt
b/data/sqlite/random/expr/slt_good_66.slt
index b1ee8b0..34da0a4 100644
--- a/data/sqlite/random/expr/slt_good_66.slt
+++ b/data/sqlite/random/expr/slt_good_66.slt
@@ -21434,14 +21434,13 @@ SELECT - 89 / + COALESCE ( + 79, 89 + - 51 )
----
-1
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-4082
SELECT + COALESCE ( - 53, + 23, + 80 ) * ( + 31 ) + 68 + + 62 - + + CASE 51
WHEN - - 16 * - CASE WHEN - COUNT ( * ) > + + COALESCE ( - COALESCE ( 28, - ( -
- CASE WHEN 87 BETWEEN + + COUNT ( * ) + - 89 AND - 80 + - - 1 + 85 AND NULL
NOT BETWEEN NULL AND 81 + CASE CASE - 96 WHEN + ( + + 58 ) * + 87 THEN 77 ELSE
- 40 * + 80 END WHEN 73 - 40 * - COUNT ( * ) THEN COALESCE ( COUNT ( * ), + 12
) + - 47 WHEN + 53 + + 7 / 17 THEN + 92 * 0 WHEN 9 / - COALESCE ( + COUNT ( *
), SUM ( 5 ) * COUNT ( [...]
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort
SELECT 6 * - 31 + - 12, 42 AS col0
diff --git a/data/sqlite/random/expr/slt_good_68.slt
b/data/sqlite/random/expr/slt_good_68.slt
index 8baa233..bcaa3f3 100644
--- a/data/sqlite/random/expr/slt_good_68.slt
+++ b/data/sqlite/random/expr/slt_good_68.slt
@@ -42245,14 +42245,10 @@ SELECT - 87 * - 37 * + + COALESCE ( - 42, - 90 ) * -
COALESCE ( + COUNT ( - 25 )
----
135198
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-8053
SELECT - - CASE WHEN NOT NULL = NULL THEN MIN ( DISTINCT - ( - 23 ) ) END + 98
- + NULLIF ( 71, + 12 + 81 * 1 ) - 90 / + ( + SUM ( - COALESCE ( 54, - ( 56 ) )
) * 52 )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-8054
SELECT ALL + - COUNT ( * ) + 50 * + 68 AS col2
diff --git a/data/sqlite/random/expr/slt_good_7.slt
b/data/sqlite/random/expr/slt_good_7.slt
index e9d8b9b..40cc6d3 100644
--- a/data/sqlite/random/expr/slt_good_7.slt
+++ b/data/sqlite/random/expr/slt_good_7.slt
@@ -30965,15 +30965,14 @@ SELECT ALL ( + 53 ) + ( 42 ) col0, - 23 AS col2
95
-23
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-# Datafusion - Expected - 20
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]I
+# Datafusion - [Actual ] [R]I
+query RI rowsort
SELECT - 33 - CASE WHEN NOT - 5 IS NOT NULL THEN + AVG ( + + 28 ) ELSE NULL
END * + 15 * - + ( - + 58 ) + + 67 + - 1 * - + 43, + 20 AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
+20
query I rowsort
SELECT - CASE - 69 WHEN + - 29 THEN NULL WHEN - - 13 + - 17 + + 58 * 60 - + +
65 THEN - 71 * 34 END AS col2
diff --git a/data/sqlite/random/expr/slt_good_72.slt
b/data/sqlite/random/expr/slt_good_72.slt
index c38f8f6..803da6d 100644
--- a/data/sqlite/random/expr/slt_good_72.slt
+++ b/data/sqlite/random/expr/slt_good_72.slt
@@ -25038,14 +25038,10 @@ SELECT + COALESCE ( + ( + 79 ), + 60 + 41 + + - 74 +
( - - 61 ) ) / + - 90
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-4778
SELECT + 27 / - 76 * - ( ( - 21 ) ) * - CASE WHEN NOT + 53 = + 28 THEN COUNT (
* ) END * + CASE + 83 WHEN CASE COUNT ( * ) WHEN + 88 THEN 61 - + 10 WHEN 75
THEN + 25 + MIN ( DISTINCT + 35 - - 75 ) ELSE NULL END THEN COALESCE ( + ( + 74
), - ( 42 ) ) * + COUNT ( * ) ELSE NULL END
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort
SELECT ALL + 25 AS col2, 20
@@ -25252,14 +25248,10 @@ SELECT DISTINCT - ( + - 67 ) + - 35 / + - NULLIF ( +
NULLIF ( + 39, - 28 - + MAX
----
67
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-4818
SELECT CASE - + 91 WHEN + - 94 THEN NULL WHEN + 88 * 92 + - 0 + - + CASE WHEN
NOT NULL IS NOT NULL THEN + MIN ( DISTINCT + 22 ) END THEN + 59 WHEN SUM (
DISTINCT - CAST ( 80 AS INTEGER ) ) THEN NULL END / - 21
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT + 18 * 2 + - + 82
@@ -47347,15 +47339,11 @@ SELECT 31 + - 26
----
5
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-# Datafusion - Expected - 1920
-query error
+query II rowsort label-9033
SELECT DISTINCT - CASE WHEN NOT ( NULL ) IS NOT NULL THEN + MAX ( ALL + - CASE
13 WHEN + 70 THEN 54 + + 47 + + 96 END ) END, - 40 * - 48 AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
+1920
query I rowsort
SELECT ALL - 0 * + ( 27 ) * - CASE + 14 WHEN + 48 THEN - - 35 ELSE + + 39 + -
75 END * - + 39 + 69 * - + 18 - + + CASE - - 1 WHEN 44 THEN NULL ELSE ( + + 82
) END + + + 90
diff --git a/data/sqlite/random/expr/slt_good_73.slt
b/data/sqlite/random/expr/slt_good_73.slt
index 8421acb..8b88cc7 100644
--- a/data/sqlite/random/expr/slt_good_73.slt
+++ b/data/sqlite/random/expr/slt_good_73.slt
@@ -26740,15 +26740,14 @@ SELECT MAX ( ALL NULLIF ( + 0, 41 ) ) * COUNT ( * )
AS col1
----
0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 86
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] I[I]
+# Datafusion - [Actual ] I[R]
+query IR rowsort label-5093
SELECT 86, 45 + CAST ( + - 27 AS FLOAT8 ) + - 72 * + - NULLIF ( + 69, + + 96 )
* + + CASE WHEN NULL = NULL THEN COUNT ( * ) END * - 97 * 66 AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+86
+NULL
query I rowsort
SELECT CASE + 5 WHEN - 70 - 0 + - - 65 + + ( - + 77 ) THEN NULL ELSE - -
NULLIF ( + 38, - 68 / + 70 + - 56 ) END + 5 + + - 43 * + 50
diff --git a/data/sqlite/random/expr/slt_good_78.slt
b/data/sqlite/random/expr/slt_good_78.slt
index 086702d..cd45bd5 100644
--- a/data/sqlite/random/expr/slt_good_78.slt
+++ b/data/sqlite/random/expr/slt_good_78.slt
@@ -36584,14 +36584,10 @@ SELECT - + MIN ( - 21 ) + + + 31 AS col0
----
52
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-6968
SELECT ALL - 58 * 59 * ( - - CASE WHEN 12 IS NULL THEN + COUNT ( DISTINCT +
CAST ( - + 88 AS INTEGER ) ) END ) * - 70 * - COUNT ( ALL 35 ) * + 68 + + - 71
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-6969
SELECT - 15 / MIN ( DISTINCT + 84 ) AS col0
diff --git a/data/sqlite/random/expr/slt_good_80.slt
b/data/sqlite/random/expr/slt_good_80.slt
index befa493..269310c 100644
--- a/data/sqlite/random/expr/slt_good_80.slt
+++ b/data/sqlite/random/expr/slt_good_80.slt
@@ -40451,14 +40451,10 @@ SELECT ALL - NULLIF ( + + 2, + 22 ) * + - 72 / 18 + -
43
----
-35
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-7719
SELECT + CASE 87 WHEN ( MAX ( DISTINCT 4 ) ) - MAX ( DISTINCT 61 ) THEN - 25
END + CASE - CASE WHEN ( NULL ) <= + + 17 THEN + MAX ( 15 ) ELSE NULL END WHEN
- + 65 THEN - 49 ELSE + - 17 END AS col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort label-7720
SELECT ( COUNT ( + 68 ) )
diff --git a/data/sqlite/random/expr/slt_good_81.slt
b/data/sqlite/random/expr/slt_good_81.slt
index 062d1f7..85836ad 100644
--- a/data/sqlite/random/expr/slt_good_81.slt
+++ b/data/sqlite/random/expr/slt_good_81.slt
@@ -12315,15 +12315,11 @@ SELECT ALL COUNT ( * ) + - + 15 col2
----
-14
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - -42
-# Datafusion - Expected - NULL
-query error
+query II rowsort label-2353
SELECT ALL - 42 * ( COUNT ( * ) ) AS col2, - CASE WHEN NOT + 39 IS NOT NULL
THEN + SUM ( DISTINCT + - 1 ) ELSE NULL END * 56 - - + 50 + - 53 * + - 36 AS
col1
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+-42
+NULL
query I rowsort
SELECT DISTINCT - ( + + 25 ) col2
@@ -27367,14 +27363,13 @@ SELECT + CAST ( - MAX ( + 12 ) AS INTEGER ) AS col1
----
-12
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] [I]
+# Datafusion - [Actual ] [R]
+query R rowsort label-5227
SELECT ALL + CASE WHEN + 6 IS NULL THEN COUNT ( * ) END * - 75 + NULLIF ( +
AVG ( ALL + 48 ), + 45 * + NULLIF ( + 18, 59 ) ) AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT ALL 75 * - 55 + - 48 AS col1
diff --git a/data/sqlite/random/expr/slt_good_82.slt
b/data/sqlite/random/expr/slt_good_82.slt
index f4bd410..a05e380 100644
--- a/data/sqlite/random/expr/slt_good_82.slt
+++ b/data/sqlite/random/expr/slt_good_82.slt
@@ -30300,14 +30300,10 @@ SELECT 76 * - ( 48 ) - 96 AS col2
----
-3744
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-5785
SELECT DISTINCT ( + CASE WHEN NULL = NULL THEN SUM ( ALL - 99 ) END )
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT ALL 91 + + + 16 AS col2
diff --git a/data/sqlite/random/expr/slt_good_85.slt
b/data/sqlite/random/expr/slt_good_85.slt
index 043e230..dcb8d73 100644
--- a/data/sqlite/random/expr/slt_good_85.slt
+++ b/data/sqlite/random/expr/slt_good_85.slt
@@ -15450,14 +15450,10 @@ SELECT COUNT ( * ) + - 48 * + 84 AS col2
----
-4031
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 30
-query error
+query I rowsort label-2949
SELECT CASE WHEN NOT ( 92 ) <= - 0 THEN + MIN ( + 30 ) ELSE NULL END col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+30
query I rowsort label-2950
SELECT 84 + 52 / + 34
@@ -42069,15 +42065,11 @@ NULL
query error DataFusion error: Error during planning: Projections require
unique expression names but the expression "Int64\(46\) \- Int64\(\-9\) AS
col0" at position 0 and "Int64\(24\) AS col0" at position 1 have the same
name\. Consider aliasing \("AS"\) one of them\.
SELECT ALL + 46 - - 9 AS col0, 24 AS col0
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 1
-# Datafusion - Expected - -66
-query error
+query II rowsort label-8014
SELECT DISTINCT COUNT ( * ), 1 * + - CASE WHEN NOT ( + 14 ) IN ( - 28 ) THEN
SUM ( + 66 ) END AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+1
+-66
query I rowsort label-8015
SELECT + MIN ( - + 49 ) + + - 87
diff --git a/data/sqlite/random/expr/slt_good_88.slt
b/data/sqlite/random/expr/slt_good_88.slt
index 0fc01ac..220f0be 100644
--- a/data/sqlite/random/expr/slt_good_88.slt
+++ b/data/sqlite/random/expr/slt_good_88.slt
@@ -48509,14 +48509,10 @@ SELECT ALL + COUNT ( * ) / 67 + - 73 col2
----
-73
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-9231
SELECT ALL - 72 * + + 61 * 99 * - 54 + + + NULLIF ( 23, - - COALESCE ( + +
CASE WHEN NOT ( NULL ) <> ( NULL ) THEN MAX ( - 49 ) END, 16 - + 76 ) + 56 ) +
+ CASE - 20 WHEN COUNT ( * ) THEN NULL WHEN COUNT ( * ) THEN + 46 END * + 80 *
+ 62 AS col2
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query I rowsort
SELECT - 11 * 35
diff --git a/data/sqlite/random/expr/slt_good_94.slt
b/data/sqlite/random/expr/slt_good_94.slt
index 69abd0e..7792c81 100644
--- a/data/sqlite/random/expr/slt_good_94.slt
+++ b/data/sqlite/random/expr/slt_good_94.slt
@@ -21186,14 +21186,10 @@ SELECT ALL 15 - - 30
----
45
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 41
-query error
+query I rowsort label-4032
SELECT + NULLIF ( + 41, - 91 / + CASE + + 84 WHEN + 38 * - 6 THEN 90 WHEN -
AVG ( - 40 ) + - 22 * + - 4 THEN 27 ELSE - CASE WHEN NOT 71 <> NULL THEN +
COUNT ( * ) END END - + - 59 * - - 45 ) AS col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+41
query I rowsort label-4033
SELECT COALESCE ( SUM ( ALL + NULLIF ( 42, COALESCE ( - 92, + 35 ) ) ), + +
COALESCE ( + COALESCE ( 19, - 85 - - 4 + + 75 * - 57 ), - - 29 ) - - 94 + 64 -
+ 20 ) + + 77 AS col0
diff --git a/data/sqlite/random/expr/slt_good_95.slt
b/data/sqlite/random/expr/slt_good_95.slt
index ae2243a..4ce5be6 100644
--- a/data/sqlite/random/expr/slt_good_95.slt
+++ b/data/sqlite/random/expr/slt_good_95.slt
@@ -33221,14 +33221,10 @@ SELECT DISTINCT 11 * 89 - + - 55 AS col1
----
1034
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-query error
+query I rowsort
SELECT - CASE - + CASE WHEN ( ( - - 17 ) IS NOT NULL ) THEN AVG ( ALL 79 )
ELSE NULL END WHEN 49 THEN 39 * 35 ELSE NULL END
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
query II rowsort
SELECT - 68 AS col1, 1
diff --git a/data/sqlite/random/groupby/slt_good_11.slt
b/data/sqlite/random/groupby/slt_good_11.slt
index 8adf2a4..6b1b82d 100644
--- a/data/sqlite/random/groupby/slt_good_11.slt
+++ b/data/sqlite/random/groupby/slt_good_11.slt
@@ -57640,13 +57640,9 @@ query I rowsort label-9455
SELECT ALL - col2 FROM tab1 AS cor0 GROUP BY col2, col2 HAVING NOT NULL
BETWEEN - + col2 AND ( + + CAST ( NULL AS INTEGER ) )
----
-# Datafusion - Datafusion expected results:
-query error
+query I rowsort
SELECT ALL - col2 AS col2 FROM tab1 WHERE NOT NULL <> ( 78 + CASE WHEN NOT (
NULL ) IS NULL THEN + col0 ELSE NULL END ) GROUP BY col1, col2
----
-DataFusion error: External error: External error: Internal error: predicate
did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
query I rowsort label-9457
SELECT CAST ( col2 AS INTEGER ) AS col1 FROM tab0 GROUP BY col2, col1 HAVING (
NULL ) IN ( - 28 )
diff --git a/data/sqlite/random/groupby/slt_good_12.slt
b/data/sqlite/random/groupby/slt_good_12.slt
index 8ac063a..ec8bcec 100644
--- a/data/sqlite/random/groupby/slt_good_12.slt
+++ b/data/sqlite/random/groupby/slt_good_12.slt
@@ -2991,16 +2991,12 @@ query I rowsort
SELECT + col2 + ( + col2 + - col2 ) AS col2 FROM tab0 WHERE NOT ( + 69 ) IS
NULL GROUP BY col2, col2 HAVING NOT 51 IS NOT NULL
----
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-# Datafusion - Expected - NULL
-# Datafusion - Expected - NULL
-query error
+query I rowsort
SELECT col0 + - CASE WHEN 64 IS NULL THEN + col0 END FROM tab2 AS cor0 GROUP
BY col0
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
+NULL
+NULL
query I rowsort
SELECT + ( col0 ) / col0 - col0 / - col0 FROM tab1 cor0 GROUP BY col0 HAVING
NOT ( + 38 ) IS NOT NULL
@@ -25913,13 +25909,9 @@ SELECT DISTINCT - 59 * - 88 * - col2 + + + ( + - col2
) FROM tab2 GROUP BY col2
-410247
-451791
-# Datafusion - Datafusion expected results:
-query error
+query I rowsort
SELECT ALL - 99 AS col2 FROM tab0 cor0 WHERE NULL = 95 / + + CASE WHEN NOT 23
IS NOT NULL THEN col2 END GROUP BY col2, col2
----
-DataFusion error: External error: External error: Internal error: predicate
did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
query I rowsort
SELECT ( + + col0 ) AS col0 FROM tab1 AS cor0 GROUP BY col0, col1
@@ -34054,16 +34046,12 @@ query I rowsort label-5578
SELECT 20 FROM tab2 AS cor0 WHERE NULL IS NULL GROUP BY col0 HAVING NOT col0
NOT BETWEEN + col0 + + 84 + COUNT ( * ) AND - 2
----
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - NULL
-# Datafusion - Expected - NULL
-# Datafusion - Expected - NULL
-query error
+query I rowsort label-5579
SELECT 55 * col1 + - CASE WHEN NOT - CAST ( NULL AS INTEGER ) NOT IN ( - CAST
( NULL AS INTEGER ) ) THEN + col1 END FROM tab0 GROUP BY col1, col2 HAVING NOT
NULL IS NOT NULL
----
-DataFusion error: Internal error: predicate did not evaluate to an array.
-This was likely caused by a bug in DataFusion's code and we would welcome that
you file an bug report in our issue tracker
-
+NULL
+NULL
+NULL
query I rowsort
SELECT + + 24 FROM tab1 AS cor0 GROUP BY col0, col0
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
