FIX: GPF if checktable on Float with NC Index
PSS ID Number: Q112597 Article last modified on 06-29-1995
4.21
WINDOWS
| The information in this article applies to: |
| - Microsoft SQL Server version 4.21 |
BUG# NT: 699 (4.21 - NTMIPS) 700 (4.21 - NTAlpha)
SYMPTOMS
On either a MIPS- or an Alpha-based computer, executing either DBCC checktable or DBCC checkdb will fail with an exception alignment fault. This occurs with only non-clustered indexes (unique or not unique) when the key attribute of the non-clustered index is a float or real datatype.
The following will replicate the behavior:
use pubs go create table test(float_type float) go create nonclustered index test on test(float_type) go insert test values(1.0) go dbcc checktable (test) go
STATUS
Microsoft has confirmed this to be a problem in both the ALPHA and MIPS releases of SQL Server version 4.21 for Windows NT. This problem was corrected in SQL Server version 4.21a. For more information, contact your primary support provider.
Additional reference words: 4.21 Windows NT KBCategory: kbother kberrmsg KBSubcategory: SSrvWinNT SSrvRISC
=================================================================
Copyright Microsoft Corporation 1995.
