On 2019-02-21 15:02:23, "Tom Bassel" <tom-sql...@pettymail.com> wrote:
Are tables t3, t4, and t5 below working as designed?
Yes. See <https://sqlite.org/lang_createtable.html#rowid>:
> The rowid value can be accessed using one of the special
case-independent names "rowid", "oid", or "_rowid_" in place of a column
name. If a table contains a user defined column named "rowid", "oid" or
"_rowid_", then that name always refers the explicitly declared column
and cannot be used to retrieve the integer rowid value.
--
J. King
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
