Dear sqlite3 maintainers, I've got a segmentation fault when trying to execute the following two statements in the sqlite 3.8.5 command line program:
CREATE TABLE tab(amt DEFAULT (max(1))); INSERT INTO tab DEFAULT VALUES; I believe this is a bug, because the vanilla command line should not segfault from an invalid command, and should give some error message instead. The statement has an error because max(1) is a call to an aggregate function so should only appear in a result column of a SELECT statement or similar contexts, not in a column default. I don't load any database for this, so the command line starts from a new temporary database with empty schema and default settings. The command line reports its version as "SQLite version 3.8.5 2014-06-04 14:06:34". It is running on a debian-based linux x86-64 machine. I have built it from the sqlite-amalgamation-3080500 source to x86-64 application with a vanilla gcc 4.8.1 with the following compiler command line: gcc -Wall -ldl -lpthread -O2 -o sqlite3 shell.c sqlite3.c If you need any further information for reproducing this bug, please contact me. -- Ambrus _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
