select json_value('{"b":true}','$.b')=1 --> false with "Truncated incorrect DOUBLE value: 'true'"

MariaDB [(none)]> select json_extract('{"b":true}','$.b')=1;

+------------------------------------+

| json_extract('{"b":true}','$.b')=1 |

+------------------------------------+

|                                  1 |

+------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> select json_value('{"b":true}','$.b')=1;

+----------------------------------+

| json_value('{"b":true}','$.b')=1 |

+----------------------------------+

|                                0 |

+----------------------------------+

1 row in set, 1 warning (0.00 sec)

MariaDB [(none)]> show warnings;

+---------+------+------------------------------------------+

| Level   | Code | Message                                  |

+---------+------+------------------------------------------+

| Warning | 1292 | Truncated incorrect DOUBLE value: 'true' |

+---------+------+------------------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]>  select json_value('{"b":"true"}','$.b')='true';

+-----------------------------------------+

| json_value('{"b":"true"}','$.b')='true' |

+-----------------------------------------+

|                                       1 |

+-----------------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]> select json_value('{"b":true}','$.b')='true';

+---------------------------------------+

| json_value('{"b":true}','$.b')='true' |

+---------------------------------------+

|                                     1 |

+---------------------------------------+

1 row in set (0.00 sec)