[cl-sqlite-devel] sqlite test failing

[Antony]

On 12/15/2010 10:37 AM, Kalyanov Dmitry wrote:
> On Sat, 2010-12-11 at 23:58 -0800, Antony wrote:
>> Hi
>>
>> I just tried the sqlite tests (mostly out of curiosity)
>> and I got the results below.
>> I was wondering if this is expected or not.
>> My current environment is Windows 7 and
>>    Clozure Common Lisp Version 1.6-r14468M  (WindowsX8664)
Mystery solved. Things are good. Here's what happened.

The test code uses
   (defparameter *db-file* "/tmp/test.sqlite")
which does not work for windows.

The tests when run as is give the error
   "Could not open sqlite3 database /tmp/test.sqlite"
I tried to run it as
(let ((sqlite-tests::*db-file* "c:/D/temp/tests.tmp.sqlite"))
            (fiveam:run! 'sqlite-tests::sqlite-suite))
this gives the error
"One of inserter threads encountered a SQLITE_BUSY error"

This is misleading. What is happening is that the main thread code that 
does file checks now finds the new binding for
*db-file* and stops showing the previous error. But the thread function 
still sees the global binding (since i have not done any thread specials 
setup)

Long story short, I just changed the variable to a windows kind of path 
just to make sure the tests run ok, and they did.
They still fail sometime, but I can see why.
Thanks for the library,
-Antony