| Since
HHH-11709 Resolved was fixed, negative sequence values can be used. However, PostgreSQL requires the following SEQUENCE declaration when the start value is negative, but the increment size is positive:
create sequence NEG_TWO_SEQ minvalue -10 start -10 increment -1
So, we need to pass the minimum value explicitly, as otherwise, the sequence creation fails:
DEBUG SQL:92 - create sequence POS_ONE_SEQ start -5 increment 1
Caused by: org.postgresql.util.PSQLException: ERROR: START value (-5) cannot be less than MINVALUE (1)
|