Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.1, 12.2
-
Can result in hang or crash
Description
I noticed a crash on every version of MariaDB when running something similar to the following:
create table tst(val json); |
insert into tst values('{}'); |
select t.val<=>json_extract('[]','$') from tst t; |
Though it can be reproduced also by running just this
select '[]'<=>json_extract('[]','$') |
The problem being the comparison of JSON and VARCHAR with the <=> operator.
I suppose the problem is that even though MariaDB accepts the token json as data type, it desugars to longtext, but internally, there is still a distinct type for json data.
Attachments
Issue Links
- relates to
-
MDEV-21530 json_extract STILL crashes in Item_func_json_extract::read_json
-
- Closed
-