18 lines
638 B
Plaintext
18 lines
638 B
Plaintext
# Tests for sys schema
|
|
# Verify the sys.ps_is_thread_instrumented() function perfoms as expected
|
|
|
|
# Passing NULL/nothing should return NULL
|
|
SELECT sys.ps_is_thread_instrumented(NULL);
|
|
|
|
# By default current thread should be instrumented
|
|
SELECT sys.ps_is_thread_instrumented(CONNECTION_ID());
|
|
|
|
# Now toggle our thread to off and re-check
|
|
UPDATE performance_schema.threads SET instrumented = 'NO' WHERE processlist_id = CONNECTION_ID();
|
|
SELECT sys.ps_is_thread_instrumented(CONNECTION_ID());
|
|
|
|
# Try some huge number to check unknown connections
|
|
SELECT sys.ps_is_thread_instrumented(234623462376);
|
|
|
|
--source ../include/ps_threads_cleanup.inc
|