/ View Ticket
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference
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:

The following SQL script segfaults while running the INSERT statement:

INSERT INTO t1(rowid) VALUES(1);

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.