Is This A Known SQL Server 2005 T-SQL Bug With Sub-selects In An IN Clause

Try the following code in SQL Server 2005:


Code Snippet

CREATE DATABASE test_bug

GO

USE test_bug
GO

CREATE TABLE test1 ( a int )
CREATE TABLE test2 ( b int )
GO

INSERT INTO test1 VALUES ( 1 )
INSERT INTO test2 VALUES ( 2 )
GO

SELECT * FROM test1
SELECT * FROM test2
GO

-- This should error but instead returns all rows from test1
SELECT * FROM test1 WHERE a IN ( SELECT a FROM test2 )



I've tried it onw three different boxes that I have access to.