FIX: Invalid Column in Subquery May Result in Handled AV

ID: Q138673

The information in this article applies to:

Microsoft SQL Server version 6.0

SYMPTOMS

A subquery that references an invalid column may cause a handled access violation (AV). The expected output would be the 207 error message, "Invalid column name <table.column>".

WORKAROUND

Make sure you are referencing valid column(s) within the subquery.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.

MORE INFORMATION

The following query against the PUBS database results in the access violation:


   select au_lname from authors,titleauthor
   where au_lname + au_fname not in (select au_lname + fname from employee)

The column au_lname is not a valid column for the employee table.

Additional query words: subquery select transact-sql

Keywords : kbprg SSrvProg SSrvTran_SQL kbbug6.00 kbfix6.00.sp2
Version : winnt:6.0
Platform : winnt
Issue type :