I've managed to break a database, and I think it's related to defining new text collating sequences in Tcl. If I run "VACUUM" on it, it works fine again. I was told that this would likely be a bug in SQLite.
I've created a tarball with my broken database, and a small Tcl script that showcases the problem. The script gets the all the elements in a column, and proceed to "SELECT foo FROM table WHERE foo=foo" for all of the elements. This fails for some of them on the broken database, but succeeds after I VACUUM it. Here's the tarball with the database and script: http://www.pix.pp.se/sqlite-bork.tar.gz -- Rickard Utgren _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
