[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5718) AuditProperty.isNotNull creates an incorrect condition in the MySQL dialect

AuditProperty.isNotNull creates an incorrect condition in the MySQL dialect --------------------------------------------------------------------------- Key: HHH-5718 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5718 Project: Hibernate Core Issue Type: Bug Components: envers Affects Versions: 3.5.6 Environment: 3.5.6-FINAL, MySQL 5.0.27, for apple-darwin9.3.0 Reporter: Anthony Bishopric Assignee: Lukasz Antoniak Fix For: 4.0.0.Alpha3, 3.6.4 Attachments: SampleEntity.java, SampleEntityDAO.java When using AuditProperty.isNotNull(), envers will generate a sql condition "property<>null". This condition can never evaluate to true (it must use MySQL's "is not null" convention) Attached are two example classes which should replicate the issue.