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

ID: Q244391

The information in this article applies to:

Microsoft SQL Server versions 7.0, 7.0 Service Pack 1

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 version 7.0.

Additional query words:

Keywords : SSrvTran_SQL kbbug7.00 kbSQLServ700bug
Version : winnt:7.0,7.0 Service Pack 1
Platform : winnt
Issue type : kbbug