summaryrefslogtreecommitdiff
path: root/mysql-test/t/information_schema.test
diff options
context:
space:
mode:
authorunknown <ramil@mysql.com>2005-10-25 17:22:58 +0500
committerunknown <ramil@mysql.com>2005-10-25 17:22:58 +0500
commit48765db2e5981488ac97cb6b40ffc1df41b7d2d4 (patch)
treed1bbe2ceb5a3b0d6e932f94f8353f8274e6d5f95 /mysql-test/t/information_schema.test
parentabd77bc56397c1522f2b729334f877f9806dafd2 (diff)
downloadmariadb-git-48765db2e5981488ac97cb6b40ffc1df41b7d2d4.tar.gz
Fix for bug #14290: wrong CHARACTER_MAXIMUM_LENGTH value for some text fields.
sql/sql_show.cc: Fix for bug #14290: wrong CHARACTER_MAXIMUM_LENGTH value for some text fields. adjust CHARACTER_MAXIMUM_LENGTH value for text fields.
Diffstat (limited to 'mysql-test/t/information_schema.test')
-rw-r--r--mysql-test/t/information_schema.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test
index 9fb57fc187b..614cc5e6f9b 100644
--- a/mysql-test/t/information_schema.test
+++ b/mysql-test/t/information_schema.test
@@ -727,3 +727,12 @@ use information_schema;
select 1 from (select 1 from test.t1) a;
use test;
drop table t1;
+
+#
+# Bug #14290: character_maximum_length for text fields
+#
+
+create table t1(a blob, b text charset utf8, c text charset ucs2);
+select data_type, character_octet_length, character_maximum_length
+ from information_schema.columns where table_name='t1';
+drop table t1;