roachtest: max cardinality must be <= 1 if FDs have max 1 row

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

```
(query_comparison_util.go:419).runOneRoundQueryComparison: internal error while running optimized statement. 431 statements run: pq: internal error: max cardinality must be <= 1 if FDs have max 1 row: [0 - ]
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-multi-region/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- encrypted=false
- runtimeAssertionsBuild=true
- ssd=0
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-20248904/unoptimized-query-oracle-disable-rules-half-rand-multi-region/1753606966988/1753607977349)

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

Jira issue: CRDB-52943