better test

yakov-olkhovskiy · yakov-olkhovskiy · commit 3fc4d8988bd2 · 2024-07-04T21:51:57.000Z
diff --git a/tests/queries/0_stateless/03174_projection_deduplicate.reference b/tests/queries/0_stateless/03174_projection_deduplicate.reference
@@ -1,2 +1,3 @@
 1	one
 1	one
+1	one
diff --git a/tests/queries/0_stateless/03174_projection_deduplicate.sql b/tests/queries/0_stateless/03174_projection_deduplicate.sql
@@ -21,4 +21,10 @@ OPTIMIZE TABLE test_projection_deduplicate DEDUPLICATE; -- { serverError NOT_IMP
 
 SELECT * FROM test_projection_deduplicate;
 
+ALTER TABLE test_projection_deduplicate DROP PROJECTION test_projection;
+
+OPTIMIZE TABLE test_projection_deduplicate DEDUPLICATE;
+
+SELECT * FROM test_projection_deduplicate;
+
 DROP TABLE test_projection_deduplicate;
