From: Date: March 15 2006 9:14am
Subject: bk commit into 5.1 tree (jani:1.2184)
List-Archive: http://lists.mysql.com/commits/3852
Message-Id: <20060315081443.641EB239B8D@ibmlab.fi>

Below is the list of changes that have just been committed into a local
5.1 repository of jani. When jani 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
  1.2184 06/03/15 10:14:35 jani@stripped +2 -0
  Extended test case to check that binary column
  actually adds zeroes, not spaces at the end.

  mysql-test/t/alter_table.test
    1.48 06/03/15 10:14:30 jani@stripped +2 -0
    Extended test case to check that binary column
    actually adds zeroes, not spaces at the end.

  mysql-test/r/alter_table.result
    1.63 06/03/15 10:14:30 jani@stripped +6 -0
    Extended test case to check that binary column
    actually adds zeroes, not spaces at the end.

# 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:	jani
# Host:	ibmlab.site
# Root:	/home/my/bk/mysql-5.1-new

--- 1.62/mysql-test/r/alter_table.result	2006-03-15 09:40:24 +02:00
+++ 1.63/mysql-test/r/alter_table.result	2006-03-15 10:14:30 +02:00
@@ -636,7 +636,13 @@
 SELECT LENGTH(s) FROM t1;
 LENGTH(s)
 8
+SELECT HEX(s) FROM t1;
+HEX(s)
+7465737400000000
 ALTER TABLE t1 MODIFY s BINARY(10);
+SELECT HEX(s) FROM t1;
+HEX(s)
+74657374000000000000
 SELECT LENGTH(s) FROM t1;
 LENGTH(s)
 10

--- 1.47/mysql-test/t/alter_table.test	2006-03-15 09:40:24 +02:00
+++ 1.48/mysql-test/t/alter_table.test	2006-03-15 10:14:30 +02:00
@@ -464,6 +464,8 @@
 CREATE TABLE t1 (s BINARY(8));
 INSERT INTO t1 VALUES ('test');
 SELECT LENGTH(s) FROM t1;
+SELECT HEX(s) FROM t1;
 ALTER TABLE t1 MODIFY s BINARY(10);
+SELECT HEX(s) FROM t1;
 SELECT LENGTH(s) FROM t1;
 DROP TABLE t1;