Details
Major Description
MariaDB [(none)]> select JSON_EXTRACT("[1, 2, [30, 40]]", '$[2][1]', '$[2][1]');
|
+--------------------------------------------------------+
|
| JSON_EXTRACT("[1, 2, [30, 40]]", '$[2][1]', '$[2][1]') |
|
+--------------------------------------------------------+
|
| [40] |
|
+--------------------------------------------------------+
|
While MySQL:
+--------------------------------------------------------+
|
| JSON_EXTRACT("[1, 2, [30, 40]]", '$[2][1]', '$[2][1]') |
|
+--------------------------------------------------------+
|
| [40, 40] |
|
+--------------------------------------------------------+
|
Documentation in our case says it should so I consider this a bug.
Attachments
Activity
ok to push.
Personally i think the way it worked in MariaDB made more sence. But since we decided to copy MySQL's behaviour for these functions we have to do the change.
patch: https://github.com/MariaDB/server/commit/6e66d5bbfa00d53c06fc3df8ca98e85a684d7c1c