Re: [sqlite] unsafe use of virtual table

2020-02-05 Thread tom-sqlite
Ah I see now. Thank you Keith! Tom Message: 14 Date: Tue, 04 Feb 2020 14:57:06 -0700 From: "Keith Medcalf" To: "SQLite mailing list" Subject: Re: [sqlite] unsafe use of virtual table Message-ID: <62147479ae781d49902e13c3c23a3...@mail.dessus.com> Content-Type: text/plain; charset="utf-8" This

[sqlite] unsafe use of virtual table

2020-02-04 Thread tom-sqlite
e point me to where I can find more info on unsafe use of virtual tables? Thanks Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Release date of 3.30.1

2019-12-02 Thread tom-sqlite
at 2018-11-05 20:37, but still lists its release date as 2018-11-05. Thanks Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_USE_ALLOCA compile time option on FreeBSD

2019-11-21 Thread tom-sqlite
, and alloca() cannot determine such an error. Avoid alloca() with large unbounded allocations. FreeBSD 12.0-RELEASE-p9September 5, 2006 FreeBSD 12.0-RELEASE-p9 Not a big deal, just a little confusing for alloca() to be recommended yet discouraged by OS. Tom

[sqlite] Documentation correction

2019-04-15 Thread tom-sqlite
integer primary key: CREATE TABLE t(rowid integer primary key); insert into t values(15); select rowid, oid from t; Results: 15|15 Thanks, Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WITHOUT ROWID tables with a ROWID

2019-02-22 Thread tom-sqlite
Ah I see now. Sorry I should have read the docs more carefully -- it is working according to spec in all cases. Great answers. Thanks guys! Tom ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin