Ticket Hash: | c2ad16f997ee9c8ed9d3cc4bc5a3da5397a074ec | ||
Title: | Segfault on query involving deeply nested aggregate views | ||
Status: | Fixed | Type: | Code_Defect |
Severity: | Critical | Priority: | Immediate |
Subsystem: | Unknown | Resolution: | Fixed |
Last Modified: |
2012-05-21 21:26:35 13.14 years ago |
Created: |
2012-05-21 03:21:05 13.14 years ago |
Version Found In: | 3.7.12 |
Description: | ||||
Running the attached script (which consists of the schema of [http://www.skrooge.org | Skrooge] following by a single query) results in a segfault. The original bug report can be seen at [https://bugs.kde.org/show_bug.cgi?id=300183] and the report on the SQLite mailing list is at [http://www.mail-archive.com/sqlite-users%40sqlite.org/msg70289.html] Bisecting suggests that the problem was inserted by check-in [430bb59d798286a86c351]. <hr><i>drh added on 2012-05-21 16:54:14:</i><br> Simpler test case: <blockquote><pre> CREATE TABLE t1(x,y); SELECT max((SELECT a FROM (SELECT count(1) AS a FROM t1))) FROM t1; </pre></blockquote> <hr><i>drh added on 2012-05-21 17:14:14:</i><br> Another simple test case: <blockquote><pre> CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; </pre></blockquote> |
Attachments:
- c2ad16f99-bug.txt [download] added by drh on 2012-05-21 03:24:26. [details]