summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/jp/r/jp_lpad_sjis.result
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-13 12:24:36 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-13 12:24:36 +0000
commit06eaf7232e9a920468c0f8d74dcf2fe8b555501c (patch)
treee2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/jp/r/jp_lpad_sjis.result
parentInitial commit. (diff)
downloadmariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.tar.xz
mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.zip
Adding upstream version 1:10.11.6.upstream/1%10.11.6
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/jp/r/jp_lpad_sjis.result')
-rw-r--r--mysql-test/suite/jp/r/jp_lpad_sjis.result110
1 files changed, 110 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_lpad_sjis.result b/mysql-test/suite/jp/r/jp_lpad_sjis.result
new file mode 100644
index 00000000..46cbde52
--- /dev/null
+++ b/mysql-test/suite/jp/r/jp_lpad_sjis.result
@@ -0,0 +1,110 @@
+drop table if exists `�s�P`;
+drop table if exists `�s�Q`;
+drop table if exists `�s�R`;
+drop table if exists `�s�S`;
+drop table if exists `�s�T`;
+drop table if exists `�s�U`;
+drop table if exists `�s�V`;
+drop table if exists `�s�W`;
+drop table if exists `�s�X`;
+SET NAMES sjis;
+SET character_set_database = sjis;
+CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
+CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
+CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
+INSERT INTO `�s�P` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
+INSERT INTO `�s�Q` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
+INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
+INSERT INTO `�s�S` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
+INSERT INTO `�s�T` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
+INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
+INSERT INTO `�s�V` VALUES ('�����'),('����'),('���'),('��'),('�'),('');
+INSERT INTO `�s�W` VALUES ('����������'),('��������'),('������'),('����'),('��'),('');
+INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
+SELECT `�b�P`, LPAD(`�b�P`,5,'�') FROM `�s�P`;
+�b�P LPAD(`�b�P`,5,'�')
+ �����
+� �����
+�� �����
+��� �����
+���� �����
+����� �����
+SELECT `�b�P`, LPAD(`�b�P`,5,'�w') FROM `�s�Q`;
+�b�P LPAD(`�b�P`,5,'�w')
+ �w�w�w�w�w
+�� �w�w�w�w��
+���� �w�w�w����
+������ �w�w������
+�������� �w��������
+���������� ����������
+SELECT `�b�P`, LPAD(`�b�P`,5,'�\') FROM `�s�R`;
+�b�P LPAD(`�b�P`,5,'�\')
+ �\�\�\�\�\
+�\ �\�\�\�\�\
+�\�\ �\�\�\�\�\
+�\�\�\ �\�\�\�\�\
+�\�\�\�\ �\�\�\�\�\
+�\�\�\�\�\ �\�\�\�\�\
+SELECT `�b�P`, LPAD(`�b�P`,5,'�') FROM `�s�S`;
+�b�P LPAD(`�b�P`,5,'�')
+ �����
+� �����
+�� �����
+��� �����
+���� �����
+����� �����
+SELECT `�b�P`, LPAD(`�b�P`,5,'�w') FROM `�s�T`;
+�b�P LPAD(`�b�P`,5,'�w')
+ �w�w�w�w�w
+�� �w�w�w�w��
+���� �w�w�w����
+������ �w�w������
+�������� �w��������
+���������� ����������
+SELECT `�b�P`, LPAD(`�b�P`,5,'�\' ) FROM `�s�U`;
+�b�P LPAD(`�b�P`,5,'�\' )
+ �\�\�\�\�\
+�\ �\�\�\�\�\
+�\�\ �\�\�\�\�\
+�\�\�\ �\�\�\�\�\
+�\�\�\�\ �\�\�\�\�\
+�\�\�\�\�\ �\�\�\�\�\
+SELECT `�b�P`, LPAD(`�b�P`,5,'�') FROM `�s�V`;
+�b�P LPAD(`�b�P`,5,'�')
+����� �����
+���� �����
+��� �����
+�� �����
+� �����
+ �����
+SELECT `�b�P`, LPAD(`�b�P`,5,'�w') FROM `�s�W`;
+�b�P LPAD(`�b�P`,5,'�w')
+���������� ����������
+�������� �w��������
+������ �w�w������
+���� �w�w�w����
+�� �w�w�w�w��
+ �w�w�w�w�w
+SELECT `�b�P`, LPAD(`�b�P`,5,'�\' ) FROM `�s�X`;
+�b�P LPAD(`�b�P`,5,'�\' )
+�\�\�\�\�\ �\�\�\�\�\
+�\�\�\�\ �\�\�\�\�\
+�\�\�\ �\�\�\�\�\
+�\�\ �\�\�\�\�\
+�\ �\�\�\�\�\
+ �\�\�\�\�\
+DROP TABLE `�s�P`;
+DROP TABLE `�s�Q`;
+DROP TABLE `�s�R`;
+DROP TABLE `�s�S`;
+DROP TABLE `�s�T`;
+DROP TABLE `�s�U`;
+DROP TABLE `�s�V`;
+DROP TABLE `�s�W`;
+DROP TABLE `�s�X`;