int-initial-oracle - Build # 2541 - Failure:
Check console output at https://ci.openbravo.com/job/int-initial-oracle/2541/
to view the results.
Committers since last success:
Changes for Build #2541
Alvaro Ferraz <alvaro.fer...@openbravo.com> null
Fixes issue 38785: Perfomance issue in add details button of payment in
window
Performance problem when filtering by order/invoice in Add Payment grid if
there is any record selected.
If no record is selected in the grid, the query performs well.
However, if we filter the grid with some record selected, the query adds an OR
clause that results in a bad execution plan:
AND (fin_paymen0_.FIN_Payment_Scheduledetail_ID IN
('17262A2A1E0E43B69935E7E2BD221BBB', 'F2FE327416A746E0A6735B21363D801D')
OR invoice7_.IsSOTrx = 'Y'
AND invoice7_.C_Currency_ID = '130'
AND businesspa1_.C_BPartner_ID = '812938173C81527EE97A8201FD232C24')
C_BPartner_ID filter has been moved out from the OR clause, fixing the
performance problem:
AND (fin_paymen0_.FIN_Payment_Scheduledetail_ID IN
('17262A2A1E0E43B69935E7E2BD221BBB', 'F2FE327416A746E0A6735B21363D801D')
OR invoice7_.IsSOTrx = 'Y'
AND invoice7_.C_Currency_ID = '130')
AND businesspa1_.C_BPartner_ID = '812938173C81527EE97A8201FD232C24'
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/AddPaymentOrderInvoicesTransformer.java
Last 20 lines of the console output:
[...truncated 3280 lines...]
+ (( i=0 ))
+ (( i<12 ))
++ jps
++ grep Bootstrap
++ true
+ '[' '' = '' ']'
+ break
++ jps
++ grep Bootstrap
++ true
+ '[' '' '!=' '' ']'
+ true
+ '[' 0 '!=' 0 ']'
+ echo
POST BUILD TASK : SUCCESS
END OF POST BUILD TASK : 0
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-builds mailing list
Openbravo-builds@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
