Derby
  1. Derby
  2. DERBY-2610

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: 10.2.2.0, 10.3.1.4
    • Fix Version/s: 10.3.1.4
    • Component/s: JDBC
    • Labels:
      None
    • Issue & fix info:
      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=?".

      1. DERBY-2610-1.diff
        40 kB
        Jørgen Løland
      2. DERBY-2610-1.stat
        0.8 kB
        Jørgen Løland
      3. releaseNote.html
        3 kB
        Jørgen Løland
      4. releaseNote.html
        3 kB
        Myrna van Lunteren

        Issue Links

          Activity

          Jørgen Løland created issue -
          Jørgen Løland made changes -
          Field Original Value New Value
          Assignee Jørgen Løland [ jorgenlo ]
          Jørgen Løland made changes -
          Attachment DERBY-2610-1.diff [ 12357024 ]
          Attachment DERBY-2610-1.stat [ 12357023 ]
          Jørgen Løland made changes -
          Derby Info [Patch Available]
          Jørgen Løland made changes -
          Link This issue depends on DERBY-1484 [ DERBY-1484 ]
          Kristian Waagan made changes -
          Derby Info [Patch Available]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Jørgen Løland made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Jørgen Løland made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Jørgen Løland made changes -
          Derby Info [Existing Application Impact]
          Jørgen Løland made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Myrna van Lunteren made changes -
          Attachment releaseNote.html [ 12358310 ]
          Myrna van Lunteren made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          A B made changes -
          Link This issue relates to DERBY-2758 [ DERBY-2758 ]
          Jørgen Løland made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Jørgen Løland made changes -
          Attachment releaseNote.html [ 12358935 ]
          Jørgen Løland made changes -
          Derby Info [Existing Application Impact] [Existing Application Impact, Release Note Needed]
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Existing Application Impact, Release Note Needed] [Release Note Needed]
          Gavin made changes -
          Link This issue depends on DERBY-1484 [ DERBY-1484 ]
          Gavin made changes -
          Link This issue depends upon DERBY-1484 [ DERBY-1484 ]
          Gavin made changes -
          Workflow jira [ 12403282 ] Default workflow, editable Closed status [ 12802252 ]

            People

            • Assignee:
              Jørgen Løland
              Reporter:
              Jørgen Løland
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development