Re: Q: WHERE 1=1 AND 1=0 AND 1=1, how many rows returned?

Posted in 1996

Brent Jackson — Tue, 13 Feb 1996 00:26:27 GMT — source: Informix-list mailing list archive (1991-1998)

kerry@kcbbs.gen.nz (Kerry Sainsbury) wrote: >Encountered a *great* bug today: >SELECT tabname FROM systables > WHERE 1=1 AND 1=0 AND 1=1 >Q: What will the above query do? >A: return all the rows in systables! >This is SE 5.02.something on our Unisys SYSV box. I get the same for SCO Unix with OnLine 5.00.UD5 and 5.02.UC6 I prefer the where clause of : WHERE 1=1 AND NOT 1=1 AND 1=1 It's a goodie ! Cheers, Brent Jackson. brent@hypercom.co.nz Phone : 64-9-3603593 Fax : 64-9-3602840