Problems in comparisons using JSON_EXTRACT

MariaDB [(none)]> SELECT VERSION();

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

| VERSION()       |

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

| 10.6.9-MariaDB  |

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

1 row in set (0.000 sec)

MariaDB [(none)]> SELECT

    ->   JSON_VALID('"MariaDB"'),

    ->   JSON_TYPE('"MariaDB"'),

    ->   JSON_EXTRACT('"MariaDB"', '$'),

    ->   JSON_EXTRACT('"MariaDB"', '$') = JSON_EXTRACT('"MariaDB"', '$'), -- I would expect 1

    ->   JSON_EXTRACT('"MariaDB"', '$') <=> JSON_EXTRACT('"MariaDB"', '$'), -- I would expect 1

    ->   JSON_EXTRACT('"MariaDB"', '$') IN ('"MariaDB"'), -- I would expect 1

    ->   '"MariaDB"' IN (JSON_EXTRACT('"MariaDB"', '$')), -- I would expect 1

    ->   JSON_EXTRACT('"MariaDB"', '$') IN ('MariaDB'), -- I would expect 0

    ->   'MariaDB' IN (JSON_EXTRACT('"MariaDB"', '$'))\G -- I would expect 0

*************************** 1. row ***************************

                                          JSON_VALID('"MariaDB"'): 1

                                           JSON_TYPE('"MariaDB"'): STRING

                                   JSON_EXTRACT('"MariaDB"', '$'): "MariaDB"

  JSON_EXTRACT('"MariaDB"', '$') = JSON_EXTRACT('"MariaDB"', '$'): 0

JSON_EXTRACT('"MariaDB"', '$') <=> JSON_EXTRACT('"MariaDB"', '$'): 0

                  JSON_EXTRACT('"MariaDB"', '$') IN ('"MariaDB"'): 0

                  '"MariaDB"' IN (JSON_EXTRACT('"MariaDB"', '$')): 0

                    JSON_EXTRACT('"MariaDB"', '$') IN ('MariaDB'): 1

                    'MariaDB' IN (JSON_EXTRACT('"MariaDB"', '$')): 1

1 row in set (0.001 sec)