Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5, 10.6, 10.4(EOL)
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
Attachments
Issue Links
- is part of
-
MDEV-33073 always green buildbot
- Stalled
- links to