diff options
Diffstat (limited to 'plugin/type_uuid/mysql-test')
11 files changed, 44 insertions, 44 deletions
diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid-debug.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid-debug.result index 0416c39c6f9..fc0eaae2627 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid-debug.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid-debug.result @@ -14,5 +14,5 @@ Table Create Table t1 CREATE TABLE `t1` ( `c01` uuid DEFAULT NULL, `c02` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result index d388cab45d7..ab30c262148 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result @@ -11,7 +11,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DESCRIBE t1; Field Type Null Key Default Extra a uuid YES NULL @@ -67,7 +67,7 @@ t1 CREATE TABLE `t1` ( `c3` uuid DEFAULT '00000000-0000-0000-0000-000000000000', `c4` uuid DEFAULT 'ffffffff-ffff-ffff-ffff-ffffffffffff', `c5` uuid DEFAULT cast(X'ffffffffffffffffffffffffffffffff' as uuid) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DESCRIBE t1; Field Type Null Key Default Extra c1 uuid YES 00000000-0000-0000-0000-000000000000 @@ -225,7 +225,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `CAST('00000000-0000-0000-0000-000000000000' AS UUID)` uuid NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; # # Text and binary formats, comparison operators @@ -1509,7 +1509,7 @@ t2 CREATE TABLE `t2` ( `COALESCE(c, c_text)` uuid DEFAULT NULL, `COALESCE(c, c_mediumtext)` uuid DEFAULT NULL, `COALESCE(c, c_longtext)` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT LEAST(c, c_char), @@ -1528,7 +1528,7 @@ t2 CREATE TABLE `t2` ( `LEAST(c, c_text)` uuid DEFAULT NULL, `LEAST(c, c_mediumtext)` uuid DEFAULT NULL, `LEAST(c, c_longtext)` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; DROP TABLE t1; CREATE TABLE t1 (a UUID); @@ -1570,7 +1570,7 @@ t2 CREATE TABLE `t2` ( `COALESCE(a, '00000000-0000-0000-0000-000000000000')` uuid DEFAULT NULL, `LEAST(a,'00000000-0000-0000-0000-000000000000')` uuid DEFAULT NULL, `GREATEST(a,'00000000-0000-0000-0000-000000000000')` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SELECT COALESCE(a, 0x00000000000000000000000000000000) FROM t1 ORDER BY a; COALESCE(a, 0x00000000000000000000000000000000) @@ -1606,7 +1606,7 @@ t2 CREATE TABLE `t2` ( `COALESCE(a, 0x00000000000000000000000000000000)` uuid DEFAULT NULL, `LEAST(a,0x00000000000000000000000000000000)` uuid DEFAULT NULL, `GREATEST(a,0x00000000000000000000000000000000)` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SELECT COALESCE(a, 10) FROM t1; ERROR HY000: Illegal parameter data types uuid and int for operation 'coalesce' @@ -1831,7 +1831,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` varchar(36) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 (a UUID); INSERT INTO t1 VALUES ('ffffffff-ffff-ffff-ffff-ffffffffffff'); @@ -1854,7 +1854,7 @@ t2 CREATE TABLE `t2` ( `CAST(a AS CHAR(66000))` mediumtext DEFAULT NULL, `CAST(a AS CHAR(16777215))` mediumtext DEFAULT NULL, `CAST(a AS CHAR(16777216))` longtext DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t2; CAST(a AS CHAR) ffffffff-ffff-ffff-ffff-ffffffffffff CAST(a AS CHAR(36)) ffffffff-ffff-ffff-ffff-ffffffffffff @@ -1890,7 +1890,7 @@ t2 CREATE TABLE `t2` ( `cb66000` mediumblob DEFAULT NULL, `cb16777215` mediumblob DEFAULT NULL, `cb16777216` longblob DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT CAST(a AS BINARY(4)) AS cb4, @@ -1909,7 +1909,7 @@ t2 CREATE TABLE `t2` ( `cb32` binary(32) DEFAULT NULL, `cb530` varbinary(530) DEFAULT NULL, `cb65535` blob DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT HEX(cb4), HEX(cb), @@ -2021,7 +2021,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `MIN(a)` uuid DEFAULT NULL, `MAX(a)` uuid DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t2; MIN(a) MAX(a) 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000002 @@ -2084,7 +2084,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` uuid NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING '00000000-0000-0000-0000-000000000001'; EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' @@ -2123,7 +2123,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` varchar(36) DEFAULT NULL, `c2` varchar(36) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT CONCAT(_utf8'1', LEFT(a,35)) AS c1, @@ -2133,10 +2133,10 @@ FROM t1; SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( - `c1` varchar(36) CHARACTER SET utf8mb3 DEFAULT NULL, - `c2` varchar(36) CHARACTER SET utf8mb3 DEFAULT NULL, - `c3` varchar(36) CHARACTER SET utf8mb3 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `c1` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, + `c2` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, + `c3` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT CONCAT(_latin1'1', LEFT(a,35)) AS c1, @@ -2149,7 +2149,7 @@ t2 CREATE TABLE `t2` ( `c1` varchar(36) DEFAULT NULL, `c2` varchar(36) DEFAULT NULL, `c3` varchar(36) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; DROP TABLE t1; # @@ -2163,7 +2163,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1 ORDER BY c; c 00000000-0000-0000-0000-000000000000 @@ -2177,7 +2177,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1 ORDER BY c; c 00000000-0000-0000-0000-000000000000 @@ -2191,7 +2191,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1 ORDER BY c; c 00000000-0000-0000-0000-000000000000 @@ -2205,7 +2205,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1 ORDER BY c; c 00000000-0000-0000-0000-000000000000 diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_csv.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_csv.result index 1ad371ec561..d912244e691 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_csv.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_csv.result @@ -10,7 +10,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` uuid NOT NULL -) ENGINE=CSV DEFAULT CHARSET=latin1 +) ENGINE=CSV DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci FOR i IN 0..255 DO INSERT INTO t1 VALUES (CONCAT(REPEAT(0x00,15), UNHEX(HEX(i)))); diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result index f777723eefc..d769f1a1374 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_innodb.result @@ -14,7 +14,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1 +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci FOR i IN 0..255 DO INSERT INTO t1 VALUES (CONCAT(REPEAT(0x00, 15),CHAR(i USING BINARY))); @@ -121,7 +121,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1 +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci BEGIN; FOR i IN 0..255 DO diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result index 9d2c27a9e25..f2a1e27d0d0 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_memory.result @@ -14,7 +14,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MEMORY DEFAULT CHARSET=latin1 +) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci FOR i IN 0..255 DO INSERT INTO t1 VALUES (CONCAT(REPEAT(0x00, 15),CHAR(i USING BINARY))); @@ -188,7 +188,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MEMORY DEFAULT CHARSET=latin1 +) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci BEGIN; FOR i IN 0..255 DO diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_decimal.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_decimal.result index 4eae75fbfc3..65dcabda42d 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_decimal.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_decimal.result @@ -29,7 +29,7 @@ t2 CREATE TABLE `t2` ( `target` uuid DEFAULT '00000000-0000-0000-0000-000000000000', `source` decimal(38,0) DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, @@ -201,7 +201,7 @@ t2 CREATE TABLE `t2` ( `target` decimal(38,0) DEFAULT 0, `source` uuid DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_double.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_double.result index 60f1a1a09ae..ae19f916544 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_double.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_double.result @@ -29,7 +29,7 @@ t2 CREATE TABLE `t2` ( `target` uuid DEFAULT '00000000-0000-0000-0000-000000000000', `source` double DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, @@ -201,7 +201,7 @@ t2 CREATE TABLE `t2` ( `target` double DEFAULT 0, `source` uuid DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_int.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_int.result index cb3f4c282e3..c92584a8b1e 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_int.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_int.result @@ -29,7 +29,7 @@ t2 CREATE TABLE `t2` ( `target` uuid DEFAULT '00000000-0000-0000-0000-000000000000', `source` int(11) DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, @@ -201,7 +201,7 @@ t2 CREATE TABLE `t2` ( `target` int(11) DEFAULT 0, `source` uuid DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_time.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_time.result index c86d46085e9..a4feb55b577 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_time.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_time.result @@ -29,7 +29,7 @@ t2 CREATE TABLE `t2` ( `target` uuid DEFAULT '00000000-0000-0000-0000-000000000000', `source` time DEFAULT '00:00:00', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, @@ -201,7 +201,7 @@ t2 CREATE TABLE `t2` ( `target` time DEFAULT '00:00:00', `source` uuid DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_uint.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_uint.result index 5202cd83865..252704d57ef 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_uint.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_mix_uint.result @@ -29,7 +29,7 @@ t2 CREATE TABLE `t2` ( `target` uuid DEFAULT '00000000-0000-0000-0000-000000000000', `source` int(10) unsigned DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, @@ -201,7 +201,7 @@ t2 CREATE TABLE `t2` ( `target` int(10) unsigned DEFAULT 0, `source` uuid DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE t3 LIKE t2; INSERT INTO t3 VALUES (1, diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result index 35cc25abfd6..8df2c85ae48 100644 --- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result +++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid_myisam.result @@ -14,7 +14,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci FOR i IN 0..255 DO INSERT INTO t1 VALUES (CONCAT(REPEAT(0x00, 15),CHAR(i USING BINARY))); @@ -121,7 +121,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci BEGIN; FOR i IN 0..255 DO @@ -205,7 +205,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PackKey PACKED DROP TABLE t1; @@ -216,7 +216,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PackKey PACKED DROP TABLE t1; @@ -227,7 +227,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` uuid DEFAULT NULL, KEY `a` (`a`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PackKey NOT PACKED DROP TABLE t1; |