SQLite

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;
    ...

pExpr is already NULL from caller 'exprAnalyzeOrTerm' -> affRight = sqlite3ExprAffinity(pOrTerm->pExpr->pRight);

Bisecting shows that the bug was introduced by the refactoring of COLLATE at check-in [8542e6180d4321d45b], just a few days prior to the release of version 3.7.15, and needed to address bug [71e333e7d2e642afc96d2].

So, we fixed one bug but in the process introduced another....