summaryrefslogtreecommitdiff
path: root/mysql-test/r/udf.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-06-29 21:10:35 +0200
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit4dcbb775aea9afc79d550661b384e0528c47eda4 (patch)
treeb42f0cdd90589a97f20a21089790af727995f4ab /mysql-test/r/udf.result
parentb3e11d33db5ab866c710ff8dd8653c314578f545 (diff)
downloadmariadb-git-4dcbb775aea9afc79d550661b384e0528c47eda4.tar.gz
parentheses in default
- Adding SHOW CREATE TABLE into all DEFAULT tests, to cover need_parentheses_in_default() for all items - Fixing a few items not to print parentheses in DEFAULT: spatial function-alike predicates, IS_IPV4 and IS_IPV6 functions, COLUMN_CHECK() and COLUMN_EXISTS().
Diffstat (limited to 'mysql-test/r/udf.result')
-rw-r--r--mysql-test/r/udf.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/udf.result b/mysql-test/r/udf.result
index 120b4d22b03..dc9806bb7d1 100644
--- a/mysql-test/r/udf.result
+++ b/mysql-test/r/udf.result
@@ -453,6 +453,12 @@ SELECT METAPHON('Hello');
METAPHON('Hello')
HL
CREATE TABLE t1 (a VARCHAR(10), b VARCHAR(10) DEFAULT METAPHON(a));
+SHOW CREATE TABLE t1;
+Table Create Table
+t1 CREATE TABLE `t1` (
+ `a` varchar(10) DEFAULT NULL,
+ `b` varchar(10) DEFAULT METAPHON(a)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
INSERT INTO t1 (a) VALUES ('Hello');
SELECT * FROM t1;
a b