JSON_TABLE: Some types for regular columns are not supported by parser

select * from json_table('{"a":"b"}',"$" columns(a text path '$.a')) foo;

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 'text path '$.a')) foo' at line 1

select * from json_table('{"a":"b"}',"$" columns(a text path '$.a')) foo;

+------+

| a    |

+------+

| b    |

+------+

1 row in set (0.001 sec)