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.