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