“PS. I was truly impressed with Richard Hipp fixing each and every of these cases within a couple of hours of sending in a report.”

CREATE VIRTUAL TABLE t0 USING fts4(x,order=DESC);
INSERT INTO t0(docid,x)VALUES(-1E0,'0(o');
INSERT INTO t0 VALUES('');
INSERT INTO t0 VALUES('');
INSeRT INTO t0 VALUES('o');
SELECT docid FROM t0 WHERE t0 MATCH'"0*o"';

I would love to know why it needs that lowercase “e” to trip the bug.