Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022634Openbravo ERP07. Sales managementpublic2012-12-19 12:202012-12-31 08:48
gorkaion 
gorkaion 
immediatecriticalalways
closedfixed 
20Gentoo
pi 
pi 
naiaramartinez
Core
Automated tests
2012-12-19
https://code.openbravo.com/erp/devel/pi/rev/91d5e374a3a4 [^]
No
0022634: test int-dbcons-pgsql failure due to view change
Test int-dbcons-pgsql failure due to view change

Build 0003587 (Dec 19, 2012 11:13:29 AM)


Output

diff -r bf1cabd2bc65 src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml
--- a/src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml Wed Dec 19 10:07:13 2012 +0100
+++ b/src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml Wed Dec 19 10:21:15 2012 +0000
@@ -1,4 +1,4 @@
 <?xml version="1.0"?>
   <database name="VIEW M_PRERESERVATION_PICK_EDIT">
- <view name="M_PRERESERVATION_PICK_EDIT"><![CDATA[SELECT COALESCE(res.m_reservation_stock_id, (sol.c_orderline_id || pol.c_orderline_id)) AS m_prereservation_pick_edit_id, pol.ad_client_id, pol.ad_org_id, pol.createdby, pol.created, pol.updated, pol.updatedby, to_char('Y') AS isactive, pol.c_orderline_id AS purchase_orderline_id, sol.c_orderline_id AS sales_orderline_id, so.documentno, sol.line, so.dateordered, so.datepromised, pol.qtyordered AS purchasedqty, del.qty AS receivedqty, res.quantity AS reservedqty, res.m_reservation_stock_id, CASE WHEN res.m_reservation_stock_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected, sol.qtyordered, sol.qtydelivered, solres.m_reservation_id, COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0) AS otherresqty, so.c_bpartner_id FROM c_orderline pol JOIN c_order po ON pol.c_order_id = po.c_order_id AND po.issotrx = 'N' AND po.docstatus = 'CO' JOIN c_orderline sol ON pol.m_product_id = sol.m_product_id AND sol.qtyordered <> sol.qtydelivered JOIN c_order so ON sol.c_order_id = so.c_order_id AND so.issotrx = 'Y' AND so.docstatus = 'CO' JOIN (SELECT COALESCE(sum(mp.qty), 0) AS qty, ol.c_orderline_id FROM c_orderline ol JOIN c_order o ON ol.c_order_id = o.c_order_id AND o.issotrx = 'N' AND o.docstatus = 'CO' LEFT JOIN m_matchpo mp ON mp.c_orderline_id = ol.c_orderline_id AND mp.m_inoutline_id IS NOT NULL GROUP BY ol.c_orderline_id) del ON del.c_orderline_id = pol.c_orderline_id AND del.qty <> pol.qtyordered LEFT JOIN (SELECT r.c_orderline_id AS sales_orderline_id, rs.c_orderline_id AS purchase_orderline_id, rs.quantity, rs.m_reservation_stock_id FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL AND rs.c_orderline_id IS NOT NULL AND rs.m_locator_id IS NULL AND (r.res_status != 'CL')) res ON res.sales_orderline_id = sol.c_orderline_id AND res.purchase_orderline_id = pol.c_orderline_id LEFT JOIN (SELECT sum(rs.quantity - COALESCE(rs.releasedqty, 0)) AS qty, r.m_reservation_id, r.c_orderline_id, r.quantity AS resqty FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL GROUP BY r.m_reservation_id, r.c_orderline_id, r.quantity) solres ON solres.c_orderline_id = sol.c_orderline_id WHERE (COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0)) <> (sol.qtyordered - sol.qtydelivered)]]></view>
+ <view name="M_PRERESERVATION_PICK_EDIT"><![CDATA[SELECT COALESCE(res.m_reservation_stock_id, (sol.c_orderline_id || pol.c_orderline_id)) AS m_prereservation_pick_edit_id, pol.ad_client_id, pol.ad_org_id, pol.createdby, pol.created, pol.updated, pol.updatedby, to_char('Y') AS isactive, pol.c_orderline_id AS purchase_orderline_id, sol.c_orderline_id AS sales_orderline_id, so.documentno, sol.line, so.dateordered, so.datepromised, pol.qtyordered AS purchasedqty, del.qty AS receivedqty, res.quantity AS reservedqty, res.m_reservation_stock_id, CASE WHEN res.m_reservation_stock_id IS NULL THEN 'N' ELSE 'Y' END AS ob_selected, sol.qtyordered, sol.qtydelivered, solres.m_reservation_id, COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0) AS otherresqty, so.c_bpartner_id FROM c_orderline pol JOIN c_order po ON pol.c_order_id = po.c_order_id AND po.issotrx = 'N' AND po.docstatus = 'CO' JOIN c_orderline sol ON pol.m_product_id = sol.m_product_id AND sol.qtyordered <> sol.qtydelivered JOIN c_order so ON sol.c_order_id = so.c_order_id AND so.issotrx = 'Y' AND so.docstatus = 'CO' JOIN (SELECT COALESCE(sum(mp.qty), 0) AS qty, ol.c_orderline_id FROM c_orderline ol JOIN c_order o ON ol.c_order_id = o.c_order_id AND o.issotrx = 'N' AND o.docstatus = 'CO' LEFT JOIN m_matchpo mp ON mp.c_orderline_id = ol.c_orderline_id AND mp.m_inoutline_id IS NOT NULL GROUP BY ol.c_orderline_id) del ON del.c_orderline_id = pol.c_orderline_id AND del.qty <> pol.qtyordered LEFT JOIN (SELECT r.c_orderline_id AS sales_orderline_id, rs.c_orderline_id AS purchase_orderline_id, rs.quantity, rs.m_reservation_stock_id FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL AND rs.c_orderline_id IS NOT NULL AND rs.m_locator_id IS NULL AND r.res_status <> 'CL') res ON res.sales_orderline_id = sol.c_orderline_id AND res.purchase_orderline_id = pol.c_orderline_id LEFT JOIN (SELECT sum(rs.quantity - COALESCE(rs.releasedqty, 0)) AS qty, r.m_reservation_id, r.c_orderline_id, r.quantity AS resqty FROM m_reservation r JOIN m_reservation_stock rs ON r.m_reservation_id = rs.m_reservation_id WHERE r.c_orderline_id IS NOT NULL GROUP BY r.m_reservation_id, r.c_orderline_id, r.quantity) solres ON solres.c_orderline_id = sol.c_orderline_id WHERE (COALESCE(solres.qty, 0) - COALESCE(res.quantity, 0)) <> (sol.qtyordered - sol.qtydelivered)]]></view>
   </database>
