mysql-test/suite/sysschema/t/fn_ps_thread_account.test
raw| 1 | # Tests for sys schema |
| 2 | # Verify the sys.ps_thread_account() function perfoms as expected |
| 3 | |
| 4 | # Passing NULL, or an unknown connection id, should return NULL |
| 5 | SELECT sys.ps_thread_account(NULL); |
| 6 | SELECT sys.ps_thread_account(234623462376); |
| 7 | |
| 8 | -- error 1264 |
| 9 | SELECT sys.ps_thread_account(-1); |
| 10 | |
| 11 | # Check result |
| 12 | SELECT sys.ps_thread_account(ps_current_thread_id()); |