Hello, 

my system is: 

QNX 6.3.0 on PowerPC 
SQLITE 3.7.5

In my example I have the following databases:

data.s3db
configuration.s3db
definition.s3db

I made an sqlite_open() with data.s3db and sqlite_exec() with the other two 
databases.

i detected the following bug:

-the "definition.s3db" is attached as the third database.
 if I do some changes in this database with the command interpreter "sqlite3" 
and try to 
 read the changes in the database i get always the old (prior) data. 

- if I make a reboot, and then a select again I get the same old data

- if I change the order of attach, so i place my "definition.s3db" on the 
second position, 
  then it works. 

finally:
the first db that i open with sqlite_open is ok. 
the second db that i "attach" with sqlite_exec is ok. 
all other dbs deliver sometimes old data 

hope you can reproduce this behavior 
if you need test databases, please contact me 
i can deliver such files 


best regards

Norbert Hübsch
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to