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: (text/x-fossil-wiki)
The INSERT statement at the end of the following SQL causes SQLite to enter
an infinite loop:

<blockquote><verbatim>
CREATE TABLE tab1( value INTEGER);
INSERT INTO tab1 (value, _rowid_) values( 11, 1);
INSERT INTO tab1 (value, _rowid_) SELECT 22,2;
</verbatim></blockquote>

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