Jmix Use shading-jdbc bug

Support
#1

Problem description

An error is reported when the query scope locates multiple tables. No sorting is normal

Recurrence Bug

sample code

cn.cruder.dousx.jsjpg.JmixShadingJdbcPgApplicationTests#insertTests create 1000 data,Then executecn.cruder.dousx.jsjpg.JmixShadingJdbcPgApplicationTests#orderFailTest

#4

Hi!

Looks like there is a problem with EclipseLink.
Could you test its reprodusion on a clear EclipseLink project (without Jmix Framework)?

Regards,
Dmitriy

#5

Hi！

Sorting looks fine using EclipseLink alone.

This is sample code.

#7

Hello!
I’ve tried to reproduce the problem using provided project, but it looks like this project has conflict in dependencies.
The problem occurs when I run cn.cruder.dousx.jsjpg.JmixShadingJdbcPgApplicationTests#insertTests

Execution failed for task ':compileJava'.
> Could not resolve all files for configuration ':compileClasspath'.
   > Could not resolve org.codehaus.groovy:groovy:3.0.13.
     Required by:
         project : > io.jmix.bom:jmix-bom:1.4.4 > org.springframework.boot:spring-boot-dependencies:2.7.7
         project : > io.jmix.core:jmix-core-starter:1.4.4 > io.jmix.core:jmix-core:1.4.4
      > Module 'org.codehaus.groovy:groovy' has been rejected:
           Cannot select module with conflict on capability 'org.codehaus.groovy:groovy:3.0.13' also provided by [org.apache.groovy:groovy:4.0.3(groovyApiElements)]
   > Could not resolve org.apache.groovy:groovy:4.0.3.
     Required by:
         project : > org.apache.shardingsphere:shardingsphere-jdbc-core:5.2.1 > org.apache.shardingsphere:shardingsphere-traffic-core:5.2.1 > org.apache.shardingsphere:shardingsphere-infra-common:5.2.1 > org.apache.shardingsphere:shardingsphere-infra-util:5.2.1
         project : > org.apache.shardingsphere:shardingsphere-jdbc-core:5.2.1 > org.apache.shardingsphere:shardingsphere-traffic-core:5.2.1 > org.apache.shardingsphere:shardingsphere-infra-common:5.2.1 > org.apache.shardingsphere:shardingsphere-infra-util:5.2.1 > org.apache.groovy:groovy:4.0.3 > org.apache.groovy:groovy-bom:4.0.3
      > Module 'org.apache.groovy:groovy' has been rejected:
           Cannot select module with conflict on capability 'org.codehaus.groovy:groovy:4.0.3' also provided by [org.codehaus.groovy:groovy:3.0.13(compile)]

It seems either Jmix 2.x (with spring boot 3) or shardingsphere with lower version should be used.

Could you please recheck the project in order to get rid of dependency conflicts or provide more info how to run it correctly?

Regards,
Dmitry