Dimitri Furman (dfurman@cloud99.net) writes:
> I haven't found anything, so I went ahead and opened a bug:
> http://lab.msdn.microsoft.com/Produc...px?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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx