| 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:
(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. | ||||