blob: ca8b4fb437c6483e9158dbf02595c44bb5b694b4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- source include/not_embedded.inc
# Tests for sys schema
# Verify the sys.ps_thread_id() function perfoms as expected
# Passing unknown connection id should return NULL
SELECT sys.ps_thread_id(234623462376);
# Grab the thread_id for this connection directly from Performance Schema
let $MY_THREAD_ID=`SELECT thread_id FROM performance_schema.threads
WHERE PROCESSLIST_ID = connection_id()`;
--disable_query_log ONCE
eval SET @ps_thread_id = $MY_THREAD_ID;
SELECT sys.ps_thread_id(CONNECTION_ID()) = @ps_thread_id;
# Passing NULL should also return the current connection thread id
SELECT sys.ps_thread_id(NULL) = @ps_thread_id;
|
