diff options
| author | unknown <anozdrin/alik@quad.> | 2008-02-15 14:14:09 +0300 |
|---|---|---|
| committer | unknown <anozdrin/alik@quad.> | 2008-02-15 14:14:09 +0300 |
| commit | ea34b5e7aa2eb78a77a619875e33dab773185ed9 (patch) | |
| tree | 8a9e4dd85bad6b33aa0698b2424a9801706ec0fa /mysql-test/r/innodb_mysql.result | |
| parent | 5704c7fe2cf52fb8bec0f8e8006f7a4b181e1660 (diff) | |
| download | mariadb-git-ea34b5e7aa2eb78a77a619875e33dab773185ed9.tar.gz | |
Add a test case for Bug#21704: Renaming column does not update
FK definition.
mysql-test/r/innodb_mysql.result:
Updated result file.
Diffstat (limited to 'mysql-test/r/innodb_mysql.result')
| -rw-r--r-- | mysql-test/r/innodb_mysql.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_mysql.result b/mysql-test/r/innodb_mysql.result index e9f00a667c0..ffc3ca25a99 100644 --- a/mysql-test/r/innodb_mysql.result +++ b/mysql-test/r/innodb_mysql.result @@ -1634,4 +1634,17 @@ vid tid idx name type 3 1 2 c1 NULL 3 1 1 pk NULL DROP TABLE t1; +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +CREATE TABLE t1(id INT PRIMARY KEY) +ENGINE=innodb; +CREATE TABLE t2( +t1_id INT PRIMARY KEY, +CONSTRAINT fk1 FOREIGN KEY (t1_id) REFERENCES t1(id)) +ENGINE=innodb; + +ALTER TABLE t1 CHANGE id id2 INT; + +DROP TABLE t2; +DROP TABLE t1; End of 5.1 tests |