Michael,
It works using the shell with one simple table, so I'm investigating
this further to see if I can get this to break using the shell (by
adding pragmas, triggers, indexes, from my code). This is on a new file
in a different folder to the other test.
The OS is Windows 7 x64, SQLite 3.7.13 from the site. Local file,
persists across a reboot. Not sure about your question regarding 3rd
party software - there's a lot of software that I run, of course?
Antivirus, hmm, maybe... Need to try and get it to happen using the shell.
Dennis
On 29/06/2012 10:35 PM, Black, Michael (IS) wrote:
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
