Spracherkennung für: .test vermutete Sprache: SQL {SQL[110] ADA[66] VHDL[66]} [Methode: maximale Elemente, drei Dimensionen]
-- 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;
[Dauer der Verarbeitung: 0.16 Sekunden, vorverarbeitet 2026-10-11]
