Sean Mills opened SPR-15333 and commented

After upgrading to the latest Postgresql JDBC driver (42.0.0), I ran into a bug while processing call meta data. The meta data ResultSet returns a short type for the 'NULLABLE' column. However, the org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(...) method uses the getBoolean() method. I originally thought this was a problem with the latest Postgresql JDBC driver, but in reviewing the JavaDoc, the getBoolean() method doesn't describe how to handle anything other than NULL, 0, or 1. Since the 'NULLABLE' column can return 2, meaning unknown, the code should change to process the ResultSet with the explicitly defined type.

Affects: 4.3.6

Issue Links:

• Spring JDBC not correctly processing Postgresql ?| and ?& operator [SPR-15382] #19945 Spring JDBC not correctly processing Postgresql ?| and ?& operator

Referenced from: commits cfd9b34, 79ea779