Intermediate changes

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

1 files changed, 27 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/expr/as_dict_tuple_key.yql b/yql/essentials/tests/sql/suites/expr/as_dict_tuple_key.yql
new file mode 100644
index 00000000000..78c8bb39244
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/expr/as_dict_tuple_key.yql
@@ -0,0 +1,27 @@
+/* postgres can not */
+$d = AsDict(
+    AsTuple(AsTuple(),"foo"),
+    AsTuple(AsTuple(),"bar")
+);
+
+select ListSort(DictItems($d)),ListSort(DictKeys($d)),ListSort(DictPayloads($d));
+select DictLookup($d,AsTuple());
+select DictContains($d,AsTuple());
+
+$d = AsDict(
+    AsTuple(AsTuple(1),"foo"),
+    AsTuple(AsTuple(2),"bar")
+);
+
+select ListSort(DictItems($d)),ListSort(DictKeys($d)),ListSort(DictPayloads($d));
+select DictLookup($d,AsTuple(1)),DictLookup($d,AsTuple(3));
+select DictContains($d,AsTuple(1)),DictContains($d,AsTuple(3));
+
+$d = AsDict(
+    AsTuple(AsTuple(1,2),"foo"),
+    AsTuple(AsTuple(1,3),"bar")
+);
+
+select ListSort(DictItems($d)),ListSort(DictKeys($d)),ListSort(DictPayloads($d));
+select DictLookup($d,AsTuple(1,2)),DictLookup($d,AsTuple(1,4));
+select DictContains($d,AsTuple(1,2)),DictContains($d,AsTuple(1,4));