Strong Liu resolved HHH-2389.
Fix Version/s: 4.0.0.Beta1
fixed by HHH-2176
Improving DB2 dialect
Project: Hibernate Core
Issue Type: Improvement
Affects Versions: 3.2.1
Environment: Development based on v 3.2.1
Reporter: Nicolas Billard
Assignee: Strong Liu
Fix For: 4.0.0.Beta1
The class joined to this issue overrides the DB2 dialect. The dialect included in
hibernate doesn't work very well when you want to limit returned results (when you
call setFirstResult and / or setMaxResults on a query) :
- the instructions "fetch first XXX row only is not used
- a temporary table is used when it's not usefull
- when you have subselects, an exception can occur if subselects have order by clause
(because of the getRowNumber method, not corrected here).
This version of getLimitString() method generates faster requests (tests made on a table
of 300000 rows shows that fetching rows from 20 to 30 takes 0.3 seconds with original
version, 0.02 with this one).
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: