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