--character_set sjis
--disable_warnings
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`;
drop table if exists `�s�P�O`;
--enable_warnings

#
# Test TRIM() function with Japanese characters sjis encoding
#

SET NAMES sjis;
SET character_set_database = sjis;

CREATE TABLE `�s�P` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `�s�Q` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `�s�R` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `�s�S` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `�s�T` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `�s�U` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `�s�V` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `�s�W` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `�s�X` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `�s�P�O` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `�s�P�P` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `�s�P�Q` (`�b�P` char(12), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;

# Nothing to trim
INSERT INTO `�s�P` VALUES ('�����');
# Test data for TRIM(TRAILING [remstr] FROM str)
INSERT INTO `�s�P` VALUES ('������');
INSERT INTO `�s�P` VALUES ('�������');
INSERT INTO `�s�P` VALUES ('��������');
# Test data for TRIM(LEADING [remstr] FROM str)
INSERT INTO `�s�P` VALUES ('������');
INSERT INTO `�s�P` VALUES ('�������');
INSERT INTO `�s�P` VALUES ('��������');
# Test data for TRIM(BOTH [remstr] FROM str)
INSERT INTO `�s�P` VALUES ('�����������');
# Test data for TRIM without [remstr] (remove spaces) 
INSERT INTO `�s�P` VALUES ('   �����   ');
INSERT INTO `�s�Q` VALUES ('����������');
INSERT INTO `�s�Q` VALUES ('������������');
INSERT INTO `�s�Q` VALUES ('��������������');
INSERT INTO `�s�Q` VALUES ('����������������');
INSERT INTO `�s�Q` VALUES ('������������');
INSERT INTO `�s�Q` VALUES ('��������������');
INSERT INTO `�s�Q` VALUES ('����������������');
INSERT INTO `�s�Q` VALUES ('����������������������');
INSERT INTO `�s�Q` VALUES ('   ����������   ');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\�\�\�\�\�\�\');
INSERT INTO `�s�R` VALUES ('   �\�\�\�\�\   ');

INSERT INTO `�s�S` VALUES ('�����');
INSERT INTO `�s�S` VALUES ('������');
INSERT INTO `�s�S` VALUES ('�������');
INSERT INTO `�s�S` VALUES ('��������');
INSERT INTO `�s�S` VALUES ('������');
INSERT INTO `�s�S` VALUES ('�������');
INSERT INTO `�s�S` VALUES ('��������');
INSERT INTO `�s�S` VALUES ('�����������');
INSERT INTO `�s�S` VALUES ('   �����   ');
INSERT INTO `�s�T` VALUES ('����������');
INSERT INTO `�s�T` VALUES ('������������');
INSERT INTO `�s�T` VALUES ('��������������');
INSERT INTO `�s�T` VALUES ('����������������');
INSERT INTO `�s�T` VALUES ('������������');
INSERT INTO `�s�T` VALUES ('��������������');
INSERT INTO `�s�T` VALUES ('����������������');
INSERT INTO `�s�T` VALUES ('����������������������');
INSERT INTO `�s�T` VALUES ('   ����������   ');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\�\�\�\�\�\�\');
INSERT INTO `�s�U` VALUES ('   �\�\�\�\�\   ');

INSERT INTO `�s�V` VALUES ('�����');
INSERT INTO `�s�V` VALUES ('������');
INSERT INTO `�s�V` VALUES ('�������');
INSERT INTO `�s�V` VALUES ('��������');
INSERT INTO `�s�V` VALUES ('������');
INSERT INTO `�s�V` VALUES ('�������');
INSERT INTO `�s�V` VALUES ('��������');
INSERT INTO `�s�V` VALUES ('�����������');
INSERT INTO `�s�V` VALUES ('   �����   ');
INSERT INTO `�s�W` VALUES ('����������');
INSERT INTO `�s�W` VALUES ('������������');
INSERT INTO `�s�W` VALUES ('��������������');
INSERT INTO `�s�W` VALUES ('����������������');
INSERT INTO `�s�W` VALUES ('������������');
INSERT INTO `�s�W` VALUES ('��������������');
INSERT INTO `�s�W` VALUES ('����������������');
INSERT INTO `�s�W` VALUES ('����������������������');
INSERT INTO `�s�W` VALUES ('   ����������   ');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\�\�\�\�\�\�\');
INSERT INTO `�s�X` VALUES ('   �\�\�\�\�\   ');

INSERT INTO `�s�P�O` VALUES ('�����');
INSERT INTO `�s�P�O` VALUES ('������');
INSERT INTO `�s�P�O` VALUES ('�������');
INSERT INTO `�s�P�O` VALUES ('��������');
INSERT INTO `�s�P�O` VALUES ('������');
INSERT INTO `�s�P�O` VALUES ('�������');
INSERT INTO `�s�P�O` VALUES ('��������');
INSERT INTO `�s�P�O` VALUES ('�����������');
INSERT INTO `�s�P�O` VALUES ('   �����   ');
INSERT INTO `�s�P�P` VALUES ('����������');
INSERT INTO `�s�P�P` VALUES ('������������');
INSERT INTO `�s�P�P` VALUES ('��������������');
INSERT INTO `�s�P�P` VALUES ('����������������');
INSERT INTO `�s�P�P` VALUES ('������������');
INSERT INTO `�s�P�P` VALUES ('��������������');
INSERT INTO `�s�P�P` VALUES ('����������������');
INSERT INTO `�s�P�P` VALUES ('����������������������');
INSERT INTO `�s�P�P` VALUES ('   ����������   ');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\�\�\�\�\�\�\');
INSERT INTO `�s�P�Q` VALUES ('   �\�\�\�\�\   ');

#InnoDB
SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�P`;
SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�P`;
SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�P`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P`;
SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�Q`;
SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�Q`;
SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�Q`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�Q`;
SELECT `�b�P`,TRIM(TRAILING '�\'FROM `�b�P`) FROM `�s�R`;
SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�R`;
SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�R`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�R`;

