sql, kv: mixed-isolation-level workloads must turn on FK-check locking for serializable txns

pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test.TestCCLLogic_fk_read_committed [failed](https://mesolite.cluster.engflow.com/invocations/default/6b8c80f0-a13b-461e-9194-8c388d9c9e2e?testReportRun=1&testReportShard=4&testReportAttempt=1#targets-Ly9wa2cvY2NsL2xvZ2ljdGVzdGNjbC90ZXN0cy9mYWtlZGlzdC1kaXNrOmZha2VkaXN0LWRpc2tfdGVzdA==) on release-25.3 @ [c9ca39c05d2239cf7f30de947cbc6b1faab3beb4](https://github.com/cockroachdb/cockroach/commits/c9ca39c05d2239cf7f30de947cbc6b1faab3beb4):

```
=== RUN TestCCLLogic_fk_read_committed
test_log_scope.go:165: test logs captured to: outputs.zip/logTestCCLLogic_fk_read_committed4252608103
test_log_scope.go:76: use -show-logs to present logs inline
test_server_shim.go:143: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
[10:21:18] --- progress: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed: 5 statements
[10:21:21] --- progress: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed: 8 statements
[10:21:33] --- done: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed with config fakedist-disk: 40 tests, 2 failures
[10:21:45] --- total progress: 40 statements
--- total: 40 tests, 2 failures
logic.go:4549: -- test log scope end --
test logs left over in: outputs.zip/logTestCCLLogic_fk_read_committed4252608103
--- FAIL: TestCCLLogic_fk_read_committed (40.60s)
=== RUN TestCCLLogic_fk_read_committed/fk_cascade_race_150282
[10:21:30] --- progress: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed: 29 statements
[10:21:33] --- progress: /mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed: 36 statements
logic.go:3147:

/mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed:159: SELECT * FROM child_150282;
expected:

but found (query options: "") :
4 1

logic.go:2335:
/mnt/engflow/worker/work/0/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/logictestccl/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/logictestccl/testdata/logic_test/fk_read_committed:163: too many errors encountered, skipping the rest of the input
--- FAIL: TestCCLLogic_fk_read_committed/fk_cascade_race_150282 (4.94s)
```

Parameters:
- attempt=1
- race=true
- run=1
- shard=4
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

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

Jira issue: CRDB-53404