You might try entering a bug ticket. In the meantime, you have to use "AS" aliases for all columns in views.
--- Boris Popov <[EMAIL PROTECTED]> wrote: > To be honest I don't like re-sending messages myself, but it seems this may > have slipped through the cracks and I would really like to hear whether it's > SQLite's issue or mine. > > Thanks! > > -Boris > > -- > +1.604.689.0322 > DeepCove Labs Ltd. > 4th floor 595 Howe Street > Vancouver, Canada V6C 2T5 > > [EMAIL PROTECTED] > > CONFIDENTIALITY NOTICE > > This email is intended only for the persons named in the message > header. Unless otherwise indicated, it contains information that is > private and confidential. If you have received it in error, please > notify the sender and delete the entire message including any > attachments. > > Thank you. > > -----Original Message----- > From: Boris Popov [mailto:[EMAIL PROTECTED] > Sent: Friday, March 24, 2006 4:16 PM > To: [email protected] > Subject: [sqlite] Error when matching column names in a view > > Any comments would be appreciated, > > SQLite version 3.3.4 > Enter ".help" for instructions > sqlite> create table one (id integer primary key); > sqlite> create table two (id integer primary key); > sqlite> select one.id, two.id from one join two where one.id=two.id; > sqlite> create view three as select one.id, two.id from one join two where > one.id=two.id; > sqlite> select * from three; > sqlite> select one.id from three; > SQL error: no such column: one.id > sqlite> select id from three; > SQL error: no such column: id > sqlite> create view four as select one.id as oneid, two.id as twoid from one > join two where one.id=two.id; > sqlite> select oneid from four; > sqlite> > > The last one is a workaround to show that you can reference columns by their > alias, but not their name in a view. > > Could this be related to http://www.sqlite.org/cvstrac/chngview?cn=3128 by > any chance? > > Thanks! > > -Boris > > -- > +1.604.689.0322 > DeepCove Labs Ltd. > 4th floor 595 Howe Street > Vancouver, Canada V6C 2T5 > > [EMAIL PROTECTED] > > CONFIDENTIALITY NOTICE > > This email is intended only for the persons named in the message > header. Unless otherwise indicated, it contains information that is > private and confidential. If you have received it in error, please > notify the sender and delete the entire message including any > attachments. > > Thank you. > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
