What happens?

When extracting from json, if a key in the json has a null value, it's returned as a non-null object in SQL. This is not what I would expect at all, and breaks things like COALESCE.

To Reproduce

Pretty easy to see what I mean by running this snippet:

select json_extract('{ "foo": null }', '$.foo') is null;

OS:

macOS / m1

DuckDB Version:

v0.7.1 b00b93f

DuckDB Client:

CLI & typescript

Full Name:

Ken Miller

Affiliation:

Watershed

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree