summaryrefslogtreecommitdiff
path: root/mysql-test/t/udf.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/udf.test')
-rw-r--r--mysql-test/t/udf.test16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/udf.test b/mysql-test/t/udf.test
index 4ee412f80d8..42a813b0782 100644
--- a/mysql-test/t/udf.test
+++ b/mysql-test/t/udf.test
@@ -512,3 +512,19 @@ DROP TABLE t1;
--echo #
--echo End of 5.1 tests.
+--echo #
+--echo # MDEV-10134 Add full support for DEFAULT
+--echo #
+
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
+eval CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
+SELECT METAPHON('Hello');
+CREATE TABLE t1 (a VARCHAR(10), b VARCHAR(10) DEFAULT METAPHON(a));
+SHOW CREATE TABLE t1;
+INSERT INTO t1 (a) VALUES ('Hello');
+SELECT * FROM t1;
+DROP FUNCTION METAPHON;
+# QQ: this should return an error
+#INSERT INTO t1 (a) VALUES ('Hello');
+#SELECT * FROM t1;
+DROP TABLE t1;