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

     1  select @@sql_select_limit;
     2  @@sql_select_limit
     3  18446744073709551615
     4  set sql_select_limit=default;
     5  select @@sql_select_limit;
     6  @@sql_select_limit
     7  18446744073709551615
     8  set autocommit=0;
     9  begin;
    10  select @@sql_select_limit;
    11  @@sql_select_limit
    12  18446744073709551615
    13  set sql_select_limit=default;
    14  commit;
    15  select @@sql_select_limit;
    16  @@sql_select_limit
    17  18446744073709551615
    18  begin;
    19  select @@sql_mode;
    20  @@sql_mode
    21  ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES
    22  set sql_mode = 'NO_UNSIGNED_SUBTRACTION';
    23  select @@sql_mode;
    24  @@sql_mode
    25  NO_UNSIGNED_SUBTRACTION
    26  commit;
    27  set @@sql_mode=default;
    28  set autocommit=1;