Hi Alexey,
More input: JSON's true is converted to integer 0, not 1.
SELECT *
FROM
JSON_TABLE('{"col": true}',
'$' COLUMNS(
col1 INT PATH '$.col' ERROR ON ERROR
)
) as jt;
In MariaDB, this produces
+------+
| col1 |
+------+
| 0 |
+------+
While I think it should produce what MySQL and OracleDB produce:
+------+
| col1 |
+------+
| 1 |
+------+
BR
Sergei
--
Sergei Petrunia, Software Developer
MariaDB Corporation | Skype: sergefp | Blog: http://petrunia.net
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
