SQLite

View Ticket
Login
Ticket Hash: e9654505cfda93610585fde5a9bbf2e730c8a8d5
Title: Inifinite loop in INSERT statement.
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2014-05-23 11:51:48
Version Found In: 3.8.4.3
User Comments:
drh added on 2014-05-23 10:15:44:

The INSERT statement at the end of the following SQL causes SQLite to enter an infinite loop:

CREATE TABLE tab1( value INTEGER);
INSERT INTO tab1 (value, _rowid_) values( 11, 1);
INSERT INTO tab1 (value, _rowid_) SELECT 22,2;

Bisecting shows that this bug was introduced by check-in [a72687699ba2af2e7] for version 3.8.4.