liquibase skips quotes for default value 'infinity' - PostgresSQL


I’m using PostgresSQL server and there are columns which have default value set up to ‘infinity’. But liquibase removes quotes and i have error related to syntax in generated sql. But it works fine with all other default constants…

sql code in DB:

 date_from date DEFAULT ‘1900-01-01’::date,

 date_to date DEFAULT ‘infinity’::date,
sql code in generated sql:

date_from date DEFAULT ‘1900-01-01’, date_to date DEFAULT INFINITY,

Do you have any idea how I can resolve it?

Hi Taras,


Sharing more from the internal bug ticket (Thanks Steve) we don’t capture this object correctly with doing the diff. The snapshot is not good as well.

For example:


Hi Taras,