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.

            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: