diff options
| author | unknown <svoj@may.pils.ru> | 2006-06-19 14:05:14 +0500 |
|---|---|---|
| committer | unknown <svoj@may.pils.ru> | 2006-06-19 14:05:14 +0500 |
| commit | 46cdd39ea68ca4635983a16ecc1d88b5309e43ef (patch) | |
| tree | 833750e7295c7b3452ff970cf85a822ba0595a03 /mysql-test/t/myisam.test | |
| parent | 3cbf2eafbfd1f7721d85282531ce3378b07d27ba (diff) | |
| download | mariadb-git-46cdd39ea68ca4635983a16ecc1d88b5309e43ef.tar.gz | |
BUG#18036 - update of table joined to self reports table as crashed
Certain updates of table joined to self results in unexpected
behavior.
The problem was that record cache was mistakenly enabled for
self-joined table updates. Normally record cache must be disabled
for such updates.
Fixed wrong condition in code that determines whether to use
record cache for self-joined table updates.
Only MyISAM tables were affected.
mysql-test/r/myisam.result:
Test case for BUG#18036.
mysql-test/t/myisam.test:
Test case for BUG#18036.
sql/sql_update.cc:
Fixed wrong condition in code that determines whether to use
record cache for self-joined table updates.
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 7e4cc324b12..5f948973141 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -705,4 +705,13 @@ select count(*) from t1 where id2 = 10; select count(id1) from t1 where id2 = 10; drop table t1; +# +# BUG#18036 - update of table joined to self reports table as crashed +# +CREATE TABLE t1(a CHAR(9), b VARCHAR(7)) ENGINE=MyISAM; +INSERT INTO t1(a) VALUES('xxxxxxxxx'),('xxxxxxxxx'); +UPDATE t1 AS ta1,t1 AS ta2 SET ta1.b='aaaaaa',ta2.b='bbbbbb'; +SELECT * FROM t1; +DROP TABLE t1; + # End of 4.1 tests |