OracleDialect - NUMBER type mapping issues

Hello all - my first post here :wink:

I’m currently migrating some apps from 5 to 6.1 version (spring boot 3).

In addition to previously mentioned issues, there are few others (when using NativeQuery).

For example, it seems that 6.1.7 is incorrectly mapping number(5,0) to java Short (which max value is only 32767).

This seems to be fixed in 6.2 branch, but when I was giving it a try I have discovered that numbers for which precision is not known (for example count(*) where precision is 0) are now reported as Integer instead of BigDecimal, which may not always be correct (and is a breaking change).

Best Regards

Please create a JIRA issue for these problems, ideally with a reproducer and we will look into it.