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

     1  create table tt(aa int, bb int, cc int);
     2  insert into tt values (1, 1, 1);
     3  select * from tt;
     4  select aa from tt;
     5  select aA from tt;
     6  select count(*) from tt;
     7  select COUNT(*)  from tt;
     8  show variables like 'keep_user_target%';
     9  set global keep_user_target_list_in_result = 1;
    10  select aa from tt;
    11  select aA from tt;
    12  select AA from tt;
    13  select Aa from tt;
    14  select count(*) from tt;
    15  select COUNT(*)  from tt;
    16  select cOuNt(*)  from tt;
    17  set global keep_user_target_list_in_result = default;
    18  drop table tt;
    19  
    20  drop table if exists t1;
    21  create table t1(
    22  aa int,
    23  bb varchar(25)
    24  );
    25  insert into  t1 values (0, 'a');
    26  insert into  t1 values (1, NULL);
    27  insert into  t1 values (NULL, NULL);
    28  insert into  t1 values (null, 'b');
    29  select * from t1;
    30  select coalesCE(Aa, 1) from t1;
    31  select coalEsCE(aA, 1) from t1;
    32  select cOAlesce(bB, '1') from t1;
    33  set global keep_user_target_list_in_result = 1;
    34  select * from t1;
    35  select coalesCE(Aa, 1) from t1;
    36  select coalEsCE(aA, 1) from t1;
    37  select cOAlesce(bB, '1') from t1;
    38  set global keep_user_target_list_in_result = default;
    39  drop table t1;