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/r/errors.result | |
| parent | d2e447d57c86c726714e2d6502cb208a71c7ce83 (diff) | |
| parent | ad031d51100555dd1b77baaa075d2f7c8790571b (diff) | |
| download | mariadb-git-1a2e4afe355759e9c8259a3ff79c2509dfd54bb0.tar.gz | |
Merge 5.1 => 5.5.
Diffstat (limited to 'mysql-test/r/errors.result')
| -rw-r--r-- | mysql-test/r/errors.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/errors.result b/mysql-test/r/errors.result index e6a1b492b39..3e1848b950f 100644 --- a/mysql-test/r/errors.result +++ b/mysql-test/r/errors.result @@ -146,3 +146,17 @@ ERROR 22003: BIGINT value is out of range in '(-(73) * -(2465717823867977728))' # # End Bug#57882 # +CREATE TABLE t1 (a INT); +CREATE TABLE t2(a INT PRIMARY KEY, b INT); +SELECT '' AS b FROM t1 GROUP BY VALUES(b); +ERROR 42S22: Unknown column '' in 'VALUES() function' +REPLACE t2(b) SELECT '' AS b FROM t1 GROUP BY VALUES(b); +ERROR 42S22: Unknown column '' in 'VALUES() function' +UPDATE t2 SET a=(SELECT '' AS b FROM t1 GROUP BY VALUES(b)); +ERROR 42S22: Unknown column '' in 'VALUES() function' +INSERT INTO t2 VALUES (1,0) ON DUPLICATE KEY UPDATE +b=(SELECT '' AS b FROM t1 GROUP BY VALUES(b)); +ERROR 42S22: Unknown column '' in 'VALUES() function' +INSERT INTO t2(a,b) VALUES (1,0) ON DUPLICATE KEY UPDATE +b=(SELECT VALUES(a)+2 FROM t1); +DROP TABLE t1, t2; |