summaryrefslogtreecommitdiff
path: root/mysql-test/r/multi_update.result
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2003-12-13 04:04:38 +0200
committerunknown <monty@mysql.com>2003-12-13 04:04:38 +0200
commitdb37aa2297d30c339b1d6128f26fe437ae89a605 (patch)
treecf05e1e4ec36f367ed2af0f1637a851099cc54ba /mysql-test/r/multi_update.result
parentcbc18a76c83365240b0bb684b8b0990ca6d4797d (diff)
parent759ea82ee1335543da1d484d76468b6686057e90 (diff)
downloadmariadb-git-db37aa2297d30c339b1d6128f26fe437ae89a605.tar.gz
Merge
sql/sql_select.cc: Auto merged sql/sql_update.cc: Auto merged mysql-test/r/multi_update.result: SCCS merged mysql-test/t/multi_update.test: SCCS merged
Diffstat (limited to 'mysql-test/r/multi_update.result')
-rw-r--r--mysql-test/r/multi_update.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result
index 5b265d578cd..31be96fc0fd 100644
--- a/mysql-test/r/multi_update.result
+++ b/mysql-test/r/multi_update.result
@@ -327,6 +327,16 @@ select t1.a, t1.b,t2.a, t2.b from t1 left join t2 on t1.a=t2.a where t1.b=1 and
a b a b
2 2 NULL NULL
drop table t1,t2;
+create table t1 (a int not null auto_increment primary key, b int not null);
+insert into t1 (b) values (1),(2),(3),(4);
+update t1, t1 as t2 set t1.b=t2.b+1 where t1.a=t2.a;
+select * from t1;
+a b
+1 2
+2 3
+3 4
+4 5
+drop table t1;
drop table if exists t1, t2;
create table t1(id1 smallint(5), field char(5));
create table t2(id2 smallint(5), field char(5));