Operational Defect Database
BugZero found this defect 39 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2884531
Fixes an issue in which using the INSERT statement with the CAST or CONVERT function from a string representing negative zero to a decimal or numeric datatype succeeds, but you see the following error message on DBCC CHECKDB and DBCC CHECKTABLE: Msg 2570, Level 16, State 3, Line <LineNumber> Page (1:360), slot 0 in object ID <ObjectID>, index ID <IndexID>, partition ID <PartitionID>, alloc unit ID <UnitID> (type "In-row data"). Column "<ColumnName>" value is out of range for data type "decimal". Update column to a legal value.
Last update date:
4/11/2024
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4365.2
Fixed releases:
15.0.4365.2
Description:
Fixes an issue in which using the INSERT statement with the CAST or CONVERT function from a string representing negative zero to a decimal or numeric datatype succeeds, but you see the following error message on DBCC CHECKDB and DBCC CHECKTABLE: Msg 2570, Level 16, State 3, Line <LineNumber> Page (1:360), slot 0 in object ID <ObjectID>, index ID <IndexID>, partition ID <PartitionID>, alloc unit ID <UnitID> (type "In-row data"). Column "<ColumnName>" value is out of range for data type "decimal". Update column to a legal value.
