diff options
| author | bell@sanja.is.com.ua <> | 2004-02-09 14:44:03 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-02-09 14:44:03 +0200 |
| commit | 74a9ca1991b61c51d666ac5901b9358085deea6c (patch) | |
| tree | d823a9d8db9cbcd5878af1651e74b2afa0277116 /mysql-test/r/derived.result | |
| parent | b99d13582b7d874879d6bdc0748aaef6a4fa2d08 (diff) | |
| download | mariadb-git-74a9ca1991b61c51d666ac5901b9358085deea6c.tar.gz | |
ufter revview fix (BUG#2120)
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index dea4dd9b4c2..6f35097e2b8 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -267,12 +267,16 @@ N M 3 0 UPDATE `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N SET P1.M = 2, P2.N = 2; ERROR HY000: The target table P2 of the UPDATE is not updatable. +UPDATE `t1` AS P1 INNER JOIN (SELECT aaaa FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N SET P1.M = 2; +ERROR 42S22: Unknown column 'aaaa' in 'field list' delete P1.* from `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N; select * from t1; N M 3 0 delete P1.*,P2.* from `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N; ERROR HY000: The target table P2 of the DELETE is not updatable. +delete P1.* from `t1` AS P1 INNER JOIN (SELECT aaa FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N; +ERROR 42S22: Unknown column 'aaa' in 'field list' drop table t1; CREATE TABLE t1 ( OBJECTID int(11) NOT NULL default '0', |