aarch.macos: mtr test failure parts.partition_mgm* COLLATE=latin1_swedish_ci

parts.partition_mgm_lc2_innodb 'innodb'  w2 [ fail ]

        Test ended at 2024-01-23 01:35:32

CURRENT_TEST: parts.partition_mgm_lc2_innodb

--- /Users/ec2-user/buildbot/aarch64-macos/build/mysql-test/suite/parts/r/partition_mgm_lc2_innodb.result	2024-01-22 18:58:13

+++ /Users/ec2-user/buildbot/aarch64-macos/build/mysql-test/suite/parts/r/partition_mgm_lc2_innodb.reject	2024-01-23 01:35:20

@@ -55,7 +55,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY KEY (`a`)

 (PARTITION `parta` ENGINE = InnoDB,

  PARTITION `partB` ENGINE = InnoDB,

@@ -83,7 +83,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY KEY (`a`)

 (PARTITION `parta` ENGINE = InnoDB,

  PARTITION `partB` ENGINE = InnoDB,

@@ -111,7 +111,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY KEY (`a`)

 (PARTITION `parta` ENGINE = InnoDB,

  PARTITION `partB` ENGINE = InnoDB,

@@ -126,7 +126,7 @@

 Table	Create Table

 TableB	CREATE TABLE `TableB` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

 SELECT PARTITION_NAME, IF(TABLE_ROWS, 'YES', 'NO') AS HAVE_TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA ='MySQL_Test_DB' AND TABLE_NAME = 'TableA';

 PARTITION_NAME	HAVE_TABLE_ROWS

 parta	NO

@@ -155,7 +155,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY KEY (`a`)

 (PARTITION `parta` ENGINE = InnoDB,

  PARTITION `partB` ENGINE = InnoDB,

@@ -191,7 +191,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY KEY (`a`)

 (PARTITION `partB` COMMENT = 'Previusly named parta' ENGINE = InnoDB,

  PARTITION `parta` COMMENT = 'Previusly named partB' ENGINE = InnoDB,

@@ -263,7 +263,7 @@

 Table	Create Table

 tablea	CREATE TABLE `tablea` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY KEY (`a`)

 (PARTITION `partB` COMMENT = 'Previusly named parta' ENGINE = InnoDB,

  PARTITION `parta` COMMENT = 'Previusly named partB' ENGINE = InnoDB,

@@ -288,7 +288,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

 # Cleaning up after KEY PARTITIONING test

 DROP TABLE TableA;

 # 2.0 HASH partitioning mgm

@@ -354,7 +354,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY HASH (`a`)

 (PARTITION `parta` ENGINE = InnoDB,

  PARTITION `partB` ENGINE = InnoDB,

@@ -382,7 +382,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY HASH (`a`)

 (PARTITION `parta` ENGINE = InnoDB,

  PARTITION `partB` ENGINE = InnoDB,

@@ -418,7 +418,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY HASH (`a`)

 (PARTITION `partB` COMMENT = 'Previusly named parta' ENGINE = InnoDB,

  PARTITION `parta` COMMENT = 'Previusly named partB' ENGINE = InnoDB,

@@ -490,7 +490,7 @@

 Table	Create Table

 tablea	CREATE TABLE `tablea` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY HASH (`a`)

 (PARTITION `partB` COMMENT = 'Previusly named parta' ENGINE = InnoDB,

  PARTITION `parta` COMMENT = 'Previusly named partB' ENGINE = InnoDB,

@@ -515,7 +515,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

 # Cleaning up after HASH PARTITIONING test

 DROP TABLE TableA;

 # 3.0 RANGE partitioning mgm

@@ -570,7 +570,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY RANGE (`a`)

 (PARTITION `parta` VALUES LESS THAN (4) ENGINE = InnoDB,

  PARTITION `partB` VALUES LESS THAN (7) ENGINE = InnoDB,

@@ -601,7 +601,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY RANGE (`a`)

 (PARTITION `parta` VALUES LESS THAN (4) ENGINE = InnoDB,

  PARTITION `partB` VALUES LESS THAN (7) ENGINE = InnoDB,

@@ -639,7 +639,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY RANGE (`a`)

 (PARTITION `parta` VALUES LESS THAN (4) ENGINE = InnoDB,

  PARTITION `partD` VALUES LESS THAN (8) COMMENT = 'Previously partB and partly Partc' ENGINE = InnoDB,

@@ -712,7 +712,7 @@

 Table	Create Table

 tablea	CREATE TABLE `tablea` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY RANGE (`a`)

 (PARTITION `parta` VALUES LESS THAN (4) ENGINE = InnoDB,

  PARTITION `partD` VALUES LESS THAN (8) COMMENT = 'Previously partB and partly Partc' ENGINE = InnoDB,

@@ -738,7 +738,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

 # Cleaning up after RANGE PARTITIONING test

 DROP TABLE TableA;

 # 4.0 LIST partitioning mgm

@@ -793,7 +793,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY LIST (`a`)

 (PARTITION `parta` VALUES IN (1,8,9) ENGINE = InnoDB,

  PARTITION `partB` VALUES IN (2,10,11) ENGINE = InnoDB,

@@ -824,7 +824,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY LIST (`a`)

 (PARTITION `parta` VALUES IN (1,8,9) ENGINE = InnoDB,

  PARTITION `partB` VALUES IN (2,10,11) ENGINE = InnoDB,

@@ -862,7 +862,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY LIST (`a`)

 (PARTITION `Partc` VALUES IN (1,7) COMMENT = 'Mix 1 of old parta and Partc' ENGINE = InnoDB,

  PARTITION `parta` VALUES IN (3,9) COMMENT = 'Mix 2 of old parta and Partc' ENGINE = InnoDB,

@@ -927,7 +927,7 @@

 Table	Create Table

 tablea	CREATE TABLE `tablea` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY LIST (`a`)

 (PARTITION `Partc` VALUES IN (1,7) COMMENT = 'Mix 1 of old parta and Partc' ENGINE = InnoDB,

  PARTITION `parta` VALUES IN (3,9) COMMENT = 'Mix 2 of old parta and Partc' ENGINE = InnoDB,

@@ -951,7 +951,7 @@

 Table	Create Table

 TableA	CREATE TABLE `TableA` (

   `a` int(11) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=latin1

+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

 # Cleaning up after LIST PARTITIONING test

 DROP TABLE TableA;

 # Testing TRUNCATE PARTITION

@@ -970,7 +970,7 @@

   `a` bigint(20) NOT NULL AUTO_INCREMENT,

   `b` varchar(255) DEFAULT NULL,

   PRIMARY KEY (`a`)

-) ENGINE=InnoDB AUTO_INCREMENT=2002 DEFAULT CHARSET=latin1

+) ENGINE=InnoDB AUTO_INCREMENT=2002 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

  PARTITION BY RANGE (`a`)

 (PARTITION `LT1000` VALUES LESS THAN (1000) ENGINE = InnoDB,

  PARTITION `LT2000` VALUES LESS THAN (2000) ENGINE = InnoDB,