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

     1  -- separate execution
     2  select @@sql_select_limit;
     3  set sql_select_limit=default;
     4  select @@sql_select_limit;
     5  
     6  -- set sql_select_limit after autocommit
     7  set autocommit=0;
     8  begin;
     9  select @@sql_select_limit;
    10  set sql_select_limit=default;
    11  commit;
    12  select @@sql_select_limit;
    13  
    14  -- set sql_mode after autocommit
    15  begin;
    16  select @@sql_mode;
    17  set sql_mode = 'NO_UNSIGNED_SUBTRACTION';
    18  select @@sql_mode;
    19  commit;
    20  set @@sql_mode=default;
    21  
    22  
    23  set autocommit=1;