N/A
No tags attached.
Issue History
2012-12-19 12:20gorkaionNew Issue
2012-12-19 12:20gorkaionAssigned To => gorkaion
2012-12-19 12:20gorkaionModules => Core
2012-12-19 12:20gorkaionTriggers an Emergency Pack => No
2012-12-19 12:21gorkaionReview Assigned To => naiaramartinez
2012-12-19 12:21gorkaionRegression level => Automated tests
2012-12-19 12:21gorkaionRegression date => 2012-12-19
2012-12-19 12:21gorkaionRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/91d5e374a3a4 [^]
2012-12-19 12:22hgbotCheckin
2012-12-19 12:22hgbotNote Added: 0055074
2012-12-19 12:22hgbotStatusnew => resolved
2012-12-19 12:22hgbotResolutionopen => fixed
2012-12-19 12:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ba7850bc2648aad74df97eaee78402b774a3cad1 [^]
2012-12-19 20:31hudsonbotCheckin
2012-12-19 20:31hudsonbotNote Added: 0055097
2012-12-31 08:48naiaramartinezStatusresolved => closed

Notes
(0055074)
hgbot   
2012-12-19 12:22   
Repository: erp/devel/pi
Changeset: ba7850bc2648aad74df97eaee78402b774a3cad1
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Dec 19 12:22:13 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ba7850bc2648aad74df97eaee78402b774a3cad1 [^]

Fixed issue 22634.Fix pg database consistency issue in view.

---
M src-db/database/model/views/M_PRERESERVATION_PICK_EDIT.xml
---
(0055097)
hudsonbot   
2012-12-19 20:31   
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/a69803a2b545 [^]

Maturity status: Test