Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-655

getImportedKeys returns duplicate rows in some cases

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: 10.2.1.6
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Sun JDK 1.4.2, Windows XP

      Description

      I have a database with a large number of tables. I get duplicate rows when I call DatabaseMetaData.getImportedKeys for a particular table. However, if I create the same table with same number of foreign keys in another database (which has fewer number of tables), then getImportedKeys returns me the correct number of rows. This error seems to happen only when the database has a large number of tables. I will attach a repro for this shortly.

        Attachments

        1. bigdb.sql
          454 kB
          Deepa
        2. keys.java
          2 kB
          Deepa
        3. smalldb.sql
          2 kB
          Deepa
        4. keys_test.zip
          1.39 MB
          Deepa
        5. Derby655GetImportedKeysPatch1.txt
          4 kB
          Mamta A. Satoor
        6. Derby655GetImportedKeysStat1.txt
          0.3 kB
          Mamta A. Satoor
        7. Derby655GetImportedKeysPatch1Codeline101.txt
          5 kB
          Mamta A. Satoor
        8. Derby655GetImportedKeysPatch2Codeline101.txt
          9 kB
          Mamta A. Satoor
        9. Derby655GetImportedKeysPatch1CodelineTrunk.txt
          9 kB
          Mamta A. Satoor
        10. Derby655GetImportedKeysPatch1CodelineTrunkUpgradeTest.txt
          3 kB
          Mamta A. Satoor

          Issue Links

            Activity

              People

              • Assignee:
                mamtas Mamta A. Satoor
                Reporter:
                deepa Deepa
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: