JSON path compiler accepts invalid input

[monetdb-team]

Date: 2019-11-28 16:59:25 +0100
From: @kutsurak
To: SQL devs <>
Version: 11.35.3 (Nov2019)

Last updated: 2019-12-20 15:36:34 +0100

Comment 27424

Date: 2019-11-28 16:59:25 +0100
From: @kutsurak

Using the following definitions

CREATE TABLE jstest (
j json
);

INSERT INTO jstest VALUES ('{"track":{"segments":[{"location":[ 47.763,13.4034 ],"start time":"2018-10-14 10:05:14","HR":73},{"location":[ 47.706,13.2635 ],"start time":"2018-10-14 10:39:21","HR":135}]}}');

The JSON path compiler accepts the path: '$.track.segments[][' and produces results.

It should throw an error about incomplete input instead.

Comment 27425

Date: 2019-11-28 17:21:32 +0100
From: MonetDB Mercurial Repository <>

Changeset 9e35cff499bc 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=9e35cff499bc

Changeset description:

Add test for bug #6792

Comment 27426

Date: 2019-11-28 17:21:36 +0100
From: MonetDB Mercurial Repository <>

Changeset 2066af063159 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=2066af063159

Changeset description:

Add fix for bug #6792