SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLCL 26.1 - Liquibase Update is updating the sequence

Scott H.3 days ago

Hi.. I recently updated to SqlCL 26.1… This is my changelog

However.. when deployed to production, this changed my identity column to start with 1611.. in production, I was already over 2000.. so my users got PK errors. Fortunately, for this update, I only had a few tables, so I was able to increase the sequences properly.

Reverting back to 25.4.2, this still seems to happen. Is there a command to avoid this when updating a table? Or is this a bug?

Added 3 days ago

#identity, #liquibase, #sqlcl

5 comments

100 views

3 mentions