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

     1  statement ok
     2  SET SEARCH_PATH = foo
     3  
     4  query T
     5  SHOW SEARCH_PATH
     6  ----
     7  foo
     8  
     9  statement ok
    10  DISCARD ALL
    11  
    12  query T
    13  SHOW SEARCH_PATH
    14  ----
    15  public
    16  
    17  query T
    18  SET timezone = 'Europe/Amsterdam'; SHOW TIMEZONE
    19  ----
    20  Europe/Amsterdam
    21  
    22  query T
    23  DISCARD ALL; SHOW TIMEZONE
    24  ----
    25  UTC
    26  
    27  query T
    28  SET TIME ZONE 'Europe/Amsterdam'; SHOW TIME ZONE
    29  ----
    30  Europe/Amsterdam
    31  
    32  query T
    33  DISCARD ALL; SHOW TIME ZONE
    34  ----
    35  UTC
    36  
    37  statement ok
    38  PREPARE a AS SELECT 1
    39  
    40  statement ok
    41  DISCARD ALL
    42  
    43  statement error prepared statement \"a\" does not exist
    44  DEALLOCATE a
    45  
    46  statement ok
    47  BEGIN
    48  
    49  statement error DISCARD ALL cannot run inside a transaction block
    50  DISCARD ALL