|
select * from json_table ('{}', '$' COLUMNS(x FOR ORDINALITY)) a;
|
|
bb-10.6-mdev17399-psergey2 8b533cc1d5
|
MariaDB [db]> select * from json_table ('{}', '$' COLUMNS(x FOR ORDINALITY)) a;
|
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 '('{}', '$' COLUMNS(x FOR ORDINALITY)) a' at line 1
|
It works in MySQL:
|
MySQL 8.0.23
|
MySQL [db]> select * from json_table ('{}', '$' COLUMNS(x FOR ORDINALITY)) a;
|
+------+
|
| x |
|
+------+
|
| 1 |
|
+------+
|
1 row in set (0.001 sec)
|
Given the expected complexity of statements involving JSON_TABLE, I think it's important to allow for pretty multi-line formatting of all sorts (it's not the same as having this limitation for a simple single-argument function like COUNT).
|