summaryrefslogtreecommitdiff
path: root/mysql-test/t/dyncol.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2015-10-19 12:15:49 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2015-10-19 12:15:49 +0200
commit9a3ff0789fbf6c0ea627415c90ae5487449f433b (patch)
tree0804d71662e1b4497bc77559afa2e759a768229a /mysql-test/t/dyncol.test
parent151f967380c44d46a6d9a5fda1d19985ebf0e22c (diff)
downloadmariadb-git-9a3ff0789fbf6c0ea627415c90ae5487449f433b.tar.gz
MDEV-8565: COLUMN_CHECK fails on valid data
Check allows zero lengts int/uint now.
Diffstat (limited to 'mysql-test/t/dyncol.test')
-rw-r--r--mysql-test/t/dyncol.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/dyncol.test b/mysql-test/t/dyncol.test
index 86dcee8148a..ac55fec3e2b 100644
--- a/mysql-test/t/dyncol.test
+++ b/mysql-test/t/dyncol.test
@@ -872,5 +872,17 @@ set impressions = column_add(impressions,
drop table t1;
--echo #
+--echo # MDEV-8565: COLUMN_CHECK fails on valid data
+--echo #
+
+SELECT COLUMN_CHECK(COLUMN_CREATE('a',0,'b','1'));
+
+SELECT COLUMN_CHECK(COLUMN_CREATE('a',1,'b','1'));
+
+SELECT COLUMN_JSON(COLUMN_CREATE('a',0,'b','1'));
+
+SELECT COLUMN_JSON(COLUMN_CREATE('a',1,'b','1'));
+
+--echo #
--echo # end of 10.0 tests
--echo #