Re: [HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Ian Barwick
On Mon, 26 Jul 2004 16:32:33 -0700 (PDT), Stephan Szabo <[EMAIL PROTECTED]> wrote: > On Tue, 27 Jul 2004, Ian Barwick wrote: > > > Apologies if this has been covered previously. > > > > Given a statement like this: > > SELECT * FROM foo WHERE id IN (SELECT id FROM bar) > > I would expect it to f

Re: [HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Ian Barwick
On Tue, 27 Jul 2004 01:33:44 +0200, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > On Tuesday 27 July 2004 01:15, Ian Barwick wrote: > > Apologies if this has been covered previously. > > > > Given a statement like this: > > SELECT * FROM foo WHERE id IN (SELECT id FROM bar) > > I would expect

Re: [HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Andreas Joseph Krogh
On Tuesday 27 July 2004 01:15, Ian Barwick wrote: > Apologies if this has been covered previously. > > Given a statement like this: > SELECT * FROM foo WHERE id IN (SELECT id FROM bar) > I would expect it to fail if "bar" does not have a column "id". The > test case below (tested in 7.4.3 and 7.4

Re: [HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Stephan Szabo
On Tue, 27 Jul 2004, Ian Barwick wrote: > Apologies if this has been covered previously. > > Given a statement like this: > SELECT * FROM foo WHERE id IN (SELECT id FROM bar) > I would expect it to fail if "bar" does not have a column "id". The > test case below (tested in 7.4.3 and 7.4.1) shows

[HACKERS] Unexpected subquery behaviour

2004-07-26 Thread Ian Barwick
Apologies if this has been covered previously. Given a statement like this: SELECT * FROM foo WHERE id IN (SELECT id FROM bar) I would expect it to fail if "bar" does not have a column "id". The test case below (tested in 7.4.3 and 7.4.1) shows this statement will however appear succeed, but pro