0028362: c_invoice_post creates unnecesary contention on m_pricelist and c_doctype

Issue History
Date Modified	Username	Field	Change
2014-12-09 10:03	alostale	New Issue
2014-12-09 10:03	alostale	Assigned To	=> Sandrahuguet
2014-12-09 10:03	alostale	Modules	=> Core
2014-12-09 10:03	alostale	Regression level	=> Production - Confirmed Stable
2014-12-09 10:03	alostale	Triggers an Emergency Pack	=> No
2014-12-09 10:04	alostale	Regression date	=> 2012-06-19
2014-12-09 10:04	alostale	Regression introduced in release	=> 3.0MP13
2014-12-09 10:04	alostale	Triggers an Emergency Pack	No => Yes
2014-12-09 10:04	alostale	Regression introduced by commit	=> https://code.openbravo.com/erp/devel/pi/rev/09a2cab4bfac [^]
2014-12-09 10:05	alostale	Relationship added	related to 0028360
2014-12-09 10:05	alostale	Tag Attached: Performance
2014-12-09 10:05	alostale	Issue Monitored: alostale
2014-12-09 12:39	alostale	Relationship added	related to 0028365
2014-12-10 10:24	Sandrahuguet	Note Added: 0072378
2014-12-10 10:30	hgbot	Checkin
2014-12-10 10:30	hgbot	Note Added: 0072380
2014-12-10 10:30	hgbot	Status	new => resolved
2014-12-10 10:30	hgbot	Resolution	open => fixed
2014-12-10 10:30	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/a73f9b345a421d0a76f498bc1c722b15825daefc [^]
2014-12-10 13:58	umartirena	Review Assigned To	=> umartirena
2014-12-10 13:58	umartirena	Note Added: 0072398
2014-12-10 13:58	umartirena	Status	resolved => closed
2014-12-10 13:58	umartirena	Fixed in Version	=> pi
2014-12-30 23:27	hudsonbot	Checkin
2014-12-30 23:27	hudsonbot	Note Added: 0073202

Notes
(0072378) Sandrahuguet (developer) 2014-12-10 10:24	Test Plan: -Create a new Sales Invoice with lines (check its price list) -In a pg client (psql) run: begin select c_invoice_post(null, (select c_order_id from c_invoice order by created desc limit 1)); - Create new Sales Invoice with same price list

(0072380) hgbot (developer) 2014-12-10 10:30	Repository: erp/devel/pi Changeset: a73f9b345a421d0a76f498bc1c722b15825daefc Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Tue Dec 09 18:59:11 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/a73f9b345a421d0a76f498bc1c722b15825daefc [^] Fixed bug 28362 c_invoice_post creates unnecesary contentions Avoiding the join with m_pricelist and c_doctype contentions are solved --- M src-db/database/model/functions/C_INVOICE_POST.xml ---

(0072398) umartirena (reporter) 2014-12-10 13:58	Code Review + Testing OK

(0073202) hudsonbot (developer) 2014-12-30 23:27	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/6525fe229e06 [^] Maturity status: Test