>-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
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
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
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:
>
>
(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
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
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
7 matches
Mail list logo