diff options
| author | Norvald H. Ryeng <norvald.ryeng@oracle.com> | 2012-03-12 09:24:59 +0100 |
|---|---|---|
| committer | Norvald H. Ryeng <norvald.ryeng@oracle.com> | 2012-03-12 09:24:59 +0100 |
| commit | 1a2e4afe355759e9c8259a3ff79c2509dfd54bb0 (patch) | |
| tree | e81e5701323b0349293d6a96e507ecd3dae592c4 /mysql-test/t/errors.test | |
| parent | d2e447d57c86c726714e2d6502cb208a71c7ce83 (diff) | |
| parent | ad031d51100555dd1b77baaa075d2f7c8790571b (diff) | |
| download | mariadb-git-1a2e4afe355759e9c8259a3ff79c2509dfd54bb0.tar.gz | |
Merge 5.1 => 5.5.
Diffstat (limited to 'mysql-test/t/errors.test')
| -rw-r--r-- | mysql-test/t/errors.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/errors.test b/mysql-test/t/errors.test index 82822c87e89..82204e1bfac 100644 --- a/mysql-test/t/errors.test +++ b/mysql-test/t/errors.test @@ -171,3 +171,21 @@ SELECT UPDATEXML(-73 * -2465717823867977728,@@global.auto_increment_increment,nu --echo # --echo # End Bug#57882 --echo # + +# +# Bug #13031606 VALUES() IN A SELECT STATEMENT CRASHES SERVER +# +CREATE TABLE t1 (a INT); +CREATE TABLE t2(a INT PRIMARY KEY, b INT); +--error ER_BAD_FIELD_ERROR +SELECT '' AS b FROM t1 GROUP BY VALUES(b); +--error ER_BAD_FIELD_ERROR +REPLACE t2(b) SELECT '' AS b FROM t1 GROUP BY VALUES(b); +--error ER_BAD_FIELD_ERROR +UPDATE t2 SET a=(SELECT '' AS b FROM t1 GROUP BY VALUES(b)); +--error ER_BAD_FIELD_ERROR +INSERT INTO t2 VALUES (1,0) ON DUPLICATE KEY UPDATE + b=(SELECT '' AS b FROM t1 GROUP BY VALUES(b)); +INSERT INTO t2(a,b) VALUES (1,0) ON DUPLICATE KEY UPDATE + b=(SELECT VALUES(a)+2 FROM t1); +DROP TABLE t1, t2; |