SQLite

View Ticket
Login
2014-05-23
11:51 Fixed ticket [e9654505]: Inifinite loop in INSERT statement. plus 5 other changes (artifact: 8389cd6e user: drh)
11:48
Make sure sufficient VDBE registers are allocated for an INSERT...SELECT when there is an idlist on the insert table that includes an explicit rowid. Ticket [e9654505cfda93610585fde5a9bbf2e730c8a8d5] (check-in: 9a2dd187 user: drh tags: trunk)
10:15 New ticket [e9654505] Inifinite loop in INSERT statement.. (artifact: cc3683f6 user: drh)

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.