Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0056135Openbravo ERPA. Platformpublic2024-07-31 12:462025-03-27 12:10
ablasco 
ablasco 
normalmajorhave not tried
closedduplicate 
5
 
 
approved
No
Core
No
0056135: DBSM Tests to ensure pg16 is supported
Some dbsm Tests are failing due exported models in views.

- MaterializedView -
- RemoveMaterializedViewChange.
- exported contents expected:<[<view name="TEST_VIEW"><![CDATA[SELECT COALESCE(t.col2, '-') AS c FROM test t WHERE (t.col1 IN ('A', 'B')) OR (t.col2 IN ('C', 'D'))]]></view>]>

but was:<[<view name="TEST_VIEW"><![CDATA[SELECT COALESCE(col2, '-') AS c FROM test t WHERE (col1 IN ('A', 'B')) OR (col2 IN ('C', 'D'))]]></view>]>

Alias t removed on pg16 update.


Configure an environment with postgres 16.
Configure dbsm to execute the tests.

Execute in dbsm.

ant run.tests
Skip the tests which are failing with postgres 16
No tags attached.
Issue History
2024-07-31 12:46ablascoNew Issue
2024-07-31 12:46ablascoAssigned To => ablasco
2024-07-31 12:46ablascoOBNetwork customer => No
2024-07-31 12:46ablascoModules => Core
2024-07-31 12:46ablascoTriggers an Emergency Pack => No
2024-07-31 12:55hgbotMerge Request Status => open
2024-07-31 12:55hgbotNote Added: 0167528
2024-08-06 12:34hgbotNote Added: 0167748
2024-08-06 12:50AugustoMauchStatusnew => scheduled
2024-09-21 10:58hgbotMerge Request Statusopen => approved
2024-09-21 10:58hgbotNote Added: 0169447
2024-09-21 10:58hgbotNote Added: 0169448
2025-03-27 12:10hgbotNote Added: 0177484
2025-03-27 12:10hgbotStatusscheduled => closed
2025-03-27 12:10hgbotResolutionopen => duplicate

Notes
(0167528)
hgbot   
2024-07-31 12:55   
Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/48 [^]
(0167748)
hgbot   
2024-08-06 12:34   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1641 [^]
(0169447)
hgbot   
2024-09-21 10:58   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: b284d42cd32fc9a2a255d90d81fb0f23c7ac0b5b
Author: Augusto Mauch <augusto.mauch@openbravo.com>
Date: 21-09-2024 08:58:26
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/b284d42cd32fc9a2a255d90d81fb0f23c7ac0b5b [^]

Related to ISSUE-56135: Make sure warehouse order is deterministic by sorting by priority, id

---
M src/org/openbravo/retail/posterminal/term/Warehouses.java
---
(0169448)
hgbot   
2024-09-21 10:58   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1641 [^]
(0177484)
hgbot   
2025-03-27 12:10   
Issue exported to Jira: https://openbravo.atlassian.net/browse/RM-24217 [^]