Project:
| View Revisions: Issue #35458 | [ 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 | ||
| Steps To Reproduce | Apply the patch attached in 0033581 Run ant smartbuild -Dlocal=no. Verify the index is properly added to the database Set core as indevelopment. Export database. Verify the index is properly exported. Send the changeset to try, or run Upgrade_FS test locally. The error in the attached screenshot is raised. |
||
| Revision | 2017-03-09 08:43 by vmromanos | ||
| Steps To Reproduce | Apply the patch attached in 0033581 (or add the index described in Description section) Run ant smartbuild -Dlocal=no. Verify the index is properly added to the database Set core as indevelopment. Export database. Verify the index is properly exported. Send the changeset to try, or run Upgrade_FS test locally. The error in the attached screenshot is raised. |
||
| 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 |
 |