Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-2629

Double index creation for alterTable

XMLWordPrintable

      In JDBCStartCommand::hasIndex() the variable idxAscDesc may be null, since null is a valid result value for ASC_OR_DESC in DatabaseMetaData.

      This leads to returning false for hasIndex() and therefore creating an index on the column - which already may have one (after first deployment).

      Also the implementation currently looks at ascending columns.

      If someone shares their ideas on this matter I can cook up a patch.

        1. jdbcstartcommand.patch
          0.9 kB
          Jesper Pedersen
        2. jdbcstartcommand.patch
          5 kB
          Jesper Pedersen

              olubyans@redhat.com Alexey Loubyansky
              jpederse@redhat.com Jesper Pedersen
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: