SQLite

Ticket Change Details
Login
Overview

Artifact ID: cabcf4a364788b08384123240aaf412db4493c93
Ticket: bfbf38e5e9956ac69f9491e5112636ff2ecef923
Segfault on a nested join
User & Date: drh 2012-11-02 15:14:42
Changes

  1. Appended to comment:
    
    
    <hr><i>drh added on 2012-11-02 15:14:42:</i><br>
    An even simpler demonstration that omits the subquery in the FROM clause:
    
    <blockquote><pre>
    CREATE TABLE t1(id1, value1);
    INSERT INTO t1 VALUES(4469,2),(4469,1);
    CREATE TABLE t2 (value2);
    INSERT INTO t2 VALUES(1);
    SELECT (SELECT sum(value2=value1) FROM t2), max(value1)
      FROM t1
     GROUP BY id1;
    </pre></blockquote>