SQLite

Ticket Change Details
Login
History Page Plaintext Raw Timeline
Overview

Artifact ID: cc3683f6f84c9f5bca9e275e1358fdf7ec8672fa
Ticket: e9654505cfda93610585fde5a9bbf2e730c8a8d5
Inifinite loop in INSERT statement.
User & Date: drh 2014-05-23 10:15:44
Changes

  1. foundin changed to: "3.8.4.3"
  2. icomment: 
    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.
  3. login: "drh"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Severe"
  6. status changed to: "Open"
  7. title changed to: "Inifinite loop in INSERT statement."
  8. type changed to: "Code_Defect"