roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on release-23.1 @ ed045dc72631760a58a58d46de01d6ffacd3335a:

(query_comparison_util.go:257).runOneRoundQueryComparison: . 2215 statements run: expected unoptimized and optimized results to be equal
  []string{
  	strings.Join({
- 		"-",
+ 		"0",
  		",1972-09-27 00:00:00 +0000 +0000,0000-01-01 00:00:00 +1559 +1559",
  	}, ""),
  }
sql: SELECT
	(
		SELECT
			(
				SELECT
					tab_1669."col""1_3" AS col_4817
				FROM
					defaultdb.public."t
able5"@[0] AS tab_1670
				ORDER BY
					col_4817 ASC NULLS LAST
				LIMIT
					1:::INT8
			)
				AS col_4818
		FROM
			defaultdb.public.table1@[0] AS tab_1669
		ORDER BY
			col_4818 ASC
		LIMIT
			1:::INT8
	)
		AS col_4819,
	'1972-09-27':::DATE AS col_4820,
	'00:00:00+15:59':::TIMETZ AS col_4821
ORDER BY
	col_4820 NULLS FIRST, col_4819 ASC, col_4821 DESC NULLS LAST
LIMIT
	75:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1

Parameters:

• ROACHTEST_arch=amd64
• ROACHTEST_cloud=gce
• ROACHTEST_cpu=4
• ROACHTEST_encrypted=false
• ROACHTEST_metamorphicBuild=false
• ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: unoptimized-query-oracle: missing DOid.name population when decoding from disk #123816 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-24.1]

This test on roachdash | Improve this report!

Jira issue: CRDB-38641

[yuzefovich]

dup of #118273