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

[mederly]

  Branch: refs/heads/support-4.8
  Home:   https://github.com/Evolveum/midpoint
  Commit: 323d69de8a45b39204c0a6f16e5a31df8805cd62
      https://github.com/Evolveum/midpoint/commit/323d69de8a45b39204c0a6f16e5a31df8805cd62
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2024-01-24 (Wed, 24 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.

Related to MID-9427.

(cherry picked from commit 4a512fdb978325db4709bf21ad6491b54ad29163)


  Commit: 814ab03197d73aa8c230fe32e30a53db38194eda
      https://github.com/Evolveum/midpoint/commit/814ab03197d73aa8c230fe32e30a53db38194eda
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2024-01-24 (Wed, 24 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/resources/basic/objects.xml
    M repo/repo-sql-impl/src/main/java/com/evolveum/midpoint/repo/sql/query/hqm/JoinSpecification.java

  Log Message:
  -----------
  Add some tests using "@" operator

Plus fixed the handling of join conditions.

Related to MID-9427.

(cherry picked from commit 6b153f3d205ad0630e413428b5273df4d202ad7a)


Compare: https://github.com/Evolveum/midpoint/compare/98a1550e1f58...814ab03197d7