[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql

[Lukasz Antoniak (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=42120#action_42120 ] 

Lukasz Antoniak edited comment on HHH-6116 at 5/24/11 4:14 PM:
---------------------------------------------------------------

Very similar to HHH-4787.

      was (Author: lukasz.antoniak):
    Duplicates: HHH-4787.
  
> Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
> ------------------------------------------------------------------------
>
>                 Key: HHH-6116
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: envers
>    Affects Versions: 3.6.0, 3.6.1, 3.6.2, 3.6.3
>         Environment: hibernate 3.6.1 , oracle 10g...
> hibernate 3.6.3 , oracle 10g...
>            Reporter: Uli Steinkopf
>            Assignee: Lukasz Antoniak
>             Fix For: 3.6.4, 4.0.0.Alpha3
>
>
> Hello...
> AuditEntity.revisionProperty("..").isNotNull() create sql in the form of
>  column_name <> null 
> instead of 
>  column_name is not null 
> like the sql standard 
> says. E.g oracle handles "<>" different than "is not", so actual version is in this env usesless...

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