When we edit an existing soft object such as a Package Body or Function in a text editor the change does not get picked up by Project Stage – project stage -verbose -debug does not update the checksum of the modified file, and instead shows the following message:
Skipping file: src/database/demo/package_bodies/p1.sql becasue the only changes are in the sxml
I am running 25.4.2.044.1837, reproduced on a free:latest-lite container.
Steps to reproduce:
sql -thin system/mypw@//localhost/freepdb1
create user demo identified by demo;
alter user demo quota unlimited on users;
project init -name demo_project -schemas demo
!git init --initial-branch=main
!git add --all
!git commit -m "initial"
!git checkout -b ticket-1
create package demo.p1 as
procedure proc1;
end;
/
create or replace package body demo.p1 as
procedure proc1 as
begin null;
end;
end;
/
project export
!git add --all
!git commit -m "package initial src"
project stage
!git add --all
!git commit -m "package initial dist"
!git checkout main
!git merge ticket-1
!git checkout -b pkg-edit
exit
(note, in trying to reproduce the error, it was important to exit and the app and re-open it. I think once the object has been exported in the current session the error condition goes away)
notepad src/database/demo/package_bodies/p1.sql
<edit the text file to add another null; line>
sql -thin system/mypw@//localhost/freepdb1
!git add --all
!git commit -m "package body edited"
project stage -verbose -debug
outputs the following:
src/database/demo/package_bodies/p1.sql -> src/database/demo/package_bodies/p1.sql
Skipping file: src/database/demo/package_bodies/p1.sql becasue the only changes are in the sxml