[jboss-jira] [JBoss JIRA] Closed: (JBAS-2629) Double index creation for alterTable
[ 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