IGNITE-21935: Cover SQL E153(Updatable queries with subqueries) feature by tests (#3630)
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 54a1972..22c7437 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 4cdf18f..b36c1ff 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 @@
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 5b5597e..0000000
--- 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
-