[MDEV-19487] JSON_TYPE doesnt detect the type of String Values (returns NULL) and for Date/DateTime returns "INTEGER" - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2.22, 10.3.15, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.5.25, 10.6.18, 10.11.8, 11.0.6, 11.1.5, 11.2.4, 11.4.2
Component/s: JSON
Labels:
None
Environment:
Windows 10 64 bit

Description

Hi this sentence:

select JSON_TYPE(json_value(JSON_OBJECT("id", 1, "name", 'Monty', "date", Cast('2019-01-01' as Date) ), '$.date'));

Returns INTEGER, at least it should say 'STRING'

select JSON_TYPE(json_value(JSON_OBJECT("id", 1, "name", 'Monty', "date", Cast('2019-01-01' as Date) ), '$.name'));

returns NULL, if you apply JSON_QUOTE for the JSON_VALUE returned value, it returns STRING.

Attachments

Issue Links

is part of

MDEV-15931 JSON_TYPE doesn't work correctly

Stalled

Activity

People

Assignee:: Rucha Deodhar

Reporter:: Francisco Dueñas

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2019-05-15 16:10

Updated:: 2024-05-05 19:37

Resolved:: 2024-04-30 06:25

Git Integration

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