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.
