Description
At development time there should be an error or warning given when the length of a primary key field exceeds the documented limit of 500 bytes.
Use Case
- when analyzing the entity definitions (Analyze Model) the primary key length and length of indices should be checked against the allowed maximum (500bytes).
Importance
Primary keys (PK) >500bytes can cause severe problems at runtime. We have customer reports that database clients are crashing and uservers hang indefinitely when trying to retrieve data via the PK where the PK >500 bytes. This should be caught during development, it is difficult to track down and fix at runtime.
Type
Proc Code
Operating System
Not Applicable
Status
Open