github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/cli/interactive_tests/test_auto_trace.tcl (about)

     1  #! /usr/bin/env expect -f
     2  
     3  source [file join [file dirname $argv0] common.tcl]
     4  
     5  start_server $argv
     6  
     7  spawn $argv sql
     8  eexpect root@
     9  
    10  start_test "Check traces over simple statements"
    11  send "\\set auto_trace\r"
    12  eexpect root@
    13  send "select 1;\r"
    14  # main result
    15  eexpect "1 row"
    16  # trace result
    17  eexpect "session recording"
    18  eexpect "executing: SELECT 1"
    19  eexpect "rows affected: 1"
    20  eexpect root@
    21  end_test
    22  
    23  start_test "Check traces over simple statements with errors"
    24  send "select woo;\r"
    25  # main result
    26  eexpect "column \"woo\" does not exist"
    27  # trace result
    28  eexpect "session recording"
    29  eexpect "executing: SELECT woo"
    30  eexpect "does not exist"
    31  eexpect root@
    32  end_test
    33  
    34  start_test "Check results in simple traces"
    35  send "\\reset auto_trace\r"
    36  eexpect root@
    37  send "create table t(x int); insert into t values (1),(2);\r"
    38  eexpect root@
    39  send "\\set auto_trace=results\r"
    40  eexpect root@
    41  send "select * from t;\r"
    42  # main result
    43  eexpect "2 rows"
    44  # trace result
    45  eexpect "session recording"
    46  eexpect "executing: SELECT \* FROM t"
    47  eexpect "output row:"
    48  eexpect "output row:"
    49  eexpect "rows affected: 2"
    50  eexpect root@
    51  end_test
    52  
    53  start_test "Check KV traces"
    54  send "\\set auto_trace=kv\r"
    55  eexpect root@
    56  send "select * from t;\r"
    57  # main result
    58  eexpect "2 rows"
    59  # trace result
    60  eexpect "querying next range"
    61  eexpect "Scan"
    62  eexpect "rows affected: 2"
    63  eexpect root@
    64  end_test
    65  
    66  start_test "Check results in KV traces"
    67  send "\\set auto_trace=kv,results\r"
    68  eexpect root@
    69  send "select * from t;\r"
    70  # main result
    71  eexpect "2 rows"
    72  # trace result
    73  eexpect "querying next range"
    74  eexpect "Scan"
    75  eexpect "output row:"
    76  eexpect "output row:"
    77  eexpect "rows affected: 2"
    78  eexpect root@
    79  end_test
    80  
    81  # Terminate.
    82  send "\\q\r"
    83  eexpect eof
    84  
    85  stop_server $argv