diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
commit | 06eaf7232e9a920468c0f8d74dcf2fe8b555501c (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/jp/r/jp_lpad_sjis.result | |
parent | Initial commit. (diff) | |
download | mariadb-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.result | 110 |
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`; |