Hello all, I'm new to this mailing list and I guess I found a bug in SQLite.
I'm not sure how to use this mailing list since this is the first time I'm using one. so I will just append the plain sql file to this email with an backtrace generated with gdb. Running the sqlite3 CLI interface with the parameters -init twdata.sql twdata.db crashes the SQLite library with a segfault. It seems this happens only on the new 3.6.12 version. An older version of the library on another Computer doesn't crash. But I can't insert any rows into the userMailBox table. cheers.
$ gdb --args /usr/bin/sqlite3 -init twdata.sql twdata.db GNU gdb 6.8 Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "i686-pc-linux-gnu"... (no debugging symbols found) (gdb) r Starting program: /usr/bin/sqlite3 -init twdata.sql twdata.db (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) (no debugging symbols found) [Thread debugging using libthread_db enabled] (no debugging symbols found) (no debugging symbols found) -- Loading resources from twdata.sql [New Thread 0xb7cb86c0 (LWP 1947)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0xb7cb86c0 (LWP 1947)] 0xb7eb3ad1 in exprNodeIsConstant () from /usr/lib/libsqlite3.so.0 (gdb) backtrace #0 0xb7eb3ad1 in exprNodeIsConstant () from /usr/lib/libsqlite3.so.0 #1 0xb7eb36ef in sqlite3WalkExpr () from /usr/lib/libsqlite3.so.0 #2 0xb7eb3712 in sqlite3WalkExpr () from /usr/lib/libsqlite3.so.0 #3 0xb7ee71a1 in sqlite3ExprCodeTarget () from /usr/lib/libsqlite3.so.0 #4 0xb7ee8299 in sqlite3ExprCode () from /usr/lib/libsqlite3.so.0 #5 0xb7efa9ce in sqlite3Insert () from /usr/lib/libsqlite3.so.0 #6 0xb7f05bed in sqlite3Parser () from /usr/lib/libsqlite3.so.0 #7 0xb7f085da in sqlite3RunParser () from /usr/lib/libsqlite3.so.0 #8 0xb7f0c519 in sqlite3Prepare () from /usr/lib/libsqlite3.so.0 #9 0xb7f0cbde in sqlite3LockAndPrepare () from /usr/lib/libsqlite3.so.0 #10 0xb7ef7465 in sqlite3_exec () from /usr/lib/libsqlite3.so.0 #11 0x0804e57c in ?? () #12 0x09b157f0 in ?? () #13 0x09b27500 in ?? () #14 0x0804b310 in ?? () #15 0xbfc41c9c in ?? () #16 0xbfc41c48 in ?? () #17 0x08048e56 in ?? () #18 0x0000002d in ?? () #19 0x00000000 in ?? () (gdb) q The program is running. Exit anyway? (y or n) y
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
