R1 - Derived-table JOIN ON applies wrong affinity for TEXT <= INTEGER

```sql
CREATE TABLE l(txt TEXT);
CREATE TABLE r(flag INTEGER);
INSERT INTO l VALUES ('');
INSERT INTO r VALUES (0);

SELECT 'inner', L.txt, R.flag
FROM (SELECT txt FROM l) AS L
JOIN r AS R ON L.txt <= R.flag
UNION ALL
SELECT 'cross', L.txt, R.flag
FROM (SELECT txt FROM l) AS L
CROSS JOIN r AS R
WHERE L.txt <= R.flag
ORDER BY 1, 2, 3;
```

  Turso:  inner||0

  SQLite: <empty>