SQLite

For example:

<verbatim>
  PRAGMA recursive_triggers = 1;

  CREATE TABLE t1(a);
  CREATE INDEX i1 ON t1(a);
  CREATE TABLE t3(c);

  CREATE TRIGGER tr AFTER INSERT ON t3 BEGIN
    INSERT INTO t3 SELECT new.c+1 WHERE new.c<5;
    SELECT * FROM t1 WHERE a IN (1, 2, 3, 4);
  END;

  INSERT INTO t3 VALUES(2);
</verbatim>

The trigger above uses an ephemeral table for the IN(...) results. Running the sample above causes a segfault (or assert() failure if SQLITE_DEBUG is defined).

The problem was introduced by check-in [6bf5ba10d28f1b0a32] on 2016-09-18
and first appeared in version 3.15.0.