Debian Codegraph @

mysql-test/suite/jp/r/jp_rpad_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`, RPAD(`C1`,5,'。') FROM `T1`;
54 C1 RPAD(`C1`,5,'。')
55 。。。。。
56 ア ア。。。。
57 アイ アイ。。。
58 アイウ アイウ。。
59 アイウエ アイウエ。
60 アイウエオ アイウエオ
61 SELECT `C1`, RPAD(`C1`,5,'X') FROM `T2`;
62 C1 RPAD(`C1`,5,'X')
63 XXXXX
64 あ あXXXX
65 あい あいXXX
66 あいう あいうXX
67 あいうえ あいうえX
68 あいうえお あいうえお
69 SELECT `C1`, RPAD(`C1`,5,'丄') FROM `T3`;
70 C1 RPAD(`C1`,5,'丄')
71 丄丄丄丄丄
72 龔 龔丄丄丄丄
73 龔龖 龔龖丄丄丄
74 龔龖龗 龔龖龗丄丄
75 龔龖龗龞 龔龖龗龞丄
76 龔龖龗龞龡 龔龖龗龞龡
77 SELECT `C1`, RPAD(`C1`,5,'。') FROM `T4`;
78 C1 RPAD(`C1`,5,'。')
79 。。。。。
80 ア ア。。。。
81 アイ アイ。。。
82 アイウ アイウ。。
83 アイウエ アイウエ。
84 アイウエオ アイウエオ
85 SELECT `C1`, RPAD(`C1`,5,'X') FROM `T5`;
86 C1 RPAD(`C1`,5,'X')
87 XXXXX
88 あ あXXXX
89 あい あいXXX
90 あいう あいうXX
91 あいうえ あいうえX
92 あいうえお あいうえお
93 SELECT `C1`, RPAD(`C1`,5,'丄' ) FROM `T6`;
94 C1 RPAD(`C1`,5,'丄' )
95 丄丄丄丄丄
96 龔 龔丄丄丄丄
97 龔龖 龔龖丄丄丄
98 龔龖龗 龔龖龗丄丄
99 龔龖龗龞 龔龖龗龞丄
100 龔龖龗龞龡 龔龖龗龞龡
101 SELECT `C1`, RPAD(`C1`,5,'。') FROM `T7`;
102 C1 RPAD(`C1`,5,'。')
103 アイウエオ アイウエオ
104 アイウエ アイウエ。
105 アイウ アイウ。。
106 アイ アイ。。。
107 ア ア。。。。
108 。。。。。
109 SELECT `C1`, RPAD(`C1`,5,'X') FROM `T8`;
110 C1 RPAD(`C1`,5,'X')
111 あいうえお あいうえお
112 あいうえ あいうえX
113 あいう あいうXX
114 あい あいXXX
115 あ あXXXX
116 XXXXX
117 SELECT `C1`, RPAD(`C1`,5,'丄' ) FROM `T9`;
118 C1 RPAD(`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`;