YDB public API invalid types functional tests

11 files changed, 80 insertions, 0 deletions

diff --git a/ydb/public/sdk/python2/ydb/convert.py b/ydb/public/sdk/python2/ydb/convert.py
index cccb5641e1..07a3658b31 100644
--- a/ydb/public/sdk/python2/ydb/convert.py
+++ b/ydb/public/sdk/python2/ydb/convert.py
@@ -124,6 +124,8 @@ _to_native_map = {
     "dict_type": _pb_to_dict,
     "struct_type": _pb_to_struct,
     "void_type": _pb_to_void,
+    "empty_list_type": _pb_to_list,
+    "empty_dict_type": _pb_to_dict,
 }
 
 
diff --git a/ydb/tests/functional/canonical/canondata/result.json b/ydb/tests/functional/canonical/canondata/result.json
index 1454198ef6..7b90e51e8e 100644
--- a/ydb/tests/functional/canonical/canondata/result.json
+++ b/ydb/tests/functional/canonical/canondata/result.json
@@ -914,6 +914,26 @@
             "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_ct.script-script_/simple_ct.script_Questions.results"
         }
     },
+    "test_sql.TestCanonicalFolder1.test_case[simple/empty_dict_select.sql-plan]": {
+        "plan": {
+            "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-plan_/simple_empty_dict_select.sql.plan"
+        }
+    },
+    "test_sql.TestCanonicalFolder1.test_case[simple/empty_dict_select.sql-result_sets]": {
+        "result_sets": {
+            "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-result_sets_/simple_empty_dict_select.sql.results"
+        }
+    },
+    "test_sql.TestCanonicalFolder1.test_case[simple/empty_list_select.sql-plan]": {
+        "plan": {
+            "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-plan_/simple_empty_list_select.sql.plan"
+        }
+    },
+    "test_sql.TestCanonicalFolder1.test_case[simple/empty_list_select.sql-result_sets]": {
+        "result_sets": {
+            "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-result_sets_/simple_empty_list_select.sql.results"
+        }
+    },
     "test_sql.TestCanonicalFolder1.test_case[simple/empty_select.sql-plan]": {
         "plan": {
             "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_empty_select.sql-plan_/simple_empty_select.sql.plan"
@@ -934,6 +954,16 @@
             "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_multi_select.sql-result_sets_/simple_multi_select.sql.results"
         }
     },
+    "test_sql.TestCanonicalFolder1.test_case[simple/null_select.sql-plan]": {
+        "plan": {
+            "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-plan_/simple_null_select.sql.plan"
+        }
+    },
+    "test_sql.TestCanonicalFolder1.test_case[simple/null_select.sql-result_sets]": {
+        "result_sets": {
+            "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-result_sets_/simple_null_select.sql.results"
+        }
+    },
     "test_sql.TestCanonicalFolder1.test_case[simple/q1.sql-plan]": {
         "plan": {
             "uri": "file://test_sql.TestCanonicalFolder1.test_case_simple_q1.sql-plan_/simple_q1.sql.plan"
diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-plan_/simple_empty_dict_select.sql.plan b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-plan_/simple_empty_dict_select.sql.plan
new file mode 100644
index 0000000000..bedd745711
--- /dev/null
+++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-plan_/simple_empty_dict_select.sql.plan
@@ -0,0 +1,7 @@
+{
+    "meta": {
+        "type": "query",
+        "version": "0.2"
+    },
+    "tables": []
+}
\ No newline at end of file
diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-result_sets_/simple_empty_dict_select.sql.results b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-result_sets_/simple_empty_dict_select.sql.results
new file mode 100644
index 0000000000..2b12f02037
--- /dev/null
+++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_dict_select.sql-result_sets_/simple_empty_dict_select.sql.results
@@ -0,0 +1,7 @@
+[
+    [
+        {
+            "column0": {}
+        }
+    ]
+]
\ No newline at end of file
diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-plan_/simple_empty_list_select.sql.plan b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-plan_/simple_empty_list_select.sql.plan
new file mode 100644
index 0000000000..bedd745711
--- /dev/null
+++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-plan_/simple_empty_list_select.sql.plan
@@ -0,0 +1,7 @@
+{
+    "meta": {
+        "type": "query",
+        "version": "0.2"
+    },
+    "tables": []
+}
\ No newline at end of file
diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-result_sets_/simple_empty_list_select.sql.results b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-result_sets_/simple_empty_list_select.sql.results
new file mode 100644
index 0000000000..743bd790ce
--- /dev/null
+++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_empty_list_select.sql-result_sets_/simple_empty_list_select.sql.results
@@ -0,0 +1,7 @@
+[
+    [
+        {
+            "column0": []
+        }
+    ]
+]
\ No newline at end of file
diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-plan_/simple_null_select.sql.plan b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-plan_/simple_null_select.sql.plan
new file mode 100644
index 0000000000..bedd745711
--- /dev/null
+++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-plan_/simple_null_select.sql.plan
@@ -0,0 +1,7 @@
+{
+    "meta": {
+        "type": "query",
+        "version": "0.2"
+    },
+    "tables": []
+}
\ No newline at end of file
diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-result_sets_/simple_null_select.sql.results b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-result_sets_/simple_null_select.sql.results
new file mode 100644
index 0000000000..57e375dafe
--- /dev/null
+++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_simple_null_select.sql-result_sets_/simple_null_select.sql.results
@@ -0,0 +1,7 @@
+[
+    [
+        {
+            "column0": null
+        }
+    ]
+]
\ No newline at end of file
diff --git a/ydb/tests/functional/canonical/sql/simple/empty_dict_select.sql b/ydb/tests/functional/canonical/sql/simple/empty_dict_select.sql
new file mode 100644
index 0000000000..0b01fa35fe
--- /dev/null
+++ b/ydb/tests/functional/canonical/sql/simple/empty_dict_select.sql
@@ -0,0 +1,2 @@
+--!syntax_v1
+SELECT {};
diff --git a/ydb/tests/functional/canonical/sql/simple/empty_list_select.sql b/ydb/tests/functional/canonical/sql/simple/empty_list_select.sql
new file mode 100644
index 0000000000..bc81097fc4
--- /dev/null
+++ b/ydb/tests/functional/canonical/sql/simple/empty_list_select.sql
@@ -0,0 +1,2 @@
+--!syntax_v1
+SELECT [];
diff --git a/ydb/tests/functional/canonical/sql/simple/null_select.sql b/ydb/tests/functional/canonical/sql/simple/null_select.sql
new file mode 100644
index 0000000000..645e17da8c
--- /dev/null
+++ b/ydb/tests/functional/canonical/sql/simple/null_select.sql
@@ -0,0 +1,2 @@
+--!syntax_v1
+SELECT null;