SQLite
Ticket Change Details
Not logged in
Overview

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

  1. Change foundin to "3.7.15"
  2. Change icomment to:
    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. Change login to "nobody"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change private_contact to "2ed04df9406b2968426cb33430a95417205dd79f"
  6. Change severity to "Critical"
  7. Change status to "Open"
  8. Change title to:
    crash when filtering twice by same predicate using aliases
    
  9. Change type to "Code_Defect"