=== modified file 'CHANGES' --- CHANGES 2009-01-23 18:21:18 +0000 +++ CHANGES 2009-03-17 09:47:33 +0000 @@ -11,6 +11,9 @@ - Fixed Bug #42309 - Statement.getGeneratedKeys() returns 2 keys when using ON DUPLICATE KEY UPDATE + - Fixed Bug #43714 - useInformationSchema with + DatabaseMetaData.getExportedKeys() throws exception + 10-22-08 - Version 5.1.7 - Fixed BUG#33861 - Added global blacklist for LoadBalancingConnectionProxy and implemented in RandomBalanceStrategy and BestResponseTimeBalanceStrategy. === modified file 'src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java' --- src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java 2008-11-11 06:19:59 +0000 +++ src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java 2009-03-17 09:39:08 +0000 @@ -572,7 +572,7 @@ + "(SELECT CONSTRAINT_NAME FROM" + " INFORMATION_SCHEMA.TABLE_CONSTRAINTS" + " WHERE TABLE_SCHEMA = REFERENCED_TABLE_SCHEMA AND" - + " TABLE_NAME = REFERENCED_TABLE_NAME AND" + + " TABLE_NAME = A.REFERENCED_TABLE_NAME AND" + " CONSTRAINT_TYPE IN ('UNIQUE','PRIMARY KEY') LIMIT 1)" + " AS PK_NAME," + importedKeyNotDeferrable === modified file 'src/testsuite/regression/MetaDataRegressionTest.java' --- src/testsuite/regression/MetaDataRegressionTest.java 2008-10-20 22:29:45 +0000 +++ src/testsuite/regression/MetaDataRegressionTest.java 2009-03-17 10:14:35 +0000 @@ -2268,4 +2268,21 @@ closeMemberJDBCResources(); } } + + /** + * Bug #43714 - useInformationSchema with DatabaseMetaData.getExportedKeys() throws exception + */ + public void testBug43714() throws Exception { + Connection c_IS = null; + try { + c_IS = getConnectionWithProps("useInformationSchema=true"); + DatabaseMetaData dbmd = c_IS.getMetaData(); + rs = dbmd.getExportedKeys("x", "y", "z"); + } finally { + try { + c_IS.close(); + } catch (SQLException ex) {} + closeMemberJDBCResources(); + } + } }