[Hibernate-JIRA] Created: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
5:35 a.m.
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.3, 3.6.2, 3.6.1, 3.6.0
Environment: hibernate 3.6.1 , oracle 10g...
hibernate 3.6.3 , oracle 10g...
Reporter: Uli Steinkopf
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:03 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=c...
]
Uli Steinkopf commented on HHH-6116:
------------------------------------
Seems that the Problem is not the creation of sql itself rather than the hql before.....
org.hibernate.envers.query.criteria.NotNullAuditExpression
...
public void addToQuery(AuditConfiguration auditCfg, String entityName, QueryBuilder qb,
Parameters parameters) {
String propertyName = propertyNameGetter.get(auditCfg);
RelationDescription relatedEntity = CriteriaTools.getRelatedEntity(auditCfg,
entityName, propertyName);
if (relatedEntity == null) {
parameters.addWhereWithParam(propertyName, "<>", null); //
!!!!!!this is the problem
} else {
relatedEntity.getIdMapper().addIdEqualsToQuery(parameters, null, propertyName,
false);
}
}
So incorrect HQL is created.....
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:46 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=c...
]
Uli Steinkopf commented on HHH-6116:
------------------------------------
seems that change line 47 in org.hibernate.envers.query.criteria.NotNullAuditExpression
to
parameters.addWhere(propertyName, true, "is not", "null",false);
fix the problem..May be there is a similiar prob in
org.hibernate.envers.query.criteria.NullAuditExpression
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:36 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=c...
]
Lukasz Antoniak commented on HHH-6116:
--------------------------------------
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:09 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=c...
]
Lukasz Antoniak reassigned HHH-6116:
------------------------------------
Assignee: Lukasz Antoniak
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:11 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=c...
]
Lukasz Antoniak resolved HHH-6116.
----------------------------------
Resolution: Fixed
Fix Version/s: 3.6.4
4.0.0.Alpha3
Fixed together with issue 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: 4.0.0.Alpha3, 3.6.4
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:16 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-6116) Envers AuditEntity.revisionProperty("...").isNotNull() creates wrong sql
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-6116?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4962
days inactive
5004
days old
hibernate-issues@lists.jboss.org
6 comments
2 participants
participants (2)
-
Lukasz Antoniak (JIRA) -
Uli Steinkopf (JIRA)