From e2ba74b8252586bd27ace8603aab33c76b2b50cd Mon Sep 17 00:00:00 2001
From: unknown <cmiller@zippy.(none)>
Date: Thu, 2 Mar 2006 19:59:49 -0500
Subject: Expanding a binary field should result in 0x00-filled positions, not
 0x20 (ASCII space).  For Bug#16857.

sql/field_conv.cc:
  Bug#16857:  Do not expand BINARY fields as if they are strings (which
  presumably /should/ be filled with spaces).  Instead, fill BINARY fields
  with 0x00 bytes.
---
 mysql-test/r/binary.result | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'mysql-test/r/binary.result')

diff --git a/mysql-test/r/binary.result b/mysql-test/r/binary.result
index a8d6c3bf411..c5673d1c00d 100644
--- a/mysql-test/r/binary.result
+++ b/mysql-test/r/binary.result
@@ -141,3 +141,22 @@ t1	CREATE TABLE `t1` (
   `a` binary(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
 drop table t1;
+create table t1 (col1 binary(4));
+insert into t1 values ('a'),('a ');
+select hex(col1) from t1;
+hex(col1)
+61000000
+61200000
+alter table t1 modify col1 binary(10);
+select hex(col1) from t1;
+hex(col1)
+61000000000000000000
+61200000000000000000
+insert into t1 values ('b'),('b ');
+select hex(col1) from t1;
+hex(col1)
+61000000000000000000
+61200000000000000000
+62000000000000000000
+62200000000000000000
+drop table t1;
-- 
cgit v1.2.1