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