diff options
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/create.result | 14 | ||||
-rw-r--r-- | mysql-test/r/create_not_windows.result | 14 | ||||
-rw-r--r-- | mysql-test/t/create.test | 15 | ||||
-rw-r--r-- | mysql-test/t/create_not_windows.test | 20 |
4 files changed, 34 insertions, 29 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 57ec76a0b53..27a6c8a9d03 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -773,17 +773,3 @@ Warnings: Warning 1071 Specified key was too long; max key length is 765 bytes insert into t1 values('aaa'); drop table t1; -drop table if exists `about:text`; -create table `about:text` ( -_id int not null auto_increment, -`about:text` varchar(255) not null default '', -primary key (_id) -); -show create table `about:text`; -Table Create Table -about:text CREATE TABLE `about:text` ( - `_id` int(11) NOT NULL auto_increment, - `about:text` varchar(255) NOT NULL default '', - PRIMARY KEY (`_id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 -drop table `about:text`; diff --git a/mysql-test/r/create_not_windows.result b/mysql-test/r/create_not_windows.result new file mode 100644 index 00000000000..b975c98c2b1 --- /dev/null +++ b/mysql-test/r/create_not_windows.result @@ -0,0 +1,14 @@ +drop table if exists `about:text`; +create table `about:text` ( +_id int not null auto_increment, +`about:text` varchar(255) not null default '', +primary key (_id) +); +show create table `about:text`; +Table Create Table +about:text CREATE TABLE `about:text` ( + `_id` int(11) NOT NULL auto_increment, + `about:text` varchar(255) NOT NULL default '', + PRIMARY KEY (`_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table `about:text`; diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index d1e9818088d..e22c2b5c426 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -674,19 +674,4 @@ create table t1(f1 varchar(800) binary not null, key(f1)) engine = innodb insert into t1 values('aaa'); drop table t1; -# -# Bug#19479:mysqldump creates invalid dump -# ---disable_warnings -drop table if exists `about:text`; ---enable_warnings -create table `about:text` ( -_id int not null auto_increment, -`about:text` varchar(255) not null default '', -primary key (_id) -); - -show create table `about:text`; -drop table `about:text`; - # End of 5.0 tests diff --git a/mysql-test/t/create_not_windows.test b/mysql-test/t/create_not_windows.test new file mode 100644 index 00000000000..71ad9ccd7fe --- /dev/null +++ b/mysql-test/t/create_not_windows.test @@ -0,0 +1,20 @@ +# Non-windows specific create tests. + +--source include/not_windows.inc + +# +# Bug#19479:mysqldump creates invalid dump +# +--disable_warnings +drop table if exists `about:text`; +--enable_warnings +create table `about:text` ( +_id int not null auto_increment, +`about:text` varchar(255) not null default '', +primary key (_id) +); + +show create table `about:text`; +drop table `about:text`; + +# End of 5.0 tests |