Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0034258
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] Y. DBSourceManagerminoralways2016-10-20 18:592022-02-01 08:09
ReportercaristuView Statuspublic 
Assigned ToTriage Platform Base 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034258: Not possible to apply two indexes on the same column but with different operator class in Oracle

DescriptionIs not possible to apply two indexes on the same column but with different operator class in Oracle. This model definition is valid in PostgreSQL but currently not possible to apply in Oracle.

Oracle does not allow to have more that one index defined for a particular set of columns, and as the operator class definition is not taken into account in Oracle, eventually two indexes for the same column, one with operator class and the other one without it, are considered the same in Oracle.
Steps To Reproduce1) In an Oracle based environment, apply the attached patch which contains two index definitions. They both apply to the same column, but one of them make use of an operator class.

2) Run ant update.database -Dforce=yes. The following error is thrown by the task and it does not end correctly:

[java] 263567 WARN - SQL Command failed with: ORA-01408: such column list already indexed
     [java]
     [java] 263583 WARN - -- END
     [java] CREATE INDEX A_AMORTIZATION_UPPER_OPC ON A_AMORTIZATION (NAME)
     [java] 281824 INFO - Executed 604 SQL command(s) with 1 error(s)


3) Repeat steps 1) and 2) in a PostgreSQL based environment. Both indexes are created properly.

TagsNo tags attached.
Attached Filesdiff file icon indexesIssue34258.diff [^] (739 bytes) 2016-10-20 19:02 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0030525 closedAugustoMauch Provide support in DBSourceManager to define an operator class in index columns 
related to feature request 0032211 closedcaristu support for partial indexes 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2016-10-20 18:59 caristu New Issue
2016-10-20 18:59 caristu Assigned To => platform
2016-10-20 18:59 caristu Modules => Core
2016-10-20 18:59 caristu Triggers an Emergency Pack => No
2016-10-20 19:00 caristu Steps to Reproduce Updated View Revisions
2016-10-20 19:00 caristu Issue Monitored: networkb
2016-10-20 19:00 caristu Issue End Monitor: networkb
2016-10-20 19:00 caristu Relationship added related to 0030525
2016-10-20 19:01 caristu Relationship added related to 0032211
2016-10-20 19:02 caristu File Added: indexesIssue34258.diff
2016-10-20 19:09 caristu Description Updated View Revisions
2016-12-01 13:09 alostale Type defect => design defect
2022-02-01 08:09 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker