github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/reset (about)

     1  # LogicTest: local
     2  
     3  statement error unrecognized configuration parameter "foo"
     4  RESET FOO
     5  
     6  statement ok
     7  SET SEARCH_PATH = foo
     8  
     9  query T
    10  SHOW SEARCH_PATH
    11  ----
    12  foo
    13  
    14  statement ok
    15  RESET SEARCH_PATH
    16  
    17  query T
    18  SHOW SEARCH_PATH
    19  ----
    20  public
    21  
    22  statement error parameter "server_version" cannot be changed
    23  RESET SERVER_VERSION
    24  
    25  statement error parameter "server_version_num" cannot be changed
    26  RESET SERVER_VERSION_NUM
    27  
    28  # Lower case
    29  
    30  statement ok
    31  SET search_path = foo
    32  
    33  query T
    34  SHOW search_path
    35  ----
    36  foo
    37  
    38  statement ok
    39  RESET search_path
    40  
    41  query T
    42  SHOW search_path
    43  ----
    44  public
    45  
    46  statement ok
    47  RESET client_encoding; RESET NAMES
    48  
    49  query T
    50  SET timezone = 'Europe/Amsterdam'; SHOW TIMEZONE
    51  ----
    52  Europe/Amsterdam
    53  
    54  query T
    55  RESET timezone; SHOW TIMEZONE
    56  ----
    57  UTC
    58  
    59  query T
    60  SET time zone 'Europe/Amsterdam'; SHOW TIME ZONE
    61  ----
    62  Europe/Amsterdam
    63  
    64  query T
    65  RESET time zone; SHOW TIME ZONE
    66  ----
    67  UTC