Bug #9769 Passing in NULL procedureNamePattern to getProcedures() causes error

Description:
We have been using this API call, getProcedures(), for many versions.  We have always been passing in NULL for the procedureNamePattern if we want it to match all patterns.  However using this method in version 3-17 causes the following error:

java.sql.SQLException: Procedure name pattern can not be NULL or empty.
 at com.mysql.jdbc.DatabaseMetaData.getProcedures(DatabaseMetaData.java:2740)
 at util.TestJDBCandJNDI.listStorProc(TestData.java:242)
 at util.TestData.main(TestData.java:23)

I looked through the changelog and was not able to see any reference to getProcedures() having been changed from 3-16 to 3-17.

Thanks

How to repeat:
Call getProcedures() and pass in a NULL Procedure name pattern.

Suggested fix:
Either document or rollback the change to the original behaviour - that NULL matches all cases.

Thanks

Accepting NULL is not JDBC compliant (and was therefore a bug). Since the behavior is undefined by the JDBC spec (or the SQL spec), this is not a bug. You will need to use "%" if you want to match _all_ procedures, just as the JDBC specification states.

Fixed for  3.1.8.

Should accept null for name pattern parameters in DBMD (meaning "%"), 
	  even though it isn't JDBC compliant, for legacy's sake. Disable by setting
	  connection property "nullNamePatternMatchesAll" to "false" (which will be 
	  the default value in C/J 3.2.x).