Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 25 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/in/in_ansi_variant.sql b/yql/essentials/tests/sql/suites/in/in_ansi_variant.sql
new file mode 100644
index 0000000000..86b2a2dbfa
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/in/in_ansi_variant.sql
@@ -0,0 +1,25 @@
+/* postgres can not */
+/* syntax version 1 */
+PRAGMA AnsiInForEmptyOrNullableItemsCollections;
+Select Enum("foo",Enum<"foo","bar">) in (
+            AsEnum("foo")
+        ),
+        Enum("foo",Enum<"foo","bar">) in (
+            AsEnum("bar")
+        ),
+        Enum("foo",Enum<"foo","bar">) in (
+            AsEnum("foo"),
+            AsEnum("bar")
+        ),
+        Enum("foo",Enum<"foo","bar">) in (
+            AsEnum("bar"),
+            AsEnum("baz")
+        ),
+        Enum("foo",Enum<"foo","bar">) in [
+            AsEnum("foo"),
+            AsEnum("bar")
+        ],
+        Enum("foo",Enum<"foo","bar">) in {
+            AsEnum("bar"),
+            AsEnum("baz")
+        };        
\ No newline at end of file