NULL inet and json types are not handled

[kindermoumoute]

Table is created with the following query:

CREATE TABLE example (
    key uuid NOT NULL,
    my_ip inet
);

Generated query will be:

-- name: CreateExample :one
INSERT INTO example (key) VALUES ($1) RETURNING *;

Then when I call the query I got this error when calling CreateExample(ctx, uuid.New()):

sql: Scan error on column index 1, name "my_ip": unsupported Scan, storing driver.Value type <nil> into type *net.IP

EDIT: replace inet with json and the same issue happens. More types might be involved.

[kindermoumoute]

Looks like we can't just use golang standard types (net.IP, net.HardwareAddr, json.RawMessage...) since they don't properly implement Scan. There are a bunch of opensource driver that already fixed this such as pgtype.

[kyleconroy]

The net.IP portion of this has been addressed in #1142. The JSON portion is a duplicate of #129. Don't worry though! The JSON side of things will also be fixed in v1.10.0