sql: comparison overload not found

This issue tracks `comparison overload not found` internal errors we've seen with different reproductions. Reproductions on 26.1 are:

```sql
create table v0 (v1 int);
SELECT * FROM v0 WHERE (SELECT () FROM (VALUES (-61.309167, 'csf5ytz20', '22:51:37.5110+2'::TIMETZ, '65p9eb', '05-04-0858 BC 22:46:23.7669-5'::TIMESTAMPTZ)) AS ta65) = '0tnj8ir';
```

```sql
CREATE TABLE t_ow0g_ (c_deesne_t STRING);

SELECT 1
FROM (SELECT pg_catalog.unknownrecv(NULL) AS c5) AS subq_0
WHERE EXISTS(
SELECT NULL WHERE subq_0.c5 NOT IN (SELECT NULL FROM t_ow0g_ UNION (SELECT NULL))
)
UNION (SELECT NULL);
```

```sql
DROP DATABASE IF EXISTS database1;
CREATE DATABASE database1;
USE database1;

CREATE TABLE t1(c1 INTEGER);
CREATE VIEW v0(c0) AS SELECT ('a'||NULL) FROM t1;
SELECT * FROM v0 WHERE (v0.c0 BETWEEN (CASE v0.c0 WHEN v0.c0 THEN v0.c0 END ) AND ('a'));
-- internal error: comparison overload not found (ge, unknown, unknown)
```

```sql
TABLE POSITION ( NULL IN 'abc' ) NATURAL JOIN POSITION ( NULL IN 'abc' );
```

Jira issue: CRDB-58228