← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/t/kill_wait.test

  • Committer: Stewart Smith
  • Date: 2011-01-21 01:09:12 UTC
  • mfrom: (2099 staging)
  • mto: (2099.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2100.
  • Revision ID: stewart@flamingspork.com-20110121010912-x5ogi8rm08nortxp
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/t/kill_wait.test
32
32
connection con5;
33
33
set @count_barrier= "count_barrier";
34
34
SELECT WAIT_UNTIL(@count_barrier, 4);
35
 
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
 
35
SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
36
36
SELECT if ((@id:=ID), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con3%" AND ID != CONNECTION_ID();
37
37
kill QUERY (@id);
38
38
SELECT WAIT_UNTIL(@count_barrier, 3);
39
 
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%con3%" ORDER BY ID;
 
39
SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%con3%" ORDER BY ID;
40
40
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS;
41
41
SELECT signal(@count_barrier);