1# suite/funcs_1/t/is_cml_myisam.test
2#
3# Check the content of information_schema.columns about tables using
4# UNICODE columns.
5# Variant for storage engine MyISAM
6#
7# Author:
8# 2008-06-04 mleich Create this script based on older scripts and new code.
9#
10
11--source include/have_ucs2.inc
12
13# This test cannot be used for the embedded server because privileges
14# are expected within result sets.
15--source include/not_embedded.inc
16
17--source include/have_myisam.inc
18let $engine_type= MyISAM;
19SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
20USE test;
21--disable_warnings
22DROP TABLE IF EXISTS t1;
23--enable_warnings
24eval CREATE TABLE t1
25(
26   f1 CHAR         UNICODE,
27   f2 CHAR(0)      UNICODE,
28   f3 CHAR(10)     UNICODE,
29   f5 VARCHAR(0)   UNICODE,
30   f6 VARCHAR(255) UNICODE,
31   f7 VARCHAR(260) UNICODE,
32   f8 TEXT         UNICODE,
33   f9 TINYTEXT     UNICODE,
34   f10 MEDIUMTEXT  UNICODE,
35   f11 LONGTEXT    UNICODE
36) ENGINE = $engine_type;
37
38# We look only for the tables created here.
39let $my_where = WHERE table_schema LIKE 'test%';
40--source suite/funcs_1/datadict/columns.inc
41
42DROP TABLE t1;
43