diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-06-29 21:10:35 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
| commit | 4dcbb775aea9afc79d550661b384e0528c47eda4 (patch) | |
| tree | b42f0cdd90589a97f20a21089790af727995f4ab /mysql-test/r/dyncol.result | |
| parent | b3e11d33db5ab866c710ff8dd8653c314578f545 (diff) | |
| download | mariadb-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/dyncol.result')
| -rw-r--r-- | mysql-test/r/dyncol.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/dyncol.result b/mysql-test/r/dyncol.result index 3a0abfdc733..88b2afb2d70 100644 --- a/mysql-test/r/dyncol.result +++ b/mysql-test/r/dyncol.result @@ -1895,6 +1895,22 @@ dyncol2_check INT DEFAULT COLUMN_CHECK(dyncol2), dyncol1_list TEXT DEFAULT COLUMN_LIST(dyncol1), dyncol1_json TEXT DEFAULT COLUMN_JSON(dyncol1) ); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `name` varchar(10) DEFAULT NULL, + `value` varchar(10) DEFAULT NULL, + `dyncol0` blob DEFAULT COLUMN_CREATE(name, value), + `value_dyncol0_name0` varchar(10) DEFAULT (COLUMN_GET(dyncol0, 'name0' AS CHAR)), + `dyncol1` blob DEFAULT COLUMN_ADD(dyncol0, 'name1', 'value1'), + `value_dyncol1_name1` varchar(10) DEFAULT (COLUMN_GET(dyncol1, 'name1' AS CHAR)), + `dyncol2` blob DEFAULT COLUMN_DELETE(dyncol1, 'name1'), + `dyncol2_exists_name0` int(11) DEFAULT COLUMN_EXISTS(dyncol2, 'name0'), + `dyncol2_exists_name1` int(11) DEFAULT COLUMN_EXISTS(dyncol2, 'name1'), + `dyncol2_check` int(11) DEFAULT COLUMN_CHECK(dyncol2), + `dyncol1_list` text DEFAULT COLUMN_LIST(dyncol1), + `dyncol1_json` text DEFAULT COLUMN_JSON(dyncol1) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 INSERT INTO t1 (name,value) VALUES ('name0', 'value0'); SELECT value_dyncol0_name0, value_dyncol1_name1 FROM t1; value_dyncol0_name0 value_dyncol1_name1 |