diff options
Diffstat (limited to 'mysql-test/suite/sysschema/t/fn_ps_thread_account.test')
| -rw-r--r-- | mysql-test/suite/sysschema/t/fn_ps_thread_account.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/t/fn_ps_thread_account.test b/mysql-test/suite/sysschema/t/fn_ps_thread_account.test new file mode 100644 index 00000000000..77b6241add0 --- /dev/null +++ b/mysql-test/suite/sysschema/t/fn_ps_thread_account.test @@ -0,0 +1,11 @@ +-- source include/not_embedded.inc +# Tests for sys schema +# Verify the sys.ps_thread_account() function perfoms as expected + +# Passing NULL, or an unknown connection id, should return NULL +SELECT sys.ps_thread_account(NULL); +SELECT sys.ps_thread_account(234623462376); + + +# Check result +SELECT sys.ps_thread_account(sys.ps_thread_id(NULL)); |