Re: [sqlite] Documentation update 2

Fixed now (I think). Thanks for the bug reports On 1/30/18, William Entriken wrote: > Hello again. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.6. > Currently: > >> This race condition had apparently existing in all prior versions of > SQLite... > > Should

[sqlite] Documentation update 2

Hello again. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.6. Currently: > This race condition had apparently existing in all prior versions of SQLite... Should be: > This race condition had apparently existed in all prior versions of SQLite... Regards, William Entriken

[sqlite] Documentation update

Hello. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.3. Perhaps this should be > 8.3. I/O error while obtaining a lock leads to corruption Regards, William Entriken ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] I encounter a problem when build sqlite for iOS

I have checked in changes (written by Dan) that should address your concerns. The next release of SQLite will probably run the Makefile to completion without errors in your environment. NB: This is not an error in SQLite. The problem is in a Makefile such that the Makefile does not play well

Re: [sqlite] sqlite3_set_last_insert_rowid

Probably best reserved for initialization of a shard of a database where you can set next to last of a prior .db. On Tue, Jan 30, 2018 at 9:14 AM, petern wrote: > For one, within a function that does an INSERT, set_last_insert_rowid makes > it possible to "pop"

[sqlite] System.Data.SQLite version 1.0.107.0 released

System.Data.SQLite version 1.0.107.0 (with SQLite 3.22.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] sqlite3_set_last_insert_rowid

I don't need this program so delete this. Sent from Yahoo Mail on Android On Tue, Jan 30, 2018 at 11:15 AM, petern wrote: For one, within a function that does an INSERT, set_last_insert_rowid makes it possible to "pop" last_insert_rowid. Consider a function

Re: [sqlite] sqlite3_set_last_insert_rowid

For one, within a function that does an INSERT, set_last_insert_rowid makes it possible to "pop" last_insert_rowid. Consider a function which INSERT's into the model and then INSERT's a log table row. The caller probably isn't interested in the log rowid. A better question to ask is always why

Re: [sqlite] [EXTERNAL] sqlite3_set_last_insert_rowid

Ok, thanks. Should have looked at that. RBS On Tue, Jan 30, 2018 at 3:12 PM, Hick Gunter wrote: > See http://sqlite.org/c3ref/last_insert_rowid.html > > "Some virtual table implementations may INSERT rows into rowid tables as > part of committing a transaction (e.g. to flush

[sqlite] (no subject)

Sent from Yahoo Mail on Android ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] sqlite3_set_last_insert_rowid

See http://sqlite.org/c3ref/last_insert_rowid.html "Some virtual table implementations may INSERT rows into rowid tables as part of committing a transaction (e.g. to flush data accumulated in memory to disk). In this case subsequent calls to this function return the rowid associated with these

[sqlite] sqlite3_set_last_insert_rowid

Just wonder what the possible use for this is. RBS ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I encounter a problem when build sqlite for iOS

On 1/30/18, Kingle Zhuang wrote: > shell.c:7098:9: error: 'system' is unavailable: not available on iOS > x = system(zCmd); Is the command-line shell in any way useful to iOS? Are you able to run the command-line shell on iOS? Can you explain to us how you do

[sqlite] I encounter a problem when build sqlite for iOS

shell.c:7098:9: error: 'system' is unavailable: not available on iOS x = system(zCmd); ^ /Applications/Xcode.app/Contents/Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator11.2.sdk/usr/include/stdlib.h:195:6: note: 'system' has been explicitly marked

Re: [sqlite] [EXTERNAL] Groups in C API

The feature in last paragraph is already the case with plain ORDER BY. All records in "group" order. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Stephan Buchert Gesendet: Dienstag, 30. Jänner 2018 12:17 An:

Re: [sqlite] Groups in C API

On Tue, 30 Jan 2018 12:16:32 +0100, Stephan Buchert wrote: > Thanks for the replies. > > Allowing non-aggregate columns in aggregate queries is very useful, as > shown with the min/max functions. It is forbidden in most SQL dialects, only supported by SQLite as a dirty

[sqlite] Groups in C API

Thanks for the replies. Allowing non-aggregate columns in aggregate queries is very useful, as shown with the min/max functions. Probably with this feature comes that SQLite even allows all non-aggregate columns in SELECTs with GROUP BY. Perhaps the documentation should warn more clearly, that

Re: [sqlite] [EXTERNAL] 3.22 'planner omits unused left joins'

>CREATE TABLE t1 (a INTEGER PRIMARY KEY); CREATE TABLE t2 (a INTEGER PRIMARY KEY); CREATE TABLE t3 (a INTEGER); CREATE UNIQUE INDEX ndx on t3(a); EXPLAIN QUERY PLAN SELECT t1.a FROM t1 left join t2 using (a); 0|0|0|SCAN TABLE t1 EXPLAIN QUERY PLAN SELECT t1.a FROM t1 left join t3 using (a);