[midPoint-git] [Evolveum/midpoint] 00e4c2: Fix archetypeRef/@/name query on generic repo

[mederly]

  Branch: refs/heads/tmp/mid-9427-second-attempt
  Home:   https://github.com/Evolveum/midpoint
  Commit: 00e4c276033fcb39d0efc1ca688758c40bb945c1
      https://github.com/Evolveum/midpoint/commit/00e4c276033fcb39d0efc1ca688758c40bb945c1
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2024-01-23 (Tue, 23 Jan 2024)

  Changed paths:
    M repo/repo-sql-impl-test/src/test/java/com/evolveum/midpoint/repo/sql/QueryInterpreterTest.java
    M repo/repo-sql-impl-test/src/test/java/com/evolveum/midpoint/repo/sql/SearchTest.java
    M repo/repo-sql-impl-test/src/test/java/com/evolveum/midpoint/repo/sql/SequenceTest.java
    M repo/repo-sql-impl-test/testng-integration.xml
    M repo/repo-sql-impl/src/main/java/com/evolveum/midpoint/repo/sql/query/definition/JpaLinkDefinition.java
    M repo/repo-sql-impl/src/main/java/com/evolveum/midpoint/repo/sql/query/definition/JpaReferenceDefinition.java
    M repo/repo-sql-impl/src/main/java/com/evolveum/midpoint/repo/sql/query/hqm/JoinSpecification.java
    M repo/repo-sql-impl/src/main/java/com/evolveum/midpoint/repo/sql/query/resolution/ItemPathResolver.java

  Log Message:
  -----------
  Fix archetypeRef/@/name query on generic repo

When dereferencing using the "@" operator, we now tell
Hibernate to use the specific target (joined) type by using
root joins.

However, the SQL that is generated sometimes suboptimal,
as it includes useless join on M_OBJECT table.

Related to MID-9427. To be reviewed.