diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2004-05-04 23:04:05 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2004-05-04 23:04:05 +0300 |
| commit | 5bd7b50cf1c227af00cdf3fab969ee5a2545f4f4 (patch) | |
| tree | ab3b788364417bddf4ae2820a5b6a3f7294f4e57 /mysql-test/r/multi_update.result | |
| parent | af794dde932c9fcf056c8afcfd00ad3483d237c7 (diff) | |
| download | mariadb-git-5bd7b50cf1c227af00cdf3fab969ee5a2545f4f4.tar.gz | |
Fix for a multi table updates when one of the tables is not updated
but used in a nested query.
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index f0975b6fa10..2b312a86289 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -324,6 +324,7 @@ a b 7 7 8 8 9 9 +update t1,t2 set t1.b=t2.b, t1.a=t2.a where t1.a=t2.a and not exists (select * from t2 where t2.a > 10); drop table t1,t2; CREATE TABLE t3 ( KEY1 varchar(50) NOT NULL default '', PARAM_CORR_DISTANCE_RUSH double default NULL, PARAM_CORR_DISTANCE_GEM double default NULL, PARAM_AVG_TARE double default NULL, PARAM_AVG_NB_DAYS double default NULL, PARAM_DEFAULT_PROP_GEM_SRVC varchar(50) default NULL, PARAM_DEFAULT_PROP_GEM_NO_ETIK varchar(50) default NULL, PARAM_SCENARIO_COSTS varchar(50) default NULL, PARAM_DEFAULT_WAGON_COST double default NULL, tmp int(11) default NULL, PRIMARY KEY (KEY1)) ENGINE=MyISAM; INSERT INTO t3 VALUES ('A',1,1,22,3.2,'R','R','BASE2',0.24,NULL); |