bzr commit into mysql-5.0-bugteam branch (ramil:2715) Bug#34774

[Ramil Kalimullin]

#At file:///home/ram/mysql/mysql-5.0-bugteam/

 2715 Ramil Kalimullin	2008-11-14
      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.
modified:
  mysql-test/r/federated.result
  mysql-test/t/federated.test

per-file messages:
  mysql-test/r/federated.result
    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
    Test case for bug #34774: key prefix on text field in federated 
    tables can cause server to crash!
      - test case.
=== modified file 'mysql-test/r/federated.result'
--- a/mysql-test/r/federated.result	2008-09-16 17:05:30 +0000
+++ b/mysql-test/r/federated.result	2008-11-14 07:42:29 +0000
@@ -2085,6 +2085,15 @@ Table	Checksum
 test.t1	2465757603
 DROP TABLE t1;
 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;
 End of 5.0 tests
 SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
 SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;

=== modified file 'mysql-test/t/federated.test'
--- a/mysql-test/t/federated.test	2008-09-16 17:05:30 +0000
+++ b/mysql-test/t/federated.test	2008-11-14 07:42:29 +0000
@@ -1824,6 +1824,25 @@ DROP TABLE t1;
 connection master;
 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;
+
 connection default;
 
 --echo End of 5.0 tests