You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by iv...@apache.org on 2022/02/15 12:50:01 UTC
[ignite] 01/01: IGNITE-15585 Unignore previously failed tests.
This is an automated email from the ASF dual-hosted git repository.
ivandasch pushed a commit to branch ignite-15585
in repository https://gitbox.apache.org/repos/asf/ignite.git
commit 07b01a487813bad8d31a05eeb38fcd444b4c1a1b
Author: Ivan Daschinsky <iv...@apache.org>
AuthorDate: Tue Feb 15 15:48:44 2022 +0300
IGNITE-15585 Unignore previously failed tests.
---
..._not_in.test_ignore => test_simple_not_in.test} | 3 +-
.../subquery/exists/test_correlated_exists.test | 36 ++++++++++++++++++++
.../exists/test_correlated_exists.test_ignore | 39 ----------------------
3 files changed, 37 insertions(+), 41 deletions(-)
diff --git a/modules/calcite/src/test/sql/subquery/any_all/test_simple_not_in.test_ignore b/modules/calcite/src/test/sql/subquery/any_all/test_simple_not_in.test
similarity index 86%
rename from modules/calcite/src/test/sql/subquery/any_all/test_simple_not_in.test_ignore
rename to modules/calcite/src/test/sql/subquery/any_all/test_simple_not_in.test
index 794e44f..653b219 100644
--- a/modules/calcite/src/test/sql/subquery/any_all/test_simple_not_in.test_ignore
+++ b/modules/calcite/src/test/sql/subquery/any_all/test_simple_not_in.test
@@ -1,14 +1,13 @@
# name: test/sql/subquery/any_all/test_simple_not_in.test
# description: Test subqueries with (NOT) IN clause
# group: [any_all]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-15584
statement ok
PRAGMA enable_verification
# scalar subquery
query I
-SELECT 1 AS one WHERE 1 IN (SELECT 1);
+SELECT 1 AS one FROM (VALUES (NULL)) WHERE 1 IN (SELECT 1);
----
1
diff --git a/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test b/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test
index 9d00e09..3f444d2 100644
--- a/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test
+++ b/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test
@@ -28,4 +28,40 @@ NULL true
2 true
3 true
+# correlated EXISTS
+query IT
+SELECT i, EXISTS(SELECT i FROM integers WHERE i1.i>2) FROM integers i1 ORDER BY i NULLS FIRST;
+----
+NULL false
+1 false
+2 false
+3 true
+
+query IT
+SELECT i, EXISTS(SELECT i FROM integers WHERE i=i1.i) FROM integers i1 ORDER BY i NULLS FIRST;
+----
+NULL false
+1 true
+2 true
+3 true
+
+query I
+SELECT i FROM integers i1 WHERE EXISTS(SELECT i FROM integers WHERE i=i1.i) ORDER BY i;
+----
+1
+2
+3
+# SUM on exists
+query R
+SELECT SUM(CASE WHEN EXISTS(SELECT i FROM integers WHERE i=i1.i) THEN 1 ELSE 0 END) FROM integers i1;
+----
+3.000000
+
+query IT
+SELECT i, EXISTS(SELECT i FROM integers WHERE i IS NULL OR i>i1.i*10) FROM integers i1 ORDER BY i NULLS FIRST;
+----
+NULL true
+1 true
+2 true
+3 true
diff --git a/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test_ignore b/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test_ignore
index b63b773..0749c04 100644
--- a/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test_ignore
+++ b/modules/calcite/src/test/sql/subquery/exists/test_correlated_exists.test_ignore
@@ -1,7 +1,6 @@
# name: test/sql/subquery/exists/test_correlated_exists.test
# description: Test correlated exists
# group: [exists]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-15585
# Ignore https://issues.apache.org/jira/browse/IGNITE-15586
# Ignore https://issues.apache.org/jira/browse/IGNITE-15587
# Ignore https://issues.apache.org/jira/browse/IGNITE-15588
@@ -19,22 +18,6 @@ INSERT INTO integers VALUES (1), (2), (3), (NULL)
# correlated EXISTS
query IT
-SELECT i, EXISTS(SELECT i FROM integers WHERE i1.i>2) FROM integers i1 ORDER BY i NULLS FIRST;
-----
-NULL false
-1 false
-2 false
-3 true
-
-query IT
-SELECT i, EXISTS(SELECT i FROM integers WHERE i=i1.i) FROM integers i1 ORDER BY i NULLS FIRST;
-----
-NULL false
-1 true
-2 true
-3 true
-
-query IT
SELECT i, EXISTS(SELECT i FROM integers WHERE i1.i>i OR i1.i IS NULL) FROM integers i1 ORDER BY i NULLS FIRST;
----
NULL true
@@ -42,13 +25,6 @@ NULL true
2 true
3 true
-query I
-SELECT i FROM integers i1 WHERE EXISTS(SELECT i FROM integers WHERE i=i1.i) ORDER BY i;
-----
-1
-2
-3
-
# correlated EXISTS with aggregations
query T
SELECT EXISTS(SELECT i FROM integers WHERE i>MIN(i1.i)) FROM integers i1;
@@ -80,21 +56,6 @@ true 3
# SUM on exists
query R
-SELECT SUM(CASE WHEN EXISTS(SELECT i FROM integers WHERE i=i1.i) THEN 1 ELSE 0 END) FROM integers i1;
-----
-3.000000
-
-48
-
-query IT
-SELECT i, EXISTS(SELECT i FROM integers WHERE i IS NULL OR i>i1.i*10) FROM integers i1 ORDER BY i NULLS FIRST;
-----
-NULL true
-1 true
-2 true
-3 true
-
-query R
SELECT (SELECT COVAR_POP(i2.i, i1.i) FROM integers i2) FROM integers i1 ORDER BY 1 NULLS FIRST
----
NULL