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

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: