github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/set/set_keep_user_target.sql (about)

     1  set global keep_user_target_list_in_result = 0;
     2  select @@keep_user_target_list_in_result;
     3  set global keep_user_target_list_in_result = 1;
     4  
     5  drop account if exists default_1;
     6  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
     7  -- @session:id=1&user=default_1:admin&password=111111
     8  set global keep_user_target_list_in_result = 1;
     9  select @@lower_case_table_names;
    10  select @@keep_user_target_list_in_result;
    11  create database if not exists test;
    12  use test;
    13  drop table if exists t1;
    14  create table t1(aa int, bb int, cc int, AbC varchar(25), A_BC_d double);
    15  insert into t1 values (1,2,3,'A',10.9);
    16  select * from t1;
    17  select Aa from t1;
    18  select BB from t1;
    19  select aA, bB, CC, abc, a_Bc_D from t1;
    20  drop table t1;
    21  drop database test;
    22  -- @session
    23  drop account default_1;
    24  set global keep_user_target_list_in_result = 0;