Microsoft KB Archive/67742

PRSQL9012025: Joins with False WHERE Clause GP-Fault ID Number: Q67742

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9012025

SYMPTOMS When trying to join two tables together using the following query, the SQL server GP-faults:

SELECT table1.*, table2.* FROM table1, table2 WHERE table1.col1 = table2.col2 AND 1 = 2 CAUSE The tables being joined had at least 25 columns with 500 rows each, and were joined together with a clause that equates to NULL such as

where 1=2 -or- where ‘apple’ > ‘bob’

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.1. We are researching this problem and will post new information here as it becomes available.