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

Leave a Reply