SQLite
View Ticket
Not logged in
Ticket UUID: 3a88d85f36704eebe134f7f48aebf00cd6438c1a
Title: Segfault when a DEFAULT value contains an aggregate function
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-08-06 00:29:20
Version Found In: 3.8.5
User Comments:
drh added on 2014-08-05 20:51:51: (text/x-fossil-wiki)
The following SQL script segfaults while running the INSERT statement:

<blockquote><verbatim>
CREATE TABLE t1(x DEFAULT(max(1)));
INSERT INTO t1(rowid) VALUES(1);
</verbatim></blockquote>

The problem appears to be the use of an aggregate function as part of
the default value for a column.  This problem has been in the code
since at least 2006-01-01 and probably before that.  This problem was
detected and reported on the sqlite-users@sqlite.org mailing list by
Zsb√°n Ambrus.