Hello,
I sometimes run into a weird behavior with SQLcl projects.
I export my changes and commit them, then run project stage. However, those changes don't appear in the next folder. If I then re-run project export (there's nothing new to commit, since no changes were made) and run project stage again, the changes suddenly appear.
I don't have solid evidence for exactly when this happens, but I've noticed it seems to occur more often when the export was done a few days before running project stage. It's not just happening to me; my whole team has experienced it. We're currently on SQLcl 26.1.2, but we also saw the same behavior on 26.1.1.
Has anyone else experienced this behavior?
If so, is this a bug? Can anyone explain why this happens? I always assumed that project stage determines the changes by comparing the relevant Git branches. If that's the case, I don't understand why running project export again suddenly causes those changes to appear during staging.