BUG: Many ISNULLs Within an Expression May Cause Access Violation

ID: Q247134

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55405 (SQLBUG_70)

SYMPTOMS

A T-SQL Query with an expression having many operands calling the ISNULL System Function may cause a handled Access Violation (AV) for the connection. The following error message occurs:

ODBC: Msg 0, Level 19, State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Connection Broken

WORKAROUND

Use the COALESCE System Function instead of ISNULL.

STATUS

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

MORE INFORMATION

Both string and numeric expressions that have a lot of operands with calls to ISNULL can cause the Access Violation.

Additional query words: AV SELECT Access Violation Expression

Keywords : SSrvTran_SQL kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug