5 Feb
2021
5 Feb
'21
11:53 a.m.
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