1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
--result_format 2
--source include/have_ndb.inc
##
## Bug#33840016 Fix ndb_api_wait_nanos_count* statistics gathering
## - check that the 'nanos_count' session value changes during query
##
CREATE TABLE t1 (
pk int PRIMARY KEY,
b VARCHAR(100)
) engine = NDB;
INSERT INTO t1 VALUES (1, "aaa"), (2, "bbb"), (3, "ccc"), (4, "ddd");
let $nanos_count_before =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME = 'Ndb_api_wait_nanos_count_session'`;
## This query should make the 'nanos_count' move
SELECT * FROM t1 WHERE pk=1 FOR UPDATE;
let $nanos_count_after =
`SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME = 'Ndb_api_wait_nanos_count_session'`;
if ($nanos_count_before == $nanos_count_after) {
# No change detected in 'nanos_count', dump variables and fail test
SELECT VARIABLE_VALUE FROM performance_schema.session_status
WHERE VARIABLE_NAME = 'Ndb_api_wait_nanos_count_session';
echo nanos_count_before: $nanos_count_before;
echo nanos_count_after: $nanos_count_after;
die Failed to detect change in 'nanos_count' for session;
}
DROP TABLE t1;
|
