Re: [sqlite] [EXTERNAL] Re: Is it possible to CREATE TABLE from other tables in a complex way?

2018-03-25 Thread Hick Gunter
>-Ursprüngliche Nachricht- >Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im >Auftrag von David Raymond >Gesendet: Freitag, 23. März 2018 21:52 >An: SQLite mailing list >Betreff: [EXTERNAL] Re: [sqlite] Is it possible to CREATE TABLE from other >tables in a co

Re: [sqlite] How to build SQLite with enabled SQLITE_ENABLE_ICU option using MinGW?

2018-03-25 Thread Keith Medcalf
You have to build it first, or use a pre-built version. MinGW does not appear to be a supported compiler on Windows. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sq

[sqlite] How to build SQLite with enabled SQLITE_ENABLE_ICU option using MinGW?

2018-03-25 Thread Victoria Nope
Hi there, I'm quite lost how to build SQLite with ICU support, using the MinGW compiler. My setup is simple, I've grabbed SQLite amalgamation, version 3.22.0 and ICU 60 ZIP file for Windows platforms: https://sqlite.org/2018/sqlite-amalgamation-322.zip http://download.icu-project.org/files/i

Re: [sqlite] Missing/undocumented HAVE_STRERROR_R

2018-03-25 Thread Yuriy M. Kaminskiy
On 03/16/18 10:12 , Jens Alfke wrote: > I'm debugging a problem that involves some errors logged by SQLite via > unixLogErrorAtLine(). The messages contain an errno value but not the > associated message. The message is missing because the call to > strerror_r() is #ifdef'd out by this line: > >

[sqlite] I can't undestand an assertion in a Lemon Parser

2018-03-25 Thread NightClicer Parhom
(English is not my native language; please excuse typing errors.) Greetings! I have a fun with my own simple project Lemon Server. It is a simple HTTP Server where HTTP protocol (RFC7230) was implemented with a Lemon Parser. I got a result grammar file but a fresh revision of the Lemon Parser c

Re: [sqlite] Determine sort order of query

2018-03-25 Thread Keith Medcalf
It isn't. In fact if you do a SELECT b, e FROM t1, t2 ORDER BY b, e; you get both the covering indexes being used and a temp sorter (although the temp sorter does nothing). Perhaps an opportunity for future optimization? --- The fact that there's a Highway to Hell but only a Stairway to Hea

Re: [sqlite] Determine sort order of query

2018-03-25 Thread x
Nice one Keith. Thanks. sqlite> create table t1 (a, b text, c); sqlite> create table t2 (d, e text, f); sqlite> create index b on t1(b); sqlite> create index e on t2(e); sqlite> explain query plan select * from t1,t2 order by b, t1.RowID, e, t2.RowID; 0|0|0|SCAN TABLE t1 USING INDEX b 0|1|1|SCAN