|
Upon a missing mandatory JSON table alias, MariaDB produces the generic syntax error ER_PARSE_ERROR:
|
bb-10.6-mdev17399-psergey2 8b533cc1d5
|
MariaDB [db]> select * from json_table('[]', '$' COLUMNS(x FOR ORDINALITY));
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
|
while MySQL returns a nicer context-specific error:
|
MySQL 8.0.23
|
MySQL [db]> select * from json_table('[]', '$' COLUMNS(x FOR ORDINALITY));
|
ERROR 3667 (42000): Every table function must have an alias
|
It is a cosmetic problem, but deep within a more complicated query it can become confusing.
|