Hello. H2 preserves the specified name of constraint as is. Your command creates a constraint with the name GS_PAYS_UN1_1. This constraint in H2 needs a compatible index on column GS_PAYS_LIB. If such index wasn't found, H2 creates its automatically and name of such index is autogenerated. In your case in can be GS_PAYS_UN1_1_INDEX_3 or some else.
It looks like you check the result in the wrong place. You can read constraints from INFORMATION_SCHEMA.TABLE_CONSTRAINTS table. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f5efb57c-fcb8-424b-ac2e-fb566f4051d7n%40googlegroups.com.
