diff options
| author | unknown <svoj@mysql.com/april.(none)> | 2006-12-20 20:01:31 +0400 |
|---|---|---|
| committer | unknown <svoj@mysql.com/april.(none)> | 2006-12-20 20:01:31 +0400 |
| commit | 2efb6576008acd580680849e1e618da021b57c7e (patch) | |
| tree | 07b49f1420b38586b00555274fbede619a469630 /mysql-test/t/myisam.test | |
| parent | 76da582ca5f8a93ae5ff7e7fdea1991d47658196 (diff) | |
| parent | 9d094c56bc6f15d16f51d4b0bcf9de3cd4674d7f (diff) | |
| download | mariadb-git-2efb6576008acd580680849e1e618da021b57c7e.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG21310/mysql-4.1-engines
into mysql.com:/home/svoj/devel/mysql/BUG21310/mysql-5.0-engines
sql/lock.cc:
Use local.
mysql-test/r/myisam.result:
Manual merge.
mysql-test/t/myisam.test:
Manual merge.
sql/sql_update.cc:
Manual merge.
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index d785002abdd..34267c3754a 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -1004,4 +1004,23 @@ connection default; select * from t1; drop table t1; +# +# BUG#21310 - Trees in SQL causing a "crashed" table with MyISAM storage +# engine +# + +# A simplified test case that reflect crashed table issue. +CREATE TABLE t1(a VARCHAR(16)); +INSERT INTO t1 VALUES('aaaaaaaa'),(NULL); +UPDATE t1 AS ta1, t1 AS ta2 SET ta1.a='aaaaaaaaaaaaaaaa'; +SELECT * FROM t1; +DROP TABLE t1; + +# A test case that reflect wrong result set. +CREATE TABLE t1(a INT); +INSERT INTO t1 VALUES(1),(2); +UPDATE t1,t1 AS t2 SET t1.a=t1.a+2 WHERE t1.a=t2.a-1; +SELECT * FROM t1 ORDER BY a; +DROP TABLE t1; + # End of 4.1 tests |