~drizzle-trunk/drizzle/development

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '; SELECT @t1, @t2, @t3, @t4 := @t1+@t2+@t3' at line 1

set @foo="SELECT 1+2+3";

execute @drop;

execute @create WITH NO RETURN;

execute @insert WITH NO RETURN;

execute @select WITH NO RETURN;

execute @drop WITH NO RETURN;

EXECUTE @does_not_exist;

ERROR HY000: Incorrect arguments to Invalid Variable

EXECUTE "";

Warnings:

Note 1249 Select 2 was reduced during optimization

Note 1003 select (select 0 AS `0` union select 0 AS `0`) AS `(SELECT (SELECT 0 UNION SELECT 0))`

EXECUTE "SELECT (SELECT 1) UNION SELECT (SELECT 2)" WITH NO RETURN;

EXECUTE "explain extended SELECT (SELECT 1) UNION SELECT (SELECT 2)" WITH NO RETURN;

EXECUTE "SELECT (SELECT (SELECT 0 UNION SELECT 0))" WITH NO RETURN;

EXECUTE "explain extended SELECT (SELECT (SELECT 0 UNION SELECT 0))" WITH NO RETURN;

SET @var="CREATE SCHEMA d; CREATE SCHEMA e;";

EXECUTE @var WITH NO RETURN;

100

show schemas LIKE "d";

101

Database (d)

102

103

show schemas LIKE "e";

104

Database (e)

105

106

DROP SCHEMA d;

107

DROP SCHEMA e;

108

SET @var="CREATE SCHEMA d; SELECT fosdsd; CREATE SCHEMA e;";

109

EXECUTE @var WITH NO RETURN;

110

show schemas LIKE "d";

111

Database (d)

112

113

show schemas LIKE "e";

114

Database (e)

115

DROP SCHEMA d;

116

SET @var = "SET @var='test value'";

117

EXECUTE @var;

118

SELECT @var;

119

@var

120

test value

121

CREATE TABLE t1 (a int);

122

SET @var = "ALTER TABLE t1 ADD COLUMN (b char(100))";

123

EXECUTE @var;

124

SHOW CREATE TABLE t1;

125

Table Create Table

126

t1 CREATE TABLE `t1` (

127

`a` INT DEFAULT NULL,

128

`b` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL

129

) ENGINE=InnoDB COLLATE = utf8_general_ci

130

DROP TABLE t1;

131

CREATE TABLE t1 (a int, b char(20));

132

SET @var = "INSERT INTO t1 VALUES (@a_val, @b_val)";

133

SET @a_val = 1;

134

SET @b_val = 'TNETENNBA';

135

EXECUTE @var;

136

SELECT * FROM t1;

137

a b

138

1 TNETENNBA

139

SET @a_val = 2;

140

SET @b_val = 'OVERNUMEROUSNESS';

141

EXECUTE @var;

142

SELECT * FROM t1;

143

a b

144

1 TNETENNBA

145

2 OVERNUMEROUSNESS

146

DROP TABLE t1;

147

CREATE TABLE t1 (a int, b char(100), c char(100));

148

INSERT INTO t1 VALUES (1, 'Moss', 'IT');

149

INSERT INTO t1 VALUES (2, 'Roy', 'IT');

150

INSERT INTO t1 VALUES (3, 'Jen', 'IT');

151

SET @var = "UPDATE t1 SET c = @new_dept WHERE b = @name";

152

SET @new_dept = "Relationship Manager";

153

SET @name = 'Jen';

154

EXECUTE @var;

155

SELECT * FROM t1;

156

a b c

157

1 Moss IT

158

2 Roy IT

159

3 Jen Relationship Manager

160

DROP TABLE t1;

161

CREATE TABLE t1 (a int);

162

INSERT INTO t1 VALUES (42);

163

INSERT INTO t1 VALUES (9);

164

INSERT INTO t1 VALUES (1);

165

INSERT INTO t1 VALUES (0);

166

INSERT INTO t1 VALUES (2);

167

SET @var = "DELETE FROM t1 WHERE a%2=0";

168

EXECUTE @var;

169

SELECT * FROM t1;

170

171

172

173

DROP TABLE t1;

174

CREATE TABLE t1 (a int);

175

SET @var = "CREATE INDEX a_index ON t1 (a)";

176

EXECUTE @var;

177

SHOW CREATE TABLE t1;

178

Table Create Table

179

t1 CREATE TABLE `t1` (

180

`a` INT DEFAULT NULL,

181

KEY `a_index` (`a`)

182

) ENGINE=InnoDB COLLATE = utf8_general_ci

183

SET @var = "DROP INDEX a_index ON t1";

184

EXECUTE @var;

185

SHOW CREATE TABLE t1;

186

Table Create Table

187

t1 CREATE TABLE `t1` (

188

`a` INT DEFAULT NULL

189

) ENGINE=InnoDB COLLATE = utf8_general_ci

190

DROP TABLE t1;

Older »