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

[Mark Hobson (JIRA)]

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

Mark Hobson commented on ANN-466:
---------------------------------

I can see the reasons for deterministic configuration and spec-compliance.  How can this issue not get lost in JIRA but be raised for future consideration in the spec?

> 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