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

ID: Q181923


The information in this article applies to:

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.


Keywords          : SSrvGen kbbug6.50 
Version           : Windows:6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 16, 1999