Binding on @Query

[volnei]

Micronaut appers to binding only first field

	@Query(value = "SELECT DATE(e.created_at) as date, e.event AS event, COUNT(e.id) AS total FROM events e WHERE app = :app GROUP BY e.event, DATE(e.created_at)", nativeQuery = true, readOnly = true)
	public abstract Mono<List<EventStatsDTO>> stats(String app);

DTO

import java.time.LocalDate;

import io.micronaut.core.annotation.Introspected;
import lombok.Data;

@Data
@Introspected
public class EventStatsDTO {
    
    private String event;
    private LocalDate date;
    private Long total;
}

Results in

["2023-08-04"]

[radovanradic]

Hi, I tried to recreate sample app for this and it looks ok (it's just jdbc repository, but that shouldn't make difference).
mn-mysql-dto.zip
Can you take a look and update what's diff so we can try to reproduce.

[volnei]

@radovanradic thank you for your reply and attention!

I fixed it by using Flux<EventStatsDTO> insted of Mono<List<EventStatsDTO>> but I don't know why the second one doest work