JSON_TABLE: Unexpected ER_MIX_OF_GROUP_FUNC_AND_FIELDS upon query with JOIN

SET sql_mode='ONLY_FULL_GROUP_BY';

CREATE TABLE t (a TEXT);

INSERT INTO t VALUES ('{}'),('[]');

SELECT SUM(o) FROM t JOIN JSON_TABLE(t.a, '$' COLUMNS(o FOR ORDINALITY)) jt;

# Cleanup

DROP TABLE t;

MariaDB [test]> SELECT SUM(o) FROM t JOIN JSON_TABLE(t.a, '$' COLUMNS(o FOR ORDINALITY)) jt;

ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

MySQL [test]> SELECT SUM(o) FROM t JOIN JSON_TABLE(t.a, '$' COLUMNS(o FOR ORDINALITY)) jt;

+--------+

| SUM(o) |

+--------+

|      2 |

+--------+

1 row in set (0.001 sec)