Panache projection handles primitive type incorrectly

[joachimglink]

Describe the bug

I have a POJO with a constructor of some fields (some are objects like a String, others are primitive types like boolean or short).
If I do a "select new MyPojo(...)" query, it works fine and the POJO is created as expected.

But when using the #project(..) method from PanacheQuery, I get an error for a missing constructor. Only if I change the constructor of the POJO to have no primitive types but the object types (long->Long, boolean->Boolean) this works again.

Expected behavior

The Panache projection should also work with primitive types.

Actual behavior

No response

How to Reproduce?

Working:
((Session) MyEntity.getEntityManager()).createQuery("select new MyPojo(attribString, attribBoolean) from MY_ENTITY).list();

Not working:
MyEntity.find(select attribString, attribBoolean) from MY_ENTITY).project(MyPojo.class).list()

Output of uname -a or ver

No response

Output of java -version

21

Quarkus version or git rev

3.14.4

Build tool (ie. output of mvnw --version or gradlew --version)

mvn

Additional information

No response

[quarkus-bot]

/cc @FroMage (panache), @loicmathieu (panache)

[yrodiere]

I believe the limitation is in Hibernate ORM; created an improvement request there: https://hibernate.atlassian.net/browse/HHH-18664

[joachimglink]

@yrodiere why should it be a Hibernate limitation when the default Hibernate / JPA projection with "select new xxx(..)" is working just fine?

[yrodiere]

Because Panache is also relying on Hibernate ORM for .project(), only a different feature:

quarkus/extensions/panache/hibernate-orm-panache-common/runtime/src/main/java/io/quarkus/hibernate/orm/panache/common/runtime/CommonPanacheQueryImpl.java

Lines 107 to 111 in 55b1565

	// If the query starts with a select clause, we pass it on to ORM which can handle that via a projection type
	if (lowerCasedTrimmedQuery.startsWith("select ")) {
	// just pass it through
	return new CommonPanacheQueryImpl<>(this, query, countQuery, type);
	}

quarkus/extensions/panache/hibernate-orm-panache-common/runtime/src/main/java/io/quarkus/hibernate/orm/panache/common/runtime/CommonPanacheQueryImpl.java

Line 387 in 55b1565

hibernateQuery = session.createSelectionQuery(orderBy != null ? query + orderBy : query, projectionType);