SQLite Forum

A crash bug in function isLikeOrGlob()
Login
The best I could do is shown in the [test case][1] that is included with
the fix.

> ~~~~
  CREATE TABLE t0(a PRIMARY KEY,b TEXT AS ('2') UNIQUE);
  SELECT * FROM t0 AS x JOIN t0 AS y
   WHERE x.b='2'
     AND (y.a=2 OR (x.b LIKE '2*' AND y.a=x.b));
~~~~

So I was able to take off the "WITHOUT ROWID" from the table definition,
and remove the "likely()" term from the WHERE clause.  I wasn't able to
simplify beyond that.

The problem arose for a tricky and unlikely interaction between:

   *   The LIKE optimizer
   *   The OR optimizer
   *   Generated columns


[1]: src:/fdiff?v1=6912c4280d0ad26d&v2=1b63f8c00154e587