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

     1  create table test(a int);
     2  insert into test values(1);
     3  create table new_test like test;
     4  show create table new_test;
     5  Table    Create Table
     6  new_test    CREATE TABLE `new_test` (\n`a` INT DEFAULT null\n)
     7  drop table test;
     8  drop table new_test;
     9  create database test1;
    10  use test1;
    11  create table test(a int);
    12  insert into test values(1);
    13  create database test2;
    14  use test2;
    15  create table new_test like test1.test;
    16  show create table new_test;
    17  Table    Create Table
    18  new_test    CREATE TABLE `new_test` (\n`a` INT DEFAULT null\n)
    19  drop database test1;
    20  drop database test2;
    21  create database test1;
    22  use test1;
    23  create table test(a int);
    24  insert into test values(1);
    25  create table test like test;
    26  table test already exists
    27  create view view1 as select * from test;
    28  show create view view1;
    29  View    Create View    character_set_client    collation_connection
    30  view1    create view view1 as select * from test;    utf8mb4    utf8mb4_general_ci
    31  create table new_test like view1;
    32  internal error: test1.view1 is not BASE TABLE
    33  drop database test1;