summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/r/partition_tinyint_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/parts/r/partition_tinyint_innodb.result')
-rw-r--r--mysql-test/suite/parts/r/partition_tinyint_innodb.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/parts/r/partition_tinyint_innodb.result b/mysql-test/suite/parts/r/partition_tinyint_innodb.result
index 19f0e2c57c4..3dbbc4b7097 100644
--- a/mysql-test/suite/parts/r/partition_tinyint_innodb.result
+++ b/mysql-test/suite/parts/r/partition_tinyint_innodb.result
@@ -9,7 +9,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`a`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY KEY (`a`)
(PARTITION `pa1` MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = InnoDB,
PARTITION `pa2` MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = InnoDB,
@@ -45,7 +45,7 @@ Table Create Table
t2 CREATE TABLE `t2` (
`a` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`a`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY KEY (`a`)
PARTITIONS 8
insert into t2 values (255), (254), (253), (252);
@@ -77,7 +77,7 @@ Table Create Table
t3 CREATE TABLE `t3` (
`a` tinyint(4) NOT NULL,
PRIMARY KEY (`a`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
PARTITION BY KEY (`a`)
PARTITIONS 7
insert into t3 values (127), (126), (125), (124), (-128), (-127), (1), (-1), (0);