Re: [sqlite] Locking issue on NFS filesystem

2010-06-13 Thread Simon Slavin
On 14 Jun 2010, at 3:16am, Prakash Reddy Bande wrote: > I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5 > (But use caution: this locking mechanism might not work correctly if the > database file is kept on an NFS filesystem.) > > The question is, do we have a

[sqlite] Locking issue on NFS filesystem

2010-06-13 Thread Prakash Reddy Bande
Hi, I have stumbled upon the issue as described in http://sqlite.org/faq.html#q5 (But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem.) The question is, do we have a workaround. Our application has to store data in user home

Re: [sqlite] [bug] documentation error SELECT statement GROUP BY clause

2010-06-13 Thread Jay A. Kreibich
On Sun, Jun 13, 2010 at 10:04:51PM +0200, Kees Nuyt scratched on the wall: > There appears to be an error in the description of the > SELECT statement on http://www.sqlite.org/lang_select.html . The syntax diagrams have several instances of things that the diagrams allow, but are not legal

[sqlite] [bug] documentation error SELECT statement GROUP BY clause

2010-06-13 Thread Kees Nuyt
Hi, There appears to be an error in the description of the SELECT statement on http://www.sqlite.org/lang_select.html . The GROUP BY clause in the select-core part http://www.sqlite.org/images/syntax/select-core.gif refers to ordering-term. Ordering-term

[sqlite] SqlLite not working properly after large data integration tests

2010-06-13 Thread Lake Lake
I have a lengthy question about sqllite, involving a problem with the repeatability of a test harness that uses a sqllite in-memory database. I have posted it on stackoverflow: