roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed about cockroach HOT 2 CLOSED

SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;

CREATE TABLE table1 (col1_2 INT, col1_5 BYTES, col1_6 FLOAT4);

CREATE TABLE table3 (col3_0 INT);

ALTER TABLE table1 INJECT STATISTICS '[{"avg_size": 21, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4355941221932217744, "histo_col_type": "", "name": "__auto__", "null_count": 1441974855537419809, "row_count": 4360275294930779434}]';

INSERT INTO table1 (col1_6, col1_5, col1_2) VALUES (0, '1', 1);
INSERT INTO table1 (col1_6, col1_5, col1_2) VALUES (0, '', 2);
INSERT INTO table3 (col3_0) VALUES (1);

SET testing_optimizer_random_seed = 8309711156756112119;
SET testing_optimizer_disable_rule_probability = 0.500000;

SET vectorize = off;

SELECT
	string_agg(tab_1893.col1_5::BYTES, tab_1893.col1_5::BYTES ORDER BY tab_1893.col1_5::BYTES ASC NULLS LAST)::BYTES
		AS col_5396,
	tab_1893.col1_6 AS col_5398
FROM
	defaultdb.public.table1 AS tab_1893
WHERE
	EXISTS(
		SELECT
			true AS col_5394
		FROM
			defaultdb.public.table3 AS tab_1897
	)
GROUP BY
	tab_1893.col1_6, tab_1893.col1_5
HAVING
	bool_and(true::BOOL)::BOOL
ORDER BY
	col_5398 DESC NULLS LAST,
	tab_1893.col1_6 ASC NULLS FIRST,
	col_5396 ASC NULLS FIRST,
	tab_1893.col1_5 ASC NULLS FIRST
LIMIT
	3;

RESET testing_optimizer_random_seed;
RESET testing_optimizer_disable_rule_probability;

SELECT
	string_agg(tab_1893.col1_5::BYTES, tab_1893.col1_5::BYTES ORDER BY tab_1893.col1_5::BYTES ASC NULLS LAST)::BYTES
		AS col_5396,
	tab_1893.col1_6 AS col_5398
FROM
	defaultdb.public.table1 AS tab_1893
WHERE
	EXISTS(
		SELECT
			true AS col_5394
		FROM
			defaultdb.public.table3 AS tab_1897
	)
GROUP BY
	tab_1893.col1_6, tab_1893.col1_5
HAVING
	bool_and(true::BOOL)::BOOL
ORDER BY
	col_5398 DESC NULLS LAST,
	tab_1893.col1_6 ASC NULLS FIRST,
	col_5396 ASC NULLS FIRST,
	tab_1893.col1_5 ASC NULLS FIRST
LIMIT
	3;