Debian Codegraph @

mysql-test/suite/jp/t/jp_enum_utf8.test

raw
1 #Server variable option 'lower_case_table_names' sets '0' as default value
2 #in case sensitive filesystem. Using 'lower_case_table_names=0' in case of
3 #insensitive filsystem is not allowed.
4 -- source include/have_case_sensitive_file_system.inc
5 --source include/have_utf8.inc
6 --source include/have_innodb.inc
7 --disable_warnings
8 drop table if exists `T1`;
9 drop table if exists `T2`;
10 drop table if exists `T3`;
11 drop table if exists `T4`;
12 drop table if exists `T5`;
13 drop table if exists `T6`;
14 drop table if exists `T7`;
15 drop table if exists `T8`;
16 drop table if exists `T9`;
17 --enable_warnings
18
19 #
20 # Test ENUM values with Japanese characters in utf8 encoding
21 #
22
23 SET NAMES utf8;
24 SET character_set_database = utf8;
25
26 CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
27 CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
28 CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
29 CREATE TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 CREATE TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
31 CREATE TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
32 CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
33 CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
34 CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
35
36 INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
37 INSERT INTO `T2` VALUES ('あ'),('い'),('う');
38 INSERT INTO `T3` VALUES ('龔'),('龖'),('龗');
39 INSERT INTO `T4` VALUES ('ア'),('イ'),('ウ');
40 INSERT INTO `T5` VALUES ('あ'),('い'),('う');
41 INSERT INTO `T6` VALUES ('龔'),('龖'),('龗');
42 INSERT INTO `T7` VALUES ('ア'),('イ'),('ウ');
43 INSERT INTO `T8` VALUES ('あ'),('い'),('う');
44 INSERT INTO `T9` VALUES ('龔'),('龖'),('龗');
45
46 SELECT * FROM `T1`;
47 SELECT * FROM `T2`;
48 SELECT * FROM `T3`;
49 SELECT * FROM `T4`;
50 SELECT * FROM `T5`;
51 SELECT * FROM `T6`;
52 SELECT * FROM `T7`;
53 SELECT * FROM `T8`;
54 SELECT * FROM `T9`;
55
56 SHOW CREATE TABLE `T1`;
57 SHOW CREATE TABLE `T2`;
58 SHOW CREATE TABLE `T3`;
59 SHOW CREATE TABLE `T4`;
60 SHOW CREATE TABLE `T5`;
61 SHOW CREATE TABLE `T6`;
62 SHOW CREATE TABLE `T7`;
63 SHOW CREATE TABLE `T8`;
64 SHOW CREATE TABLE `T9`;
65
66 DESC `T1`;
67 DESC `T2`;
68 DESC `T3`;
69 DESC `T4`;
70 DESC `T5`;
71 DESC `T6`;
72 DESC `T7`;
73 DESC `T8`;
74 DESC `T9`;
75
76 #
77 # Test problem with enum values after the colum with NOT NULL restriction
78 #
79
80 ALTER TABLE `T1` ADD `C2` CHAR(1) NOT NULL FIRST;
81 ALTER TABLE `T2` ADD `C2` CHAR(1) NOT NULL FIRST;
82 ALTER TABLE `T3` ADD `C2` CHAR(1) NOT NULL FIRST;
83 ALTER TABLE `T4` ADD `C2` CHAR(1) NOT NULL FIRST;
84 ALTER TABLE `T5` ADD `C2` CHAR(1) NOT NULL FIRST;
85 ALTER TABLE `T6` ADD `C2` CHAR(1) NOT NULL FIRST;
86 ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
87 ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
88 ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
89
90 SHOW CREATE TABLE `T1`;
91 SHOW CREATE TABLE `T2`;
92 SHOW CREATE TABLE `T3`;
93 SHOW CREATE TABLE `T4`;
94 SHOW CREATE TABLE `T5`;
95 SHOW CREATE TABLE `T6`;
96 SHOW CREATE TABLE `T7`;
97 SHOW CREATE TABLE `T8`;
98 SHOW CREATE TABLE `T9`;
99
100 DESC `T1`;
101 DESC `T2`;
102 DESC `T3`;
103 DESC `T4`;
104 DESC `T5`;
105 DESC `T6`;
106 DESC `T7`;
107 DESC `T8`;
108 DESC `T9`;
109
110 DROP TABLE `T1`;
111 DROP TABLE `T2`;
112 DROP TABLE `T3`;
113 DROP TABLE `T4`;
114 DROP TABLE `T5`;
115 DROP TABLE `T6`;
116 DROP TABLE `T7`;
117 DROP TABLE `T8`;
118 DROP TABLE `T9`;