It persists across a reboot?
You can create a database, delete it, reboot, and your app will still see the
original table?
All I can say is wow...your system is really hosed.
Even anti-virus shouldn't cause that. This would infer some sort of caching
that is semi-permanent.
Have you got a 2nd computer you can test this on?
Would you be willing to share your app so others can check this? As "House"
used to say..."interesting".
I've got XP x64 and Windows 7 32-bit I can test.
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 8:57 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] An interesting (strange) issue with selects
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
