Bug #3279 getImportedKeys
Submitted: 24 Mar 2004 2:30 Modified: 24 Mar 2004 6:35
Reporter: Simon Greenaway Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:3.1.1 or 3.0.9 OS:Solaris (Solaris 2.8)
Assigned to: Mark Matthews CPU Architecture:Any

[24 Mar 2004 2:30] Simon Greenaway 
Description:
'.getImportedKeys(...)' will not return foreign keys when accessing Mysql 4.1.1, just an empty result set. Seems to work ok with 4.0.x. Fails on all tables tried.

Mysql:

./mysql  Ver 14.3 Distrib 4.1.1-alpha, for sun-solaris2.8 (sparc)

Java:

1.4.2 Windows.
1.5.0 Beta Windows.

Jconnect:

3.1.1
3.0.9

How to repeat:
ResultSet fkrs=Sql.getDatabaseMetaData().getImportedKeys(database, null,table);
        
while(fkrs.next())
{
    for(Field f:fields)
    {
        System.out.println(fkrs.getString(8));
    }
}
[24 Mar 2004 6:35] Mark Matthews 
This code is exercised daily by both the JDBC conformance testsuite and by our own unit and regression tests, and it works as expected.

Your bug report does not include enough information to repeat this for your situation. Can you please provide a repeatable testcase, including all schemas and Java code?