diff options
| author | Daniil Demin <deminds@ydb.tech> | 2025-03-12 16:27:40 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-03-12 16:27:40 +0300 |
| commit | 33a24c0c14da1fc6bcfe23162b76008d9b62fd21 (patch) | |
| tree | d4892866fa10681f6076104c9e0e77f138cb3f1b | |
| parent | 544240601801ea481394f0c44fe0da68a1aa631e (diff) | |
| download | ydb-33a24c0c14da1fc6bcfe23162b76008d9b62fd21.tar.gz | |
view: tests with UDFs in the view query (#15625)
4 files changed, 16 insertions, 0 deletions
diff --git a/ydb/core/kqp/ut/view/input/cases/udf/create_view.sql b/ydb/core/kqp/ut/view/input/cases/udf/create_view.sql new file mode 100644 index 0000000000..978d3bf022 --- /dev/null +++ b/ydb/core/kqp/ut/view/input/cases/udf/create_view.sql @@ -0,0 +1,4 @@ +CREATE VIEW `view_with_udf` WITH (security_invoker = TRUE) AS + SELECT + "bbb" LIKE Unwrap("aaa") +; diff --git a/ydb/core/kqp/ut/view/input/cases/udf/drop_view.sql b/ydb/core/kqp/ut/view/input/cases/udf/drop_view.sql new file mode 100644 index 0000000000..8df4db2342 --- /dev/null +++ b/ydb/core/kqp/ut/view/input/cases/udf/drop_view.sql @@ -0,0 +1 @@ +DROP VIEW `view_with_udf`; diff --git a/ydb/core/kqp/ut/view/input/cases/udf/etalon_query.sql b/ydb/core/kqp/ut/view/input/cases/udf/etalon_query.sql new file mode 100644 index 0000000000..ef128b2cc5 --- /dev/null +++ b/ydb/core/kqp/ut/view/input/cases/udf/etalon_query.sql @@ -0,0 +1,6 @@ +SELECT + * +FROM ( + SELECT + "bbb" LIKE Unwrap("aaa") +); diff --git a/ydb/core/kqp/ut/view/input/cases/udf/select_from_view.sql b/ydb/core/kqp/ut/view/input/cases/udf/select_from_view.sql new file mode 100644 index 0000000000..bcbe58af84 --- /dev/null +++ b/ydb/core/kqp/ut/view/input/cases/udf/select_from_view.sql @@ -0,0 +1,5 @@ +SELECT + * +FROM + `view_with_udf` +; |