167 lines
3.0 KiB
Plaintext
167 lines
3.0 KiB
Plaintext
|
|
Basic reset scenario
|
|
--------------------
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
|
|
Check the pipelining
|
|
--------------------
|
|
RUN select 2.1 as value
|
|
RUN select 2.2 as value
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
value
|
|
2.1
|
|
0 rows affected
|
|
value
|
|
2.2
|
|
0 rows affected
|
|
RUN recvok
|
|
|
|
Reset session variable
|
|
----------------------
|
|
RUN set lc_messages= pl_PL
|
|
|
|
0 rows affected
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
RUN SELECT IF(@@lc_messages NOT LIKE 'pl_PL', 'OK', 'FAIL') AS result;;
|
|
Verify ["SELECT IF(@@lc_messages NOT LIKE 'pl_PL', 'OK', 'FAIL') AS result;" returns in "result" column, following value OK]
|
|
|
|
Reset user variable
|
|
-------------------
|
|
RUN set @secret = 12345
|
|
|
|
0 rows affected
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
RUN SELECT IF(@secret IS NULL, 'OK', 'FAIL') AS result;;
|
|
Verify ["SELECT IF(@secret IS NULL, 'OK', 'FAIL') AS result;" returns in "result" column, following value OK]
|
|
|
|
Reset prepare statments
|
|
-----------------------
|
|
send Mysqlx.Prepare.Prepare {
|
|
stmt_id: 123
|
|
stmt {
|
|
type: STMT
|
|
stmt_execute {
|
|
stmt: "select 2.3"
|
|
}
|
|
}
|
|
}
|
|
|
|
RUN recvok
|
|
RUN SHOW STATUS LIKE 'Prepared_stmt_count';
|
|
Verify [Status variable "Prepared_stmt_count" needs to have a value of 1]
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
send Mysqlx.Prepare.Execute {
|
|
stmt_id: 123
|
|
}
|
|
|
|
Got expected error:
|
|
Mysqlx.Error {
|
|
severity: ERROR
|
|
code: 5110
|
|
msg: "Statement with ID=123 was not prepared"
|
|
sql_state: "HY000"
|
|
}
|
|
|
|
RUN SHOW STATUS LIKE 'Prepared_stmt_count';
|
|
Verify [Status variable "Prepared_stmt_count" needs to have a value of 0]
|
|
|
|
Reset table lock
|
|
----------------
|
|
RUN CREATE TABLE test.example1(value INT)
|
|
|
|
0 rows affected
|
|
RUN CREATE TABLE test.example2(value INT)
|
|
|
|
0 rows affected
|
|
RUN LOCK TABLES test.example2 READ
|
|
|
|
0 rows affected
|
|
RUN SELECT COUNT(*) FROM test.example2
|
|
COUNT(*)
|
|
0
|
|
0 rows affected
|
|
RUN SELECT COUNT(*) FROM test.example1;
|
|
Got expected error:
|
|
Mysqlx.Error {
|
|
severity: ERROR
|
|
code: 1100
|
|
msg: "Table \'example1\' was not locked with LOCK TABLES"
|
|
sql_state: "HY000"
|
|
}
|
|
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
RUN SELECT COUNT(*) FROM test.example1
|
|
COUNT(*)
|
|
0
|
|
0 rows affected
|
|
RUN SELECT COUNT(*) FROM test.example2
|
|
COUNT(*)
|
|
0
|
|
0 rows affected
|
|
RUN DROP TABLE test.example1
|
|
|
|
0 rows affected
|
|
RUN DROP TABLE test.example2
|
|
|
|
0 rows affected
|
|
|
|
Expect block is not reset
|
|
-------------------------
|
|
send Mysqlx.Expect.Open {
|
|
cond {
|
|
condition_key: 1
|
|
}
|
|
}
|
|
|
|
RUN recvok
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
send Mysqlx.Expect.Close {
|
|
}
|
|
|
|
RUN recvok
|
|
|
|
Reset global variable
|
|
---------------------
|
|
RUN set global max_connections = 1234
|
|
|
|
0 rows affected
|
|
send Mysqlx.Session.Reset {
|
|
keep_open: true
|
|
}
|
|
|
|
RUN recvok
|
|
RUN SELECT IF(@@global.max_connections = 1234, 'OK', 'FAIL') AS result;;
|
|
Verify ["SELECT IF(@@global.max_connections = 1234, 'OK', 'FAIL') AS result;" returns in "result" column, following value OK]
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
set @@global.max_connections = default;
|