liquibase skips quotes for default value 'infinity' - PostgresSQL

Liquibase Users
#1

Hello

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?

#2

Hi Taras,

Ronak

#3

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:



},

#4

Hi Taras,

https://github.com/liquibase/liquibase/issues/1094