> Even though it had been fixed in 3.6.23, why I could reproduce it? Actually it's found in version 3.6.23 and fixed in the trunk of SQLite repository but SQLite didn't have a release since then. So this bug will be fixed in the next version.
Pavel 2010/6/8 陶渊俊 <yuanjun....@dragonsoftit.com>: > This is my first time to reply email of gmane-news. > so if there is anything wrong, please forgive me. > > > >>Which operating system are you running ? > > > >>Are you running your code in the command-line program or with your own > program ? > > > >>If you are running your own program, are you accessing SQLite with the C > functions, or are you using a library > >>someone else made ? > > > >>Simon. > > > > My operating system is fedora10. > > Uname -a : > > Linux localhost.localdomain 2.6.22.18-co-0.7.5 #1 PREEMPT Mon Sep 14 > 22:21:15 UTC 2009 i686 i686 i386 GNU/Linux > > > > Yesterday, I only tested it in the command line. > Today, I tested example program. The result was as same as command line. > The program I used was a example: > > http://www.sqlite.org/quickstart.html > > > >>Information on this page: http://www.sqlite.org/lang_createtrigger.html > >>Reads: > >> The "INSERT INTO *table* DEFAULT VALUES" form of the >>INSERT<http://www.sqlite.org/lang_insert.html>statement is not >>supported. > >>I do not think it is a problem/defect/bug. What say? > >>Harsha > > I had read this page, what the page said is that sqlite doesn`t support a > "DEFAULT VALUES" form of the INSERT statement with a trigger. > > > > > > > But I think even though sqlite doesn`t support it, the core dump is > a fatal error, it will crash the totall program which is using sqlite. > > > Whatever user do, at least there should be dump an error to the control > or err-log like "DEFAULT VALUES with trigger is not supported by sqlite!" > > > and let the main program continue rather than a core dump. > So I think it is a bug. > >> Known bug. Fixed: > >> http://www.sqlite.org/src/info/f3162063fd > >> -j > >>-- >>Jay A. Kreibich < J A Y @ K R E I B I.C H > > > Yeah, my investigation is from the email: > > > http://thread.gmane.org/gmane.comp.db.sqlite.general/56571 > > > > > > So I had read the page what you provided. > > > Even though it had been fixed in 3.6.23, why I could reproduce it? > > > My sqlite version is 3.6.23.1, Need I some lately update?or patch? > > -bash-3.2# sqlite3 -version > 3.6.23 > -bash-3.2# > > Thanks for all reply. > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users