Support ANY/ALL for MVA in select list

[sanikolaev]

Proposal:

The any/all() function in MVA does not work when used in the select list, making it unusable for custom ranking. (related discussion on Slack.)

MRE:

mysql> drop table if exists t; create table t(m multi, f text); insert into t values(1, 'a', (1,2)),(2, 'a', ()); select * from t; select * from t where any(m) in (1); select any(m) in (1) from t;
--------------
drop table if exists t
--------------

Query OK, 0 rows affected (0.01 sec)

--------------
create table t(m multi, f text)
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
insert into t values(1, 'a', (1,2)),(2, 'a', ())
--------------

Query OK, 2 rows affected (0.00 sec)

--------------
select * from t
--------------

+------+------+------+
| id   | f    | m    |
+------+------+------+
|    1 | a    | 1,2  |
|    2 | a    |      |
+------+------+------+
2 rows in set (0.00 sec)
--- 2 out of 2 results in 0ms ---

--------------
select * from t where any(m) in (1)
--------------

+------+------+------+
| id   | f    | m    |
+------+------+------+
|    1 | a    | 1,2  |
+------+------+------+
1 row in set (0.00 sec)
--- 1 out of 1 results in 0ms ---

--------------
select any(m) in (1) from t
--------------

ERROR 1064 (42000): P01: syntax error, unexpected ')' near ') in (1) from t'

Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed
• Changelog updated
• OpenAPI YAML updated and issue created to rebuild clients