Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0044612 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Openbravo ERP] Y. DBSourceManager | minor | always | 2020-07-15 07:37 | 2022-11-03 12:47 | |||||||
Reporter | guillermogil | 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 | 3.0PR20Q1.2 | SCM revision | ||||||||||
Review Assigned To | AugustoMauch | |||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0044612: ORA fails applying changes to columns used in functional indexes | |||||||||||
Description | When updating an Oracle database having changes in a column that participates in a functional index, Oracle fails and the change is not applied. This can occur by either a config script providing those changes or by a regular DB change. In case a template modifies an indexed column oracle fails on compilation: SQL Command failed with: ORA-30556: either functional or bitmap join index is defined on the column to be modified | |||||||||||
Steps To Reproduce | Case 1: regular change 1.1. modify src-db/database/model/tables/C_BPARTNER.xml to set NAME length to 120 1.2. run update.database ERROR: ORA-30556: functional index is defined on the column to be modified Case 2: config scrip 2.1 Modify on a template the column name of C_BPartner: <columnSizeChange tablename="C_BPARTNER" columnname="NAME" newSize="120" oldSize="60"/> 2.2. run update.database ERROR: ORA-30556 | |||||||||||
Proposed Solution | Oracle does not support modifying columns if the participate in functional indexes, we'll recreate the whole table instead. | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||||||||||||||||
|
Notes | |
(0121898) hgbot (developer) 2020-08-07 09:24 |
Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/13 [^] |
(0142871) hgbot (developer) 2022-11-03 12:40 |
Repository: https://gitlab.com/openbravo/product/dbsm [^] Changeset: b1d1eea508d36244e5a3cc428e3c0c256088e02b Author: Asier Lostalé <asier.lostale@openbravo.com> Date: 03-11-2022 11:24:30 URL: https://gitlab.com/openbravo/product/dbsm/-/commit/b1d1eea508d36244e5a3cc428e3c0c256088e02b [^] [create-db] related to BUG-44612: adds test case --- A src-test/model/configScripts/BASE_MODEL_FUNCT_IDX.xml M src-test/src/org/openbravo/dbsm/test/configscript/ConfigScriptColumnSizeChange.java --- |
(0142881) alostale (manager) 2022-11-03 12:47 |
Fix for 0044892 solves the config script case on install.source |
Issue History | |||
Date Modified | Username | Field | Change |
2020-07-15 07:37 | guillermogil | New Issue | |
2020-07-15 07:37 | guillermogil | Assigned To | => platform |
2020-07-15 07:37 | guillermogil | Modules | => Core |
2020-07-15 07:37 | guillermogil | Triggers an Emergency Pack | => No |
2020-07-15 07:40 | guillermogil | version | => 3.0PR20Q1.2 |
2020-07-17 16:29 | shuehner | Issue Monitored: shuehner | |
2020-08-07 09:24 | hgbot | Note Added: 0121898 | |
2020-08-07 12:18 | alostale | Summary | In case a template modifies an indexed column oracle fails => ORA fails applying changes to columns used in functional indexes |
2020-08-07 12:18 | alostale | Description Updated | View Revisions |
2020-08-07 12:18 | alostale | Steps to Reproduce Updated | View Revisions |
2020-08-07 12:18 | alostale | Proposed Solution updated | |
2020-08-17 12:32 | AugustoMauch | Assigned To | platform => AugustoMauch |
2020-08-17 12:34 | AugustoMauch | Assigned To | AugustoMauch => alostale |
2020-08-17 12:34 | AugustoMauch | Review Assigned To | => AugustoMauch |
2020-08-26 10:28 | caristu | Relationship added | related to 0044892 |
2020-08-26 11:43 | caristu | Relationship added | related to 0044896 |
2020-08-26 14:41 | shuehner | Relationship added | related to 0044901 |
2022-02-01 07:24 | alostale | Assigned To | alostale => Triage Platform Base |
2022-11-03 12:40 | hgbot | Note Added: 0142871 | |
2022-11-03 12:47 | alostale | Note Added: 0142881 |
Copyright © 2000 - 2009 MantisBT Group |