Weird behaviours with sub dependencies

[augustocdias]

I'm using the sqlx cli to generate a local cache and then to check if it is up to date in the CI.

We're having a weird behaviour where I push a change and the CI fails saying the cache is not up to date. I try to generate again and it generates with no changes whatsoever. My colleague pulls my branch and generates on his machine and it generates changes which he pushes and the problem is solved. This happened the other way around too (I had to pull and generate for branches of him).

I suspect this is related to sub dependencies that also has queries inside because it is always one of those. We have a workspace with sub crates that uses sqlx. Each has its own queries. One of this projects depend on another that has also its queries. I noticed that the queries from the sub project are being generated in the sql json from both projects.

Is this the expected behaviour? Does this explain this weird issue?

[tkintscher]

I am said colleague and have only one more bit of insight.
Last time this happend, I ran cargo sqlx prepare. This yielded no (discernible, in git) changes.

But cargo sqlx prepare --check failed and asked me to run prepare again. I couldn't resolve this on my machine.

(and I only ran this inside a particular crate, not on the workspace level)