Flaky test: 04003_cast_nullable_read_in_order_explain #98506
Description
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: 04003_cast_nullable_read_in_order_explain
Failure reason: result differs with reference
CI report: Stateless tests (amd_binary, ParallelReplicas, s3 storage, parallel)
Failing test history: cidb
Test output:
2026-03-03 02:25:09 Reason: result differs with reference:
2026-03-03 02:25:09 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/04003_cast_nullable_read_in_order_explain.reference 2026-03-03 01:52:29.225106312 +1200
2026-03-03 02:25:09 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/04003_cast_nullable_read_in_order_explain.stdout 2026-03-03 02:25:08.922853888 +1200
2026-03-03 02:25:09 @@ -4,80 +4,73 @@
2026-03-03 02:25:09 DROP TABLE IF EXISTS test_nullable_order_by;
2026-03-03 02:25:09 CREATE TABLE test_nullable_order_by (x UInt32, y UInt32) ENGINE=MergeTree ORDER BY x;
2026-03-03 02:25:09 INSERT INTO test_nullable_order_by SELECT number, number FROM numbers(1e6);
2026-03-03 02:25:09 SELECT ltrim(explain)
2026-03-03 02:25:09 FROM
2026-03-03 02:25:09 (
2026-03-03 02:25:09 EXPLAIN actions=1
2026-03-03 02:25:09 SELECT y FROM test_nullable_order_by ORDER BY x::UInt64 LIMIT 1000000000
2026-03-03 02:25:09 )
2026-03-03 02:25:09 WHERE explain LIKE '%ReadType%';
2026-03-03 02:25:09 -ReadType: InOrder
2026-03-03 02:25:09 SELECT ltrim(explain)
2026-03-03 02:25:09 FROM
2026-03-03 02:25:09 (
2026-03-03 02:25:09 EXPLAIN actions = 1
2026-03-03 02:25:09 SELECT y FROM test_nullable_order_by ORDER BY x::Nullable(UInt64) LIMIT 1000000000
2026-03-03 02:25:09 )
2026-03-03 02:25:09 WHERE explain LIKE '%ReadType%';
2026-03-03 02:25:09 -ReadType: InOrder
2026-03-03 02:25:09 DROP TABLE IF EXISTS test_accurate_cast_or_null;
2026-03-03 02:25:09 CREATE TABLE test_accurate_cast_or_null (x Date32, y UInt32) ENGINE=MergeTree ORDER BY x;
2026-03-03 02:25:09 INSERT INTO test_accurate_cast_or_null SELECT toDate32('1969-12-29') + number, number FROM numbers(6);
2026-03-03 02:25:09 -- Should not use read in order optimization because of `accurateCastOrNull`
2026-03-03 02:25:09 SELECT ltrim(explain)
2026-03-03 02:25:09 FROM
2026-03-03 02:25:09 (
2026-03-03 02:25:09 EXPLAIN actions = 1
2026-03-03 02:25:09 SELECT x, accurateCastOrNull(x, 'Date') AS d
2026-03-03 02:25:09 FROM test_accurate_cast_or_null
2026-03-03 02:25:09 ORDER BY accurateCastOrNull(x, 'Date')
2026-03-03 02:25:09 LIMIT 10
2026-03-03 02:25:09 )
2026-03-03 02:25:09 WHERE explain LIKE '%ReadType%';
2026-03-03 02:25:09 -ReadType: Default
2026-03-03 02:25:09 SELECT ltrim(explain)
2026-03-03 02:25:09 FROM
2026-03-03 02:25:09 (
2026-03-03 02:25:09 EXPLAIN actions = 1
2026-03-03 02:25:09 SELECT x, accurateCastOrNull(toInt64(x), 'Date') AS d, toTypeName(d)
2026-03-03 02:25:09 FROM test_accurate_cast_or_null
2026-03-03 02:25:09 ORDER BY accurateCastOrNull(toInt64(x), 'Date')
2026-03-03 02:25:09 LIMIT 10
2026-03-03 02:25:09 )
2026-03-03 02:25:09 WHERE explain LIKE '%ReadType%';
2026-03-03 02:25:09 -ReadType: Default
2026-03-03 02:25:09 DROP TABLE IF EXISTS test_accurate_cast_or_null_float;
~~~~~ truncated 41 lines ~~~~~