0024275: Some brackets are missing in m_locator_trg, and the sql is not correct

Description

Some brackets are missing in m_locator_trg, and the sql is not correct

Steps To Reproduce

- m_locator_trg
- Some brackets are missing in
select count(*)
into v_count
from m_storage_detail
where m_locator_id = old.m_locator_id
and COALESCE(qtyonhand,0) <> 0
or COALESCE(qtyorderonhand, 0) <> 0
or COALESCE(preqtyonhand, 0) <> 0
or COALESCE(preqtyorderonhand, 0) <> 0

Proposed Solution

Change:

select count(*)
into v_count
from m_storage_detail
where m_locator_id = old.m_locator_id
and COALESCE(qtyonhand,0) <> 0
or COALESCE(qtyorderonhand, 0) <> 0
or COALESCE(preqtyonhand, 0) <> 0
or COALESCE(preqtyorderonhand, 0) <> 0

by

select count(*)
into v_count
from m_storage_detail
where m_locator_id = old.m_locator_id
and (COALESCE(qtyonhand,0) <> 0
or COALESCE(qtyorderonhand, 0) <> 0
or COALESCE(preqtyonhand, 0) <> 0
or COALESCE(preqtyorderonhand, 0) <> 0);

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0061426) hgbot (developer) 2013-09-26 17:51	Repository: erp/devel/pi Changeset: 3e69b0ee867b68ed20ccbcd3991e9f6512060035 Author: Jon Alegría <jon.alegria <at> openbravo.com> Date: Thu Sep 26 17:51:40 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/3e69b0ee867b68ed20ccbcd3991e9f6512060035 [^] Fixes issue 0024275: Some brackets are missing in m_locator_trg, and the sql is not correct --- M src-db/database/model/triggers/M_LOCATOR_TRG.xml ---

(0061436) hudsonbot (developer) 2013-09-27 03:11	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/71a3ba7a4af8 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2013-07-05 14:20	jonalegriaesarte	New Issue
2013-07-05 14:20	jonalegriaesarte	Assigned To	=> jonalegriaesarte
2013-07-05 14:20	jonalegriaesarte	Modules	=> Core
2013-07-05 14:20	jonalegriaesarte	Triggers an Emergency Pack	=> No
2013-08-19 16:47	jonalegriaesarte	Target Version	3.0MP27 => 3.0MP28
2013-09-16 13:18	jonalegriaesarte	Target Version	3.0MP28 => 3.0MP29
2013-09-26 17:51	hgbot	Checkin
2013-09-26 17:51	hgbot	Note Added: 0061426
2013-09-26 17:51	hgbot	Status	new => resolved
2013-09-26 17:51	hgbot	Resolution	open => fixed
2013-09-26 17:51	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/3e69b0ee867b68ed20ccbcd3991e9f6512060035 [^]
2013-09-26 17:52	jonalegriaesarte	Review Assigned To	=> egoitz
2013-09-26 17:57	egoitz	Status	resolved => closed
2013-09-26 17:57	egoitz	Fixed in Version	=> 3.0MP28
2013-09-27 03:11	hudsonbot	Checkin
2013-09-27 03:11	hudsonbot	Note Added: 0061436