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

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/21284451?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/21284451?buildTab=artifacts#/unoptimized-query-oracle/disable-rules=half/rand-tables) on release-25.2 @ [7c7060608b38d64f013496a51840b73c1b425086](https://github.com/cockroachdb/cockroach/commits/7c7060608b38d64f013496a51840b73c1b425086):

```
(query_comparison_util.go:419).runOneRoundQueryComparison: . 1637 statements run: expected unoptimized and optimized results to be equal
[]string{
- ``e'\'table{_2\''``,
+ "105",
}
sql: SELECT
(
SELECT
tab_863."?col2_9" AS col_2591
FROM
defaultdb.public."table{_2" AS tab_863
ORDER BY
col_2591 DESC
LIMIT
1:::INT8
)
AS col_2592
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- diskCount=0
- encrypted=false
- metamorphicBufferedSender=false
- runtimeAssertionsBuild=false
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md)

See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

See: [Grafana](https://go.crdb.dev/roachtest-grafana/teamcity-21284451/unoptimized-query-oracle-disable-rules-half-rand-tables/1774513116721/1774516120034)

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*unoptimized-query-oracle/disable-rules=half/rand-tables.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-62094