summaryrefslogtreecommitdiff
path: root/mysql-test/r/udf.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-06-09 16:42:49 +0400
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit778a1a4aac3161b5dc5e10dabca117b42d343b8a (patch)
tree3220ac96568478394d984a253de5c869ca7643ee /mysql-test/r/udf.result
parent582ee3973e1004f12be1921e7ef466fb062bf424 (diff)
downloadmariadb-git-778a1a4aac3161b5dc5e10dabca117b42d343b8a.tar.gz
More test for MDEV-10134 Add full support for DEFAULT
UDF
Diffstat (limited to 'mysql-test/r/udf.result')
-rw-r--r--mysql-test/r/udf.result14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/udf.result b/mysql-test/r/udf.result
index bcfc9941db9..f6d8e946ecf 100644
--- a/mysql-test/r/udf.result
+++ b/mysql-test/r/udf.result
@@ -445,3 +445,17 @@ DROP FUNCTION myfunc_double;
DROP TABLE t1;
#
End of 5.1 tests.
+#
+# MDEV-10134 Add full support for DEFAULT
+#
+CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
+SELECT METAPHON('Hello');
+METAPHON('Hello')
+HL
+CREATE TABLE t1 (a VARCHAR(10), b VARCHAR(10) DEFAULT METAPHON(a));
+INSERT INTO t1 (a) VALUES ('Hello');
+SELECT * FROM t1;
+a b
+Hello HL
+DROP FUNCTION METAPHON;
+DROP TABLE t1;