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 e9f9e22 Updates for changes in DataFusion PR #15462 (#9) e9f9e22 is described below commit e9f9e22ccf09145a7368f80fd6a871f11e2b4481 Author: Bruce Ritchie <bruce.ritc...@veeva.com> AuthorDate: Wed Apr 9 06:31:33 2025 -0400 Updates for changes in DataFusion PR #15462 (#9) --- data/sqlite/random/aggregates/slt_good_11.slt | 4 ++-- data/sqlite/random/groupby/slt_good_12.slt | 8 ++++---- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/data/sqlite/random/aggregates/slt_good_11.slt b/data/sqlite/random/aggregates/slt_good_11.slt index b9dd3ff..4f26801 100644 --- a/data/sqlite/random/aggregates/slt_good_11.slt +++ b/data/sqlite/random/aggregates/slt_good_11.slt @@ -6356,9 +6356,9 @@ SELECT DISTINCT + ( - COUNT ( * ) ) * + COUNT ( * ) AS col0 FROM tab2 ---- -9 -# Datafusion - Datafusion expected results: -query error DataFusion error: Arrow error: Divide by zero error +query I rowsort label-1028 SELECT - 69 FROM tab0 WHERE + - col1 NOT IN ( - + col1, CAST ( + col0 AS INTEGER ), + + ( + + col1 ) / + - 0 * + col0 ) +---- query I rowsort SELECT ALL - col1 * - col0 + - ( 88 ) AS col1 FROM tab1 diff --git a/data/sqlite/random/groupby/slt_good_12.slt b/data/sqlite/random/groupby/slt_good_12.slt index 98bde5d..58bbf38 100644 --- a/data/sqlite/random/groupby/slt_good_12.slt +++ b/data/sqlite/random/groupby/slt_good_12.slt @@ -12137,9 +12137,9 @@ SELECT - col1 + - col1 AS col1 FROM tab2 WHERE NULL IS NULL GROUP BY col1 -122 -82 -# Datafusion - Datafusion expected results: -query error DataFusion error: Arrow error: Divide by zero error +query I rowsort SELECT DISTINCT col1 AS col1 FROM tab0 WHERE NOT + CASE + 87 WHEN col1 THEN col1 ELSE NULL END NOT BETWEEN - col1 / + col1 AND NULL GROUP BY col1 HAVING NOT col1 * 75 IS NOT NULL +---- query I rowsort SELECT ( - ( - col0 ) ) FROM tab0 GROUP BY col0 HAVING NULL IN ( 93 ) @@ -26969,9 +26969,9 @@ SELECT DISTINCT - + col0 AS col2, col0 / + - col0 FROM tab1 AS cor0 WHERE col2 * -82 -1 -# Datafusion - Datafusion expected results: -query error DataFusion error: Arrow error: Divide by zero error +query I rowsort SELECT - col0 * 87 * - col1 FROM tab0 WHERE NOT col1 BETWEEN 67 + 65 AND - 41 / - col1 + + + col0 * + col1 * col2 / - col0 GROUP BY col1, col0 HAVING NOT col0 IS NOT NULL +---- query I rowsort SELECT DISTINCT ( - - col1 ) + + 43 FROM tab2 GROUP BY col1, col1, col1 --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org For additional commands, e-mail: commits-h...@datafusion.apache.org