SQLite

The query at the end of the following SQL raises an assertion fault:

CREATE VIRTUAL TABLE fts USING fts4(content TEXT);
CREATE TABLE t1(x TEXT PRIMARY KEY, y);
SELECT DISTINCT fts.rowid, t1.x
  FROM fts, t1
 WHERE fts MATCH 'hello world'
   AND content=x
 ORDER BY y;

This problem was introduced with the Next Generation Query Planner by check-in [0fe31f60cadc5fe5] on 2013-06-26 for version 3.8.0. The problem was first detected by RedHat (see https://bugzilla.redhat.com/show_bug.cgi?id=1075889).