github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/insert/not_null_check.sql (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  insert into t2 values (null, null);
     9  insert into t3 values (0, 0);
    10  insert into t1 select * from t3;
    11  select * from t1;
    12  insert into t1 select * from t2;
    13  select * from t1;
    14  drop table if exists t1;
    15  drop table if exists t2;
    16  drop table if exists t3;
    17  create table t(a int not null, b int);
    18  insert into t values (1, 1);
    19  insert into t values (1, null);
    20  insert into t values (2, null);
    21  insert into t values (3, null);
    22  update t set a=null;
    23  drop database if exists test;