[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1493) mapping.Table fails to add a nullable column (without default value)

[Patrick Decat (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28240 ] 

Patrick Decat commented on HHH-1493:
------------------------------------

Hi,
I too have encountered this problem with Sybase ASE 12.0.0.8.

I've uploaded a proper patch generated with 'svn diff' as Table.java.patch2 (see HHH-1494).

Best regards,
Patrick.

> mapping.Table fails to add a nullable column (without default value)
> --------------------------------------------------------------------
>
>                 Key: HHH-1493
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1493
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.1.2
>         Environment: Sybase 11.1.1-swr8229, Window XP, java 1.4.2_08-b03
>            Reporter: Alexis Midon
>   Original Estimate: 30 minutes
>  Remaining Estimate: 30 minutes
>
> org.hibernate.mapping.Table.sqlAlterStrings(...) method builds a malformed 'alter table' query when the column is nullable (without any default value).
> For instance, generated query is: 
> alter table MY_TABLE add FOO varchar(255)
> instead of:
> alter table MSP_STPFC_ENTRY_TABLE add FUU varchar(255) null
> The mistake is obvious when you compare with method Table.sqlCreateString(...)

-- 
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