Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Wrong add contraint unique statement for informix

Description

Hibernate 4.2.2, Informix 11.5

Unique constraint for a varchar colum generated by hibernate:

alter table CONTENT_TYPE add constraint UK_bj57mo7jmskov9s34ylf5wa18 unique (TYPE)

According to the Informix doc the unique constraint name should be at the end.

Activity

Show:

Brett MeyerJuly 25, 2013 at 2:40 PM

Thanks for testing, but please don't close it yet.

Oliver PfauJuly 25, 2013 at 2:33 PM

Tested successfully with 4.2.4-SNAPSHOT

Oliver PfauJuly 25, 2013 at 2:25 PM

Generates now:

alter table CONTENT_TYPE add constraint unique (TYPE) constraint UK_bj57mo7jmskov9s34ylf5wa18

and uk is existing in informix database. Thanks.

Oliver PfauJuly 25, 2013 at 2:22 PM

Ok...will do that.

Brett MeyerJuly 25, 2013 at 2:08 PM

Definitely not compatible. Try 4.2.4-SNAPSHOT

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Created July 12, 2013 at 7:34 AM
Updated August 8, 2013 at 2:32 AM
Resolved July 25, 2013 at 2:41 PM