diff options
Diffstat (limited to 'mysql-test/suite/archive/archive.result')
-rw-r--r-- | mysql-test/suite/archive/archive.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/archive/archive.result b/mysql-test/suite/archive/archive.result index 656038f42b4..fa2b4f7ee00 100644 --- a/mysql-test/suite/archive/archive.result +++ b/mysql-test/suite/archive/archive.result @@ -11141,7 +11141,7 @@ t2 CREATE TABLE `t2` ( `fld3` char(30) NOT NULL DEFAULT '', `fld4` char(35) NOT NULL DEFAULT '', `fld5` char(35) NOT NULL DEFAULT '' -) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t2 WHERE auto != 100000; auto fld1 companynr fld3 fld4 fld5 1 000001 00 Omaha teethe neat @@ -12667,7 +12667,7 @@ t6 CREATE TABLE `t6` ( `b` tinyblob DEFAULT NULL, `c` int(11) DEFAULT NULL, KEY `a` (`a`) -) ENGINE=ARCHIVE AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1, t2, t4, t5, t6; create table t1 (i int) engine=archive; insert into t1 values (1); @@ -12734,7 +12734,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `col1` int(11) DEFAULT NULL, `col2` varchar(20) DEFAULT NULL -) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1; col1 col2 INSERT INTO t1 (col1, col2) VALUES (1, "value"); @@ -12796,7 +12796,7 @@ t1 CREATE TABLE `t1` ( `c` varchar(255) DEFAULT NULL, `d` blob DEFAULT NULL, `e` blob DEFAULT NULL -) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1; a b c d e 1 text varchar blob1 blob2 @@ -12892,7 +12892,7 @@ show create table t1; Table Create Table t1 CREATE TEMPORARY TABLE `t1` ( `a` int(11) DEFAULT NULL -) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci alter table t1 add column b varchar(10); select * from t1; a b @@ -12904,5 +12904,5 @@ Table Create Table t1 CREATE TEMPORARY TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` varchar(10) DEFAULT NULL -) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; |