main.column_compression_parts fails on s390x Ubuntu 24.04

CURRENT_TEST: main.column_compression_parts

--- /home/buildbot/s390x-ubuntu-2204/build/mysql-test/main/column_compression_parts.result	2026-05-08 09:19:53.000000000 +0000

+++ /home/buildbot/s390x-ubuntu-2204/build/mysql-test/main/column_compression_parts.reject	2026-05-08 13:30:00.048828666 +0000

@@ -216,7 +216,6 @@

 INSERT INTO t1 VALUES (REPEAT('a',100),23),(REPEAT('v',100),123),(REPEAT('z',100),24),(REPEAT('k',100),124);

 SELECT id,SUBSTRING(a,1,10) FROM t1 where a=(REPEAT('k',100)) order by id;

 id	SUBSTRING(a,1,10)

-124	kkkkkkkkkk

 DROP TABLE t1;

 -------------------------------------------------------------------------------------------

CREATE TABLE t1 (a VARCHAR(1000) COMPRESSED, id INT NOT NULL)

PARTITION BY RANGE(id)

SUBPARTITION BY KEY(a) SUBPARTITIONS 4

(PARTITION p0 VALUES LESS THAN (5),

PARTITION p1 VALUES LESS THAN (MAXVALUE));

INSERT INTO t1 VALUES (REPEAT('a',100),23),(REPEAT('v',100),123),(REPEAT('z',100),24),(REPEAT('k',100),124);

ANALYZE FORMAT=JSON SELECT id,SUBSTRING(a,1,10) FROM t1 where a=(REPEAT('k',100)) order by id;

ANALYZE

{

  "query_optimization": {

    "r_total_time_ms": 0.08763148

  },

  "query_block": {

    "select_id": 1,

    "table": {

      "message": "no matching row in const table"

    }

  }

}

CREATE TABLE t1 (a VARCHAR(1000) COMPRESSED, id INT NOT NULL)

PARTITION BY RANGE(id)

SUBPARTITION BY KEY(a) SUBPARTITIONS 4

(PARTITION p0 VALUES LESS THAN (5),

PARTITION p1 VALUES LESS THAN (MAXVALUE));

INSERT INTO t1 VALUES (REPEAT('a',100),23),(REPEAT('v',100),123),(REPEAT('z',100),24),(REPEAT('k',100),124);

ANALYZE FORMAT=JSON SELECT id,SUBSTRING(a,1,10) FROM t1 where a=(REPEAT('k',100)) order by id;

ANALYZE

{

  "query_optimization": {

    "r_total_time_ms": 0.334909589

  },

  "query_block": {

    "select_id": 1,

    "r_loops": 1,

    "r_total_time_ms": 0.020236539,

    "nested_loop": [

      {

        "table": {

          "table_name": "t1",

          "partitions": ["p0_p0sp1", "p1_p1sp1"],

          "access_type": "system",

          "r_loops": 0,

          "rows": 1,

          "r_rows": null,

          "r_engine_stats": {},

          "filtered": 100,

          "r_filtered": null

        }

      }

    ]

  }

}

DROP TABLE t1;