BUG: SQL 7.0 Create Statistics or WHERE Clause on Float Returns EXCEPTION_FLT_INVALID_OPERATION (244391)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB244391 |
|---|
|