Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.6
-
None
Description
MariaDB 10.2 |
|
MariaDB [test]> SELECT JSON_CONTAINS('[{"a":"b"},{"c":"d"}]','{"c":"d"}'); |
+------------------------------------------------+ |
| JSON_CONTAINS('[{"a":"b"},{"c":"d"}]','{"c":"d"}') | |
+------------------------------------------------+ |
| 0 |
|
+------------------------------------------------+ |
1 row in set (0.00 sec) |
MySQL 5.7 |
|
MySQL [test]> SELECT JSON_CONTAINS('[{"a":"b"},{"c":"d"}]','{"c":"d"}'); |
+------------------------------------------------+ |
| JSON_CONTAINS('[{"a":"b"},{"c":"d"}]','{"c":"d"}') | |
+------------------------------------------------+ |
| 1 |
|
+------------------------------------------------+ |
1 row in set (0.00 sec) |