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.
smime.p7s
Description: S/MIME cryptographic signature
