Microsoft KB Archive/244391

= BUG: SQL 7.0 Create Statistics or WHERE Clause on Float Returns EXCEPTION_FLT_INVALID_OPERATION =

Article ID: 244391

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q244391



BUG #: 56695 (SQLBUG_70)



SYMPTOMS
Using a SELECT statement with a WHERE clause against a FLOAT datatype, with auto create statistics, may return an error. The auto create statistics may not appear when executing SP_HELPINDEX. Attempting to use DROP then CREATE STATISTICS may also return the following error:

ODBC: Msg 0, Level 19, State 1

SqlDumpExceptionHandler: Process 12 generated fatal exception c0000090 EXCEPTION_FLT_INVALID_OPERATION. SQL Server is terminating this process.

This bug does not occur until a significant number of rows have been inserted into a table containing a FLOAT datatype.



WORKAROUND
Change the datatype in the table from FLOAT to DECIMAL or NUMERIC.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB244391

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.