Re: [sqlite] sqlite3 hangs on query

2017-02-16 Thread Jens-Heiner Rechtien
On 15/02/2017 23:36, Richard Hipp wrote: On 2/15/17, Richard Hipp wrote: It is an optimization opportunity, not a bug. That optimization is now on trunk. Very cool! Thanks, - Heiner ___ sqlite-users mailing list

Re: [sqlite] sqlite3 hangs on query

2017-02-15 Thread Jens-Heiner Rechtien
0.000317 sys 0.000248. Note that the *space* table is empty, so the expected result of the cross join in the first query would be an empty result set. With a slightly different data set this is just what I get. Thanks, - Heiner On 14/02/2017 13:33, Jens-Heiner Rechtien wrote: Hi SQLite

[sqlite] sqlite3 hangs on query

2017-02-14 Thread Jens-Heiner Rechtien
7.0 (Linux Fedora 24), 3.14.0 (iOS 10), always the same behavior. Many thanks for your consideration and especially for your great tool. Heiner -- Jens-Heiner Rechtien <jrech...@adobe.com <mailto:aw...@adobe.com>> Computer Scientist Adobe Systems Engineering GmbH Große Elbst