Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #41795 Back to Issue ]
Summary 0041795: Oracle only: multi-column index with function based column doesn't properly apply
Revision 2019-09-10 18:16 by vmromanos
Steps To Reproduce In an Oracle instance clone the following modules:
https://code.openbravo.com/erp/pmods/org.openbravo.oms [^]
https://code.openbravo.com/erp/mods/org.openbravo.api.ticket [^]

Note the OBOMS_STOCK_BY_WAREHOUSE table has the following index:
  <index name="OBOMS_SBW_AVAILABLEPROD_IX" unique="false">
        <index-column name="functionBasedColumn" functionExpression="(QTYONHAND-RESERVEDQTY)>0"/>
        <index-column name="M_PRODUCT_ID"/>
  </index>

Run ant install.source (with smartbuild -Dlocal=no it is also reproducible).
The following error is thrown:

[createdatabase] 168019 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - SQL Command failed with: ORA-00907: falta el paréntesis derecho
[createdatabase]
[createdatabase] 168019 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END
[createdatabase] CREATE INDEX OBOMS_SBW_AVAILABLEPROD_IX ON OBOMS_STOCK_BY_WAREHOUSE (((QTYONHAND-RESERVEDQTY)>0), M_PRODUCT_ID)
[createdatabase] 210228 [main] INFO org.apache.ddlutils.platform.OracleStandardBatchEvaluator - Executed 14045 SQL command(s) with 1 error(s) in 141956 ms
Revision 2019-09-10 18:15 by vmromanos
Steps To Reproduce In an Oracle instance clone the following modules:
https://code.openbravo.com/erp/pmods/org.openbravo.oms [^]
https://code.openbravo.com/erp/mods/org.openbravo.api.ticket [^]

Note the OBOMS_RUN_ORDERLINE table has the following index:
  <index name="OBOMS_SBW_AVAILABLEPROD_IX" unique="false">
        <index-column name="functionBasedColumn" functionExpression="(QTYONHAND-RESERVEDQTY)>0"/>
        <index-column name="M_PRODUCT_ID"/>
  </index>

Run ant install.source (with smartbuild -Dlocal=no it is also reproducible).
The following error is thrown:

[createdatabase] 168019 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - SQL Command failed with: ORA-00907: falta el paréntesis derecho
[createdatabase]
[createdatabase] 168019 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END
[createdatabase] CREATE INDEX OBOMS_SBW_AVAILABLEPROD_IX ON OBOMS_STOCK_BY_WAREHOUSE (((QTYONHAND-RESERVEDQTY)>0), M_PRODUCT_ID)
[createdatabase] 210228 [main] INFO org.apache.ddlutils.platform.OracleStandardBatchEvaluator - Executed 14045 SQL command(s) with 1 error(s) in 141956 ms
Revision 2019-09-10 18:12 by vmromanos
Steps To Reproduce In an Oracle instance clone the following modules:
https://code.openbravo.com/erp/pmods/org.openbravo.oms [^]
https://code.openbravo.com/erp/mods/org.openbravo.api.ticket [^]

Note the OBOMS_RUN_ORDERLINE table has the following index:
  <index name="OBOMS_RUNRCRUN_RUNRULE_IX" unique="false">
        <index-column name="OBOMS_RUN_ID"/>
        <index-column name="functionBasedColumn" functionExpression="COALESCE(OBOMS_RUN_RULE_ID,'X')"/>
  </index>

Run ant install.source (with smartbuild -Dlocal=no it is also reproducible).
The following error is thrown:

[createdatabase] 168019 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - SQL Command failed with: ORA-00907: falta el paréntesis derecho
[createdatabase]
[createdatabase] 168019 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END
[createdatabase] CREATE INDEX OBOMS_SBW_AVAILABLEPROD_IX ON OBOMS_STOCK_BY_WAREHOUSE (((QTYONHAND-RESERVEDQTY)>0), M_PRODUCT_ID)
[createdatabase] 210228 [main] INFO org.apache.ddlutils.platform.OracleStandardBatchEvaluator - Executed 14045 SQL command(s) with 1 error(s) in 141956 ms


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker