Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2
-
None
Description
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; |
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-