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