SQLite

Ticket Change Details
Login
Overview

Artifact ID: ff39df430cac1438494888df20e11d1a634d6be6
Ticket: d58ccbb3f1b7cf54cdac178799408816fb7c073f
Segmentation fault on a valid query with "union"
User & Date: anonymous 2013-01-28 10:28:40
Changes

  1. foundin changed to: "3.7.15.2"
  2. icomment:
    The following SQL run in a shell generates a segmentation fault: 
    
    <pre>create view v0 as select 0 as n;
    create view v1 as select * from v0 union select * from v0;
    create view v2 as select * from v1 union select * from v1;
    create view v3 as select * from v2 union select * from v2;
    create view v4 as select * from v3 union select * from v3;
    create view v5 as select * from v4 union select * from v4;
    create view v6 as select * from v5 union select * from v5;
    create view v7 as select * from v6 union select * from v6;
    create view v8 as select * from v7 union select * from v7;
    create view v9 as select * from v8 union select * from v8;
    create view v10 as select * from v9 union select * from v9;
    create view v11 as select * from v10 union select * from v10;
    create view v12 as select * from v11 union select * from v11;
    create view v13 as select * from v12 union select * from v12;
    create view v14 as select * from v13 union select * from v13;
    create view v15 as select * from v14 union select * from v14;
    create view v16 as select * from v15 union select * from v15;
    create view v17 as select * from v16 union select * from v16;
    create view v18 as select * from v17 union select * from v17;
    create view v19 as select * from v18 union select * from v18;
    create view v20 as select * from v19 union select * from v19;</pre>
    
    This fault has been present in the code since version 3.7.15.2, 2013-01-09 and early.
    
  3. login: "anonymous"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to: "Segmentation fault on a valid query with "union""
  8. type changed to: "Code_Defect"