Hi,

I am using JPA with Hibernate 4.2.1. I have a mapped field of type varchar which is marked with unique=true. Hibernate generates the following on schema creation:

alter table CONTENT_TYPE drop constraint UK_bj57mo7jmskov9s34ylf5wa18
10:01:00,924 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] (http--0.0.0.0-9090-5) alter table CONTENT_TYPE add constraint UK_bj57mo7jmskov9s34ylf5wa18 unique (TYPE)

Unfortunatelty no unique constraint is existing in the informix database. Tried to execute the add constraint statement without success. In the informix documentation there is no name defined for the constraint. After removing the name it works:

alter table CONTENT_TYPE add constraint unique (TYPE)

Is this a bug in the informix dialect?

Cheers
Oliver