bk commit into 5.0 tree (ramil:1.2613) BUG#34774

[ramil]

Below is the list of changes that have just been committed into a local
5.0 repository of ramil.  When ramil does a push these changes
will be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2008-05-05 09:49:39+05:00, ramil@stripped +2 -0
  Test case for bug #34774: key prefix on text field in federated 
  tables can cause server to crash!
  
  The bug will be fixed by patch for #34779: "crash in checksum table
  on federated tables with blobs containing nulls"
  
  Only a test case commited.

  mysql-test/r/federated.result@stripped, 2008-05-05 09:49:37+05:00, ramil@stripped +9 -0
    Test case for bug #34774: key prefix on text field in federated 
    tables can cause server to crash!
      - test result.

  mysql-test/t/federated.test@stripped, 2008-05-05 09:49:37+05:00, ramil@stripped +20 -0
    Test case for bug #34774: key prefix on text field in federated 
    tables can cause server to crash!
      - test case.

diff -Nrup a/mysql-test/r/federated.result b/mysql-test/r/federated.result
--- a/mysql-test/r/federated.result	2008-03-20 19:07:16 +04:00
+++ b/mysql-test/r/federated.result	2008-05-05 09:49:37 +05:00
@@ -2071,6 +2071,15 @@ DROP TABLE t1;
 DROP TABLE t1;
 CREATE TABLE t1 (a INT) ENGINE=federated CONNECTION='mysql://@:://';
 DROP TABLE t1;
+CREATE TABLE t1 (a TEXT, b TEXT, KEY(b(1)));
+INSERT INTO t1 VALUES (NULL, NULL), (NULL, NULL), (NULL, NULL), (NULL, NULL);
+CREATE TABLE t1
+(a TEXT, b TEXT, KEY(b(1))) ENGINE=FEDERATED
+CONNECTION='mysql://root@stripped:SLAVE_PORT/test/t1';
+SELECT t1.a FROM t1, t1 as t2 WHERE t2.b NOT LIKE t1.b;
+a
+DROP TABLE t1;
+DROP TABLE t1;
 DROP TABLE IF EXISTS federated.t1;
 DROP DATABASE IF EXISTS federated;
 DROP TABLE IF EXISTS federated.t1;
diff -Nrup a/mysql-test/t/federated.test b/mysql-test/t/federated.test
--- a/mysql-test/t/federated.test	2008-03-25 12:47:55 +04:00
+++ b/mysql-test/t/federated.test	2008-05-05 09:49:37 +05:00
@@ -1750,4 +1750,24 @@ DROP TABLE t1;
 CREATE TABLE t1 (a INT) ENGINE=federated CONNECTION='mysql://@:://';
 DROP TABLE t1;
 
+
+#
+# Bug #34774    key prefix on text field in federated tables can cause
+# server to crash!
+#
+connection slave;
+CREATE TABLE t1 (a TEXT, b TEXT, KEY(b(1)));
+INSERT INTO t1 VALUES (NULL, NULL), (NULL, NULL), (NULL, NULL), (NULL, NULL);
+connection master;
+--replace_result $SLAVE_MYPORT SLAVE_PORT
+eval CREATE TABLE t1
+  (a TEXT, b TEXT, KEY(b(1))) ENGINE=FEDERATED
+  CONNECTION='mysql://root@stripped:$SLAVE_MYPORT/test/t1';
+SELECT t1.a FROM t1, t1 as t2 WHERE t2.b NOT LIKE t1.b;
+connection slave;
+DROP TABLE t1;
+connection master;
+DROP TABLE t1;
+
+
 source include/federated_cleanup.inc;