aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDaniil Demin <deminds@ydb.tech>2025-03-12 16:27:40 +0300
committerGitHub <noreply@github.com>2025-03-12 16:27:40 +0300
commit33a24c0c14da1fc6bcfe23162b76008d9b62fd21 (patch)
treed4892866fa10681f6076104c9e0e77f138cb3f1b
parent544240601801ea481394f0c44fe0da68a1aa631e (diff)
downloadydb-33a24c0c14da1fc6bcfe23162b76008d9b62fd21.tar.gz
view: tests with UDFs in the view query (#15625)
-rw-r--r--ydb/core/kqp/ut/view/input/cases/udf/create_view.sql4
-rw-r--r--ydb/core/kqp/ut/view/input/cases/udf/drop_view.sql1
-rw-r--r--ydb/core/kqp/ut/view/input/cases/udf/etalon_query.sql6
-rw-r--r--ydb/core/kqp/ut/view/input/cases/udf/select_from_view.sql5
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`
+;