JPQL giving different order of joined tables in count query

Support
#1

I have a below JPQL query with some Inner joins:

select e from table1 t1 
INNER JOIN table2 c ON c.column1 = e.column1 
INNER JOIN table3 vm ON vm.column2 = c.column2 
INNER JOIN table4 dm ON e.column3 = dm.column3
INNER JOIN table5 u ON dm.column4 = u.column4

When I perform a count operation on this query then the order of the join changes. Please refer the below count query that gets generated:

//Trigger
unconstrainedDataManager.getCount(loadContext);

//Query generated
SELECT COUNT(t0.COLLECTION_ID) FROM table5 t4, table4 t3, table3 t2, table2 t1, table1 t0

Is there any way that I can define the order of the joins like below:

SELECT COUNT(t0.COLLECTION_ID) FROM table1 t0, table5 t4, table4 t3, table3 t2, table2 t1

Version Details :
Jmix version: 1.5.0
Jmix Studio plugin version: 2.0.0-231

#5

Hello,

The order of joins is defined by Eclipselink library and may not be preserved.
You can execute exact SQL query you want using EntityManager.

Regards,
Dmitry