On Tue, Aug 5, 2014 at 4:15 PM, Zsbán Ambrus <amb...@math.bme.hu> wrote:
> 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; > The ticket is here: www.sqlite.org/src/tktview/3a88d85f3670 > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
