Posted by Erland Sommarskog on 04/14/06 00:29

Dimitri Furman (dfurman@cloud99.net) writes:
> I haven't found anything, so I went ahead and opened a bug:
> http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackId=
> FDBK48623
>
> Feel free to add anything that may be important.

Good!

I tested it on the CTP of SP1, and the bug appears there as well.

I final blow to anyone who is in doubt over whether this is a bug is
that if I add WITH (INDEX = 1), that is index hint force the clustered
index to be used, the query returns a non-empty result set.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]