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

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, 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.