diff options
| author | unknown <jani@ibmlab.site> | 2006-03-15 09:40:30 +0200 |
|---|---|---|
| committer | unknown <jani@ibmlab.site> | 2006-03-15 09:40:30 +0200 |
| commit | 8ba02d7270919ad493b4061d04d6204cd81e805c (patch) | |
| tree | e0838d9a7077278a29270f5f14c57c35983f29ad /mysql-test/t/alter_table.test | |
| parent | d4df3f23eaa67210cd5ad4a1f1e6ef90a868660a (diff) | |
| download | mariadb-git-8ba02d7270919ad493b4061d04d6204cd81e805c.tar.gz | |
Added a test case for Bug#18038 MySQL server corrupts binary columns data
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 6d0ec720840..57fa7acbc86 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -449,3 +449,21 @@ 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; + +# +# Bug#18038 MySQL server corrupts binary columns data +# + +CREATE TABLE t1 (s CHAR(8) BINARY); +INSERT INTO t1 VALUES ('test'); +SELECT LENGTH(s) FROM t1; +ALTER TABLE t1 MODIFY s CHAR(10) BINARY; +SELECT LENGTH(s) FROM t1; +DROP TABLE t1; + +CREATE TABLE t1 (s BINARY(8)); +INSERT INTO t1 VALUES ('test'); +SELECT LENGTH(s) FROM t1; +ALTER TABLE t1 MODIFY s BINARY(10); +SELECT LENGTH(s) FROM t1; +DROP TABLE t1; |