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

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

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

(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 1896 statements run: pq: internal error: ordering column group (3,20) contains non-equivalent columns (op project)
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1

Parameters:

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

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

• roachtest: unoptimized-query-oracle: difference between execution engines around GROUP BY and NULLs #156270 roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-25.3 release-blocker]

This test on roachdash | Improve this report!

Jira issue: CRDB-56160

[yuzefovich]

dup of #134816