Kbase P41148: New index on char column (incremental protoora)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Incremental protoora added an index on a character column
The index is not populated
u##column-name has been created (by an ALTER statement) but it has not been populated
CAUSE:
Known issue: the .sql generated is not including the statement
UPDATE table_name
SET U##column-name = UPPER(column-name);
FIX:
Run within Oracle the statement:
UPDATE table_name
SET U##column-name = UPPER(column-name);