github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/pgwire/testdata/pgtest/param_status (about)

     1  # Change the application name.
     2  
     3  send
     4  Query {"String": "SET application_name = 'pgtest'"}
     5  ----
     6  
     7  until
     8  ReadyForQuery
     9  ----
    10  {"Type":"ParameterStatus","Name":"application_name","Value":"pgtest"}
    11  {"Type":"CommandComplete","CommandTag":"SET"}
    12  {"Type":"ReadyForQuery","TxStatus":"I"}
    13  
    14  # Change the time zone using an offset.
    15  
    16  send
    17  Query {"String": "SET TIME ZONE +6"}
    18  ----
    19  
    20  until crdb_only
    21  ParameterStatus
    22  ----
    23  {"Type":"ParameterStatus","Name":"TimeZone","Value":"6"}
    24  
    25  
    26  # TODO(#42404): postgres has a different output. This is what we have right now
    27  # as code, but we need to dig into what/why we use this format in param status.
    28  until noncrdb_only
    29  ParameterStatus
    30  ----
    31  {"Type":"ParameterStatus","Name":"TimeZone","Value":"\u003c+06\u003e-06"}
    32  
    33  until
    34  ReadyForQuery
    35  ----
    36  {"Type":"CommandComplete","CommandTag":"SET"}
    37  {"Type":"ReadyForQuery","TxStatus":"I"}
    38  
    39  send
    40  Query {"String": "SET TIME ZONE -11.5"}
    41  ----
    42  
    43  until crdb_only
    44  ParameterStatus
    45  ----
    46  {"Type":"ParameterStatus","Name":"TimeZone","Value":"-11.5"}
    47  
    48  until noncrdb_only
    49  ParameterStatus
    50  ----
    51  {"Type":"ParameterStatus","Name":"TimeZone","Value":"\u003c-11:30\u003e+11:30"}
    52  
    53  until
    54  ReadyForQuery
    55  ----
    56  {"Type":"CommandComplete","CommandTag":"SET"}
    57  {"Type":"ReadyForQuery","TxStatus":"I"}
    58  
    59  # Change the time zone using a real string.
    60  
    61  send
    62  Query {"String": "SET TIME ZONE 'America/New_York'"}
    63  ----
    64  
    65  until
    66  ReadyForQuery
    67  ----
    68  {"Type":"ParameterStatus","Name":"TimeZone","Value":"America/New_York"}
    69  {"Type":"CommandComplete","CommandTag":"SET"}
    70  {"Type":"ReadyForQuery","TxStatus":"I"}