Query projection in pageable data

[MinionCZ]

Hello,
I was looking at projections and I really like this feature. I was trying to make it work in batch operations with paging to fetch paged results of IDs, but I am constantly getting this error:

14:19:42.130 [io-executor-thread-1] ERROR i.m.http.server.RouteExecutor - Unexpected error occurred: Select item was not an entity type
org.hibernate.query.IllegalQueryOperationException: Select item was not an entity type
	at org.hibernate.query.sqm.internal.SqmUtil.sortSpecification(SqmUtil.java:847)
	at org.hibernate.query.sqm.internal.AbstractSqmSelectionQuery.lambda$setOrder$0(AbstractSqmSelectionQuery.java:137)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682)
	at org.hibernate.query.sqm.internal.AbstractSqmSelectionQuery.setOrder(AbstractSqmSelectionQuery.java:138)
	at org.hibernate.query.sqm.internal.QuerySqmImpl.setOrder(QuerySqmImpl.java:775)
	at io.micronaut.data.hibernate.operations.HibernateJpaOperations.setOrder(HibernateJpaOperations.java:235)
	at io.micronaut.data.hibernate.operations.HibernateJpaOperations.setOrder(HibernateJpaOperations.java:95)
	at io.micronaut.data.hibernate.operations.AbstractHibernateOperations.bindPageable(AbstractHibernateOperations.java:643)
	at io.micronaut.data.hibernate.operations.AbstractHibernateOperations.bindPreparedQuery(AbstractHibernateOperations.java:533)
	at io.micronaut.data.hibernate.operations.AbstractHibernateOperations.collectResults(AbstractHibernateOperations.java:425)
	at io.micronaut.data.hibernate.operations.AbstractHibernateOperations.collectFindAll(AbstractHibernateOperations.java:363)
	at io.micronaut.data.hibernate.operations.HibernateJpaOperations.lambda$findAll$8(HibernateJpaOperations.java:325)
	at io.micronaut.data.hibernate.operations.HibernateJpaOperations.lambda$executeRead$21(HibernateJpaOperations.java:566)
	at io.micronaut.transaction.support.AbstractPropagatedStatusTransactionOperations.lambda$execute$2(AbstractPropagatedStatusTransactionOperations.java:68)
	at io.micronaut.transaction.TransactionCallback.apply(TransactionCallback.java:37)
	at io.micronaut.transaction.support.AbstractTransactionOperations.executeTransactional(AbstractTransactionOperations.java:333)
	at io.micronaut.transaction.support.AbstractTransactionOperations.lambda$openConnectionAndExecuteTransaction$5(AbstractTransactionOperations.java:302)
	at io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
	at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
	at io.micronaut.transaction.support.AbstractTransactionOperations.openConnectionAndExecuteTransaction(AbstractTransactionOperations.java:301)
	at io.micronaut.transaction.support.AbstractTransactionOperations.executeWithExistingTransaction(AbstractTransactionOperations.java:248)
	at io.micronaut.transaction.support.AbstractTransactionOperations.doExecute(AbstractTransactionOperations.java:131)
	at io.micronaut.transaction.support.AbstractTransactionOperations.doExecute(AbstractTransactionOperations.java:125)
	at io.micronaut.transaction.support.AbstractPropagatedStatusTransactionOperations.execute(AbstractPropagatedStatusTransactionOperations.java:65)
	at io.micronaut.transaction.TransactionOperations.executeRead(TransactionOperations.java:76)
	at io.micronaut.data.hibernate.operations.HibernateJpaOperations.executeRead(HibernateJpaOperations.java:566)
	at io.micronaut.data.hibernate.operations.HibernateJpaOperations.findAll(HibernateJpaOperations.java:323)
	at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
	at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
	at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
	at cz.deuss.companyservice.database.repository.CompanyRepository$Intercepted.findId(Unknown Source)
	at cz.deuss.companyservice.service.CompanyService.getCompanies(CompanyService.kt:42)
	at cz.deuss.companyservice.service.$CompanyService$Definition$Intercepted.$$access$$getCompanies(Unknown Source)
	at cz.deuss.companyservice.service.$CompanyService$Definition$Exec.dispatch(Unknown Source)
	at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invoke(AbstractExecutableMethodsDefinition.java:456)
	at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:134)
	at io.micronaut.transaction.interceptor.TransactionalInterceptor.lambda$intercept$5(TransactionalInterceptor.java:140)
	at io.micronaut.transaction.support.AbstractPropagatedStatusTransactionOperations.lambda$execute$2(AbstractPropagatedStatusTransactionOperations.java:68)
	at io.micronaut.transaction.TransactionCallback.apply(TransactionCallback.java:37)
	at io.micronaut.transaction.support.AbstractTransactionOperations.executeTransactional(AbstractTransactionOperations.java:333)
	at io.micronaut.transaction.support.AbstractTransactionOperations.executeWithNewTransaction(AbstractTransactionOperations.java:318)
	at io.micronaut.transaction.support.AbstractTransactionOperations.executeNew(AbstractTransactionOperations.java:235)
	at io.micronaut.transaction.support.AbstractTransactionOperations.doExecute(AbstractTransactionOperations.java:137)
	at io.micronaut.transaction.support.AbstractTransactionOperations.lambda$doExecute$0(AbstractTransactionOperations.java:122)
	at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
	at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
	at io.micronaut.transaction.support.AbstractTransactionOperations.doExecute(AbstractTransactionOperations.java:120)
	at io.micronaut.transaction.support.AbstractPropagatedStatusTransactionOperations.execute(AbstractPropagatedStatusTransactionOperations.java:65)
	at io.micronaut.transaction.interceptor.TransactionalInterceptor.intercept(TransactionalInterceptor.java:140)
	at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
	at cz.deuss.companyservice.service.$CompanyService$Definition$Intercepted.getCompanies(Unknown Source)
	at cz.deuss.companyservice.controller.CompaniesController.getCompanies(CompanyController.kt:37)
	at cz.deuss.companyservice.controller.$CompaniesController$Definition$Intercepted.$$access$$getCompanies(Unknown Source)
	at cz.deuss.companyservice.controller.$CompaniesController$Definition$Exec.dispatch(Unknown Source)
	at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invoke(AbstractExecutableMethodsDefinition.java:456)
	at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:134)
	at io.micronaut.validation.ValidatingInterceptor.validateReturnExecutableValidator(ValidatingInterceptor.java:166)
	at io.micronaut.validation.ValidatingInterceptor.intercept(ValidatingInterceptor.java:109)
	at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
	at cz.deuss.companyservice.controller.$CompaniesController$Definition$Intercepted.getCompanies(Unknown Source)
	at cz.deuss.companyservice.controller.$CompaniesController$Definition$Exec.dispatch(Unknown Source)
	at io.micronaut.context.AbstractExecutableMethodsDefinition$DispatchedExecutableMethod.invokeUnsafe(AbstractExecutableMethodsDefinition.java:461)
	at io.micronaut.context.DefaultBeanContext$BeanContextUnsafeExecutionHandle.invokeUnsafe(DefaultBeanContext.java:4354)
	at io.micronaut.web.router.AbstractRouteMatch.execute(AbstractRouteMatch.java:237)
	at io.micronaut.web.router.DefaultUriRouteMatch.execute(DefaultUriRouteMatch.java:38)
	at io.micronaut.http.server.RouteExecutor.executeRouteAndConvertBody(RouteExecutor.java:488)
	at io.micronaut.http.server.RouteExecutor.lambda$callRoute$5(RouteExecutor.java:465)
	at io.micronaut.core.execution.ExecutionFlow.lambda$async$1(ExecutionFlow.java:87)
	at io.micronaut.core.propagation.PropagatedContext.lambda$wrap$3(PropagatedContext.java:211)

Here used repository and function:

@Repository
interface CompanyRepository : JpaRepository<Company, UUID> {
    fun findId(pageable: Pageable): Page<UUID>
}

Company entity has UUID id, which looks like this:

@Entity
@Table(name = "company")
@Introspected
class Company(
....
) {
    @field:Id
    val id: UUID = UUID.randomUUID()
}

Am I something missing, or is this intended functionality?

[dstepanov]

How do you call it?

[MinionCZ]

I call it from service like this:

    @Transactional(readOnly = true)
    open fun getCompanies(page: Int, pageSize: Int): CompanyPagedResponse {
        logger.info { "Getting companies with page: $page, Page: $pageSize" }
        val pageable = Pageable.from(page, pageSize, DEFAULT_SORT)
        val pagedIds = companyRepository.findId(pageable)
        val result = companyRepository.findByIdIn(pagedIds.content)
        return companyMapper.toPagedResponse(result, pagedIds.pageNumber, pagedIds.totalSize)
    }