Bug #51022 conn.getMetaData().getProcedures returns all SP's regardless of catalog

Description:
this.rs = conn1.getMetaData().getProcedures(conn1.getCatalog(),null,"%");
this.rs = conn1.getMetaData().getProcedures("test",null,"%");
this.rs = conn1.getMetaData().getProcedures("jshop",null,"%");

all return same data:
jshop, proctree
jshop, proctree1
test, b51013

General query log shows wildcard in schema fields:
WHERE ROUTINE_SCHEMA LIKE '%' AND ROUTINE_NAME LIKE '%'

How to repeat:
See Bug#51013 and Bug#49578. This was previously reported in Bug#7026.

Suggested fix:
-

Workaround would be to have different names for SP's in different databases and to use SP name filter.

This might need a bit more checking from the server side before any fixes are made.

Patch committed as rev 898.

=== modified file 'src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java'
--- src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java     2010-01-28 23:59
:15 +0000
+++ src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java     2010-02-10 16:11
:07 +0000
@@ -978,6 +978,8 @@
                        if (this.conn.getNullCatalogMeansCurrent()) {
                                db = this.database;
                        }
+               }  else {
+                       db = catalog;
                }

An entry has been added to the 5.1.12 changelog:

The catalog parameter was ignored in the DatabaseMetaData.getProcedure() method. It returned all procedures in all databases.