← 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: Brian Aker
  • Date: 2011-01-05 07:43:57 UTC
  • mto: (2060.2.1 clean)
  • mto: This revision was merged to the branch mainline in revision 2063.
  • Revision ID: brian@tangent.org-20110105074357-9zf9j38hf52xjvef
Merge in work for reserved words in SQL standard.

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);