Project:
| View Revisions: Issue #35653 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0035653: update.database can fail updating src tables with a check constraint where more than one column participates | ||
| Revision | 2017-09-12 12:55 by alostale | ||
| Steps To Reproduce | 1. In a clean pi apply attached reproduce-issue-35653.diff patch 2. execute ant update.database -> ERROR: ... [java] 27738 INFO - Updating Application Dictionary data... [java] org.postgresql.util.PSQLException: ERROR: new row for relation "obcql_query_column" violates check constraint "obcql_column_whereclause_chk" [java] Detail: Failing row contains (28F920CD36E14AFBB2025802363E8B02, 0, 0, Y, 2015-08-03 12:05:45.870978, 0, 2017-09-12 12:50:33.690805, 0, CFDF8EE593F04CFE9709F5AD19A3A573, qty, Qty, null, 10, null, 20, 29, null, W, Y, 186, Y, null, null). |
||
| Revision | 2017-09-12 12:43 by alostale | ||
| Steps To Reproduce | Create a module with a query list widget which contains some columns not filterable. Install in your env update the module to make those columns filterable and provide a valid whereclase_left_part update the environment Compilation fails (see attached log) Although xml files hold a value for whereclasue_left_part DBSource manager does not recognize it and crashes due to a check constrant failure. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |