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:00 UTC
[ignite] branch ignite-15585 created (now 07b01a4)
This is an automated email from the ASF dual-hosted git repository.
ivandasch pushed a change to branch ignite-15585
in repository https://gitbox.apache.org/repos/asf/ignite.git.
at 07b01a4 IGNITE-15585 Unignore previously failed tests.
This branch includes the following new commits:
new 07b01a4 IGNITE-15585 Unignore previously failed tests.
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
[ignite] 01/01: IGNITE-15585 Unignore previously failed tests.
Posted by iv...@apache.org.
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