JDBC: Updating to pgjdbc 42.7.5 blocked

[amotl]

Problem

pgjdbc 42.7.5 does not work well together with CrateDB, some of the qa tests started failing on it.

• Bump org.postgresql:postgresql from 42.7.4 to 42.7.5 in /by-language/java-qa cratedb-examples#804
• JDBC: Update to pgjdbc 42.7.5 crate-qa#333

Downstream

• Build(deps): Bump org.postgresql:postgresql from 42.7.3 to 42.7.5 cratedb-flink-jobs#56
• Bump org.postgresql:postgresql from 42.7.4 to 42.7.5 in /modules/cratedb testcontainers/testcontainers-java#9835

[amotl]

@mackerl also reported this recently. Thank you!

The PostgreSQL driver seems to have added changes to getColumn, getTables, etc. CrateDB seems to return an empty resultSet on many occasions which makes our application unusable.

I nailed it down to commit pgjdbc/pgjdbc@17cac52 "Fix PgDatabaseMetaData implementation of catalog as param and return value".

[amotl]

@kneth staged reports and patches to crate/crate and pgjdbc/pgjdbc. Thanks!

• Column name for scalar function call should be the function name, not the evaluated literal (JDBC compat issue) crate#17393
• Improve compatibility with non-Postgres databases pgjdbc/pgjdbc#3527
• Set column name explicitely when using current_database() in queries pgjdbc/pgjdbc#3526