Microsoft KB Archive/138673

{|
 * width="100%"|

FIX: Invalid Column in Subquery May Result in Handled AV

 * }

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 ".

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 : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600