summaryrefslogtreecommitdiff
path: root/mysql-test/r/default.result
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2016-06-30 00:16:10 +0200
committerSergei Golubchik <serg@mariadb.org>2016-06-30 11:43:02 +0200
commit6c173324ffa0c6d5a6997610ee4e6cc73bd9ae9e (patch)
tree59c88af635603d4369e5938157508b724dd0719c /mysql-test/r/default.result
parent3aadba15574c2c238671f4ecaa74f330dca4d17d (diff)
downloadmariadb-git-6c173324ffa0c6d5a6997610ee4e6cc73bd9ae9e.tar.gz
Part of MDEV-10134 Add full support for DEFAULT
Print default values for BLOB's. This is a part commit for automatic changes to make the real commit smaller. All changes here are related to that we now print DEFAULT NULL for blob and text fields, like we do for all other fields.
Diffstat (limited to 'mysql-test/r/default.result')
-rw-r--r--mysql-test/r/default.result32
1 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/r/default.result b/mysql-test/r/default.result
index 685b534b808..5531a99ec28 100644
--- a/mysql-test/r/default.result
+++ b/mysql-test/r/default.result
@@ -72,31 +72,31 @@ t2 CREATE TABLE `t2` (
`a` varchar(30) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`b` varchar(1) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`c` varchar(4) COLLATE latin1_bin NOT NULL DEFAULT '0000',
- `d` tinyblob,
- `e` tinyblob,
- `f` tinyblob,
- `g` tinyblob,
- `h` tinyblob,
- `i` tinyblob,
- `j` tinyblob,
- `k` tinyblob,
- `l` tinyblob,
- `m` tinyblob,
- `n` tinyblob,
- `o` tinyblob,
- `p` tinyblob,
+ `d` tinyblob DEFAULT NULL,
+ `e` tinyblob DEFAULT NULL,
+ `f` tinyblob DEFAULT NULL,
+ `g` tinyblob DEFAULT NULL,
+ `h` tinyblob DEFAULT NULL,
+ `i` tinyblob DEFAULT NULL,
+ `j` tinyblob DEFAULT NULL,
+ `k` tinyblob DEFAULT NULL,
+ `l` tinyblob DEFAULT NULL,
+ `m` tinyblob DEFAULT NULL,
+ `n` tinyblob DEFAULT NULL,
+ `o` tinyblob DEFAULT NULL,
+ `p` tinyblob DEFAULT NULL,
`q` varchar(30) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`r` varchar(30) COLLATE latin1_bin NOT NULL DEFAULT ' ',
- `s` tinyblob,
+ `s` tinyblob DEFAULT NULL,
`t` varchar(4) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`u` varchar(1) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`v` varchar(30) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`w` varchar(30) COLLATE latin1_bin NOT NULL DEFAULT ' ',
- `x` tinyblob,
+ `x` tinyblob DEFAULT NULL,
`y` varchar(5) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`z` varchar(20) COLLATE latin1_bin NOT NULL DEFAULT ' ',
`a1` varchar(30) COLLATE latin1_bin NOT NULL DEFAULT ' ',
- `b1` tinyblob
+ `b1` tinyblob DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin
INSERT into t2 (b) values ('1');
SHOW WARNINGS;