ReactiveDeferredResultSetAccess use ResultSetAccess interface default resolveType impl will cause NPE

[paomian]

I'm using quarkus 3.9.3 with hibernate reactive. database is pg.
When I call createNativeQuery and the query table result contains field which type is json will cause NPE.
The reason I conducted a brief survey was

https://github.com/hibernate/hibernate-orm/blob/aae9b1e55d865d215070ee7d74ecc49593f83f4f/hibernate-core/src/main/java/org/hibernate/sql/results/jdbc/internal/ResultSetAccess.java#L78-L99

columnTypeName is from this method. it must be null.

hibernate-reactive/hibernate-reactive-core/src/main/java/org/hibernate/reactive/adaptor/impl/ResultSetAdaptor.java

Lines 1352 to 1356 in a8e757f

	public String getColumnTypeName(int column) {
	// This information is in rows.columnDescriptors().get( column-1 ).dataType.name
	// but does not appear to be accessible.
	return null;
	}

and then call resolveSqlTypeDescriptor in PostgreSQLDialect. when jdbcTypeCode is OTHER it will cause NPE because columnTypeName is null
https://github.com/hibernate/hibernate-orm/blob/aae9b1e55d865d215070ee7d74ecc49593f83f4f/hibernate-core/src/main/java/org/hibernate/dialect/PostgreSQLDialect.java#L308-L337

[DavideD]

This issue has been solved as part of #1915