After upgrade Micronaut version can't compile project - unable to implement Repository method for projection Entity with embedded ID

[alapierre]

Expected Behavior

project should compile and runs like in MN 4.1.3

Actual Behaviour

I upgraded Micronaut from 4.1.3 to 4.2.2 and my project stop compile with error:

Unable to implement Repository method: InvoiceRepository.findByTimestampBetween(OffsetDateTime from,OffsetDateTime to,Pageable pageable). Cannot apply a column alias: id with expanded property: io.micronaut.data.model.PersistentAssociationPath@64918740

method looks like that:

Page<SalesInvoiceShortDto> findByTimestampBetween(OffsetDateTime from, OffsetDateTime to, Pageable pageable);

and it use projections from Entity class to DTO. Entity has composite EmbeddedId key InvoiceId

@Data
@Embeddable
@Builder
public class InvoiceId implements Serializable {

    @Size(max = 256)
    @NotEmpty
    private String number;

    @Size(max = 15)
    @NotEmpty
    private String nip;

    @Tolerate
    public InvoiceId() {
    }
}

SalesInvoiceShortDto

@Introspected
@Value
public class SalesInvoiceShortDto {

    InvoiceId id;

    OffsetDateTime timestamp;

    OffsetDateTime lastUpdated;

    ProcessingStatusEnum processingStatus;

    String invoiceReferenceNumber;

    @Nullable
    String ksefNumber;

    @Nullable
    OffsetDateTime acquisitionTimestamp;

    @Nullable
    String buyerIdentifier;

    @Nullable
    String buyerName;

Invoice

@Entity
@Data
@Builder
@DynamicUpdate
class Invoice implements Serializable {

    @Tolerate
    public Invoice() {
    }

    @EmbeddedId
    private InvoiceId id;

...

When I remove InvoiceId id property from SalesInvoiceShortDto it works - but it is not what I want to do...

Steps To Reproduce

No response

Environment Information

JDK 17

Example Application

No response

Version

4.2.2

[radovanradic]

Looks like introduced here #2495 with DTO association support

[radovanradic]

@alapierre Can you please submit simple app that reproduces the error?
I have tried to reconstruct the app from the classes you pasted
mn-data-dto-projection.zip
but I am not getting compiler error. Apparently it is missing something, so please take a look and if possible reupload app that reproduces the error. Thanks

[alapierre]

yes, sure. I will prepare demo app for you.

[radovanradic]

Ok, I was able to reproduce. It happens with @Repository and not with @JdbcRepository it seems.

[alapierre]

after upgrading to Micronaut to 4.3.1 I've got the same error. You do not need the sample project, do you?

The workaround is to use old fason new operator in a query, eg:

@Query("SELECT new io.alapierre.integrator.dto.InvoiceIdocId(i.id, i.idocId) FROM Invoice i WHERE i.sessionId = :sessionId AND i.id.tenant = :tenant")
List<InvoiceIdocId> findBySessionIdAndIdTenant(String sessionId, String tenant);

[radovanradic]

I was able to reproduce, thanks. Maybe the solution would be to use new (..) constructor in query but it's not the best because it would force DTOs to have all params constructor etc.

[alapierre]

yes, workaround is only to solve problem now. Let me know if I can help with that in any way. Thank you.