summaryrefslogtreecommitdiff
path: root/tests/udf_test.res
diff options
context:
space:
mode:
Diffstat (limited to 'tests/udf_test.res')
-rw-r--r--tests/udf_test.res24
1 files changed, 24 insertions, 0 deletions
diff --git a/tests/udf_test.res b/tests/udf_test.res
index 66634e13616..cd65d3794d8 100644
--- a/tests/udf_test.res
+++ b/tests/udf_test.res
@@ -35,6 +35,12 @@ CREATE AGGREGATE FUNCTION avgcost RETURNS REAL SONAME "udf_example.so"
Query OK, 0 rows affected
--------------
+CREATE FUNCTION myfunc_argument_name RETURNS STRING SONAME "udf_example.so"
+--------------
+
+Query OK, 0 rows affected
+
+--------------
select metaphon("hello")
--------------
@@ -107,6 +113,18 @@ avgcost(a,b)
4 rows in set
--------------
+select a, myfunc_argument_name(a) from t1;
+--------------
+
+a myfunc_argument_name(a)
+1 a
+1 a
+2 a
+3 a
+4 a
+5 rows in set
+
+--------------
drop table t1
--------------
@@ -148,4 +166,10 @@ DROP FUNCTION avgcost
Query OK, 0 rows affected
+--------------
+DROP FUNCTION myfunc_argument_name;
+--------------
+
+Query OK, 0 rows affected
+
Bye