ClassCastException when Hibernate tries to create a list of UUIDs for query since Quarkus 3.7.1

[b-thiswatch]

Describe the bug

With quarkus-hibernate-orm-panache-kotlin we have Countries and Cities with @ManyToOne and @OneToMany relation and discovered that when we call CitiyEntity.listAll(), it crashes with java.lang.IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState which is created by a ClassCastException when Hibernate tries to retrieve all Countries with a FROM-Query on Countries by using where in and converting a list of UUIDs.

wrapped[ select ce1_0.id,ce1_0.iso,ce1_0.iso3,ce1_0.name,ce1_0.nice_name,ce1_0.num_code,ce1_0.phone_code from country ce1_0 where ce1_0.id = any (?) ]

@Override
			protected void doBind(PreparedStatement st, X value, int index, WrapperOptions options) throws SQLException {
				st.setBytes( index, javaType.unwrap( value, byte[].class, options ) );
			}

When using the debugger and "Evaluate Expression" to run CityEntity.listAll() multiple times, it works after the first time.

Expected behavior

No response

Actual behavior

No response

How to Reproduce?

No response

Output of uname -a or ver

No response

Output of java -version

21

Quarkus version or git rev

3.7.1

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

mvnw

Additional information

No response

[quarkus-bot]

/cc @gsmet (hibernate-orm), @yrodiere (hibernate-orm)

[yrodiere]

Hey @b-thiswatch , thanks for reporting.

Can you please provide a reproducer?

Even better would be reproducing with the plain Hibernate ORM test case templates without Quarkus and reporting directly to the ORM project (mentioning this Quarkus issue in the description), because this really doesn't look like a bug in Quarkus, but rather in Hibernate ORM.

[b-thiswatch]

Hi @yrodiere ,

when updating Quarkus to 3.7.3 the Exception became clearer and trying to build a reproducer, I realised we ran into vladmihalcea/hypersistence-utils#698

We also updated to using the new native PostgresqlEnums...

Thanks for looking into this

[gsmet]

Nice, thanks for the feedback!

[yrodiere]

Thanks for the update!