diff options
| author | unknown <aivanov@mysql.com> | 2006-01-30 15:17:33 +0300 |
|---|---|---|
| committer | unknown <aivanov@mysql.com> | 2006-01-30 15:17:33 +0300 |
| commit | cc47eb77913aa40fc7642ccf5d372675059ec8f2 (patch) | |
| tree | 08ba2fde9e3237be148e59033c35f0b139b97a33 /mysql-test/t/innodb.test | |
| parent | 6cc16c50191951e1d4fe3eb657fa53eb3f44da9d (diff) | |
| download | mariadb-git-cc47eb77913aa40fc7642ccf5d372675059ec8f2.tar.gz | |
Fixed BUG#16387.
Applied innodb-4.1-ss17 snapshot.
Do not mistake TABLENAME_ibfk_0 for auto-generated id.
innobase/dict/dict0dict.c:
Applied innodb-4.1-ss17 snapshot.
dict_table_get_highest_foreign_id(): Ignore foreign
constraint identifiers starting with the pattern
TABLENAME_ibfk_0 (BUG#16387).
mysql-test/r/innodb.result:
Applied innodb-4.1-ss17 snapshot.
Fixed results for added test case.
mysql-test/t/innodb.test:
Applied innodb-4.1-ss17 snapshot.
Added test case.
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index e2c12eedcae..ee411a1bb37 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -1365,4 +1365,17 @@ insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1 select a,hex(b) from t1 order by b; update t1 set b = 'three' where a = 6; drop table t1; + +# Ensure that <tablename>_ibfk_0 is not mistreated as a +# generated foreign key identifier. (Bug #16387) + +CREATE TABLE t1(a INT, PRIMARY KEY(a)) ENGINE=InnoDB; +CREATE TABLE t2(a INT) ENGINE=InnoDB; +ALTER TABLE t2 ADD FOREIGN KEY (a) REFERENCES t1(a); +ALTER TABLE t2 DROP FOREIGN KEY t2_ibfk_1; +ALTER TABLE t2 ADD CONSTRAINT t2_ibfk_0 FOREIGN KEY (a) REFERENCES t1(a); +ALTER TABLE t2 DROP FOREIGN KEY t2_ibfk_0; +SHOW CREATE TABLE t2; +DROP TABLE t2,t1; + # End of 4.1 tests |