[hibernate-issues] [Hibernate-JIRA] Updated: (ANN-466) Discriminator values longer than 31 break in PostgreSQL

[Mark Hobson (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-466?page=all ]

Mark Hobson updated ANN-466:
----------------------------

    Attachment: patch.txt

Checking the HSQLDB documention, it appears that by default it ignores column length violations.  The attached patch sets the sql.enforce_strict_size property to true, which now causes the above test to fail under HSQLDB.

> Discriminator values longer than 31 break in PostgreSQL
> -------------------------------------------------------
>
>          Key: ANN-466
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-466
>      Project: Hibernate Annotations
>         Type: Bug

>   Components: binder
>     Versions: 3.2.0.ga
>     Reporter: Mark Hobson
>      Fix For: 3.2.1
>  Attachments: patch.txt
>
>
> Since ANN-321, discriminator values longer than 31 characters are commonplace.  For some reason, under HSQLDB inserting values longer than 31 into VARCHAR(31) columns succeeds without truncation, but this fails under PostgreSQL and possibly other databases.
> This can be seen by running SingleTableTest.testDefaultDiscriminatorColumn under PostgreSQL.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira