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.