diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-05-19 11:48:04 +0500 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-05-19 11:48:04 +0500 |
| commit | 6b57f95cb22cdea3443af2d624333ce2d946b963 (patch) | |
| tree | d2419d4559599e25bc022d8c2f0cf72f5aaddbc5 /mysql-test/include/mix1.inc | |
| parent | fb3e433d4e89b8b111444a1460ea2f4cacadbb9b (diff) | |
| parent | 0a892c46e0f53cb1404bea696da6adecb95d39cb (diff) | |
| download | mariadb-git-6b57f95cb22cdea3443af2d624333ce2d946b963.tar.gz | |
5.0-bugteam->5.1-bugteam merge
Diffstat (limited to 'mysql-test/include/mix1.inc')
| -rw-r--r-- | mysql-test/include/mix1.inc | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/include/mix1.inc b/mysql-test/include/mix1.inc index 7c87949830f..d40d78c21b8 100644 --- a/mysql-test/include/mix1.inc +++ b/mysql-test/include/mix1.inc @@ -1162,6 +1162,15 @@ ROLLBACK; --error 1305 ROLLBACK TO SAVEPOINT s4; +# +# Bug#39793 Foreign keys not constructed when column has a '#' in a comment or default value +# + +#This statement should be written on a single line for proper testing +CREATE TABLE t1 (f1 INTEGER PRIMARY KEY COMMENT 'My ID#', f2 INTEGER DEFAULT NULL, f3 CHAR(10) DEFAULT 'My ID#', CONSTRAINT f2_ref FOREIGN KEY (f2) REFERENCES t1 (f1)) ENGINE=INNODB; +SHOW CREATE TABLE t1; +DROP TABLE t1; + --echo End of 5.0 tests # Fix for BUG#19243 "wrong LAST_INSERT_ID() after ON DUPLICATE KEY |