 insert into test(p,q,r,txt) values ('p',null,null,'a'); -- violates test_unique_idx insert into test(p,q,r,txt) values ('p','q',null,'b');  -- violates test_unique_idx insert into test(p,q,r,txt) values ('p',null, 'r','c'); -- violates test_