Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
|
10.4 9a621200 |
innodb.full_crc32_import 'innodb' [ fail ]
|
Test ended at 2019-12-11 17:13:08
|
 |
CURRENT_TEST: innodb.full_crc32_import
|
mysqltest: At line 142: query 'SET GLOBAL innodb_compression_algorithm=2' failed: 1231: Variable 'innodb_compression_algorithm' can't be set to the value of '2'
|
The minimal fix would be
diff --git a/mysql-test/suite/innodb/t/full_crc32_import.test b/mysql-test/suite/innodb/t/full_crc32_import.test
|
index caa6329d69b..0503b40b6bd 100644
|
--- a/mysql-test/suite/innodb/t/full_crc32_import.test
|
+++ b/mysql-test/suite/innodb/t/full_crc32_import.test
|
@@ -139,6 +139,7 @@ CHECK TABLE t1;
|
DROP TABLE t1;
|
|
SET @save_algo = @@GLOBAL.innodb_compression_algorithm;
|
+--error 0,1231
|
SET GLOBAL innodb_compression_algorithm=2;
|
CREATE TABLE t1(a SERIAL) PAGE_COMPRESSED=1 ENGINE=InnoDB;
|
INSERT INTO t1 VALUES(1);
|
But while we are at it, I recommend
diff --git a/mysql-test/suite/innodb/t/full_crc32_import.test b/mysql-test/suite/innodb/t/full_crc32_import.test
|
index caa6329d69b..2c11a2423e6 100644
|
--- a/mysql-test/suite/innodb/t/full_crc32_import.test
|
+++ b/mysql-test/suite/innodb/t/full_crc32_import.test
|
@@ -139,6 +139,7 @@ CHECK TABLE t1;
|
DROP TABLE t1;
|
|
SET @save_algo = @@GLOBAL.innodb_compression_algorithm;
|
+--error 0,ER_WRONG_VALUE_FOR_VAR
|
SET GLOBAL innodb_compression_algorithm=2;
|
CREATE TABLE t1(a SERIAL) PAGE_COMPRESSED=1 ENGINE=InnoDB;
|
INSERT INTO t1 VALUES(1);
|
@@ -170,7 +171,7 @@ INSERT INTO t1 VALUES(2);
|
SELECT * FROM t1;
|
|
|
---error 0,1231
|
+--error 0,ER_WRONG_VALUE_FOR_VAR
|
SET GLOBAL innodb_compression_algorithm=3;
|
FLUSH TABLE t1 FOR EXPORT;
|
--echo # List before copying files
|