diff options
author | unknown <tomas@whalegate.ndb.mysql.com> | 2007-12-10 13:29:23 +0100 |
---|---|---|
committer | unknown <tomas@whalegate.ndb.mysql.com> | 2007-12-10 13:29:23 +0100 |
commit | dad3e3f66d2319754617b526893c3ee9f80fb7b2 (patch) | |
tree | 2c1914ebc5314d6a989d23a9d7c84f0468a96302 /mysql-test/suite/ndb/t/ndb_blob.test | |
parent | f3ccf7ea135e8d2979df594df3ac71766c85b3fd (diff) | |
download | mariadb-git-dad3e3f66d2319754617b526893c3ee9f80fb7b2.tar.gz |
backport test for bug#30674
(bug not present in 5.1)
Diffstat (limited to 'mysql-test/suite/ndb/t/ndb_blob.test')
-rw-r--r-- | mysql-test/suite/ndb/t/ndb_blob.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/ndb/t/ndb_blob.test b/mysql-test/suite/ndb/t/ndb_blob.test index b9a8c7e20ee..0388913df8b 100644 --- a/mysql-test/suite/ndb/t/ndb_blob.test +++ b/mysql-test/suite/ndb/t/ndb_blob.test @@ -497,3 +497,23 @@ select count(*) from t1; drop table t1; # End of 4.1 tests + + +# bug # 30674 : +# NOT NULL Blobs should default to zero-length. Not NULL TEXT +# should default to zero-chars +create table t1( + a int, + blob_nn blob not null, + text_nn text not null, + blob_nl blob, + text_nl text, + primary key(a) +) engine=ndb; + +insert into t1(a) values (1); +insert into t1(a, text_nl) values (2, 'MySQL Cluster NDB'); + +select a, length(blob_nn), length(text_nn), blob_nl, text_nl from t1 order by a; + +drop table t1; |