[jboss-jira] [JBoss JIRA] Reopened: (JBAS-2629) Double index creation for alterTable

[Jesper Pedersen (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBAS-2629?page=all ]

Jesper Pedersen reopened JBAS-2629:
-----------------------------------

             
Reopened to provide a more fail-safe patch

> Double index creation for alterTable
> ------------------------------------
>
>                 Key: JBAS-2629
>                 URL: http://jira.jboss.com/jira/browse/JBAS-2629
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: CMP service
>    Affects Versions: JBossAS-4.0.3 SP1
>         Environment: SuSE 10.0 with JDK-1.5.0_06
>            Reporter: Jesper Pedersen
>         Assigned To: Alexey Loubyansky
>             Fix For: JBossAS-3.2.8 Final, JBossAS-4.0.4.CR2
>
>         Attachments: jdbcstartcommand.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira