SQLite

View Ticket
Login
Ticket Hash: 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:

CREATE TABLE t1(x DEFAULT(max(1)));
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.