Microsoft KB Archive/112597

FIX: GPF if checktable on Float with NC Index

PSS ID Number: Q112597 Article last modified on 06-29-1995

4.21

WINDOWS

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.