github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/create_table.result (about)

     1  create database if not exists test;
     2  use test;
     3  drop table if exists t;
     4  begin;
     5  create table t(a int);
     6  alter table t add column b int;
     7  commit;
     8  select * from t;
     9  a    b
    10  drop database test;
    11  create database if not exists ry_flowable;
    12  use ry_flowable;
    13  SET autocommit=0;
    14  create table ACT_RU_IDENTITYLINK (
    15  ID_ varchar(64),
    16  REV_ integer,
    17  GROUP_ID_ varchar(255),
    18  TYPE_ varchar(255),
    19  USER_ID_ varchar(255),
    20  TASK_ID_ varchar(64),
    21  PROC_INST_ID_ varchar(64),
    22  PROC_DEF_ID_ varchar(64),
    23  SCOPE_ID_ varchar(255),
    24  SUB_SCOPE_ID_ varchar(255),
    25  SCOPE_TYPE_ varchar(255),
    26  SCOPE_DEFINITION_ID_ varchar(255),
    27  primary key (ID_)
    28  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
    29  create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
    30  create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
    31  create index ACT_IDX_IDENT_LNK_SCOPE on ACT_RU_IDENTITYLINK(SCOPE_ID_, SCOPE_TYPE_);
    32  create index ACT_IDX_IDENT_LNK_SUB_SCOPE on ACT_RU_IDENTITYLINK(SUB_SCOPE_ID_, SCOPE_TYPE_);
    33  desc ACT_RU_IDENTITYLINK;
    34  Field    Type    Null    Key    Default    Extra    Comment
    35  id_    VARCHAR(64)    YES    PRI    null        
    36  rev_    INT(32)    YES        null        
    37  group_id_    VARCHAR(255)    YES    MUL    null        
    38  type_    VARCHAR(255)    YES        null        
    39  user_id_    VARCHAR(255)    YES    MUL    null        
    40  task_id_    VARCHAR(64)    YES        null        
    41  proc_inst_id_    VARCHAR(64)    YES        null        
    42  proc_def_id_    VARCHAR(64)    YES        null        
    43  scope_id_    VARCHAR(255)    YES    MUL    null        
    44  sub_scope_id_    VARCHAR(255)    YES    MUL    null        
    45  scope_type_    VARCHAR(255)    YES        null        
    46  scope_definition_id_    VARCHAR(255)    YES        null        
    47  SELECT @@session.transaction_read_only;
    48  @@transaction_read_only
    49  0
    50  SELECT TABLE_SCHEMA AS TABLE_CAT,
    51  NULL AS TABLE_SCHEM,
    52  TABLE_NAME,
    53  CASE
    54  WHEN TABLE_TYPE = 'BASE TABLE' THEN
    55  CASE
    56  WHEN TABLE_SCHEMA = 'mysql'
    57  OR TABLE_SCHEMA = 'mo_catalog' THEN 'SYSTEM TABLE'
    58  ELSE 'TABLE'
    59  END
    60  WHEN TABLE_TYPE = 'TEMPORARY' THEN 'LOCAL_TEMPORARY'
    61  ELSE TABLE_TYPE
    62  END AS TABLE_TYPE,
    63  TABLE_COMMENT AS REMARKS,
    64  NULL AS TYPE_CAT,
    65  NULL AS TYPE_SCHEM,
    66  NULL AS TYPE_NAME,
    67  NULL AS SELF_REFERENCING_COL_NAME,
    68  NULL AS REF_GENERATION
    69  FROM INFORMATION_SCHEMA.TABLES
    70  WHERE TABLE_SCHEMA = 'ry_flowable' AND TABLE_NAME LIKE 'act_ru_identitylink';
    71  TABLE_CAT    TABLE_SCHEM    table_name    TABLE_TYPE    REMARKS    TYPE_CAT    TYPE_SCHEM    TYPE_NAME    SELF_REFERENCING_COL_NAME    REF_GENERATION
    72  ry_flowable    null    act_ru_identitylink    TABLE        null    null    null    null    null
    73  commit;
    74  show tables;
    75  Tables_in_ry_flowable
    76  act_ru_identitylink
    77  drop database ry_flowable;