Tests fail when mariadb is compiled with zlib-ng

When mariadb is linked with zlib-ng, tests innodb_zip.cmp_per_index main.column_compression main.column_compression_rpl fail.

These are the error messages in the log:
innodb_zip.cmp_per_index w2 [ fail ]
Test ended at 2026-09-18 11:40:05

CURRENT_TEST: innodb_zip.cmp_per_index
— /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/suite/innodb_zip/r/cmp_per_index.result 2025-11-13 09:45:30.
000000000 +0100
+++ /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/suite/innodb_zip/r/cmp_per_index.reject 2026-09-18 11:40:04.
990141979 +0200
@@ -67,8 +67,8 @@
database_name test
table_name t
index_name PRIMARY
-compress_ops 64
-compress_ops_ok 64
+compress_ops 63
+compress_ops_ok 63
uncompress_ops 0
DROP TABLE t;
SET GLOBAL innodb_cmp_per_index_enabled=@save_enabled;

Result content mismatch
[...]
main.column_compression w4 [ fail ]
Test ended at 2026-09-18 11:46:24

CURRENT_TEST: main.column_compression
— /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression.result 2025-11-13 09:45:29.000000000 +0100
+++ /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression.reject 2026-09-18 11:46:24.359870154 +0200
@@ -1096,7 +1096,7 @@
COLUMN_DECOMPRESSIONS 2
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';
DATA_LENGTH
-36
+44

1. Make sure ALTER TABLE rebuilds table
   ALTER TABLE t1 MODIFY COLUMN a TEXT CHARACTER SET latin1;
   SHOW CREATE TABLE t1;
   @@ -1130,7 +1130,7 @@
   COLUMN_DECOMPRESSIONS 5
   SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';
   DATA_LENGTH
   -36
   +44
2. Make sure CREATE TABLE ... LIKE inherits compression
   CREATE TABLE t2 LIKE t1;
   SHOW CREATE TABLE t2;
   @@ -1155,7 +1155,7 @@
   COLUMN_DECOMPRESSIONS 7
   SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t2';
   DATA_LENGTH
   -36
   +44
   DROP TABLE t2;
3. Make sure explicit CREATE TABLE ... SELECT doesn't inherit compression
   CREATE TABLE t2(a TEXT CHARACTER SET latin1) SELECT * FROM t1;

Result content mismatch
[...]
main.column_compression_rpl 'mix' w2 [ fail ]
Test ended at 2026-09-18 11:47:59

CURRENT_TEST: main.column_compression_rpl
— /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression_rpl.result 2025-11-13 09:45:29.000000000 +0100
+++ /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression_rpl.reject 2026-09-18 11:47:58.739028855 +0200
@@ -117,7 +117,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -219,7 +219,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed
@@ -358,7 +358,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a),SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -1615,7 +1615,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -1717,7 +1717,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed
@@ -1856,7 +1856,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a),SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -2194,7 +2194,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed

Result content mismatch

• saving '/var/tmp/portage/dev-db/mariadb-11.8.5-r1/temp/var-tests/2/log/main.column_compression_rpl-mix/' to '/var/tmp/portage/dev-db/mariadb-11.8.5-r1/temp/var-tests/log/main.column_compression_rpl-mix/'
  ***Warnings generated in error logs during shutdown after running tests: main.column_compression_rpl

2026-09-18 11:47:58 7 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:47:58 11 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:47:58 12 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:47:58 14 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:47:58 15 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:47:58 17 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406

[...]
main.column_compression_rpl 'row' w1 [ fail ]
Test ended at 2026-09-18 11:48:09

CURRENT_TEST: main.column_compression_rpl
— /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression_rpl.result 2025-11-13 09:45:29.000000000 +0100
+++ /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression_rpl.reject 2026-09-18 11:48:08.779344358 +0200
@@ -117,7 +117,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -219,7 +219,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed
@@ -358,7 +358,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a),SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -1615,7 +1615,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -1717,7 +1717,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed
@@ -1856,7 +1856,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a),SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -2194,7 +2194,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed

Result content mismatch

• saving '/var/tmp/portage/dev-db/mariadb-11.8.5-r1/temp/var-tests/1/log/main.column_compression_rpl-row/' to '/var/tmp/portage/dev-db/mariadb-11.8.5-r1/temp/var-tests/log/main.column_compression_rpl-row/'
  ***Warnings generated in error logs during shutdown after running tests: main.column_compression_rpl

2026-09-18 11:48:08 7 [Warning] Slave: Table 't2' already exists Error_code: 1050
2026-09-18 11:48:08 12 [Warning] Slave: Table 't2' already exists Error_code: 1050
2026-09-18 11:48:08 15 [Warning] Slave: Table 't2' already exists Error_code: 1050
[...]
main.column_compression_rpl 'stmt' w1 [ fail ]
Test ended at 2026-09-18 11:48:21

CURRENT_TEST: main.column_compression_rpl
— /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression_rpl.result 2025-11-13 09:45:29.000000000 +0100
+++ /var/tmp/portage/dev-db/mariadb-11.8.5-r1/work/mysql/mysql-test/main/column_compression_rpl.reject 2026-09-18 11:48:20.777721390 +0200
@@ -117,7 +117,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -219,7 +219,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed
@@ -358,7 +358,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a),SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -1615,7 +1615,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -1717,7 +1717,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed
@@ -1856,7 +1856,7 @@
NULL NULL M,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a),SUBSTRING(a,1,10), "M,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) M,compressed
100 aaaaaaaaaa M,compressed
@@ -2194,7 +2194,7 @@
NULL NULL S,compressed
SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t3';
DATA_LENGTH
-88
+92
SELECT LENGTH(a), SUBSTRING(a,1,10), "S,compressed" from t2;
LENGTH(a) SUBSTRING(a,1,10) S,compressed
100 aaaaaaaaaa S,compressed

Result content mismatch

• saving '/var/tmp/portage/dev-db/mariadb-11.8.5-r1/temp/var-tests/1/log/main.column_compression_rpl-stmt/' to '/var/tmp/portage/dev-db/mariadb-11.8.5-r1/temp/var-tests/log/main.column_compression_rpl-stmt/'
  ***Warnings generated in error logs during shutdown after running tests: main.column_compression_rpl

2026-09-18 11:48:20 7 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:48:20 11 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:48:20 12 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:48:20 14 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:48:20 15 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
2026-09-18 11:48:20 17 [Warning] Slave: Data too long for column 'a' at row 1 Error_code: 1406
[...]
--------------------------------------------------------------------------
The servers were restarted 1829 times
Spent 4553.658 of 1753 seconds executing testcases

Completed: Failed 5/5695 tests, 99.91% were successful.

Failing test(s): innodb_zip.cmp_per_index main.column_compression main.column_compression_rpl

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, MariaDB's bug tracker is found at
https://jira.mariadb.org

Errors/warnings were found in logfiles during server shutdown after running the
following sequence(s) of tests:
main.column_compression_rpl
main.column_compression_rpl
main.column_compression_rpl
1152 tests were skipped, 345 by the test itself.