[MDEV-11453] JSON_CONTAINS returns incorrect values - Jira

XML

Word

Printable

MariaDB 10.2
MariaDB [test]> SELECT JSON_CONTAINS('{"foo":"bar"}','{"foo":"bar"}');
+------------------------------------------------+
\| JSON_CONTAINS('{"foo":"bar"}','{"foo":"bar"}') \|
+------------------------------------------------+
\| 0 \|
+------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> SELECT JSON_CONTAINS('{"c": {"d": 4}}','{"d": 4}','$.c');
+---------------------------------------------------+
\| JSON_CONTAINS('{"c": {"d": 4}}','{"d": 4}','$.c') \|
+---------------------------------------------------+
\| 0 \|
+---------------------------------------------------+
1 row in set (0.00 sec)

MySQL 5.7
MySQL [test]> SELECT JSON_CONTAINS('{"foo":"bar"}','{"foo":"bar"}');
+------------------------------------------------+
\| JSON_CONTAINS('{"foo":"bar"}','{"foo":"bar"}') \|
+------------------------------------------------+
\| 1 \|
+------------------------------------------------+
1 row in set (0.00 sec)

MySQL [test]> SELECT JSON_CONTAINS('{"c": {"d": 4}}','{"d": 4}','$.c');
+---------------------------------------------------+
\| JSON_CONTAINS('{"c": {"d": 4}}','{"d": 4}','$.c') \|
+---------------------------------------------------+
\| 1 \|
+---------------------------------------------------+
1 row in set (0.01 sec)

relates to

MDEV-9143 JSON_xxx functions