JSON_TABLE: ON ERROR clause is used for empty values if ON EMPTY is not specified explicitly

MariaDB [test]> select * from json_table('{"a":"foo"}', '$' columns (f varchar(16) path '$.x' default '100' on error)) as jt;

+------+

| f    |

+------+

| 100  |

+------+

1 row in set (0.001 sec)

MySQL [test]> select * from json_table('{"a":"foo"}', '$' columns (f varchar(16) path '$.x' default '100' on error)) as jt;

+------+

| f    |

+------+

| NULL |

+------+

1 row in set (0.001 sec)

MariaDB [test]> select * from json_table('{"a":"foo"}', '$' columns (f varchar(16) path '$.x' default '100' on error default '0' on empty)) as jt;

+------+

| f    |

+------+

| 0    |

+------+

1 row in set (0.002 sec)