github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/log/query_tae_table.sql (about)

     1  
     2  -- this case only success in linux, not in drawin
     3  create account if not exists `query_tae_table` ADMIN_NAME 'admin' IDENTIFIED BY '123456';
     4  
     5  -- @session:id=1&user=query_tae_table:admin:accountadmin&password=123456
     6  drop database if exists `query_tae_table`;
     7  create database `query_tae_table`;
     8  use query_tae_table;
     9  drop table if exists `query_tae_table`;
    10  set @uuid_drop_table = last_uuid();
    11  create table query_tae_table (i int);
    12  set @uuid_create_table = last_uuid();
    13  insert into query_tae_table values (1);
    14  set @uuid_insert_table = last_uuid();
    15  
    16  select sleep(16);
    17  
    18  select account from system.statement_info where statement_id = @uuid_create_table;
    19  
    20  select account, statement from system.statement_info where statement = 'insert into query_tae_table values (1)' and statement_id = @uuid_insert_table limit 1;
    21  -- @session
    22  
    23  
    24  -- case: select span_kind issue #7571
    25  select span_kind from system.rawlog where `raw_item` = "span_info" and span_name = "NOT_EXIST_SPAN" limit 1;
    26  
    27  -- clean
    28  drop account `query_tae_table`;