Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

json.filter returns corrupted string when selecting JSON null value #6773

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

json.filter returns corrupted string when selecting JSON null value #6773

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2019-10-11 12:01:59 +0200
From: jpastuszek
To: SQL devs <>
Version: 11.33.11 (Apr2019-SP1)
CC: @kutsurak

Last updated: 2019-11-28 10:00:03 +0100

Comment 27354

Date: 2019-10-11 12:01:59 +0200
From: jpastuszek

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0
Build Identifier:

This queries return string witch is incorrectly encoded:

select json.filter('{"foo": null}', '$.foo')
select json.filter('[null]', '$[0]')

Reproducible: Always

Steps to Reproduce:

  1. Run query that select "null" from JSON object
  2. Observe bad string returned

Actual Results:

[�]

Expected Results:

Probably "[null]" should be returned.

Comment 27355

Date: 2019-10-11 12:45:03 +0200
From: MonetDB Mercurial Repository <>

Changeset 7d92d6226c11 made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=7d92d6226c11

Changeset description:

Add test for bug #6773

Comment 27360

Date: 2019-10-11 15:22:28 +0200
From: MonetDB Mercurial Repository <>

Changeset 848f40d8511a made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=848f40d8511a

Changeset description:

Do not return str_nil but the sequence `null` for null in JSON

This fixes the bug #6773.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant