diff options
| author | kaa@polly.local <> | 2007-04-27 12:42:15 +0400 |
|---|---|---|
| committer | kaa@polly.local <> | 2007-04-27 12:42:15 +0400 |
| commit | d7d0337482a3b07431766f30fa9035b97e385950 (patch) | |
| tree | 678e2b08d413fc216e80c2b8b8c7f369122aeb34 /mysql-test/r/update.result | |
| parent | 66b0e9ca7a7883fbc252c5ca17696fdd570a3b09 (diff) | |
| parent | 9a99aa81552178b2d7995ea41e0878dc59061c9b (diff) | |
| download | mariadb-git-d7d0337482a3b07431766f30fa9035b97e385950.tar.gz | |
Merge polly.local:/home/kaa/src/maint/bug22364/my50-bug22364
into polly.local:/home/kaa/src/maint/bug22364/my51-bug22364
Diffstat (limited to 'mysql-test/r/update.result')
| -rw-r--r-- | mysql-test/r/update.result | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index 94b62625c3f..b861ec96882 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -457,3 +457,38 @@ a quux 2 0.100000000000000000000000000000 3 NULL DROP TABLE t1; +set tmp_table_size=1024; +create table t1 (id int, a int, key idx(a)); +create table t2 (id int unsigned not null auto_increment primary key, a int); +insert into t2(a) values(1),(2),(3),(4),(5),(6),(7),(8); +insert into t2(a) select a from t2; +insert into t2(a) select a from t2; +insert into t2(a) select a from t2; +update t2 set a=id; +insert into t1 select * from t2; +select count(*) from t1 join t2 on (t1.a=t2.a); +count(*) +64 +update t1 join t2 on (t1.a=t2.a) set t1.id=t2.id; +affected rows: 0 +info: Rows matched: 64 Changed: 0 Warnings: 0 +insert into t2(a) select a from t2; +update t2 set a=id; +truncate t1; +insert into t1 select * from t2; +select count(*) from t1 join t2 on (t1.a=t2.a); +count(*) +128 +update t1 join t2 on (t1.a=t2.a) set t1.id=t2.id; +affected rows: 0 +info: Rows matched: 128 Changed: 0 Warnings: 0 +update t1 set a=1; +update t2 set a=1; +select count(*) from t1 join t2 on (t1.a=t2.a); +count(*) +16384 +update t1 join t2 on (t1.a=t2.a) set t1.id=t2.id; +affected rows: 127 +info: Rows matched: 128 Changed: 127 Warnings: 0 +drop table t1,t2; +End of 5.0 tests |