← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/r/kill_wait.result

  • Committer: Lee Bieber
  • Date: 2011-01-08 03:39:25 UTC
  • mfrom: (2062.1.2 build)
  • Revision ID: kalebral@gmail.com-20110108033925-koobar399kwrm4ba
Merge Brian - parser clean up
Merge Marisa - latest doc updates, fix sphinx warnings

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/r/kill_wait.result
18
18
SELECT WAIT_UNTIL(@count_barrier, 4);
19
19
WAIT_UNTIL(@count_barrier, 4)
20
20
1
21
 
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
22
 
USER    INFO
 
21
SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
 
22
USERNAME        INFO
23
23
root    NULL
24
24
root    SELECT wait(@count_barrier), "con1"
25
25
root    SELECT wait(@count_barrier), "con2"
26
26
root    SELECT wait(@count_barrier), "con3"
27
27
root    SELECT wait(@count_barrier), "con4"
28
 
root    SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID
 
28
root    SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID
29
29
SELECT if ((@id:=ID), "YES", "NO") FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con3%" AND ID != CONNECTION_ID();
30
30
if ((@id:=ID), "YES", "NO")
31
31
YES
33
33
SELECT WAIT_UNTIL(@count_barrier, 3);
34
34
WAIT_UNTIL(@count_barrier, 3)
35
35
1
36
 
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%con3%" ORDER BY ID;
37
 
USER    INFO
 
36
SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%con3%" ORDER BY ID;
 
37
USERNAME        INFO
38
38
root    SELECT wait(@count_barrier), "con1"
39
39
root    SELECT wait(@count_barrier), "con2"
40
40
root    SELECT wait(@count_barrier), "con4"
 
41
root    SELECT USERNAME,INFO FROM DATA_DICTIONARY.PROCESSLIST WHERE INFO LIKE "%con%" AND INFO NOT LIKE "%co
41
42
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS;
42
43
USER_BARRIER_NAME
43
44
count_barrier