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

ID: Q153455

The information in this article applies to:

Microsoft SQL Server version 6.5

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 : kbbug6.50 kbfix6.50.sp1
Version : 6.5
Platform : WINDOWS
Issue type : kbbug