← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/utility_functions/tests/t/kill.test

  • Committer: Andrew Hutchings
  • Date: 2010-12-06 19:36:53 UTC
  • mfrom: (1976 staging)
  • mto: This revision was merged to the branch mainline in revision 1991.
  • Revision ID: andrew@linuxjedi.co.uk-20101206193653-l85vryv18jb0yxx8
Merge with trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/utility_functions/tests/t/kill.test
 
1
# Test creating a bunch of connections, and then killing them.
 
2
connect (con1,localhost,root,,);
 
3
connect (con2,localhost,root,,);
 
4
connect (con3,localhost,root,,);
 
5
connect (con4,localhost,root,,);
 
6
connect (con5,localhost,root,,);
 
7
 
 
8
connection default;
 
9
SELECT COUNT(ID) FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
 
10
SELECT IF(KILL(id), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID();
 
11
SELECT count(ID) FROM DATA_DICTIONARY.PROCESSLIST WHERE COMMAND != "Killed";
 
12
--error 1713
 
13
SELECT KILL(CONNECTION_ID());