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

[cockroach-teamcity]

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

(query_comparison_util.go:257).runOneRoundQueryComparison: . 3173 statements run: expected unoptimized and optimized results to be equal
  []string{
- 	"-",
+ 	"0",
  }
sql: SELECT
	(
		SELECT
			tab_2981.col4_5 AS col_9549
		FROM
			defaultdb.public."tab'le4"@[0] AS tab_2981
		ORDER BY
			col_9549 ASC NULLS LAST
		LIMIT
			1:::INT8
	)
		AS col_9550
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/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: nil pointer in DiskRowContainer.Close #123141 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-24.1]
• roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed #123128 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-master release-blocker]

This test on roachdash | Improve this report!

Jira issue: CRDB-38244

[yuzefovich]

dup of #118273