summaryrefslogtreecommitdiff
path: root/mysql-test/t/binary.test
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2004-11-16 12:05:13 +0400
committerunknown <bar@mysql.com>2004-11-16 12:05:13 +0400
commitb670ccac133f8ff678d6721fef28397250c14cda (patch)
tree18b9b859c65287cb82f8af17aba3388a58b7620e /mysql-test/t/binary.test
parentb478635110d05f644c7fcca476f5cfc6c9ba1e40 (diff)
downloadmariadb-git-b670ccac133f8ff678d6721fef28397250c14cda.tar.gz
Bug #6552 CHAR column w/o length is legal, BINARY w/o length is not
Diffstat (limited to 'mysql-test/t/binary.test')
-rw-r--r--mysql-test/t/binary.test7
1 files changed, 7 insertions, 0 deletions
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;