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 <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 : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
Last Reviewed: March 25, 2000 |