summaryrefslogtreecommitdiff
path: root/mysql-test/suite/funcs_1/t/is_cml_innodb.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/funcs_1/t/is_cml_innodb.test')
-rw-r--r--mysql-test/suite/funcs_1/t/is_cml_innodb.test41
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/t/is_cml_innodb.test b/mysql-test/suite/funcs_1/t/is_cml_innodb.test
new file mode 100644
index 00000000000..a37e5c8d94c
--- /dev/null
+++ b/mysql-test/suite/funcs_1/t/is_cml_innodb.test
@@ -0,0 +1,41 @@
+# suite/funcs_1/t/is_cml_innodb.test
+#
+# Check the content of information_schema.columns about tables using
+# UNICODE columns.
+# Variant for storage engine InnoDB
+#
+# Author:
+# 2008-06-04 mleich Create this script based on older scripts and new code.
+#
+
+--source include/have_ucs2.inc
+
+# This test cannot be used for the embedded server because privileges
+# are expected within result sets.
+--source include/not_embedded.inc
+
+--source include/have_innodb.inc
+let $engine_type= InnoDB;
+USE test;
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+eval CREATE TABLE t1
+(
+ f1 CHAR UNICODE,
+ f2 CHAR(0) UNICODE,
+ f3 CHAR(10) UNICODE,
+ f5 VARCHAR(0) UNICODE,
+ f6 VARCHAR(255) UNICODE,
+ f7 VARCHAR(260) UNICODE,
+ f8 TEXT UNICODE,
+ f9 TINYTEXT UNICODE,
+ f10 MEDIUMTEXT UNICODE,
+ f11 LONGTEXT UNICODE
+) ENGINE = $engine_type;
+
+# We look only for the tables created here.
+let $my_where = WHERE table_schema LIKE 'test%';
+--source suite/funcs_1/datadict/columns.inc
+
+DROP TABLE t1;