SQLite

View Ticket
Login
2010-03-30
13:43 Closed ticket [f3162063fd]: Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers. plus 1 other change (artifact: 2eb0c08326 user: dan)
12:40
Do not crash when compiling an "INSERT INTO tbl DEFAULT VALUES" when tbl has either BEFORE or INSTEAD OF triggers attached to it. Ticket [f3162063fd]. (check-in: ca359a3e80 user: dan tags: trunk)
12:34 Ticket [f3162063fd] Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers. status still Open with 3 other changes (artifact: 978e7e12f2 user: drh)
11:59 New ticket [f3162063fd]. (artifact: 4f5b53a558 user: dan)

Ticket Hash: f3162063fd75dba32f0b919581c0d62ed7edbb3b
Title: Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers.
Status: Closed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Code_Generator Resolution: Fixed
Last Modified: 2010-03-30 13:43:33
15.12 years ago
Created: 2010-03-30 11:59:12
15.12 years ago
Version Found In: 3.6.23
Description:
SQLite version 3.6.23
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE t1(a, b); 
sqlite> CREATE TRIGGER tt1 BEFORE INSERT ON t1 BEGIN SELECT 1; END;
sqlite> INSERT INTO t1 DEFAULT VALUES;
Segmentation fault (core dumped)

drh added on 2010-03-30 12:34:40:
This problem appears to have been present in the code ever since the INSERT INTO ... DEFAULT VALUES construct was added in 2006 (version 3.3.8) with check-in [bc84cb54b0df]