[jboss-jira] [JBoss JIRA] Closed: (JBAS-2629) Double index creation for alterTable
Alexey Loubyansky (JIRA)
jira-events at lists.jboss.org
Tue Apr 17 05:42:30 EDT 2007
[ http://jira.jboss.com/jira/browse/JBAS-2629?page=all ]
Alexey Loubyansky closed JBAS-2629.
-----------------------------------
Resolution: Done
Please, don't re-open issues resolved for already released versions. It's better to open a new one.
> 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-4.0.4.CR2, JBossAS-3.2.8 Final
>
> Attachments: jdbcstartcommand.patch, 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
More information about the jboss-jira
mailing list