diff options
| author | jani@ibmlab.site <> | 2006-03-15 09:40:30 +0200 |
|---|---|---|
| committer | jani@ibmlab.site <> | 2006-03-15 09:40:30 +0200 |
| commit | b3e5861a021c13fac43f7b2c8360f14ac3a7e667 (patch) | |
| tree | e0838d9a7077278a29270f5f14c57c35983f29ad /mysql-test/r/alter_table.result | |
| parent | 4700bb93668d00f9a4a1e86518d0324b13bcc79a (diff) | |
| download | mariadb-git-b3e5861a021c13fac43f7b2c8360f14ac3a7e667.tar.gz | |
Added a test case for Bug#18038 MySQL server corrupts binary columns data
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 20 |
1 files changed, 20 insertions, 0 deletions
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; |