Debian Codegraph @

mysql-test/suite/jp/r/jp_lpad_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 Warnings:
12 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
13 SET character_set_database = utf8;
14 Warnings:
15 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
17 CREATE TABLE `T1` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18 Warnings:
19 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
20 CREATE TABLE `T2` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 CREATE TABLE `T3` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 CREATE TABLE `T4` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 Warnings:
28 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
29 CREATE TABLE `T5` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 CREATE TABLE `T6` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
33 Warnings:
34 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
35 CREATE TABLE `T7` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
36 Warnings:
37 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 CREATE TABLE `T8` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
39 Warnings:
40 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
41 CREATE TABLE `T9` (`C1` char(5), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
42 Warnings:
43 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
44 INSERT INTO `T1` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
45 INSERT INTO `T2` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
46 INSERT INTO `T3` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
47 INSERT INTO `T4` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
48 INSERT INTO `T5` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
49 INSERT INTO `T6` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
50 INSERT INTO `T7` VALUES ('アイウエオ'),('アイウエ'),('アイウ'),('アイ'),('ア'),('');
51 INSERT INTO `T8` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
52 INSERT INTO `T9` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
53 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`;
54 C1 LPAD(`C1`,5,'。')
55 。。。。。
56 ア 。。。。ア
57 アイ 。。。アイ
58 アイウ 。。アイウ
59 アイウエ 。アイウエ
60 アイウエオ アイウエオ
61 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`;
62 C1 LPAD(`C1`,5,'X')
63 XXXXX
64 あ XXXXあ
65 あい XXXあい
66 あいう XXあいう
67 あいうえ Xあいうえ
68 あいうえお あいうえお
69 SELECT `C1`, LPAD(`C1`,5,'丄') FROM `T3`;
70 C1 LPAD(`C1`,5,'丄')
71 丄丄丄丄丄
72 龔 丄丄丄丄龔
73 龔龖 丄丄丄龔龖
74 龔龖龗 丄丄龔龖龗
75 龔龖龗龞 丄龔龖龗龞
76 龔龖龗龞龡 龔龖龗龞龡
77 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T4`;
78 C1 LPAD(`C1`,5,'。')
79 。。。。。
80 ア 。。。。ア
81 アイ 。。。アイ
82 アイウ 。。アイウ
83 アイウエ 。アイウエ
84 アイウエオ アイウエオ
85 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T5`;
86 C1 LPAD(`C1`,5,'X')
87 XXXXX
88 あ XXXXあ
89 あい XXXあい
90 あいう XXあいう
91 あいうえ Xあいうえ
92 あいうえお あいうえお
93 SELECT `C1`, LPAD(`C1`,5,'丄' ) FROM `T6`;
94 C1 LPAD(`C1`,5,'丄' )
95 丄丄丄丄丄
96 龔 丄丄丄丄龔
97 龔龖 丄丄丄龔龖
98 龔龖龗 丄丄龔龖龗
99 龔龖龗龞 丄龔龖龗龞
100 龔龖龗龞龡 龔龖龗龞龡
101 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T7`;
102 C1 LPAD(`C1`,5,'。')
103 アイウエオ アイウエオ
104 アイウエ 。アイウエ
105 アイウ 。。アイウ
106 アイ 。。。アイ
107 ア 。。。。ア
108 。。。。。
109 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T8`;
110 C1 LPAD(`C1`,5,'X')
111 あいうえお あいうえお
112 あいうえ Xあいうえ
113 あいう XXあいう
114 あい XXXあい
115 あ XXXXあ
116 XXXXX
117 SELECT `C1`, LPAD(`C1`,5,'丄' ) FROM `T9`;
118 C1 LPAD(`C1`,5,'丄' )
119 龔龖龗龞龡 龔龖龗龞龡
120 龔龖龗龞 丄龔龖龗龞
121 龔龖龗 丄丄龔龖龗
122 龔龖 丄丄丄龔龖
123 龔 丄丄丄丄龔
124 丄丄丄丄丄
125 DROP TABLE `T1`;
126 DROP TABLE `T2`;
127 DROP TABLE `T3`;
128 DROP TABLE `T4`;
129 DROP TABLE `T5`;
130 DROP TABLE `T6`;
131 DROP TABLE `T7`;
132 DROP TABLE `T8`;
133 DROP TABLE `T9`;