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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0047694
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2021-09-14 19:022021-10-07 12:34
ReporterrbianchiniView Statuspublic 
Assigned Toplatform 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0047694: ERROR with materialed views

DescriptionERROR with materialized views, when an update.database is performed
Steps To Reproduce1)Create a Materialized View in PgAdmin
2)Do a REFRESH MATERIALIZED in PgAdmin
3)Do a Select count in PgAdmin
4)Go to the terminal and do an export.database
5)Verify that they have been exported correctly
6)Do an update.database
7)Select the view to verify if it has data ( RESULT: it has not data).
8)Do steps 2 and 3 again
9)Do step 6 again
10)Select the view to verify if it has data ( RESULT: it has not data).
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 00420423.0PR20Q1 closedAugustoMauch Add support of materialized views 

-  Notes
(0131792)
rbianchini (developer)
2021-09-14 19:03

Here is the link to the video that reproduces the error:
https://drive.google.com/drive/u/0/folders/1KtZDFpPEODg_peyiHoBezUk3hNYEQMc2 [^]
(0132089)
hgbot (developer)
2021-09-30 18:55

Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/31 [^]
(0132142)
lbressan (developer)
2021-10-04 14:11

any update?
(0132238)
hgbot (developer)
2021-10-07 10:15

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/438 [^]
(0132250)
hgbot (developer)
2021-10-07 12:28

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/438 [^]
(0132251)
hgbot (developer)
2021-10-07 12:34

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 2b19852e5d4a77c01adff341e274e0ae035860e7
Author: Augusto Mauch <augusto.mauch@openbravo.com>
Date: 2021-10-07T12:31:37+02:00
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/2b19852e5d4a77c01adff341e274e0ae035860e7 [^]

Fixes ISSUE-47694: Materialized views are needlessly recreated on update.database

Now a materialized view will only be recreated if:

Its definition has changed
Depends on any view
Depends on any other materialized view
Depends on a function that will be deleted/recreated
Depends on a table that is going to be updated on the current update.database run

---
A src-test/model/materializedViews/BASE_MODEL_UPDATED_BASE_TABLE.xml
A src-test/model/materializedViews/BASE_MODEL_UPDATED_MATERIALIZED_VIEW.xml
A src-test/model/materializedViews/BASE_MODEL_WITH_FUNCTION_DEPENDENCY.xml
A src-test/model/materializedViews/BASE_MODEL_WITH_FUNCTION_DEPENDENCY_2.xml
A src-test/model/materializedViews/BASE_MODEL_WITH_FUNCTION_DEPENDENCY_UPDATED.xml
A src-test/model/materializedViews/BASE_MODEL_WITH_MATERIALIZED_VIEW_DEPENDENCY.xml
A src-test/model/materializedViews/BASE_MODEL_WITH_VIEW_DEPENDENCY.xml
A src-test/src/org/openbravo/dbsm/test/model/recreation/MaterializedView.java
A src/org/apache/ddlutils/alteration/RemoveMaterializedViewChange.java
M src-test/model/materializedViews/DEPENDENCY.xml
M src-test/src/org/openbravo/dbsm/test/model/MaterializedViews.java
M src-test/src/org/openbravo/dbsm/test/model/ModelSuite.java
M src/org/apache/ddlutils/alteration/ModelComparator.java
M src/org/apache/ddlutils/model/MaterializedView.java
M src/org/apache/ddlutils/platform/ModelLoaderBase.java
M src/org/apache/ddlutils/platform/SqlBuilder.java
M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---
(0132252)
hgbot (developer)
2021-10-07 12:34

Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/31 [^]

- Issue History
Date Modified Username Field Change
2021-09-14 19:02 rbianchini New Issue
2021-09-14 19:02 rbianchini Assigned To => platform
2021-09-14 19:02 rbianchini Modules => Core
2021-09-14 19:02 rbianchini Regression date => 2021-09-30
2021-09-14 19:02 rbianchini Triggers an Emergency Pack => No
2021-09-14 19:03 rbianchini Note Added: 0131792
2021-09-17 08:30 ivancaceres Issue Monitored: ivancaceres
2021-09-20 13:04 cberner Regression date 2021-09-30 =>
2021-09-21 14:31 alostale Relationship added related to 0042042
2021-09-30 18:55 hgbot Note Added: 0132089
2021-10-04 14:11 lbressan Note Added: 0132142
2021-10-07 10:15 hgbot Note Added: 0132238
2021-10-07 12:28 hgbot Note Added: 0132250
2021-10-07 12:34 hgbot Resolution open => fixed
2021-10-07 12:34 hgbot Status new => closed
2021-10-07 12:34 hgbot Note Added: 0132251
2021-10-07 12:34 hgbot Note Added: 0132252


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker