Knowledge Base

FIX: Multiple "LEFT OUTER JOIN" in FROM Clause May Cause Error

Article ID: 153455

Article Last Modified on 10/3/2003

APPLIES TO

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q153455

BUG NT#: 15565 (6.50)

SYMPTOMS

Multiple LEFT OUTER JOIN tables in the FROM clause of a SELECT query may cause SQL Server error 803. For example, the following query:

   select authors.au_id
   from
   (((( authors
   left outer join titleauthor on authors.au_id=titleauthor.au_id)
   left outer join titles on titleauthor.title_id=titles.title_id)
   left outer join authors a1 on a1.au_id=titleauthor.au_id)
   left outer join roysched on titles.title_id=roysched.title_id)
   where (roysched.royalty = 20)

will cause the following SQL Server error:

Msg 803, Level 20, State 2
Unable to place buffer 0x0 holding logical page 424 in sdes for
object 'titleauthor' - either there is no room in sdes or buffer
already in requested slot.
The SQL Server is terminating this process.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: ANSI

Keywords: kbbug kbfix KB153455

Microsoft KB Archive/153455

FIX: Multiple "LEFT OUTER JOIN" in FROM Clause May Cause Error

SYMPTOMS

STATUS