This is possible since https://github.com/rails/rails/pull/50999.
Now in transactional fixtures, the other threads do checkout the
same connection as the same thread, it's just synchronized around
performing the query.

This allow to properly test async queries without having to disable
transactional fixtures.