Unless `legacy_connection_handling` was set to `false`, only the default
shard's connection pools were shared during transactional tests.