bk commit into 5.1 tree (pgalbraith:1.2279) BUG#14532

[Patrick Galbraith]

Below is the list of changes that have just been committed into a local
5.1 repository of pgalbraith. When pgalbraith 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, 2006-08-04 14:31:13+02:00, pgalbraith@stripped +2 -0
  "BUG #14532: BIT type broken on federated"
  
  Added bit type to test and new results for federated test
  
  federated.test:
    "BUG #14532: BIT type broken on federated"
    Added test for bit type as listed in bug report
  federated.result:
    "BUG #14532: BIT type broken on federated"
    Result of new bit type test

  mysql-test/r/federated.result@stripped, 2006-08-04 14:29:15+02:00, pgalbraith@stripped +13 -0
    "#14532: BIT type broken on federated"
    Result of new bit type test

  mysql-test/t/federated.test@stripped, 2006-08-04 14:28:36+02:00, pgalbraith@stripped +15 -0
    "#14532: BIT type broken on federated"
    Added test for bit type as listed in bug report

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	pgalbraith
# Host:	production.mysql.com
# Root:	/usersnfs/pgalbraith/mysql-build/mysql-5.1-engines-bug14532

--- 1.37/mysql-test/r/federated.result	2006-08-04 14:31:21 +02:00
+++ 1.38/mysql-test/r/federated.result	2006-08-04 14:31:21 +02:00
@@ -1733,6 +1733,19 @@
 9	abc	ppc
 drop table federated.t1, federated.t2;
 drop table federated.t1, federated.t2;
+create table federated.t1  (
+`bitcol` bit(3)
+) ;
+create table federated.t1  (
+`bitcol` bit(3)
+) ENGINE=FEDERATED CONNECTION="mysql://root@stripped:SLAVE_PORT/federated/t1";
+INSERT INTO federated.t1 (`bitcol`) VALUES (b'001');
+select hex(bitcol) from federated.t1;
+hex(bitcol)
+1
+select hex(bitcol) from federated.t1;
+hex(bitcol)
+1
 DROP TABLE IF EXISTS federated.t1;
 DROP DATABASE IF EXISTS federated;
 DROP TABLE IF EXISTS federated.t1;

--- 1.32/mysql-test/t/federated.test	2006-08-04 14:31:21 +02:00
+++ 1.33/mysql-test/t/federated.test	2006-08-04 14:31:21 +02:00
@@ -1479,5 +1479,20 @@
 
 connection slave;
 drop table federated.t1, federated.t2;
+create table federated.t1  (
+ `bitcol` bit(3)
+) ;
+
+connection master;
+--replace_result $SLAVE_MYPORT SLAVE_PORT
+eval create table federated.t1  (
+ `bitcol` bit(3)
+) ENGINE=FEDERATED CONNECTION="mysql://root@stripped:$SLAVE_MYPORT/federated/t1";
+
+INSERT INTO federated.t1 (`bitcol`) VALUES (b'001');
+select hex(bitcol) from federated.t1;
+
+connection slave;
+select hex(bitcol) from federated.t1;
 
 source include/federated_cleanup.inc;