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.