Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0056135Openbravo ERPA. Platformpublic2024-07-31 12:462024-09-21 10:58
ablasco 
ablasco 
normalmajorhave not tried
scheduledopen 
5
 
 
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:46ablascoModules => Core
2024-07-31 12:46ablascoTriggers an Emergency Pack => No
2024-07-31 12:55hgbotNote Added: 0167528
2024-08-06 12:34hgbotNote Added: 0167748
2024-08-06 12:50AugustoMauchStatusnew => scheduled
2024-09-21 10:58hgbotNote Added: 0169447
2024-09-21 10:58hgbotNote Added: 0169448

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 [^]