Regression: caqti-async fails tests on 3.15

[Leonidas-from-XIV]

Expected Behavior

opam install caqti-async should work on Dune 3.15

Actual Behavior

It builds but the tests fail.

Reproduction

• PR with a reproducing test:

1. opam pin <dune>#3.15
2. opam install caqti-async.2.1.1 --with-test

[ERROR] The compilation of caqti-async.2.1.1 failed at "dune runtest -p caqti-async -j 7".

#=== ERROR while compiling caqti-async.2.1.1 ==================================#
# context     2.1.5 | linux/x86_64 | ocaml-base-compiler.4.14.2 | https://opam.ocaml.org#6d17c11f
# path        ~/tarides/dune-regression-test/_opam/.opam-switch/build/caqti-async.2.1.1
# command     ~/.opam/opam-init/hooks/sandbox.sh build dune runtest -p caqti-async -j 7
# exit-code   1
# env-file    ~/.opam/log/caqti-async-96929-56464e.env
# output-file ~/.opam/log/caqti-async-96929-56464e.out
### output ###
# ((2024-03-27 11:37:53.812360105+01:00)
# [...]
#   ((monitor.ml.Error
#     ("Failed to load driver for <sqlite3:test.db?busy_timeout=60000>: Package caqti-driver-sqlite3 is not avaliable.")
#     ("Raised at Base__Error.raise in file \"src/error.ml\" (inlined), line 9, characters 14-30"
#      "Called from Dune__exe__Main_async.mk_tests.create_target in file \"testsuite/main_async.ml\", line 73, characters 8-56"
#      "Called from Stdlib__List.map in file \"list.ml\", line 92, characters 20-23"
#      "Called from Dune__exe__Main_async.mk_tests in file \"testsuite/main_async.ml\", line 75, characters 16-43"
#      "Called from Testlib.Make_alcotest_cli.run_with_args_dependency in file \"caqti/testlib/testlib.ml\", line 128, characters 24-38"
#      "Called from Dune__exe__Main_async.main in file \"testsuite/main_async.ml\", line 80, characters 4-100"
#      "Called from Async_kernel__Job_queue.run_jobs in file \"src/job_queue.ml\", line 180, characters 6-47"
#      "Caught by monitor main"))
#    ((pid 97072) (thread_id 0)))))

Specifications

• Version of dune (output of dune --version): 3.15.0~alpha1
• Version of ocaml (output of ocamlc --version): 4.14.2
• Operating system (distribution and version): Fedora Linux

Additional information

• Link to gist with verbose output (run dune with the --verbose flag):

[Leonidas-from-XIV]

I looked into it and it fails with dune runtest -p caqti-async on 3.14 and 3.15 and works with dune runtest -p caqti-async,caqti,caqti-driver-sqlite3 on both versions so while there is something odd going on, it seems to me that the issue is not a regression in Dune 3.15.