Kbase P143120: SQL-92-trigger fails after dump and reload
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/04/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL-92-trigger fails after dump and reload
Order of column "_Field"."_field-rpos" is different then the one in "_Field"."_field-Physpos".
FACT(s) (Environment):
A column was deleted and an other column was added later at the position of the deleted column via a delta df file
OpenEdge 10.1C
All Supported Operating Systems
CAUSE:
Bug# OE00182664
CAUSE:
When adding a field via a delta df in which the position is specified then even the specific position is free in the schema the field gets physically placed to the end of the table fields list. When dumping and loading the database the physically location gets corrected to be the same as the position but any trigger which has been added using the wrong field position will not work anymore because of that correction.
FIX:
Change column number in trigger accordingly or dump and reload database before creating triggers using wrong field positions.