github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/insert/not_null_check.result (about)

     1  drop database if exists test;
     2  create database test;
     3  use test;
     4  create table t1(a int not null, b int);
     5  create table t2(a int, b int);
     6  create table t3(a int, b int);
     7  insert into t1 values (null, 0);
     8  constraint violation: Column 'a' cannot be null
     9  insert into t2 values (null, null);
    10  insert into t3 values (0, 0);
    11  insert into t1 select * from t3;
    12  select * from t1;
    13  a    b
    14  0    0
    15  insert into t1 select * from t2;
    16  constraint violation: Column 'a' cannot be null
    17  select * from t1;
    18  a    b
    19  0    0
    20  drop table if exists t1;
    21  drop table if exists t2;
    22  drop table if exists t3;
    23  create table t(a int not null, b int);
    24  insert into t values (1, 1);
    25  insert into t values (1, null);
    26  insert into t values (2, null);
    27  insert into t values (3, null);
    28  update t set a=null;
    29  constraint violation: Column 'a' cannot be null
    30  drop database if exists test;