172
172
--echo # End Bug#57882
176
# Bug #13031606 VALUES() IN A SELECT STATEMENT CRASHES SERVER
178
CREATE TABLE t1 (a INT);
179
CREATE TABLE t2(a INT PRIMARY KEY, b INT);
180
--error ER_BAD_FIELD_ERROR
181
SELECT '' AS b FROM t1 GROUP BY VALUES(b);
182
--error ER_BAD_FIELD_ERROR
183
REPLACE t2(b) SELECT '' AS b FROM t1 GROUP BY VALUES(b);
184
--error ER_BAD_FIELD_ERROR
185
UPDATE t2 SET a=(SELECT '' AS b FROM t1 GROUP BY VALUES(b));
186
--error ER_BAD_FIELD_ERROR
187
INSERT INTO t2 VALUES (1,0) ON DUPLICATE KEY UPDATE
188
b=(SELECT '' AS b FROM t1 GROUP BY VALUES(b));
189
INSERT INTO t2(a,b) VALUES (1,0) ON DUPLICATE KEY UPDATE
190
b=(SELECT VALUES(a)+2 FROM t1);