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

Library import 241120-1113

1 files changed, 45 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/params/param_in_json_api.sql b/yql/essentials/tests/sql/suites/params/param_in_json_api.sql
new file mode 100644
index 0000000000..714240ad4c
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/params/param_in_json_api.sql
@@ -0,0 +1,45 @@
+/* syntax version 1 */
+/* postgres can not */
+
+DECLARE $input_json as Json;
+DECLARE $int64_param as Int64;
+DECLARE $double_param as Double;
+DECLARE $bool_param as Bool;
+DECLARE $string_param as Utf8;
+DECLARE $json_param as Json;
+
+SELECT
+    JSON_VALUE(
+        $input_json,
+        "strict $var"
+        PASSING
+            $int64_param as var
+        RETURNING Int64
+    ),
+    JSON_VALUE(
+        $input_json,
+        "strict $var"
+        PASSING
+            $double_param as var
+        RETURNING Double
+    ),
+    JSON_VALUE(
+        $input_json,
+        "strict $var"
+        PASSING
+            $bool_param as var
+        RETURNING Bool
+    ),
+    JSON_VALUE(
+        $input_json,
+        "strict $var"
+        PASSING
+            $string_param as var
+        RETURNING String
+    ),
+    JSON_QUERY(
+        $input_json,
+        "strict $var"
+        PASSING
+            $json_param as var
+    );
\ No newline at end of file