mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
19 lines
673 B
Plaintext
19 lines
673 B
Plaintext
-- source include/not_embedded.inc
|
|
# 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
|