Re: [sqlite] Bug where query does not give a result while it should

2013-12-18 Thread Harmen de Jong - CoachR Group B . V .
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy Sent: woensdag 18 december 2013 16:23 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug where query does not give a result while it should >> Are we

Re: [sqlite] Bug where query does not give a result while it should

2013-12-18 Thread Dan Kennedy
On 12/18/2013 10:10 PM, Harmen de Jong - CoachR Group B.V. wrote: We have found a query that does not give a result, while it should. The query is: select id from productionentry where id NOT IN (select productionentryid from zentry) AND examid=12581; There are rows in the table productionentry

[sqlite] Bug where query does not give a result while it should

2013-12-18 Thread Harmen de Jong - CoachR Group B . V .
We have found a query that does not give a result, while it should. The query is: select id from productionentry where id NOT IN (select productionentryid from zentry) AND examid=12581; There are rows in the table productionentry for which the id does not exist in the column productionentryid in

[sqlite] virtual tables and group by: how could we prevent to retrieve all rows from a vtab and sort them later ?

2013-12-18 Thread Perrin, Lionel
Hello, I plan to use sqlite to implement an 'aggregation tool'. Basically, the design would be the following: 1. I implement a virtual table CFL(contract, amount) which may provide up to 1 billion unsorted rows. 2. The aggregation phasis will be defined at run time and may consist

Re: [sqlite] General R*Tree query

2013-12-18 Thread Brian T. Carcich
On Wed, Dec 18, 2013 at 1:53 AM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Perhaps this is a weird way for me to get deeper knowledge of R trees, and > because I vaguely remember that Tyco refers to a specific epoch in which > coordinates are defined, but would it be possible to se

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013-12-18 Thread Jan Nijtmans
2013/12/17 margave : > Well, I gave up on sqlite inside of Cygwin. > > I found a standalone sqlite3.exe that does not depend upon (or install with) > Cygwin. > It's from http://www.sqlite.org > One executable, no .dlls ... and it just runs, no problems. I think I know what's the problem: The SQLit