Kbase P24331: SQL92 crashes with large indexed fields when an index is cre
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
SQL92 server crashes with large indexed fields when an index is created after inserting rows
Statement is executed from SQL Explorer
User gets disconnected
No error appears in the Database Log file
The Database does not stop
Example, the following will fail :
create table t1 (c1 varchar(3000), c2 varchar(3000), c3 varchar(3000));
create public synonym t1 for pub.t1;
create index idx1 on t1 (c1);
create index idx2 on t1 (c2);
create index idx3 on t1 (c3);
insert into t1 values('1','2','3');
insert into t1 values('4','5','6');
commit;
create index idx4 on t1 (c1);
CAUSE:
Bug #20030501-012
FIX:
No fix is available at this time of writting