Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042042Openbravo ERPY. DBSourceManagerpublic2019-10-16 16:422021-09-21 14:35
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR20Q1Fixed in Version3.0PR20Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042042: Add support of materialized views
DescriptionThe Reporting project requires that dbsourcemanager is able to support the use of materialized views.

Wiki: http://wiki.openbravo.com/wiki/Projects:Support_Partial_Indexes [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0042089 closed AugustoMauch Make ExportDatabase and CreateDatabase extensible so that they can be reused for the reporting project 
related to defect 0047694 closed platform ERROR with materialed views 
related to defect 0043527pi closed alostale Dbsourcemanager MaterializedView support: if MV depends on other MV order of execution can be wrong 
has duplicate feature request 0031459 closed platform dbsource manager should support Materialized Views 
causes defect 0042450 closed AugustoMauch Error during create.database with Postgresql11,12 and 13 with user_tab_columns view 
causes defect 0042477 closed alostale Log is too verbose in Oracle when exporting the database 
causes defect 0047414 closed alostale ant package.module -Dmodule not working in Oracle 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-10-16 16:42AugustoMauchNew Issue
2019-10-16 16:42AugustoMauchAssigned To => AugustoMauch
2019-10-16 16:42AugustoMauchModules => Core
2019-10-16 16:42AugustoMauchTriggers an Emergency Pack => No
2019-11-27 22:40hgbotCheckin
2019-11-27 22:40hgbotNote Added: 0115917
2019-11-27 22:40hgbotStatusnew => resolved
2019-11-27 22:40hgbotResolutionopen => fixed
2019-11-27 22:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e7f2c0e1b428e98ce4aaa8cb1563fd705f37edb0 [^]
2019-11-29 09:50alostaleReview Assigned To => alostale
2019-11-29 09:50alostaleNote Added: 0115976
2019-11-29 09:50alostaleStatusresolved => closed
2019-11-29 09:50alostaleFixed in Version => 3.0PR20Q1
2019-11-29 13:00alostaleRelationship addedcauses 0042450
2019-12-05 07:54alostaleRelationship addedrelated to 0042089
2019-12-05 07:55alostaleRelationship addedcauses 0042477
2019-12-12 23:01hudsonbotCheckin
2019-12-12 23:01hudsonbotNote Added: 0116290
2021-07-21 08:50alostaleRelationship addedrelated to 0047414
2021-07-21 11:21alostaleRelationship replacedcauses 0047414
2021-09-21 14:28alostaleRelationship addedhas duplicate 0031459
2021-09-21 14:31alostaleRelationship addedrelated to 0047694
2021-09-21 14:35alostaleRelationship addedrelated to 0043527

Notes
(0115917)
hgbot   
2019-11-27 22:40   
Repository: erp/devel/pi
Changeset: e7f2c0e1b428e98ce4aaa8cb1563fd705f37edb0
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Nov 27 22:40:08 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e7f2c0e1b428e98ce4aaa8cb1563fd705f37edb0 [^]

Fixes issue 42042: Adds support for materialized views

Dbsourcemanager supports now the definition of materialized views.

For more information check out the wiki entry:
http://wiki.openbravo.com/wiki/Projects:Support_Materialized_Views_In_DBSourceManager [^]

---
M src-db/database/build-create.xml
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/prescript-Oracle.sql
M src-db/database/model/prescript-PostgreSql.sql
M src/org/openbravo/service/system/DatabaseValidator.java
M src/org/openbravo/service/system/SystemService.java
M src/org/openbravo/service/system/SystemValidator.java
---
(0115976)
alostale   
2019-11-29 09:50   
Reviewed and tested, see https://gitlab.com/openbravocode/product/dbsm/merge_requests/2 [^]
(0116290)
hudsonbot   
2019-12-12 23:01   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/954d2b7a66fb [^]
Maturity status: Test