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:
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
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
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
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
5 matches
Mail list logo