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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0044612
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminoralways2020-07-15 07:372022-11-03 12:47
ReporterguillermogilView Statuspublic 
Assigned ToTriage Platform Base 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version3.0PR20Q1.2SCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0044612: ORA fails applying changes to columns used in functional indexes

DescriptionWhen 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 ReproduceCase 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 SolutionOracle does not support modifying columns if the participate in functional indexes, we'll recreate the whole table instead.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0044892 closedalostale On install.source config scripts are applied in two steps 
related to feature request 0044896 newTriage Platform Base Add check for dangerous operations in update.database task 
related to defect 0044901 closedTriage Platform Base PostgreSQL fails applying changes to columns used in views (during install.source) 

-  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
Powered by Mantis Bugtracker