--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;