|
DROP TABLE if EXISTS `t1` ;
|
DROP TABLE if EXISTS `t2` ;
|
CREATE TABLE `t1` (`i` INT NULL) ENGINE = INNODB;
|
CREATE TABLE `t2` (`i` INT NULL) ENGINE = INNODB;
|
update t1, t2 SET t1.i = 999 , t2.i = 999 where t1.i = t2.i and t1.i = 1 and t2.i = 1;
|
throws
/* SQL Error (1178): The storage engine for the table doesn't support IDB-1012: This version of Columnstore supports update of only one table at a time. */
But it works with InnoDB
DROP TABLE if EXISTS `t1` ;
|
DROP TABLE if EXISTS `t2` ;
|
CREATE TABLE `t1` (`i` INT NULL) ENGINE = INNODB;
|
CREATE TABLE `t2` (`i` INT NULL) ENGINE = INNODB;
|
update t1, t2 SET t1.i = 999 , t2.i = 999 where t1.i = t2.i and t1.i = 1 and t2.i = 1;
|
|