#MyISAM
SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�S`;
SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�S`;
SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�S`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�S`;
SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�T`;
SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�T`;
SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�T`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�T`;
SELECT `�b�P`,TRIM(TRAILING '�\' FROM `�b�P`) FROM `�s�U`;
SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�U`;
SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�U`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�U`;

#HEAP
SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�V`;
SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�V`;
SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�V`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�V`;
SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�W`;
SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�W`;
SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�W`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�W`;
SELECT `�b�P`,TRIM(TRAILING '�\' FROM `�b�P`) FROM `�s�X`;
SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�X`;
SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�X`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�X`;

#BDB
SELECT `�b�P`,TRIM(TRAILING '�' FROM `�b�P`) FROM `�s�P�O`;
SELECT `�b�P`,TRIM(LEADING '�' FROM `�b�P`) FROM `�s�P�O`;
SELECT `�b�P`,TRIM(BOTH '�' FROM `�b�P`) FROM `�s�P�O`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P�O`;
SELECT `�b�P`,TRIM(TRAILING '��' FROM `�b�P`) FROM `�s�P�P`;
SELECT `�b�P`,TRIM(LEADING '��' FROM `�b�P`) FROM `�s�P�P`;
SELECT `�b�P`,TRIM(BOTH '��' FROM `�b�P`) FROM `�s�P�P`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P�P`;
SELECT `�b�P`,TRIM(TRAILING '�\' FROM `�b�P`) FROM `�s�P�Q`;
SELECT `�b�P`,TRIM(LEADING '�\' FROM `�b�P`) FROM `�s�P�Q`;
SELECT `�b�P`,TRIM(BOTH '�\' FROM `�b�P`) FROM `�s�P�Q`;
SELECT `�b�P`,TRIM(`�b�P`) FROM `�s�P�Q`;

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`;
DROP TABLE `�s�P�O`;
DROP TABLE `�s�P�P`;
DROP TABLE `�s�P�Q`;