Project:
| View Revisions: Issue #41785 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0041785: Error with function index including a coalesce with a varchar | ||
| Revision | 2019-09-09 17:10 by aferraz | ||
| Steps To Reproduce | Create following index: CREATE INDEX c_order_test ON public.c_order USING btree (COALESCE(c_order_id, 'X')); Export database. Check database is correctly exported and index is exported as follows: <index name="C_ORDER_TEST" unique="false"> <index-column name="functionBasedColumn" functionExpression="COALESCE(C_ORDER_ID,'X' varying)"/> </index> Remove index from database and run ant update.database -Dlocal=yes in order to create the index from the xml. Check you get following error: SQL Command failed with: ERROR: error de sintaxis en o cerca de «varying» CREATE INDEX C_ORDER_TEST ON C_ORDER ((COALESCE(C_ORDER_ID,'X' varying))) Realize similar index including a coalesce with a decimal works fine: CREATE INDEX c_order_test ON public.c_order USING btree (COALESCE(grandtotal, 0)); |
||
| Revision | 2019-09-09 16:56 by aferraz | ||
| Steps To Reproduce | Create following index: CREATE INDEX c_order_test ON public.c_order USING btree (COALESCE(c_order_id, 'X')); Export database. Check database is correctly exported and index is exported as follows: <index name="C_ORDER_TEST" unique="false"> <index-column name="functionBasedColumn" functionExpression="COALESCE(C_ORDER_ID,'X' varying)"/> </index> Remove index from database and run ant update.database -Dlocal=yes in order to create the index from the xml. Check you get following error: SQL Command failed with: ERROR: error de sintaxis en o cerca de «varying» CREATE INDEX C_ORDER_TEST ON C_ORDER ((COALESCE(C_ORDER_ID,'X' varying))) |
||
| Revision | 2019-09-09 16:43 by aferraz | ||
| Steps To Reproduce | Create following index: CREATE INDEX c_order_test ON public.c_order USING btree (COALESCE(c_order_id, 'X')); Export database. Check database is correctly exported and index is exported as follows: <index name="C_ORDER_TEST" unique="false"> <index-column name="functionBasedColumn" functionExpression="COALESCE(C_ORDER_ID,'X' varying)"/> </index> Run ant update.database. Check you get following error: |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |