From b3e5861a021c13fac43f7b2c8360f14ac3a7e667 Mon Sep 17 00:00:00 2001
From: "jani@ibmlab.site" <>
Date: Wed, 15 Mar 2006 09:40:30 +0200
Subject: Added a test case for Bug#18038  MySQL server corrupts binary columns
 data

---
 mysql-test/r/alter_table.result | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

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

diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result
index 92c6cf052e3..f1ad8d31334 100644
--- a/mysql-test/r/alter_table.result
+++ b/mysql-test/r/alter_table.result
@@ -621,3 +621,23 @@ create table t1 (t varchar(255) default null, key t (t(80)))
 engine=myisam default charset=latin1;
 alter table t1 change t t text;
 drop table t1;
+CREATE TABLE t1 (s CHAR(8) BINARY);
+INSERT INTO t1 VALUES ('test');
+SELECT LENGTH(s) FROM t1;
+LENGTH(s)
+4
+ALTER TABLE t1 MODIFY s CHAR(10) BINARY;
+SELECT LENGTH(s) FROM t1;
+LENGTH(s)
+4
+DROP TABLE t1;
+CREATE TABLE t1 (s BINARY(8));
+INSERT INTO t1 VALUES ('test');
+SELECT LENGTH(s) FROM t1;
+LENGTH(s)
+8
+ALTER TABLE t1 MODIFY s BINARY(10);
+SELECT LENGTH(s) FROM t1;
+LENGTH(s)
+10
+DROP TABLE t1;
-- 
cgit v1.2.1