summaryrefslogtreecommitdiff
path: root/mysql-test/r/system_mysql_db_fix40123.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/system_mysql_db_fix40123.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/system_mysql_db_fix40123.result')
-rw-r--r--mysql-test/r/system_mysql_db_fix40123.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/system_mysql_db_fix40123.result b/mysql-test/r/system_mysql_db_fix40123.result
index bc4de8b4171..332609e90f1 100644
--- a/mysql-test/r/system_mysql_db_fix40123.result
+++ b/mysql-test/r/system_mysql_db_fix40123.result
@@ -219,7 +219,7 @@ proc CREATE TABLE `proc` (
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
- `body_utf8` longblob,
+ `body_utf8` longblob DEFAULT NULL,
PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'
show create table event;
@@ -246,7 +246,7 @@ event CREATE TABLE `event` (
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
- `body_utf8` longblob,
+ `body_utf8` longblob DEFAULT NULL,
PRIMARY KEY (`db`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events'
show create table general_log;