Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0056135

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] A. Platform

major

have not tried

2024-07-31 12:46

2024-09-21 10:58

Reporter

ablasco

View Status

public

Assigned To

ablasco

Priority

normal

Resolution

open

Fixed in Version

Status

scheduled

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0056135: DBSM Tests to ensure pg16 is supported

Description

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.

Steps To Reproduce

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

Execute in dbsm.

ant run.tests

Proposed Solution

Skip the tests which are failing with postgres 16

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0167528) hgbot (developer) 2024-07-31 12:55	Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/48 [^]

(0167748) hgbot (developer) 2024-08-06 12:34	Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1641 [^]

(0169447) hgbot (developer) 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 (developer) 2024-09-21 10:58	Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1641 [^]

Issue History
Date Modified	Username	Field	Change
2024-07-31 12:46	ablasco	New Issue
2024-07-31 12:46	ablasco	Assigned To	=> ablasco
2024-07-31 12:46	ablasco	Modules	=> Core
2024-07-31 12:46	ablasco	Triggers an Emergency Pack	=> No
2024-07-31 12:55	hgbot	Note Added: 0167528
2024-08-06 12:34	hgbot	Note Added: 0167748
2024-08-06 12:50	AugustoMauch	Status	new => scheduled
2024-09-21 10:58	hgbot	Note Added: 0169447
2024-09-21 10:58	hgbot	Note Added: 0169448

Copyright © 2000 - 2009 MantisBT Group