Project:
| View Revisions: Issue #35458 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0035458: com.openbravo.test.integration.erp.modules.ci.Upgrade_FS fails with function index | ||
| Revision | 2017-03-09 08:43 by vmromanos | ||
| Description | I have defined a multi-column index on the FIN_PAYMENT table which includes a function and works fine in both Oracle and Postgres: <index name="FIN_PAYMENT_BPARTNER_CREDIT" unique="false"> <index-column name="C_BPARTNER_ID"/> <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT,USED_CREDIT)"/> </index> When I send the patch to try, the job try-upgrade-pgsql fails with the following error (attached screenshot): org.apache.ddlutils.model.ModelException: The index FIN_PAYMENT_BPARTNER_CREDIT in table FIN_PAYMENT references the undefined column functionBasedColumn https://ci.openbravo.com//job/try-upgrade-pgsql/5297/ [^] |
||
| Revision | 2017-03-09 08:34 by vmromanos | ||
| Description | I have defined a multi-column index on the FIN_PAYMENT table which includes a function and works fine in both Oracle and Postgres: <index name="FIN_PAYMENT_BPARTNER_CREDIT" unique="false"> <index-column name="C_BPARTNER_ID"/> <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT,USED_CREDIT)"/> </index> When I send the patch to try, the job try-upgrade-pgsql fails with the following error (attached screenshot): org.apache.ddlutils.model.ModelException: The index FIN_PAYMENT_BPARTNER_CREDIT in table FIN_PAYMENT references the undefined column functionBasedColumn |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |