# Release 1 wrote NEW, PAID, SHIPPED. Release 2 changes the enum; hbm2ddl = none
# Hibernate ORM 7.4.17.Final, H2 2.4.240 and PostgreSQL 18.6, JDK 25

== H2
-- ORDINAL, CANCELLED inserted in the middle   (release 2 enum: NEW, CANCELLED, PAID, SHIPPED)
   stored by release 1 : [1 | 0, 2 | 1, 3 | 2]
   release 2 reads     : [NEW, CANCELLED, PAID]
   release 2 writes SHIPPED : FAILS org.hibernate.exception.ConstraintViolationException <- org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
                         Check constraint violation: "CONSTRAINT_8: "; SQL statement:
-- ORDINAL, CANCELLED appended   (release 2 enum: NEW, PAID, SHIPPED, CANCELLED)
   stored by release 1 : [1 | 0, 2 | 1, 3 | 2]
   release 2 reads     : [NEW, PAID, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
                         Check constraint violation: "CONSTRAINT_8: "; SQL statement:
-- ORDINAL, PAID renamed PAYMENT_RECEIVED   (release 2 enum: NEW, PAYMENT_RECEIVED, SHIPPED)
   stored by release 1 : [1 | 0, 2 | 1, 3 | 2]
   release 2 reads     : [NEW, PAYMENT_RECEIVED, SHIPPED]
   release 2 writes PAYMENT_RECEIVED : OK, stored [1]
-- STRING, CANCELLED inserted in the middle   (release 2 enum: NEW, CANCELLED, PAID, SHIPPED)
   stored by release 1 : [1 | NEW, 2 | PAID, 3 | SHIPPED]
   release 2 reads     : [NEW, PAID, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.DataException <- org.h2.jdbc.JdbcSQLDataException
                         Value not permitted for column "('NEW', 'PAID', 'SHIPPED')": "CANCELLED"; SQL statement:
-- STRING, CANCELLED appended   (release 2 enum: NEW, PAID, SHIPPED, CANCELLED)
   stored by release 1 : [1 | NEW, 2 | PAID, 3 | SHIPPED]
   release 2 reads     : [NEW, PAID, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.DataException <- org.h2.jdbc.JdbcSQLDataException
                         Value not permitted for column "('NEW', 'PAID', 'SHIPPED')": "CANCELLED"; SQL statement:
-- STRING, PAID renamed PAYMENT_RECEIVED   (release 2 enum: NEW, PAYMENT_RECEIVED, SHIPPED)
   stored by release 1 : [1 | NEW, 2 | PAID, 3 | SHIPPED]
   release 2 reads     : FAILS java.lang.IllegalArgumentException
                         No enum constant com.ankurm.enums.Variants.StatusRen.PAID
   release 2 writes PAYMENT_RECEIVED : FAILS org.hibernate.exception.DataException <- org.h2.jdbc.JdbcSQLDataException
                         Value not permitted for column "('NEW', 'PAID', 'SHIPPED')": "PAYMENT_RECEIVED"; SQL statement:
-- CONVERTER (codes N/P/S), CANCELLED inserted + PAID renamed   (release 2 enum: NEW, CANCELLED(C), PAYMENT_RECEIVED(P), SHIPPED)
   stored by release 1 : [1 | N, 2 | P, 3 | S]
   release 2 reads     : [NEW, PAYMENT_RECEIVED, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
                         Check constraint violation: "CONSTRAINT_8: "; SQL statement:
-- @EnumeratedValue (codes N/P/S), CANCELLED inserted + PAID renamed   (release 2 enum: NEW, CANCELLED(C), PAYMENT_RECEIVED(P), SHIPPED)
   stored by release 1 : [1 | N, 2 | P, 3 | S]
   release 2 reads     : [NEW, PAYMENT_RECEIVED, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException
                         Check constraint violation: "CONSTRAINT_8: "; SQL statement:

== PostgreSQL 18
-- ORDINAL, CANCELLED inserted in the middle   (release 2 enum: NEW, CANCELLED, PAID, SHIPPED)
   stored by release 1 : [1 | 0, 2 | 1, 3 | 2]
   release 2 reads     : [NEW, CANCELLED, PAID]
   release 2 writes SHIPPED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
-- ORDINAL, CANCELLED appended   (release 2 enum: NEW, PAID, SHIPPED, CANCELLED)
   stored by release 1 : [1 | 0, 2 | 1, 3 | 2]
   release 2 reads     : [NEW, PAID, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
-- ORDINAL, PAID renamed PAYMENT_RECEIVED   (release 2 enum: NEW, PAYMENT_RECEIVED, SHIPPED)
   stored by release 1 : [1 | 0, 2 | 1, 3 | 2]
   release 2 reads     : [NEW, PAYMENT_RECEIVED, SHIPPED]
   release 2 writes PAYMENT_RECEIVED : OK, stored [1]
-- STRING, CANCELLED inserted in the middle   (release 2 enum: NEW, CANCELLED, PAID, SHIPPED)
   stored by release 1 : [1 | NEW, 2 | PAID, 3 | SHIPPED]
   release 2 reads     : [NEW, PAID, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
-- STRING, CANCELLED appended   (release 2 enum: NEW, PAID, SHIPPED, CANCELLED)
   stored by release 1 : [1 | NEW, 2 | PAID, 3 | SHIPPED]
   release 2 reads     : [NEW, PAID, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
-- STRING, PAID renamed PAYMENT_RECEIVED   (release 2 enum: NEW, PAYMENT_RECEIVED, SHIPPED)
   stored by release 1 : [1 | NEW, 2 | PAID, 3 | SHIPPED]
   release 2 reads     : FAILS java.lang.IllegalArgumentException
                         No enum constant com.ankurm.enums.Variants.StatusRen.PAID
   release 2 writes PAYMENT_RECEIVED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
-- CONVERTER (codes N/P/S), CANCELLED inserted + PAID renamed   (release 2 enum: NEW, CANCELLED(C), PAYMENT_RECEIVED(P), SHIPPED)
   stored by release 1 : [1 | N, 2 | P, 3 | S]
   release 2 reads     : [NEW, PAYMENT_RECEIVED, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
-- @EnumeratedValue (codes N/P/S), CANCELLED inserted + PAID renamed   (release 2 enum: NEW, CANCELLED(C), PAYMENT_RECEIVED(P), SHIPPED)
   stored by release 1 : [1 | N, 2 | P, 3 | S]
   release 2 reads     : [NEW, PAYMENT_RECEIVED, SHIPPED]
   release 2 writes CANCELLED : FAILS org.hibernate.exception.ConstraintViolationException <- org.postgresql.util.PSQLException
                         ERROR: new row for relation "orders" violates check constraint "orders_status_check"
