Could you also report the md5sum values of the resultant
test.sqlite database file for Win32/CodeWarrior, OSX and linux?
(Assuming they all have the same default pragma page_size=1024;)
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> To be really sure I rewrote the example in C linked to the official
> sqlite 3.4.2.
> Here it is my source code:
>
> #include <stdio.h>
> #include <stdlib.h>
> #include <string.h>
> #include "sqlite3.h"
>
> int main(void)
> {
> sqlite3 *db = NULL;
> int rc = SQLITE_OK;
> char sql[256];
> char **result;
> int i, nrow, ncol;
>
> // open db
> rc = sqlite3_open("test.sqlite", &db);
> if (rc != SQLITE_OK) goto abort;
>
> // create table
> rc = sqlite3_exec(db, "CREATE TABLE One (a varchar primary key, b1
> integer, b2 integer, b3 integer, z varchar);", NULL, 0, NULL);
> if (rc != SQLITE_OK) goto abort;
>
> // create index
> rc = sqlite3_exec(db, "CREATE UNIQUE INDEX idx_One ON One(b1, b2,
> b3);", NULL, 0, NULL);
> if (rc != SQLITE_OK) goto abort;
>
> // insert loop
> for (i=1; i<=100; i++)
> {
> snprintf(sql, 256, "INSERT INTO One VALUES ('%d', %d, %d, %d,
> 'A');", i, i+1, i+2, i+3);
> rc = sqlite3_exec(db, sql, NULL, 0, NULL);
> if (rc != SQLITE_OK) goto abort;
> }
>
> // query test 1
> rc = sqlite3_get_table(db, "SELECT a FROM One WHERE b1 = 99 AND b2 =
> 100 and b3 = 101;", &result, &nrow, &ncol, NULL);
> if (rc != SQLITE_OK) goto abort;
>
> for(i=0; i<ncol; ++i)
> {
> printf(result[i]);
> printf("\t\t");
> }
> printf("\n");
>
> for(i=0; i<ncol*nrow; ++i)
> {
> printf(result[ncol+i]);
> printf("\t\t");
> if (i % ncol == 0) printf("\n");
> }
>
> // free table
> sqlite3_free_table(result);
>
> // close db
> sqlite3_close(db);
>
> printf("simple test finished!\n");
> return 0;
>
> abort:
> printf("%s\n", sqlite3_errmsg(db));
> if (db != NULL) sqlite3_close(db);
> return -1;
> }
>
> On Windows (not on Mac!) it returns 99 instead of the correct 98 value.
> Anyone can confirm that on Windows?
>
> Thanks a lot.
> ---
> Marco Bambini
> http://www.sqlabs.net
> http://www.sqlabs.net/blog/
> http://www.sqlabs.net/realsqlserver/
>
>
>
> On Oct 30, 2007, at 5:15 PM, [EMAIL PROTECTED] wrote:
>
> > Marco Bambini <[EMAIL PROTECTED]> wrote:
> >>
> >> I am experiencing a very strange issue in sqlite 3.4.2 (only with the
> >> Win32 version, OSX and linux works fine).
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
