Re: [sqlite] Null rowid when using CTEs

2014-11-14 Thread Dan Kennedy

On 11/14/2014 08:33 AM, RP McMurphy wrote:

When using CTEs the rowid is null. The following returns "--NULL--"

.null --NULL--
with c(x) as (select 1)
select rowid from c;


I guess that's expected. The same behaviour as for reading the rowid of 
a view or sub-select. It should probably be documented though.


Dan.





RP
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Null rowid when using CTEs

2014-11-14 Thread RP McMurphy
When using CTEs the rowid is null. The following returns "--NULL--"

.null --NULL--
with c(x) as (select 1)
select rowid from c;

RP
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users