Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0034258 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] Y. DBSourceManager | minor | always | 2016-10-20 18:59 | 2022-02-01 08:09 | |||||||
| Reporter | caristu | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Oracle | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0034258: Not possible to apply two indexes on the same column but with different operator class in Oracle | |||||||||||
| Description | Is 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 Reproduce | 1) 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  indexesIssue34258.diff [^] (739 bytes) 2016-10-20 19:02 [Show Content]
| |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |