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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024275
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminorhave not tried2013-07-05 14:202013-09-27 03:11
ReporterjonalegriaesarteView Statuspublic 
Assigned Tojonalegriaesarte 
PrioritynormalResolutionfixedFixed in Version3.0MP28
StatusclosedFix in branchFixed in SCM revision3e69b0ee867b
ProjectionnoneETAnoneTarget Version3.0MP29
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned Toegoitz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket22199
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionSome 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 SolutionChange:

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);
TagsNo 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 (viewer)
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 OBNetwork customer => Yes
2013-07-05 14:20 jonalegriaesarte Support ticket => 22199
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker