SQLite: Ticket Change Details

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

Change foundin to "3.7.15"

Change icomment to:

Try the following:
 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
---
The select statement crashes during query preparation.
7b96115e81deab0aa0472839cf787ba3f2fc64a7
  char sqlite3ExprAffinity(Expr *pExpr){
    int op;
    pExpr = sqlite3ExprSkipCollate(pExpr);
    int op = pExpr->op;                               
    op = pExpr->op;
    ...
last line crashes because sqlite3ExprSkipCollate returns null.

Change login to "nobody"
Change mimetype to "text/x-fossil-wiki"
Change private_contact to "2ed04df9406b2968426cb33430a95417205dd79f"
Change severity to "Critical"
Change status to "Open"
Change title to:

crash when filtering twice by same predicate using aliases
Change type to "Code_Defect"