github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/new_table.test (about)

     1  create table table01(a TINYINT primary key, b SMALLINT SIGNED, c INT UNSIGNED,d BIGINT not null , e FLOAT unique,f DOUBLE, g CHAR(10), h VARCHAR(20));
     2  create table table15 (a varchar(5) default 'abcde');
     3  create temporary table table05 ( a int, b char(10));
     4  create table table06 (a int primary key, b varchar(10));
     5  create table table10 (a int primary key, b varchar(10));
     6  create table `测试表` (`测试1` int);
     7  create table `a/a` (a int);
     8  create table table16 (1a20 int,1e int);
     9  create table $table18 (a$1 int, $b int, c$ int);
    10  create table table19$ (a int);
    11  create table table17 (`index` int);
    12  show tables;
    13  drop database if exists motest;
    14  create database motest;
    15  use motest;
    16  create table t1 (b char(0));
    17  insert into t1 values (""),(null);
    18  select * from t1;
    19  drop table if exists t1;
    20  create table t1 (b char(0) not null);
    21  create table if not exists t1 (b char(0) not null);
    22  insert into t1 values ("");
    23  select * from t1;
    24  drop table t1;
    25  create table t1 (ordid int not null default 1, ord  varchar(50) not null);
    26  drop table t1;
    27  create table t1 (a int not null);
    28  drop table t1;
    29  create table t1 (a varchar(5) default 'abcde');
    30  insert into t1 values();
    31  select * from t1;
    32  create table 1ea10 (1a20 int,1e int);
    33  insert into 1ea10 values(1,1);
    34  drop table 1ea10;
    35  drop table if exists t1;
    36  create table t1 (`index` int);
    37  drop table t1;
    38  drop table if exists $test1;
    39  create table motest.$test1 (a$1 int, $b int, c$ int);
    40  insert into motest.$test1 values (1,2,3);
    41  select a$1, $b, c$ from motest.$test1;
    42  create table motest.test2$ (a int);
    43  drop table motest.test2$;
    44  drop table if exists t1;
    45  create table t1 (a int not null primary key, B CHAR(20));
    46  drop table t1;
    47  create table t1 (a int not null, b int, primary key (a));
    48  insert into t1 values (1,1);
    49  select * from t1;
    50  drop table t1;
    51  create table t1(a int,b int,c int unsigned,d date,e char,f datetime,g timestamp);
    52  drop table t1;
    53  create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default 10,rel double default 3.14);
    54  insert into t1 values ('','',0,0.0);
    55  select * from t1;
    56  drop table t1;
    57  create table t1(name varchar(10), age smallint default -1);
    58  drop table if exists t1;
    59  create table t1 (c int primary key, a int default null, b int, unique key a (a, b) );
    60  insert into t1 values(1, 1, 1), (2, 2, 2), (3, 3, 3);
    61  drop table if exists t2;
    62  create table t2 (a int, unique key a (a));
    63  insert into t2 values(1);
    64  drop table t1;
    65  drop table t2;
    66  drop database if exists motest;