Kbase P19166: Case sensitivity of the fields that compose the unique index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
IBM AS/400 (RISC)
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Case sensitivity of the fields that compose the unique index is ignored.
When a new record is created with the same information in any case sensitive field but different character case error 2471 is generated which shouldn't occur in this situation.
<record> already exists with this unique index value. (2471)
CAUSE:
Bug# 20030120-015
CAUSE:
The physical files on the AS/400 are generated as if they were to compare in upper case only. It seems that setting the proper ALTSEQ tables when creating server schema is a problem here.
FIX:
Currently this bug is NPTF because of resource constraints due to status of the product and priority of the issue (CIL3)