diff options
author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-28 21:34:17 +0200 |
---|---|---|
committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-12-28 21:34:17 +0200 |
commit | 84a9a9fe5bc7583905672c0b94011cfa1606b08d (patch) | |
tree | 5297180578ae74db613ac34609d154992d7192eb /mysql-test/t/multi_update.test | |
parent | dcf6470f3100bbe7d7d78a47956b6713b0532af3 (diff) | |
download | mariadb-git-84a9a9fe5bc7583905672c0b94011cfa1606b08d.tar.gz |
aliases with multi-table updates / deletes
fix for a bug with derived tables and query cache
ix for a charset bug in timestamp
mysql-test/r/multi_update.result:
aliases with multi-table updates / deletes
mysql-test/r/query_cache.result:
fix for query cache with derived tables
mysql-test/t/multi_update.test:
aliases with multi-table updates / deletes
mysql-test/t/outfile.test:
Fix of bug with charset in timestamp
mysql-test/t/query_cache.test:
fix for a bug with derived tables and query cache
sql/field.cc:
fix for a charset bug in timestamp
sql/sql_parse.cc:
aliases with multi-table updates / deletes
sql/sql_yacc.yy:
aliases with multi-table updates / deletes
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r-- | mysql-test/t/multi_update.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test index 4e0622d14bb..28780ab4ed0 100644 --- a/mysql-test/t/multi_update.test +++ b/mysql-test/t/multi_update.test @@ -213,7 +213,7 @@ insert into t2 values(1,10),(1,20); UPDATE t1,t2 SET t1.d=t2.d,t2.d=30 WHERE t1.n=t2.n; select * from t1; select * from t2; -UPDATE t1 a ,t2 b SET t1.d=t2.d,t2.d=30 WHERE a.n=b.n; +UPDATE t1 a ,t2 b SET a.d=b.d,b.d=30 WHERE a.n=b.n; select * from t1; select * from t2; DELETE t1, t2 FROM t1 a,t2 b where a.n=b.n; |