Openbravo Issue Tracking System - Openbravo ERP | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0022634 | Openbravo ERP | 07. Sales management | public | 2012-12-19 12:20 | 2012-12-31 08:48 |
Reporter | gorkaion | ||||
Assigned To | gorkaion | ||||
Priority | immediate | Severity | critical | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | OS | 20 | OS Version | Gentoo | |
Product Version | pi | ||||
Target Version | pi | Fixed in Version | |||
Merge Request Status | |||||
Review Assigned To | naiaramartinez | ||||
OBNetwork customer | |||||
Web browser | |||||
Modules | Core | ||||
Support ticket | |||||
Regression level | Automated tests | ||||
Regression date | 2012-12-19 | ||||
Regression introduced in release | |||||
Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/91d5e374a3a4 [^] | ||||
Triggers an Emergency Pack | No | ||||
Summary | 0022634: test int-dbcons-pgsql failure due to view change | ||||
Description | 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> | ||||
Steps To Reproduce | N/A | ||||
Proposed Solution | |||||
Additional Information | |||||
Tags | No tags attached. | ||||
Relationships | |||||
Attached Files | |||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2012-12-19 12:20 | gorkaion | New Issue | |||
2012-12-19 12:20 | gorkaion | Assigned To | => gorkaion | ||
2012-12-19 12:20 | gorkaion | Modules | => Core | ||
2012-12-19 12:20 | gorkaion | Triggers an Emergency Pack | => No | ||
2012-12-19 12:21 | gorkaion | Review Assigned To | => naiaramartinez | ||
2012-12-19 12:21 | gorkaion | Regression level | => Automated tests | ||
2012-12-19 12:21 | gorkaion | Regression date | => 2012-12-19 | ||
2012-12-19 12:21 | gorkaion | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/91d5e374a3a4 [^] | ||
2012-12-19 12:22 | hgbot | Checkin | |||
2012-12-19 12:22 | hgbot | Note Added: 0055074 | |||
2012-12-19 12:22 | hgbot | Status | new => resolved | ||
2012-12-19 12:22 | hgbot | Resolution | open => fixed | ||
2012-12-19 12:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ba7850bc2648aad74df97eaee78402b774a3cad1 [^] | ||
2012-12-19 20:31 | hudsonbot | Checkin | |||
2012-12-19 20:31 | hudsonbot | Note Added: 0055097 | |||
2012-12-31 08:48 | naiaramartinez | Status | resolved => closed |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|