Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.0, 13.1
-
Unexpected results
-
Q4/2026 Server Maintenance
Description
probably affecting earlier versions too.
MariaDB [test]> select json_overlaps('[[1]]', '[[]]');
|
+--------------------------------+
|
| json_overlaps('[[1]]', '[[]]') |
|
+--------------------------------+
|
| 1 |
|
+--------------------------------+
|
1 row in set (0.000 sec)
|
 |
MariaDB [test]> select json_overlaps('[[1]]', '[[],123]');
|
+------------------------------------+
|
| json_overlaps('[[1]]', '[[],123]') |
|
+------------------------------------+
|
| 1 |
|
+------------------------------------+
|
1 row in set (0.001 sec)
|
|
MySQL 9.6:
mysql> select json_overlaps('[[1]]', '[[]]');
|
+--------------------------------+
|
| json_overlaps('[[1]]', '[[]]') |
|
+--------------------------------+
|
| 0 |
|
+--------------------------------+
|
1 row in set (0.002 sec)
|
mysql> select json_overlaps('[[1]]', '[[],123]');
|
+------------------------------------+
|
| json_overlaps('[[1]]', '[[],123]') |
|
+------------------------------------+
|
| 0 |
|
+------------------------------------+
|
1 row in set (0.001 sec)
|
Attachments
Issue Links
- relates to
-
MDEV-40168 Indexes over JSON data based on Fulltext index
-
- In Progress
-