The Ultimate Guide to High Availability with MariaDB

Comments - JSON_TYPE

1 year, 3 months ago Kevin O'Halloran
bug in JSON_TYPE ?

this appears to me to be a bug:

set @my_filters := 
'{
	"refresh_id": "8BALL",
	"location_id": "160"
}';

select  JSON_VALUE(@my_filters, '$.refresh_id') as parsed_value,
		JSON_TYPE(JSON_UNQUOTE(JSON_VALUE(@my_filters, '$.refresh_id'))) as curr,
		JSON_TYPE(JSON_VALUE(@my_filters, '$.refresh_id')) as no_unquote,
		JSON_TYPE('8BALL') as just_type,
		JSON_TYPE('"8BALL"') as quoted_just_type;

parsed_value|curr   |no_unquote|just_type|quoted_just_type|
------------+-------+----------+---------+----------------+
8BALL       |INTEGER|INTEGER   |INTEGER  |STRING          |
 
1 year, 3 months ago Kevin O'Halloran
Re: bug in JSON_TYPE ?

JSON_TYPE should not describe the parsed value 8BALL as an INT.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.