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

Queries in metadata.properties allow tablepattern for JDBC methods that do not allow patterns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 10.2.2.0, 10.3.1.4
    • 10.3.1.4
    • JDBC
    • None
    • Release Note Needed

    Description

      The DatabaseMetaData methods getBestRowIdentifier, getColumnPrivileges, getIndexInfo, getVersionColumns, getPrimaryKeys, getImportedKeys, getExportedKeys do not allow table name patterns. However, the SQL in metadata.properties implement these with "table like ?", thus allowing patterns. The SQL for these methods should be modified to "table=?".

      Attachments

        1. releaseNote.html
          3 kB
          Myrna van Lunteren
        2. releaseNote.html
          3 kB
          Jorgen Loland
        3. DERBY-2610-1.stat
          0.8 kB
          Jorgen Loland
        4. DERBY-2610-1.diff
          40 kB
          Jorgen Loland

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. DERBY-1484 Client and embedded behave differently when the table name is null in DatabaseMetaData methods

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2758 ODBC metadata function "SQLForeignKeys" returns different results in 10.3.

          • Major - Major loss of function.
          • Closed

          Activity

            People

              jorgenlo Jorgen Loland
              jorgenlo Jorgen Loland
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: