[EMAIL PROTECTED] wrote:
Can you come up with a minimal test case that exhibits this behaviour? Ideally, it would be a series of SQL statements written into the sqlite shell program that results in something visibly wrong. The second best case would be a short (10-20 line) C program that uses the sqlite API only to demonstrate the problem. Perhaps other users of this list could test on their own machines and come up with more information.
Thanks. I'll certainly try. But it is very elusive. The exact same query works fine on some machines and doesn't on others. And that's with the exact same binary executable. We even copied the executable from one machine that works to another machine that doesn't. For now we have moved back to an older version of SQLite and that seems to have fixed the problem.
