Care to show all of your steps? Not that my BS flag is waving but you're
correct that this is very odd.
What OS?
What version sqlite?
Shell from website or did you compile?
Local file?
Does it persist across a reboot?
Are you running ANY 3rd party software?
Try uninstalling your anti-virus.
D:\>mkdir dennis
D:\>cd dennis
D:\dennis>dir
Volume in drive D is Apps
Volume Serial Number is C43B-2252
Directory of D:\dennis
06/29/2012 07:24 AM <DIR> .
06/29/2012 07:24 AM <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 202,760,232,960 bytes free
D:\dennis>sqlite3 mydbname.ext
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma journal_mode=wal;
wal
sqlite> create table t(a);
sqlite> insert into t values(1);
sqlite> .quit
D:\dennis>dir
Volume in drive D is Apps
Volume Serial Number is C43B-2252
Directory of D:\dennis
06/29/2012 07:25 AM <DIR> .
06/29/2012 07:25 AM <DIR> ..
06/29/2012 07:25 AM 2,048 mydbname.ext
1 File(s) 2,048 bytes
2 Dir(s) 202,760,228,864 bytes free
D:\dennis>del mydbname.ext
D:\dennis>sqlite3 mydbname.ext
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite> .quit
D:\dennis>dir
Volume in drive D is Apps
Volume Serial Number is C43B-2252
Directory of D:\dennis
06/29/2012 07:25 AM <DIR> .
06/29/2012 07:25 AM <DIR> ..
06/29/2012 07:25 AM 0 mydbname.ext
1 File(s) 0 bytes
2 Dir(s) 202,760,232,960 bytes free
D:\dennis>del mydbname.ext
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Dennis Volodomanov [i...@psunrise.com]
Sent: Friday, June 29, 2012 6:47 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] An interesting (strange) issue with selects
Ok, tried using the shell and the result is the same as using my app.
What I did is:
1) delete the database file ("mydbname.ext") from the DOS prompt, make
sure the file is not there
2) run "sqlite3 .\mydbname.ext" from within that same folder, same DOS
prompt
3) type .dump
4) see entries in this DB, which should be impossible, since the file
wasn't there and I've issued no commands using the shell tool
Weird?
Dennis
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
