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/statistics.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/statistics.result')
| -rw-r--r-- | mysql-test/r/statistics.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/statistics.result b/mysql-test/r/statistics.result index fba00fe084d..52986fa9a6b 100644 --- a/mysql-test/r/statistics.result +++ b/mysql-test/r/statistics.result @@ -1684,6 +1684,12 @@ set use_stat_tables=@save_use_stat_tables; # MDEV-10134 Add full support for DEFAULT # CREATE TABLE t1 (a BLOB, b TEXT DEFAULT DECODE_HISTOGRAM('SINGLE_PREC_HB',a)); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` blob DEFAULT NULL, + `b` text DEFAULT DECODE_HISTOGRAM('SINGLE_PREC_HB',a) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 INSERT INTO t1 (a) VALUES (0x0000000000000000000000000101010101010101010202020303030304040404050505050606070707080809090A0A0B0C0D0D0E0E0F10111213131415161718191B1C1E202224292A2E33373B4850575F6A76818C9AA7B9C4CFDADFE5EBF0F4F8FAFCFF); SELECT b FROM t1; b |