IGNITE-21952: Cover SQL T551(Optional key words for default syntax) feature by test (#3731)
diff --git a/modules/sql-engine/src/integrationTest/sql/union/test_basic_union.test b/modules/sql-engine/src/integrationTest/sql/set/test_basic_union.test
similarity index 93%
rename from modules/sql-engine/src/integrationTest/sql/union/test_basic_union.test
rename to modules/sql-engine/src/integrationTest/sql/set/test_basic_union.test
index 0c09f87..7619edc 100644
--- a/modules/sql-engine/src/integrationTest/sql/union/test_basic_union.test
+++ b/modules/sql-engine/src/integrationTest/sql/set/test_basic_union.test
@@ -1,5 +1,7 @@
-# description: Basic union tests
+# name: test/sql/set/basic_union.test
+# description: UNION DISTINCT table operator
# feature: E071-01
+# [group] Set operations
statement ok
CREATE TABLE a(i INTEGER);
diff --git a/modules/sql-engine/src/integrationTest/sql/set/test_set_distinct.test b/modules/sql-engine/src/integrationTest/sql/set/test_set_distinct.test
new file mode 100644
index 0000000..314f882
--- /dev/null
+++ b/modules/sql-engine/src/integrationTest/sql/set/test_set_distinct.test
@@ -0,0 +1,24 @@
+# name: test/sql/set/test_set_distinct.test
+# description: Optional keyword UNION DISTINCT, EXCEPT DISTINCT, or INTERSECT DISTINCT.
+# feature: SQL T551
+# [group] Set operations
+
+query I
+SELECT 1 UNION DISTINCT SELECT * FROM (values(1),(2),(2),(3),(3),(3),(4)) s(x)
+----
+1
+2
+3
+4
+
+query I
+SELECT * FROM (values(1),(2),(2),(3),(3),(3),(5)) s(x) EXCEPT DISTINCT SELECT * FROM (values (2),(2),(3),(3),(4)) s(x)
+----
+1
+5
+
+query I
+SELECT * FROM (values(1),(2),(2),(3),(3),(3),(5)) s(x) INTERSECT DISTINCT SELECT * FROM (values (2),(2),(3),(3),(4)) s(x)
+----
+2
+3
