[MDEV-11461] JSON_TYPE does not recognize integer/double types - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.3
Component/s: JSON
Labels:
- json-10.2

Description

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

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

MySQL 5.7
MySQL [test]> SELECT JSON_TYPE('1');
+----------------+
\| JSON_TYPE('1') \|
+----------------+
\| INTEGER \|
+----------------+
1 row in set (0.00 sec)

MySQL [test]> SELECT JSON_TYPE('1.1');
+------------------+
\| JSON_TYPE('1.1') \|
+------------------+
\| DOUBLE \|
+------------------+
1 row in set (0.00 sec)

Attachments

Issue Links

relates to

MDEV-9143 JSON_xxx functions

Closed

Activity

People

Assignee:: Alexey Botchkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2016-12-02 13:34

Updated:: 2016-12-04 21:22

Resolved:: 2016-12-04 21:22

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.