bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3507) Bug#51232

[Dmitry Shulga]

#At file:///Users/shulga/projects/mysql/5.1-bugteam-bug51232/ based on revid:gshchepa@stripped

 3507 Dmitry Shulga	2010-09-27
      Added a test case for Bug#51232. The bug itself can not be repeated.

    modified:
      mysql-test/r/parser.result
      mysql-test/t/parser.test
=== modified file 'mysql-test/r/parser.result'
--- a/mysql-test/r/parser.result	2009-04-17 20:00:53 +0000
+++ b/mysql-test/r/parser.result	2010-09-27 16:44:31 +0000
@@ -615,6 +615,19 @@ UPDATE t3 SET a4={d '1789-07-14'} WHERE 
 SELECT a1, a4 FROM t2 WHERE a4 LIKE {fn UCASE('1789-07-14')};
 a1	a4
 DROP TABLE t1, t2, t3;
+DROP TABLE IF EXISTS T1;
+CREATE TABLE T1 (A1 int(11) NOT NULL auto_increment,  
+PRIMARY KEY (A1))
+ENGINE=InnoDB DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS T2;
+CREATE TABLE T2 (B1 int(11) NOT NULL auto_increment,
+B2 int(11) default NULL,
+PRIMARY KEY (B1), CONSTRAINT C_1
+FOREIGN KEY (B2) REFERENCES T2 (B1) )
+ENGINE=InnoDB DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS T1;
+DROP TABLE IF EXISTS T2;
+$$
 #
 # End of 5.1 tests
 #

=== modified file 'mysql-test/t/parser.test'
--- a/mysql-test/t/parser.test	2009-04-17 20:00:53 +0000
+++ b/mysql-test/t/parser.test	2010-09-27 16:44:31 +0000
@@ -725,6 +725,26 @@ UPDATE t3 SET a4={d '1789-07-14'} WHERE 
 SELECT a1, a4 FROM t2 WHERE a4 LIKE {fn UCASE('1789-07-14')};
 DROP TABLE t1, t2, t3;
 
+#
+# Bug#51232
+#
+--source include/have_innodb.inc
+--delimiter $$
+DROP TABLE IF EXISTS T1;
+CREATE TABLE T1 (A1 int(11) NOT NULL auto_increment,  
+PRIMARY KEY (A1))
+ENGINE=InnoDB DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS T2;
+CREATE TABLE T2 (B1 int(11) NOT NULL auto_increment,
+B2 int(11) default NULL,
+PRIMARY KEY (B1), CONSTRAINT C_1
+FOREIGN KEY (B2) REFERENCES T2 (B1) )
+ENGINE=InnoDB DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS T1;
+DROP TABLE IF EXISTS T2;
+$$
+--delimiter ;
+
 --echo #
 --echo # End of 5.1 tests
 --echo #


Attachment: [text/bzr-bundle] bzr/[e-mail]