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

Library import 241120-1113

1 files changed, 21 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/in/in_ansi_dict.sql b/yql/essentials/tests/sql/suites/in/in_ansi_dict.sql
new file mode 100644
index 0000000000..aaf4b5590c
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/in/in_ansi_dict.sql
@@ -0,0 +1,21 @@
+/* syntax version 1 */
+/* postgres can not */
+
+PRAGMA AnsiInForEmptyOrNullableItemsCollections;
+
+SELECT
+    1         IN AsDict((2, "x"), (3, "y"), (null, "z")),       -- Nothing<Bool?>
+    null      IN DictCreate(Int32, String?),                    -- false?
+    null      IN AsDict((null, "foo")),                         -- Nothing<Bool?>
+    null      IN AsDict((1, "bar")),                            -- Nothing<Bool?>
+    (1, null) IN AsDict(((1, 1), null), ((2, 2), "foo")),       -- Nothing<Bool?>
+    (1, null) IN AsDict(((2, 2), "foo"), ((3, 3), "bar")),      -- false?
+    (1, 2)    IN AsDict(((1, null), "foo"), ((2, 2), "bar")),   -- Nothing<Bool?>
+    (1, 2)    IN AsDict(((null, 1), "foo"),  ((2, 1), null)),   -- false?
+    (1, 2)    IN AsDict(((1, null), "foo"), ((2, 1), "bar")),   -- Nothing<Bool?>
+;
+
+SELECT
+    Just(1)   IN AsDict((1, "foo"), (2, "bar"), (3, null)),     -- true?
+    1         IN AsDict((Just(2), null), (Just(3), "bar")),     -- false?
+;