[BUG] - Incorrect join elimination optimization

[belovaf]

Jimmer Version

0.9.72

JDK Version

23

Database

Postgres, H2

OS

Mac

Expected behavior

Jimmer generates valid sql.

Actual behavior

Jimmer generated sql with missing alias.

Description

Jimmer incorrectly eliminates join with table if !fetchType(JOIN_ALWAYS) is used.

Reproduction steps

Model:

@MappedSuperclass
interface SerialId {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    val id: Long
}

@Entity
interface A : SerialId {
    @OneToOne(mappedBy = "a")
    val b: B?

    @OneToOne(mappedBy = "a")
    val c: C?

    val name: String
}

@Entity
interface B : SerialId {
    @OneToOne
    val a: A

    val name: String
}
@Entity
interface C : SerialId {
    @OneToOne
    val a: A

    val name: String
}

Code:

sql.executeQuery(B::class) {
            where(table.id eq 1)
            select(
                table.a.fetch(newFetcher(A::class).by {
                    c(fetchType = ReferenceFetchType.JOIN_ALWAYS) {
                        name()
                    }
                }),
            )
        }

Generated SQL

select tb_2_.ID, tb_3_.ID, tb_3_.NAME
from public.B tb_1_
left join public.C tb_3_ on tb_2_.ID = tb_3_.A_ID
where tb_1_.ID = ?

[babyfish-ct]

Try 0.9.73