hello,
i just notice something strange in sqlite. i have a db
file which is a copy of another one(not a symlink).
when i delete one row from a table in one db file and
the same row got delete from the same table in the
other db file as well. this happens when i tried
dropping a table.
this is debian stable, sqlite 3.2.1 ( yeah, i know
this is bit of too old )
% sudo sqlite3 restaurants.db
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> select * from tmp_suggest;
1|1||75|56||1|1|||||||||||1164260861|1164260861||0||||||
sqlite>
% sudo sqlite3 restaurants.db.13
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> select * from tmp_suggest;
1|1||75|56||1|1|||||||||||1164260861|1164260861||0||||||
sqlite> delete from tmp_suggest;
sqlite> select * from tmp_suggest;
sqlite>
% sudo sqlite3 restaurants.db
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> select * from tmp_suggest;
sqlite>
##### tried dropping one table. same thing happened,
% sudo sqlite3 restaurants.db
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> drop table tmp_suggest;
sqlite>
% sudo sqlite3 restaurants.db.13
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> .schema tmp_suggest
at last, i tried making the second copy of the db
file. and the problem went away. has anyone seen this
before?
James.
____________________________________________________________________________________
Sponsored Link
Mortgage rates near 39yr lows.
$420k for $1,399/mo. Calculate new payment!
www.LowerMyBills.com/lre
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
