|Title:||Segfault when a DEFAULT value contains an aggregate function|
|Last Modified:||2014-08-06 00:29:20|
|Version Found In:||3.8.5|
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 firstname.lastname@example.org mailing list by Zsbán Ambrus.