Message Title

Sylvie PERROT created an issue

Issue Type:	Bug
Affects Versions:	5.2.17, 5.3.9
Assignee:	Unassigned
Attachments:	SQL_expected.txt, SQL_generated.txt, criteria_written.txt
Created:	25/Mar/2019 06:24 AM
Environment:	PostgreSQL, Glassfish 4, JPA 2.2, Windows, Hibernate 5.3.9.Final
Priority:	Major
Reporter:	Sylvie PERROT

Hi,

I have a criteria with many inner join (about 13-14), but the generated SQL query has a different order.

This causes performance problems because the SQL query takes about 140ms to be executed, and the criteria query (and SQL generated query) takes about 3 minutes !!

See linked files : SQL_expected, SQL_generated by criteria, Criteria_written. SQL_generated.txt SQL_expected.txt criteria_written.txt

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira