Greetings! I get a StageSourceDiff error: “Modified src/database/myuser/tables/mytable.sql file is not represented in dist folder” when I run project verify, even if the file is in the dist folder. I am running SQLcl v. 26.1.2 on Oracle 19.24. Here is how I reproduce:
- From an up to date main, I create a new feature branch (myfeature)
- I run:
project export -o mytable
- I confirm that
src/database/myuser/tables/mytable.sql is updated with the two new columns that I have added (and a new hash). I add and commit the file in git.
- I run:
project stage
- I verify that the release.changelog is updated, that a stage.changelog has been created and that the new file d
ist/releases/next/changes/myfeature/myuser/mytable.sql contains the two expected alter statements for the new columns. The sqlcl_snapshot references hash1:hash2:alter, where hash1 is the hash from src/database/myuser/mytable.sql in the main branch (i.e. before export).
- I run:
project verify -verbose
- ERROR Stage StageSourceDiff There is one modified file not represented in dist folder. Modified src/database/myuser/tables/mytable.sql file is not represented in dist folder. All changes in dist folder are represented in src folder.
- I run:
project gen-artifact -version myfeature
- I log on to a separate database and run:
project deploy -file artifact/myproject-myfeature.zip -debug -verbose
- I confirm that the changeset is successfully run and the new column is added to the table.
So despite the error, the changeset is being deployed. git.defaultBranch is set to “main” in project.config.json.
If I compare to the current branch instead of main, like this: project verify -verbose -compared-branch-name myfeature, then I do not get the StageSourceDiff error.
Could you please help me understand this behaviour? Thank you!