maria-developers team mailing list archive

[Sergey Petrunia <sergey@xxxxxxxxxxx>]

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