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 �Ca : 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