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.

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