This is an automated email from the ASF dual-hosted git repository.
jooger pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
The following commit(s) were added to refs/heads/main by this push:
new 5a419c5dd9 IGNITE-21935: Cover SQL E153(Updatable queries with
subqueries) feature by tests (#3630)
5a419c5dd9 is described below
commit 5a419c5dd92fd15f278ac101c3699db1827092c3
Author: ygerzhedovich <[email protected]>
AuthorDate: Fri Apr 19 13:04:28 2024 +0300
IGNITE-21935: Cover SQL E153(Updatable queries with subqueries) feature by
tests (#3630)
---
.../sql/subquery/scalar/test_delete_subquery.test | 1 +
.../sql/subquery/scalar/test_update_subquery.test | 17 +++++
.../scalar/test_update_subquery.test_ignore | 73 ----------------------
3 files changed, 18 insertions(+), 73 deletions(-)
diff --git
a/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_delete_subquery.test
b/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_delete_subquery.test
index 54a197296a..22c7437e5d 100644
---
a/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_delete_subquery.test
+++
b/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_delete_subquery.test
@@ -1,5 +1,6 @@
# name: test/sql/subquery/scalar/test_delete_subquery.test
# description: Test subqueries in delete
+# feature: E153
# group: [scalar]
statement ok
diff --git
a/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test
b/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test
index 4cdf18f991..b36c1ff75b 100644
---
a/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test
+++
b/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test
@@ -1,5 +1,6 @@
# name: test/sql/subquery/scalar/test_update_subquery.test
# description: Test subqueries in update
+# feature: E153
# group: [scalar]
statement ok
@@ -59,3 +60,19 @@ SELECT id, i FROM integers ORDER BY id
3 2
4 3
+skipif ignite3
+# https://issues.apache.org/jira/browse/IGNITE-15616
+# use DEFAULT with correlated subquery in WHERE
+statement ok
+UPDATE integers i1 SET i=DEFAULT WHERE i=(SELECT MIN(i) FROM integers WHERE
i1.id<id);
+
+skipif ignite3
+# https://issues.apache.org/jira/browse/IGNITE-15616
+query II
+SELECT id, i FROM integers ORDER BY id
+----
+1 NULL
+2 NULL
+3 2
+4 3
+
diff --git
a/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test_ignore
b/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test_ignore
deleted file mode 100644
index 5b5597eae9..0000000000
---
a/modules/sql-engine/src/integrationTest/sql/subquery/scalar/test_update_subquery.test_ignore
+++ /dev/null
@@ -1,73 +0,0 @@
-# name: test/sql/subquery/scalar/test_update_subquery.test
-# description: Test subqueries in update
-# group: [scalar]
-
-statement ok
-PRAGMA enable_verification
-
-statement ok
-CREATE TABLE integers(id INTEGER, i INTEGER)
-
-statement ok
-INSERT INTO integers VALUES (1, 1), (2, 2), (3, 3), (4, NULL)
-
-# correlated subquery in update
-statement ok
-UPDATE integers i1 SET i=(SELECT MAX(i) FROM integers WHERE i1.i<>i)
-
-query II
-SELECT id, i FROM integers ORDER BY id
-----
-1 3
-2 3
-3 2
-4 NULL
-
-# uncorrelated subquery in update
-statement ok
-UPDATE integers i1 SET i=(SELECT MAX(i) FROM integers) WHERE i=(SELECT MIN(i)
FROM integers)
-
-query II
-SELECT id, i FROM integers ORDER BY id
-----
-1 3
-2 3
-3 3
-4 NULL
-
-# use different correlated column in subquery
-statement ok
-UPDATE integers i1 SET i=(SELECT MAX(id) FROM integers WHERE id<i1.id)
-
-query II
-SELECT id, i FROM integers ORDER BY id
-----
-1 NULL
-2 1
-3 2
-4 3
-
-# correlated subquery in WHERE
-statement ok
-UPDATE integers i1 SET i=2 WHERE i<(SELECT MAX(id) FROM integers WHERE
i1.id<id);
-
-query II
-SELECT id, i FROM integers ORDER BY id
-----
-1 NULL
-2 2
-3 2
-4 3
-
-# use DEFAULT with correlated subquery in WHERE
-statement ok
-UPDATE integers i1 SET i=DEFAULT WHERE i=(SELECT MIN(i) FROM integers WHERE
i1.id<id);
-
-query II
-SELECT id, i FROM integers ORDER BY id
-----
-1 NULL
-2 NULL
-3 2
-4 3
-
