This bug was fixed (we just went though this last week). Download a recent fossil repository and you'll be good. Sounds kind of like it's time for a new release to me. Is there any planned time for 3.7.0? Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: [email protected] on behalf of Samuel Adam Sent: Mon 5/17/2010 8:29 AM To: [email protected] Subject: [sqlite] Crash SQLite [version: 3.6.23.1; tested: shell] CREATE TABLE "Test" ("Number" INTEGER DEFAULT (123)); -- Was originally a dynamic default with strftime(). -- Cut down for test case/to find crash. CREATE TRIGGER "Automatic" BEFORE INSERT ON "Test" BEGIN DELETE FROM "Test"; END; INSERT INTO "Test" DEFAULT VALUES; -- Crash here. (Yes, I have an actual use case; that's how I found the bug.) Most recent version tested: * SQLite version 3.6.23.1 * Application tested: sqlite3.exe shell from sqlite.org (file date 2010-03-29) * Platform tested: Windows * Dr. Watson claimed exception number c0000005 (access violation): "The exception generated was c0000005 at address 00436B85 (<nosymbols>)" * A few other versions and configurations have crashed as well. * First noticed in SQLite 3.6.19. Plug for outstanding feature request: DECIMAL type (such as IEEE 754-2008 BCD format). Why? Humans use decimal; computers ought be made to serve humans, not vice versa; and if you put a penny into a database, you should be able to get a penny back out. Very truly, Samuel Adam http://certifound.com/+A 763 Montgomery Road * Hillsborough, New Jersey (U.S.) Justice: http://certifound.com/ Spotlight: http://certifound.com/+A9097BE/JPMorgan.Chase.delenda.est. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
