SQLite

Ticket Change Details
Login
Overview

Artifact ID: 275fd25264eb6e22aeb8ccf626dac6e82bd2a860
Ticket: a7b7803e8d1e8699cd8a460a38133b98892d2e17
crash when filtering twice by same predicate using aliases
User & Date: anonymous 2012-12-19 15:01:05
Changes

  1. foundin changed to: "3.7.15"
  2. icomment:
    Try the following:
    <pre>
     create table name (
       type integer,
       path text primary key);
    
     select (name.type = 0) as container from Name name where name.type = 0 or    container order by name.path
    </pre>
    ---
    
    The select statement crashes during query preparation.
    
    
    [7b96115e81deab0aa0472839cf787ba3f2fc64a7]
    
    <pre>
      char sqlite3ExprAffinity(Expr *pExpr){
        int op;
        pExpr = sqlite3ExprSkipCollate(pExpr);
        int op = pExpr->op;                               
        op = pExpr->op;
        ...
    </pre>
    last line crashes because sqlite3ExprSkipCollate returns null.
    
  3. login: "nobody"
  4. mimetype: "text/x-fossil-wiki"
  5. private_contact changed to: "2ed04df9406b2968426cb33430a95417205dd79f"
  6. severity changed to: "Critical"
  7. status changed to: "Open"
  8. title changed to:
    crash when filtering twice by same predicate using aliases
    
  9. type changed to: "Code_Defect"