On Mon, May 17, 2010 at 9:29 AM, Samuel Adam <a...@certifound.com> wrote:
> 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.
>
http://www.sqlite.org/src/info/f3162063fd
>
> (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
>
--
---------------------
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
