Re: [sqlite] ROWID bug in SELECT with JOIN?

2009-09-25 Thread BareFeet
On 26/09/2009, at 7:35 AM, sub sk79 wrote: > Select with two tables joined has no _rowid_ column in select columns. > I think this is a bug - just a quick check with the community before > filing a bug report. > > select * from names, friends where first_name = fname and _rowid_ < 2; > SQL error:

Re: [sqlite] ROWID bug in SELECT with JOIN?

2009-09-25 Thread Igor Tandetnik
sub sk79 wrote: > select * from (select * from names, friends where first_name = fname) > where _rowid_ < 2; > > Above query works - which _rowid_ is this accessing? Well, define "works". In my experiments, _rowid_ is NULL for all rows in the subselect: select typeof(_rowid_) from (select * fr

Re: [sqlite] ROWID bug in SELECT with JOIN?

2009-09-25 Thread sub sk79
select * from (select * from names, friends where first_name = fname) where _rowid_ < 2; Above query works - which _rowid_ is this accessing? Since the query works I get an impression the rowid is attached with the result-set returned by a select? -sk On Fri, Sep 25, 2009 at 6:07 PM, Igor Tan

Re: [sqlite] ROWID bug in SELECT with JOIN?

2009-09-25 Thread Igor Tandetnik
sub sk79 wrote: > Select with two tables joined has no _rowid_ column in select columns. > I think this is a bug - just a quick check with the community before > filing a bug report. > > select * from names, friends where first_name = fname and _rowid_ < 2; > SQL error: no such column: _rowid_ So

[sqlite] ROWID bug in SELECT with JOIN?

2009-09-25 Thread sub sk79
Hi, Select with two tables joined has no _rowid_ column in select columns. I think this is a bug - just a quick check with the community before filing a bug report. select * from names, friends where first_name = fname and _rowid_ < 2; SQL error: no such column: _rowid_ Complete log: = $ ./s