Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0034258 | Openbravo ERP | Y. DBSourceManager | public | 2016-10-20 18:59 | 2022-02-01 08:09 |
|
| Reporter | caristu | |
| Assigned To | Triage Platform Base | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| 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.
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | feature request | 0030525 | | closed | AugustoMauch | Provide support in DBSourceManager to define an operator class in index columns | | related to | feature request | 0032211 | | closed | caristu | support for partial indexes |
|
| Attached Files |  indexesIssue34258.diff (739) 2016-10-20 19:02
https://issues.openbravo.com/file_download.php?file_id=9935&type=bug |
|
| 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 | bug_revision_view_page.php?rev_id=13433#r13433 |
| 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 | bug_revision_view_page.php?rev_id=13435#r13435 |
| 2016-12-01 13:09 | alostale | Type | defect => design defect |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |