sqlx test fails with 'relation "my_table" does not exist'

[uvizhe]

I'm trying to test my code with #[sqlx::test] macro attributed test function and it fails with Error: error returned from database: relation "my_table" does not exist.

I have a migration script in place with 'my_table' and other tables defined with 'CREATE TABLE'.

My other tests work well using other tables from the same migration script.
The failing test tests logic that works with this new table 'my_table' which I added recently to a migration script.

I'm not sure what can be the reason for the problem and how can I debug it.

sqlx = "0.8.3"

UPD: A few details

• Turns out that this particular test does not see any of the tables from migration script
• All other working tests are located in different crates in the same workspace
• Failing test fails always, no matter if I run it isolated or run all tests in a workspace.

[uvizhe]

I found the source of the issue. My tests are located in different crates in a workspace and I forgot to put a symlink for migrations in the crate folder where my failing test is located.

So while it seemed that migration script applies it did not apply for a particular test.