JDBC: return all catalogs when catalogs name is skipped, like jdbc:presto://<host>:8080/

[WIgor]

Hi

In case of usage jdbc url without setting a catalogs name and calling DatabaseMetadata.getCatalogs()
it throws an exception "Catalog default does not exist".

Because in constructor of PrestoConnection you set such default values:
catalog.set("default");
schema.set("default");

I would propose to make special processing of such default case and return all catalogs, and same for getSchemas and others metadatas functions.

What do you think about such changes?

[electrum]

The "default" stuff is old and needs to be removed. I think the right approach is to make catalog and schema optional in StatementResource, allowing running queries like "SHOW CATALOGS" or fully qualified queries.

[OmerJog]

Was this resolved?