Re: [sqlite] invalid subselect is not detected ?

2007-07-23 Thread Ken
Joe, Indeed you are correct its a correlated subquery! Thanks again. Ken Joe Wilson <[EMAIL PROTECTED]> wrote: --- Ken wrote: > Is this an error or by design? > create table ss( ssid, ss_value); > create table s(id, s_value); ... > select id from s where id in ( select id from

Re: [sqlite] invalid subselect is not detected ?

2007-07-21 Thread Andrew Finkenstadt
On 7/21/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > > (In the 5 hour lag it takes to post to the list, this has > > probably already been answered 5 times, but what the heck...) > > > > I'd love for you to work on the slow

Re: [sqlite] invalid subselect is not detected ?

2007-07-21 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > > (In the 5 hour lag it takes to post to the list, this has > > probably already been answered 5 times, but what the heck...) > > > > I'd love for you to work on the slow email problem for me, Joe. > Call me at my office

Re: [sqlite] invalid subselect is not detected ?

2007-07-20 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > > (In the 5 hour lag it takes to post to the list, this has > probably already been answered 5 times, but what the heck...) > I'd love for you to work on the slow email problem for me, Joe. Call me at my office for the root password. :-) -- D. Richard

Re: [sqlite] invalid subselect is not detected ?

2007-07-20 Thread Joe Wilson
--- Ken <[EMAIL PROTECTED]> wrote: > Is this an error or by design? > create table ss( ssid, ss_value); > create table s(id, s_value); ... > select id from s where id in ( select id from ss); (In the 5 hour lag it takes to post to the list, this has probably already been answered 5 times, but

Re: [sqlite] invalid subselect is not detected ?

2007-07-20 Thread Andrew Finkenstadt
On 7/20/07, Ken <[EMAIL PROTECTED]> wrote: Is this an error or by design? create table ss( ssid, ss_value); create table s(id, s_value); insert into ss values (1,1234); insert into ss values (2,1234); insert into s values (1, 567); insert into s values (2, 567); insert into s values (3, 567);