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

[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