Microsoft KB Archive/65464

PRSQL9012006: Overflow Error Problem with Nonnull INTs ID Number: Q65464

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9012006

SYMPTOMS When inserting an arithmetic expression that results in an overflow into a non-nullable INT column, error message 515 “attempt to insert NULL” is reported, and an overflow is reported as a secondary error message.

CAUSE When the overflow occurs for a data type INT, the warning message number 3606 is displayed. This message returns a value of NULL to SQL Server. The NULL value is then attempted to be placed in the nonnullable INT column, which results in the “attempt to insert NULL” error message. With other data types such as SMALLINT, a numeric overflow returns error number 220 and aborts the transaction.

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.1. We are researching this problem and will post new information here as it becomes available.