Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread BardzoTajneKonto
> When testing, it is my usual practice to compile with > -DSQLITE_NO_SYNC=1 which turns off disk syncing. This > very definitely makes the tests run way faster. I > wonder if the Makefiles you are using are not setting > this option by default on windows but are on linux? On windows this

Re: [sqlite] CREATE TABLE fails if SQL starts with comment

2007-04-27 Thread Yuriy Martsynovskyy
Update to version version 3.3.17 has solved the problem. The issue existed in version 3.3.14 - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread Dennis Cote
[EMAIL PROTECTED] wrote: When testing, it is my usual practice to compile with -DSQLITE_NO_SYNC=1 which turns off disk syncing. This very definitely makes the tests run way faster. I wonder if the Makefiles you are using are not setting this option by default on windows but are on linux?

Re: [sqlite] CREATE TABLE fails if SQL starts with comment

2007-04-27 Thread drh
"Yuriy Martsynovskyy" <[EMAIL PROTECTED]> wrote: > When I execute the SQL code below on a newly created DB file I get an > error 'table Tab already exists', and it creates a table > > -- comment > CREATE TABLE Tab(ID); > > Code below works without error messages: > > CREATE TABLE Tab(ID); > I

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread drh
Dennis Cote <[EMAIL PROTECTED]> wrote: > > Do you, or anyone else, know why the linux version would not be > committing its changes to disk? > When testing, it is my usual practice to compile with -DSQLITE_NO_SYNC=1 which turns off disk syncing. This very definitely makes the tests run way

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread Dennis Cote
[EMAIL PROTECTED] wrote: I think that was fixed by check-in [3868]. Richard, It seems you were right again. :-) I'm not sure what caused my build to have a problem, but after building and running the test suite on Linux with no problems, I rebooted into Windows. I did a make clean and

[sqlite] CREATE TABLE fails if SQL starts with comment

2007-04-27 Thread Yuriy Martsynovskyy
When I execute the SQL code below on a newly created DB file I get an error 'table Tab already exists', and it creates a table -- comment CREATE TABLE Tab(ID); Code below works without error messages: CREATE TABLE Tab(ID);

[sqlite] Don't increment on "INSERT or IGNORE" conflict

2007-04-27 Thread Federico Cáceres
Hi! I have been reading through the mailing list and found this post in which someone had the same problem as i had (message 15355 I think, posted by drh), where I don't want the autoincrement column to autoincrement when INSERT or IGNORE is forced to ignore the insert. I tried the replace

Re: [sqlite] Odd performance issue under Windows - correction

2007-04-27 Thread John Stanton
John Elrick wrote: John Stanton wrote: John Elrick wrote: John Stanton wrote: I would look at the disk controller/disk drive hardware and the software driver to see if they are reporting correctly to the OS. Some of your numbers are too fast for regular disk technology and suggest

Re: [sqlite] Odd performance issue under Windows - correction

2007-04-27 Thread John Elrick
John Stanton wrote: John Elrick wrote: John Stanton wrote: I would look at the disk controller/disk drive hardware and the software driver to see if they are reporting correctly to the OS. Some of your numbers are too fast for regular disk technology and suggest that there are either

Re: [sqlite] Odd performance issue under Windows - correction

2007-04-27 Thread John Stanton
John Elrick wrote: John Stanton wrote: The real time with the pragma off is 1.78 seconds. The real time on the "faster" machine is 8.4 seconds. When I set the synchronous pragma to off on the "faster" machine, the time drops to 1.64. John Do your various machines use the same hard disk

Re: [sqlite] Odd performance issue under Windows - correction

2007-04-27 Thread John Elrick
John Stanton wrote: The real time with the pragma off is 1.78 seconds. The real time on the "faster" machine is 8.4 seconds. When I set the synchronous pragma to off on the "faster" machine, the time drops to 1.64. John Do your various machines use the same hard disk controller and

Re: [sqlite] Odd performance issue under Windows - correction

2007-04-27 Thread John Stanton
John Elrick wrote: John Elrick wrote: John Elrick wrote: Griggs, Donald wrote: John Elrick wrote: "what the heck is happening that is creating a better than order of magnitude difference in execution time on five out of seven Windows machines?". John, If the database is

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-27 Thread Klemens Friedl
Please provide the processed source package, as it has been the case for SQLite before. "The Amalgamation" big c file (plus header file) might be an (optional) neat package, but the standard processed source package shall be still available. The http://www.sqlite.org/sqlite-source-3_3_17.zip

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-27 Thread Clark Christensen
In general, I agree. I miss the zipped set of pre-processed C source. Since you have the Linux-based build system at your disposal, you can get what you're used to having with make target_source on the Linux system. This creates a tsrc directory containing the familiar pre-processed C

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread Dennis Cote
[EMAIL PROTECTED] wrote: Dennis Cote <[EMAIL PROTECTED]> wrote: Have you tried to run the latest laststmtchanges.test on Windows? I am still getting a failure that shows the same double counting that was originally reported on the mailing list. laststmtchanges-1.2.1... Expected:

[sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-27 Thread Bennett, Patrick
The last time I downloaded SQLite was version 3.3.12. For that version (and many prior versions), I could download a preprocessed archive containing all of the source code, except parse.h, parse.c and opcode.h(? - this is from memory) were the 'generated' versions. The source for the command-line