Project:
| View Revisions: Issue #41795 | [ All Revisions ] [ 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 |
 |