search

dolthub / doltpy

A Python API for Dolt
Apache License 2.0
56 stars 13 forks source link

Error on inserting empty byte array into JSON column using doltpy #168

Open zachmu opened 3 years ago

zachmu commented 3 years ago

For a table defined like this:

CREATE TABLE test (
    id integer NOT NULL,
    json_id json DEFAULT '{}' NOT NULL
)

Inserting into this table with write_rows fails if json_id is an empty byte array. Error:

column name 'json_id' is non-nullable but attempted to set a value of null