No function matches the given name and argument types 'json_extract(JSON, BOOLEAN)' about duckdb HOT 3 CLOSED

Looks like this is a case of > having a higher precedence than ->?

This seems to work fine:

SELECT COL FROM TBL WHERE (COL -> '$.K1' -> '$.K2') > 0;

from duckdb.

There is a precedence conflict here, for lambdas we want = to have higher precedence than ->:

select list_transform([1,0,2], x -> x=0);

But for JSON we want -> to have higher precedence than =:

select (json '{"field": 42}')->'field' = 42;

As such there is no good solution here - so parenthesis are just going to be required here. We'll add a note to the documentation.

from duckdb.

Same issue seems to happen with = and other operators

eg.

SELECT COL FROM TBL WHERE COL->'$.K1'->'$.K2' = 0;

and

SELECT COL FROM TBL WHERE COL->'$.K1'->'$.K2' is not null;

result in the same error

from duckdb.