sql: INET special operators do not work with ANY

[petermattis]

The INET special operators such as <<= and >>= do not work with ANY. For example,

root@localhost:26257/> SELECT INET '192.168.1/24' <<= ANY (SELECT INET '192.168.1/24');
invalid syntax: statement ignored: syntax error at or near "any"
DETAIL: source SQL:
SELECT INET '192.168.1/24' <<= ANY (SELECT INET '192.168.1/24');
                               ^

The above query works fine in Postgres. Non-INET specific operators that have INET overloads work with ANY:

root@localhost:26257/> SELECT INET '192.168.1/24' = ANY (SELECT INET '192.168.1/24');
+--------------------------------+
|   INET '192.168.1/24' = ANY    |
|  (SELECT INET '192.168.1/24')  |
+--------------------------------+
|              true              |
+--------------------------------+
(1 row)

Jira issue: CRDB-5761

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
5 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

[knz]

This is an outright syntax bug which is still present in 21.1

[msloan-pckt]

still an issue with 22.1.0

Checking a table that might have an inet[] type and looking for if an element has some overlap works in Postgres but will fail in CRDB.

This works in Postgres.

select inet '192.168.1.5' << any (array['192.168.1/24', '10/8']::inet[]);

in cockroach this fails with.

SQLSTATE: 42601
DETAIL: source SQL:
select inet '192.168.1.5' << any (array['192.168.1/24', '10/8']::inet[])
                                                                        ^