1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
--replace_column 1 #
EXECUTE "SELECT TABLE_NAME FROM DATA_DICTIONARY.tables LIMIT 2";
SET @t1=1, @t2=2, @t3:=4;
SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3;
EXECUTE "SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3";
SET @bugus_syntax= "3";
--error 1064
EXECUTE "SELECT * FROM DATA_DICTIONARY.tables LIMIT @bugus_syntax";
--replace_column 1 #
EXECUTE "SELECT TABLE_NAME FROM DATA_DICTIONARY.tables LIMIT 2";
--error 1064
EXECUTE "EXECUTE SELECT * FROM DATA_DICTIONARY.tables LIMIT 2";
EXECUTE "SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3";
set @sub_var="SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3";
EXECUTE @sub_var;
EXECUTE "CREATE TABLE t1 (a SERIAL)";
SHOW CREATE TABLE t1;
EXECUTE "INSERT INTO t1 VALUES ()";
EXECUTE "DROP TABLE t1";
--error 1064
EXECUTE "SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3; SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3";
set @foo="SELECT 1+2+3";
execute @foo;
set @create="CREATE TABLE t1 (a SERIAL)";
set @insert="INSERT INTO t1 VALUES ()";
set @select="SELECT a FROM t1";
set @drop="DROP TABLE t1";
execute @create;
execute @insert;
execute @insert;
execute @insert;
execute @select;
execute @drop;
--error 1210
EXECUTE @does_not_exist;
--error 1210
EXECUTE "";
EXECUTE "SELECT (SELECT 1) UNION SELECT (SELECT 2)";
EXECUTE "explain extended SELECT (SELECT 1) UNION SELECT (SELECT 2)";
EXECUTE "SELECT (SELECT (SELECT 0 UNION SELECT 0))";
EXECUTE "explain extended SELECT (SELECT (SELECT 0 UNION SELECT 0))";
|