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

[Emmanuel Bernard (JIRA)]

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

Emmanuel Bernard commented on ANN-466:
--------------------------------------

I'm against 2
Hibernate does not interfere with the  constraints defined at the DDL level (ie not check at runtime). I'd like to keep it that way.

The very first time you'll check for an entity insertion, you'll get the SQLException. I expect most people to do unit tests (or manual tests) before going to production.
Increasing the default column name is not an option since the spec is shipped already.

> 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