[sqlite] Failing SQLite .import returns exit status 0

Hi, Consider the following shell script: rm -f empty.db empty.csv echo "" > empty.csv echo "a, b" >> empty.csv sqlite3 empty.db \ 'DROP TABLE IF EXISTS empty;' \ '.mode csv' \ 'CREATE TABLE IF NOT EXISTS empty(A, B NOT NULL);' \ '.import empty.csv empty' '.exit' echo "error code is" $? This

Re: [sqlite] configure failure for aarch64

On 7/6/62 20:17, Beat Küng wrote: Hi I'm trying to build sqlite (the latest release 3.28.0) for an aarch64 build target and get the following error: checking build system type... ./config.guess: unable to guess system type This script, last modified 2007-07-22, has failed to recognize the

[sqlite] Missing writes with SQLITE_OPEN_SHAREDCACHE and WAL

It seems like sqlite 3.28.0 can return stale results (missing writes that committed before the read transaction started) when two read transactions from a shared cache execute concurrently with a write from a private cache or another process on a WAL database. A test case for this issue is here

Re: [sqlite] New Information Schema Views

On Fri, 07 Jun 2019 01:43:18 -0600 "Keith Medcalf" wrote: > -- Catalog Views using sqlite_master for SysObjects (Object Names) > -- requires that the eval() extension function be loaded and available > -- all TEXT columns in views have "collate nocase" attachmented to > the output > -- columns

[sqlite] configure failure for aarch64

Hi I'm trying to build sqlite (the latest release 3.28.0) for an aarch64 build target and get the following error: checking build system type... ./config.guess: unable to guess system type This script, last modified 2007-07-22, has failed to recognize the operating system you are using. It is

Re: [sqlite] Compile time error when compiling extension shathree.c together with sqlite3.c for Android

Am 07.06.2019 um 15:34 schrieb Dan Kennedy: On 7/6/62 20:23, Ulrich Telle wrote: When I append the source code of the SHA3 extension (shathree.c from ext/misc directory) to the SQLite3 amalgamation (sqlite3.c), and then try to compile it for Android, I get the following error message:

Re: [sqlite] Compile time error when compiling extension shathree.c together with sqlite3.c for Android

On 6/7/19, Ulrich Telle wrote: > Would it be possible for the SQLite developers to adjust the variable names > used in the extension shathree.c to avoid this name clash with the macro in > termbits.h? https://www.sqlite.org/src/timeline?c=3ec73711 -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Compile time error when compiling extension shathree.c together with sqlite3.c for Android

On 7/6/62 20:23, Ulrich Telle wrote: When I append the source code of the SHA3 extension (shathree.c from ext/misc directory) to the SQLite3 amalgamation (sqlite3.c), and then try to compile it for Android, I get the following error message: shathree.c:83:7: error: expected identifier or '('

[sqlite] Compile time error when compiling extension shathree.c together with sqlite3.c for Android

When I append the source code of the SHA3 extension (shathree.c from ext/misc directory) to the SQLite3 amalgamation (sqlite3.c), and then try to compile it for Android, I get the following error message: shathree.c:83:7: error: expected identifier or '(' u64 B0, B1, B2, B3, B4; ^

Re: [sqlite] New Information Schema Views

Improved version that does not execute the eval multiple times. I have not renamed the columns match the ANSI INFORMATION_SCHEMA views, though I suppose that might be possible (though I find that schema yucky -- it embodies the thinking from decades ago where one would embed table names into