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

     1  create table tt(aa int, bb int, cc int);
     2  insert into tt values (1, 1, 1);
     3  select * from tt;
     4  aa    bb    cc
     5  1    1    1
     6  select aa from tt;
     7  aa
     8  1
     9  select aA from tt;
    10  aa
    11  1
    12  select count(*) from tt;
    13  count(*)
    14  1
    15  select COUNT(*)  from tt;
    16  count(*)
    17  1
    18  show variables like 'keep_user_target%';
    19  Variable_name    Value
    20  keep_user_target_list_in_result    0
    21  set global keep_user_target_list_in_result = 1;
    22  select aa from tt;
    23  aa
    24  1
    25  select aA from tt;
    26  aA
    27  1
    28  select AA from tt;
    29  AA
    30  1
    31  select Aa from tt;
    32  Aa
    33  1
    34  select count(*) from tt;
    35  count(*)
    36  1
    37  select COUNT(*)  from tt;
    38  COUNT(*)
    39  1
    40  select cOuNt(*)  from tt;
    41  cOuNt(*)
    42  1
    43  set global keep_user_target_list_in_result = default;
    44  drop table tt;
    45  drop table if exists t1;
    46  create table t1(
    47  aa int,
    48  bb varchar(25)
    49  );
    50  insert into  t1 values (0, 'a');
    51  insert into  t1 values (1, NULL);
    52  insert into  t1 values (NULL, NULL);
    53  insert into  t1 values (null, 'b');
    54  select * from t1;
    55  aa    bb
    56  0    a
    57  1    null
    58  null    null
    59  null    b
    60  select coalesCE(Aa, 1) from t1;
    61  coalesce(aa, 1)
    62  0
    63  1
    64  1
    65  1
    66  select coalEsCE(aA, 1) from t1;
    67  coalesce(aa, 1)
    68  0
    69  1
    70  1
    71  1
    72  select cOAlesce(bB, '1') from t1;
    73  coalesce(bb, 1)
    74  a
    75  1
    76  1
    77  b
    78  set global keep_user_target_list_in_result = 1;
    79  select * from t1;
    80  aa    bb
    81  0    a
    82  1    null
    83  null    null
    84  null    b
    85  select coalesCE(Aa, 1) from t1;
    86  coalesce(aa, 1)
    87  0
    88  1
    89  1
    90  1
    91  select coalEsCE(aA, 1) from t1;
    92  coalesce(aa, 1)
    93  0
    94  1
    95  1
    96  1
    97  select cOAlesce(bB, '1') from t1;
    98  coalesce(bb, 1)
    99  a
   100  1
   101  1
   102  b
   103  set global keep_user_target_list_in_result = default;
   104  drop table t1;