roachtest: unoptimized-query-oracle/disable-rules=all/seed-multi-region failed

[cockroach-teamcity]

roachtest.unoptimized-query-oracle/disable-rules=all/seed-multi-region failed with artifacts on release-24.2 @ d5601d26e1e4c4ebb906ed434d09b906b3f642ad:

(query_comparison_util.go:416).runOneRoundQueryComparison: . 696 statements run: expected unoptimized and optimized results to be equal
  []string{
  	"0,NULL",
  	"0,NULL",
  	"0,NULL",
- 	"0,NULL",
+ 	"5.007715329123865e-18,NULL",
  	"NULL,NULL",
  	"NULL,NULL",
  	... // 3 identical elements
  }
sql: SELECT
	stddev_samp((-0.0506429618381658):::FLOAT8::FLOAT8)::FLOAT8 AS col_2801, NULL AS col_2802
FROM
	defaultdb.public.seed AS tab_809
WHERE
	EXISTS(
		SELECT
			'!''zHMRfBQrdM'' & !''DUN'' | ''VuJrUBSs'' | ''ftieOQmNtX''':::TSQUERY AS col_2800
		FROM
			defaultdb.public.seed AS tab_810
	)
GROUP BY
	tab_809.crdb_internal_mvcc_timestamp, tab_809._int4
HAVING
	bool_or(tab_809._bool::BOOL)::BOOL
ORDER BY
	tab_809._int4 ASC
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/seed-multi-region/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• fs=ext4
• localSSD=true
• runtimeAssertionsBuild=false
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-47251