-- Fail inserting a NULL value into ISOK_RESULTS.Last_Role
INSERT INTO isok_results (
    iqname, first_seen, last_seen, last_role, last_schemas
  , resolved, deferred_to, category, keep_until
  , qr_id, qr_message, qr_extra
  , notes)
  VALUES ('query1'
        , '1900-01-01'
        , '1900-01-01'
        , NULL
        , '{"schema1","schema2"}'
        , NULL
        , NULL
        , 'rtype1'
        , NULL
        , 'testresult2'
        , 'Informative message'
        , NULL
        , '');
ERROR:  null value in column "last_role" of relation "isok_results" violates not-null constraint
DETAIL:  Failing row contains (5, query1, Mon Jan 01 00:00:00 1900, Mon Jan 01 00:00:00 1900, null, {schema1,schema2}, null, null, rtype1, null, testresult2, Informative message, null, ).