roachtest: optimizer factory constructor call stack exceeded max depth of 10000

**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=half/rand-tables [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/21078724?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/21078724?buildTab=artifacts#/unoptimized-query-oracle/disable-rules=half/rand-tables) on release-25.2 @ [4e6429fb599577b6b43fbcf85c84393b1163915e](https://github.com/cockroachdb/cockroach/commits/4e6429fb599577b6b43fbcf85c84393b1163915e):

```
(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running unoptimized statement. 1178 statements run: pq: internal error: optimizer factory constructor call stack exceeded max depth of 10000
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=true
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-21078724/unoptimized-query-oracle-disable-rules-half-rand-tables/1770446710661/1770447564202)

[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-59565