On Tue, Aug 5, 2014 at 4:55 PM, Richard Hipp <d...@sqlite.org> wrote:
> > > > 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 > Preliminary fix here: http://www.sqlite.org/src/info/29ba812825bf We'll do more testing before closing the ticket. > > > >> >> 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users