I am using 4.26.0.
I have a SQL statement for a Oracle view which looks something like this -
create or replace view fx_users as
select
u.loc_cod,
rtrim(REGEXP_REPLACE(u.BusinessFunction, ‘([^,]*)(,\1)+($|,)’, ‘\1,’), ‘,’) BusinessFunction
from users u;
– Giving grant to some users
CALL give_grants(‘view_users’);
My changeset for the above SQL is like below -
This seems to be failing as it seems like liquibase is not able to handle the regex - ([^,]*)(,\1)+($|,)', ‘\1,’), ‘,’)
when splitstatements is TRUE
Is there any way get this working ?