upsert on table with NOT NULL columns is not supported

[cldellow]

I found a case where /-/upserting a non-existing row behaves differently than /-/inserting a non-existing row.

This surprised me, but I might be misunderstanding the intended use.

If I have a table like:

create table test(key text primary key, value text);

I can do:

$ curl -XPOST https://example.com/-/upsert/db/test?pk=key -d '{"key": "abc", "value": "def"}'

{"table_count": 1}

But if the columns are non null, the upsert fails:

create table test(key text primary key, value text not null);

$ curl -XPOST https://example.com/-/upsert/db/test?pk=key -d '{"key": "abc", "value": "def"}'

{"table_count": 0}

(The /-/insert endpoint adds the row in both cases.)