-
Type:
Bug
-
Status: Resolved (View Workflow)
-
Priority:
Major
-
Resolution:
Won't Fix
-
Affects Version/s: EAP 5.0.0, 4.2.0.GA_CP08, 4.3.0.GA_CP07
-
Fix Version/s: TBD
-
Component/s: Hibernate
-
Labels:None
-
Environment:
Sybase 15
-
Affects:Release Notes
-
Workaround Description:
-
Release Notes Text:
-
Release Notes Docs Status:Not Required
Test QueryByExampleTest.testJunctionNotExpressionQBE fails due to the option "ansinull" having the default value of "off" in Sybase 15. The test expects two records as a result for a query, but it gets 3. After some debugging with the query that Hibernate generated, I end up with these two simpler ones:
select id from Componentizable where not (name like ? and subName1 like ?)
select id from Componentizable where not (name like 'hibernate' and subName1 like 'ope%')
The first one returns three records, while the second returns two. The interesting part is that if I replace the first parameter in the first query by a hardcoded value ("hibernate"), it still returns 3 records. That means that the problem is probably with the binding of JDBC parameters containing a wildcard % .
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4580