[MDEV-11475] JSON_TYPE accepts arguments in invalid format Created: 2016-12-02  Updated: 2016-12-05  Resolved: 2016-12-05

Status: Closed
Project: MariaDB Server
Component/s: JSON
Affects Version/s: 10.2
Fix Version/s: 10.2.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Not a Bug Votes: 0
Labels: json-10.2

Issue Links:
Relates
relates to MDEV-9143 JSON_xxx functions Closed

 Description   

Compare:

MariaDB 10.2

 
MariaDB [test]> SELECT JSON_TYPE(1);
 
+--------------+
 
| JSON_TYPE(1) |
 
+--------------+
 
| NUMBER       |
 
+--------------+
 
1 row in set (0.00 sec)

MySQL 5.7

 
MySQL [test]> SELECT JSON_TYPE(1);
 
ERROR 3146 (22032): Invalid data type for JSON data in argument 1 to function json_type; a JSON string or JSON type is required.



 Comments   
Comment by Alexey Botchkov [ 2016-12-05 ]

Returning an error here makes no sence to me.

Generated at Thu Feb 08 07:50:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.