Error when listing procedures in Redshift #52

jpachon commented 2024年07月10日 11:38:02 +02:00

When in the object tree explorer you select to view procedures of a specific schema, in addition to showing the procedures of that schema, it shows all the procedures of pg_catalog.

Reviewing the code I have detected what could be the problem, in the class: RedshiftUDFReader.java

@Override
 public DataStore getProcedures(String catalog, String schemaPattern, String procName)
 throws SQLException
 {
 DataStore jdbcResult = super.getProcedures(catalog, procName, procName);
 if (connection.getDbSettings().getBoolProperty("procedurereader.use.jdbc", true))
 {
 return jdbcResult;
 }

the code:

DataStore jdbcResult = super.getProcedures(catalog, procName, procName);

should be:

DataStore jdbcResult = super.getProcedures(catalog, schemaPattern, procName);

SqlWorkBench/J version: Build 131 (2024年05月05日 17:43)
Redshift JDBC Driver: redshift-jdbc42-2.1.0.29.jar

When in the object tree explorer you select to view procedures of a specific schema, in addition to showing the procedures of that schema, it shows all the procedures of _pg_catalog_. Reviewing the code I have detected what could be the problem, in the class: _RedshiftUDFReader.java_ ``` @Override public DataStore getProcedures(String catalog, String schemaPattern, String procName) throws SQLException { DataStore jdbcResult = super.getProcedures(catalog, procName, procName); if (connection.getDbSettings().getBoolProperty("procedurereader.use.jdbc", true)) { return jdbcResult; } ``` the code: ``` DataStore jdbcResult = super.getProcedures(catalog, procName, procName); ``` should be: ``` DataStore jdbcResult = super.getProcedures(catalog, schemaPattern, procName); ``` SqlWorkBench/J version: Build 131 (2024年05月05日 17:43) Redshift JDBC Driver: redshift-jdbc42-2.1.0.29.jar