[MDEV-33298] aarch.macos: mtr test failure parts.partition_mgm* COLLATE=latin1_swedish_ci Created: 2024-01-23  Updated: 2024-01-24

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Critical
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Unresolved Votes: 0
Labels: test

Issue Links:
Blocks
blocks MDEV-33073 always green buildbot Open

 Description   

https://buildbot.mariadb.org/#/builders/590/builds/1900/steps/5/logs/stdio

 
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,

origin from mysql-test/suite/parts/inc/partition_mgm.inc

 Comments   
Comment by Sergei Golubchik [ 2024-01-23 ]

is it 10.4 only?

Comment by Daniel Black [ 2024-01-24 ]

10.5, 10.6 affected too. Later version might be, they just don't have a build fix yet.

macos-arch64 only.

Generated at Thu Feb 08 10:37:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.