Re: [sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

2009-03-04 Thread Dan
Create an sql dump using the ".dump" command of the sqlite3 shell tool: $ echo .dump | sqlite3 database_file.db > dump.sql Or just put the database file up for download somewhere. Or if you prefer, send it to me by email. If this bug is present in current versions, we need to fix it. But it's

Re: [sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

2009-03-04 Thread Jonathon
Thanks Dan for the reply, How would I go about creating a sql dump? As for the ORDER BY clause, I do this: SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id = d.id AND c.e_id = e.id ORDER BY a.some_ot

Re: [sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

2009-03-03 Thread Dan
On Mar 4, 2009, at 4:41 AM, Jonathon wrote: > Hello, > > I am executing a query such as: Can you post a database (or sql dump thereof) to run your queries against? Also say exactly what ORDER BY clause you are adding to the end of the query that causes it to return incorrect results? Thanks, Da

[sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

2009-03-03 Thread Jonathon
Hello, I am executing a query such as: 1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id = d.id AND c.e_id = e.id; 2. 3. CREATE TABLE tableA ( 4. id INTEGER NOT NULL