BUG: SELECT with Many Columns Causes Handled Access Violation in Optimizer (181923)


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q181923
BUG #: 17839 (sqlbug_65)

SYMPTOMS

A SELECT statement that contains too many columns can cause a handled access violation error in the optimizer which returns
DB-Library Process Dead - Connection Broken to a DB-Library client

and EXCEPTION_INT_DIVIDE_BY_ZERO is recorded in the SQL Server error log.

WORKAROUND

Remove enough columns from the SELECT to allow the query to run.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB181923
©2003 Microsoft Corporation. All rights reserved.