← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/execute_concurrent.result

  • Committer: Brian Aker
  • Date: 2010-11-11 23:42:09 UTC
  • mto: (1932.2.1 trunk)
  • mto: This revision was merged to the branch mainline in revision 1930.
  • Revision ID: brian@tangent.org-20101111234209-u3j07lya1dhcon45
Adding in concurrent execute support.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/execute_concurrent.result
 
1
SET @var="CREATE SCHEMA foomine";
 
2
EXECUTE @var CONCURRENT;
 
3
select sleep(2);
 
4
sleep(2)
 
5
0
 
6
show schemas LIKE "foomine";
 
7
Database (foomine)
 
8
foomine
 
9
SET @var="DROP SCHEMA foomine";
 
10
EXECUTE @var CONCURRENT;
 
11
SET @var="SELECT SLEEP(3)";
 
12
EXECUTE @var CONCURRENT;
 
13
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST;
 
14
USER    INFO
 
15
root    SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST
 
16
root    SELECT SLEEP(3)
 
17
EXECUTE @var;
 
18
SLEEP(3)
 
19
0
 
20
SET @var="EXECUTE \"SELECT SLEEP(3)\"";
 
21
EXECUTE @var CONCURRENT;
 
22
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST;
 
23
USER    INFO
 
24
root    SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST
 
25
root    EXECUTE "SELECT SLEEP(3)"
 
26
EXECUTE @var;
 
27
SLEEP(3)
 
28
0
 
29
SET @var="EXECUTE \"SELECT SLEEP(3)\" CONCURRENT";
 
30
EXECUTE @var CONCURRENT;
 
31
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST;
 
32
USER    INFO
 
33
root    SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST