SQLite

View Ticket
Login
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]