diff options
| author | unknown <bar@mysql.com> | 2004-11-16 12:05:13 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-11-16 12:05:13 +0400 |
| commit | b670ccac133f8ff678d6721fef28397250c14cda (patch) | |
| tree | 18b9b859c65287cb82f8af17aba3388a58b7620e /mysql-test | |
| parent | b478635110d05f644c7fcca476f5cfc6c9ba1e40 (diff) | |
| download | mariadb-git-b670ccac133f8ff678d6721fef28397250c14cda.tar.gz | |
Bug #6552 CHAR column w/o length is legal, BINARY w/o length is not
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/binary.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/binary.test | 7 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/binary.result b/mysql-test/r/binary.result index 405de1158d6..5b5f673b071 100644 --- a/mysql-test/r/binary.result +++ b/mysql-test/r/binary.result @@ -134,3 +134,10 @@ select * from t1 where firstname='john' and firstname like binary 'John'; firstname lastname John Doe drop table t1; +create table t1 (a binary); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` binary(1) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1; diff --git a/mysql-test/t/binary.test b/mysql-test/t/binary.test index 3e702fd5257..54ad8e92237 100644 --- a/mysql-test/t/binary.test +++ b/mysql-test/t/binary.test @@ -80,3 +80,10 @@ select * from t1 where firstname='john' and firstname = binary 'john'; select * from t1 where firstname='John' and firstname like binary 'john'; select * from t1 where firstname='john' and firstname like binary 'John'; drop table t1; + +# +# Bug #6552 CHAR column w/o length is legal, BINARY w/o length is not +# +create table t1 (a binary); +show create table t1; +drop table t1; |