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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
