BUG: SQL 7.0 Create Statistics or WHERE Clause on Float Returns EXCEPTION_FLT_INVALID_OPERATION
Feb.11, 2010 in
exception
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.
Resolution
Change the datatype in the table from FLOAT to DECIMAL or NUMERIC.

Leave a Reply