diff options
| author | a-romanov <Anton.Romanov@ydb.tech> | 2023-06-22 15:14:49 +0300 |
|---|---|---|
| committer | a-romanov <Anton.Romanov@ydb.tech> | 2023-06-22 15:14:49 +0300 |
| commit | 17b977f039bd579d528a4fdd5a1d635088f99b9c (patch) | |
| tree | 92490a97fe5b8e26ecd6f3026410ed6b0c041a6b | |
| parent | 4cbd34cbb94724105e988b97c41a80aacb3d5886 (diff) | |
| download | ydb-17b977f039bd579d528a4fdd5a1d635088f99b9c.tar.gz | |
Add simple test example on math udf.
4 files changed, 25 insertions, 0 deletions
diff --git a/ydb/tests/functional/canonical/canondata/result.json b/ydb/tests/functional/canonical/canondata/result.json index 7b90e51e8e4..38f24891f75 100644 --- a/ydb/tests/functional/canonical/canondata/result.json +++ b/ydb/tests/functional/canonical/canondata/result.json @@ -1250,6 +1250,16 @@ "uri": "file://test_sql.TestCanonicalFolder1.test_case_topsort_topsort_pk.sql-result_sets_/topsort_topsort_pk.sql.results" } }, + "test_sql.TestCanonicalFolder1.test_case[udfs/math.sql-plan]": { + "plan": { + "uri": "file://test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-plan_/udfs_math.sql.plan" + } + }, + "test_sql.TestCanonicalFolder1.test_case[udfs/math.sql-result_sets]": { + "result_sets": { + "uri": "file://test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-result_sets_/udfs_math.sql.results" + } + }, "test_sql.TestCanonicalFolder1.test_case[write/delete_by_pk.sql-plan]": { "plan": { "uri": "file://test_sql.TestCanonicalFolder1.test_case_write_delete_by_pk.sql-plan_/write_delete_by_pk.sql.plan" diff --git a/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-plan_/udfs_math.sql.plan b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-plan_/udfs_math.sql.plan new file mode 100644 index 00000000000..bedd7457114 --- /dev/null +++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-plan_/udfs_math.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_udfs_math.sql-result_sets_/udfs_math.sql.results b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-result_sets_/udfs_math.sql.results new file mode 100644 index 00000000000..471e73ae0e2 --- /dev/null +++ b/ydb/tests/functional/canonical/canondata/test_sql.TestCanonicalFolder1.test_case_udfs_math.sql-result_sets_/udfs_math.sql.results @@ -0,0 +1,7 @@ +[ + [ + { + "column0": 3.141592653589793 + } + ] +]
\ No newline at end of file diff --git a/ydb/tests/functional/canonical/sql/udfs/math.sql b/ydb/tests/functional/canonical/sql/udfs/math.sql new file mode 100644 index 00000000000..d978497484b --- /dev/null +++ b/ydb/tests/functional/canonical/sql/udfs/math.sql @@ -0,0 +1 @@ +SELECT Math::Pi(); |