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

     1  send
     2  Query {"String": "DROP TABLE IF EXISTS t; CREATE TABLE t (i int8); INSERT INTO t VALUES (1), (2);"}
     3  ----
     4  
     5  # drop sometimes produces a notice
     6  until ignore=NoticeResponse
     7  ReadyForQuery
     8  ----
     9  {"Type":"CommandComplete","CommandTag":"DROP TABLE"}
    10  {"Type":"CommandComplete","CommandTag":"CREATE TABLE"}
    11  {"Type":"CommandComplete","CommandTag":"INSERT 0 2"}
    12  {"Type":"ReadyForQuery","TxStatus":"I"}
    13  
    14  # Run an update that will affect multiple rows, but Execute with only 1 row
    15  # specified. The spec says maxrows should be ignored in this case, so we
    16  # expected both rows to be updated.
    17  send
    18  Parse {"Query": "UPDATE t SET i = -i"}
    19  Bind
    20  Execute {"MaxRows": 1}
    21  Sync
    22  ----
    23  
    24  until
    25  ReadyForQuery
    26  ----
    27  {"Type":"ParseComplete"}
    28  {"Type":"BindComplete"}
    29  {"Type":"CommandComplete","CommandTag":"UPDATE 2"}
    30  {"Type":"ReadyForQuery","TxStatus":"I"}
    31  
    32  send
    33  Query {"String": "SELECT * FROM t"}
    34  ----
    35  
    36  # ignore row desc due to oid mismatch
    37  until ignore=RowDescription
    38  ReadyForQuery
    39  ----
    40  {"Type":"DataRow","Values":[{"text":"-1"}]}
    41  {"Type":"DataRow","Values":[{"text":"-2"}]}
    42  {"Type":"CommandComplete","CommandTag":"SELECT 2"}
    43  {"Type":"ReadyForQuery","TxStatus":"I"}