diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-11-05 12:20:41 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-11-05 12:20:41 +0300 |
| commit | c063bd171e4eb4067e6684b77277e170b7a668bc (patch) | |
| tree | 8b36c387d70977c948b7d1412fcd7d9b940852af /mysql-test/t/update.test | |
| parent | b40aed07bffb6fa37fc03ccd063b5a189e8ddb71 (diff) | |
| parent | 754dee8e51950365956efb793af34a769cbd4792 (diff) | |
| download | mariadb-git-c063bd171e4eb4067e6684b77277e170b7a668bc.tar.gz | |
Manual merge from mysql-5.1.
Diffstat (limited to 'mysql-test/t/update.test')
| -rw-r--r-- | mysql-test/t/update.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 7d56df259ba..02e8763a630 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -452,3 +452,18 @@ DROP TABLE t1; DROP FUNCTION f1; --echo End of 5.0 tests + +--echo # +--echo # Bug #47919 assert in open_table during ALTER temporary table +--echo # + +CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT, PRIMARY KEY (f1)); +CREATE TEMPORARY TABLE t2 LIKE t1; +INSERT INTO t1 VALUES (1); +INSERT INTO t2 VALUES (1); + +ALTER TABLE t2 COMMENT = 'ABC'; +UPDATE t2, t1 SET t2.f1 = 2, t1.f1 = 9; +ALTER TABLE t2 COMMENT = 'DEF'; + +DROP TABLE t1, t2; |