github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/new_table.result (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  tables_in_new_table
    14  table01
    15  table15
    16  table06
    17  table10
    18  测试表
    19  a/a
    20  table16
    21  $table18
    22  table19$
    23  table17
    24  drop database if exists motest;
    25  create database motest;
    26  use motest;
    27  create table t1 (b char(0));
    28  insert into t1 values (""),(null);
    29  select * from t1;
    30  b
    31  
    32  null
    33  drop table if exists t1;
    34  create table t1 (b char(0) not null);
    35  create table if not exists t1 (b char(0) not null);
    36  insert into t1 values ("");
    37  select * from t1;
    38  b
    39  
    40  drop table t1;
    41  create table t1 (ordid int not null default 1, ord  varchar(50) not null);
    42  drop table t1;
    43  create table t1 (a int not null);
    44  drop table t1;
    45  create table t1 (a varchar(5) default 'abcde');
    46  insert into t1 values();
    47  select * from t1;
    48  a
    49  abcde
    50  create table 1ea10 (1a20 int,1e int);
    51  insert into 1ea10 values(1,1);
    52  drop table 1ea10;
    53  drop table if exists t1;
    54  create table t1 (`index` int);
    55  drop table t1;
    56  drop table if exists $test1;
    57  create table motest.$test1 (a$1 int, $b int, c$ int);
    58  insert into motest.$test1 values (1,2,3);
    59  select a$1, $b, c$ from motest.$test1;
    60  a$1	$b	c$
    61  1	2	3
    62  create table motest.test2$ (a int);
    63  drop table motest.test2$;
    64  drop table if exists t1;
    65  create table t1 (a int not null primary key, B CHAR(20));
    66  drop table t1;
    67  create table t1 (a int not null, b int, primary key (a));
    68  insert into t1 values (1,1);
    69  select * from t1;
    70  a	b
    71  1	1
    72  drop table t1;
    73  create table t1(a int,b int,c int unsigned,d date,e char,f datetime,g timestamp);
    74  drop table t1;
    75  create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default 10,rel double default 3.14);
    76  insert into t1 values ('','',0,0.0);
    77  select * from t1;
    78  str	strnull	intg	rel
    79  		0	0.0000
    80  drop table t1;
    81  create table t1(name varchar(10), age smallint default -1);
    82  drop table if exists t1;
    83  create table t1 (c int primary key, a int default null, b int, unique key a (a, b) );
    84  insert into t1 values(1, 1, 1), (2, 2, 2), (3, 3, 3);
    85  drop table if exists t2;
    86  create table t2 (a int, unique key a (a));
    87  insert into t2 values(1);
    88  drop table t1;
    89  drop table t2;
    90  drop database if exists motest;