details:   https://code.openbravo.com/erp/devel/pi/rev/b7b5576137de
changeset: 32673:b7b5576137de
user:      Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date:      Wed Sep 13 09:17:21 2017 +0200
summary:   Related to issue 36789: Use partial index

diffstat:

 src-db/database/model/tables/FACT_ACCT.xml |  1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diffs (11 lines):

diff -r eaf73138f70a -r b7b5576137de src-db/database/model/tables/FACT_ACCT.xml
--- a/src-db/database/model/tables/FACT_ACCT.xml        Tue Sep 12 21:41:29 
2017 +0530
+++ b/src-db/database/model/tables/FACT_ACCT.xml        Wed Sep 13 09:17:21 
2017 +0200
@@ -294,6 +294,7 @@
       </index>
       <index name="FACT_ACCT_BPARTNER" unique="false">
         <index-column name="C_BPARTNER_ID"/>
+        <whereClause><![CDATA[C_BPARTNER_ID IS NOT NULL]]></whereClause>
       </index>
       <index name="FACT_ACCT_DATEACCT" unique="false">
         <index-column name="DATEACCT"/>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to