EndDelimiter '/' not working as expected since 4.29

General Discussion
1

We are deploying SQL and PLSQL scripts on an Oracle Database via Liquibase. We use ‘/’ as endDelimiter because it’s compatible with native SQL and PLSQL.

Since 4.29 this is some kind of broken. For example this Code fails because of a misinterpretation of the ‘/’ at line end.

– liquibase formatted sql
– changeset abc:ABC_PROC runOnChange:true stripComments:false endDelimiter:/
– comment Initial Creation
CREATE OR REPLACE PROCEDURE ABC_PROC…IS
…
BEGIN
…
i := j /
2;
…
END;
/

‘/’ should only be an endDelimiter if it’s at the beginning of a new line with no other content following on the same line.
We had to switch back to 4.28 to avoid this bug.

2

@daniel.waschke are you able to file this as a bug in the Liquibase repo?

3

thanks, I reported the bug on Github EndDelimiter '/' not working as expected since 4.29 · Issue #6150 · liquibase/liquibase · GitHub

1 Like