Anti-join incorrectly handles ASCII control characters, such as "SOH" (start of heading), by failing to respect their correct ordering (e.g., "SOH" < a < b < d < e). This results in incorrect output.

Create a file test.sql and fill test.sql with follow sql statements. Notably, there is a ASCII control character "SOH"(start of heading),before letter "c".

CREATE TABLE IF NOT EXISTS t0(c0 TINYTEXT);
CREATE TABLE IF NOT EXISTS t1 LIKE t0;
INSERT INTO t0(c0) VALUES("b"), ("
c"), ("d");
INSERT INTO t1(c0) VALUES('a'), ('e');
CREATE INDEX i1 ON t0(c0(1));

Then, execute SQL from file. For example: source /test.sql

The result set of a left join should equal the union of an anti-join and a inner-join. However, the results do not fit this equation, so we find this bug.

SELECT t1.c0 FROM t1 WHERE NOT EXISTS (SELECT 1 FROM t0 WHERE t1.c0 < t0.c0);
–

SELECT t1.c0 FROM t1 INNER JOIN t0 ON t1.c0 < t0.c0;
–

SELECT t1.c0 FROM t1 LEFT JOIN t0 ON t1.c0 < t0.c0;
–