905
905
SELECT * from t1;
909
# Test multi update with different join methods
912
CREATE TABLE t1 (a int not null primary key, b int not null, key (b)) engine=innodb;
913
CREATE TABLE t2 (a int not null primary key, b int not null, key (b)) engine=innodb;
914
INSERT INTO t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12);
915
INSERT INTO t2 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9);
917
# Full join, without key
918
update t1,t2 set t1.a=t1.a+100;
922
update t1,t2 set t1.a=t1.a+100 where t1.a=101;
926
update t1,t2 set t1.b=t1.b+10 where t1.b=2;
930
update t1,t2 set t1.b=t1.b+2,t2.b=t1.b+10 where t1.b between 3 and 5 and t1.a=t2.a+100;
935
908
CREATE TABLE t2 ( NEXT_T BIGINT NOT NULL PRIMARY KEY) ENGINE=MyISAM;
936
909
CREATE TABLE t1 ( B_ID INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
937
910
SET AUTOCOMMIT=0;