1--source include/have_ucs2.inc
2--source include/have_innodb.inc
3
4--disable_warnings
5drop table if exists `�ԣ�`;
6drop table if exists `�ԣ�`;
7drop table if exists `�ԣ�`;
8drop table if exists `�ԣ�`;
9drop table if exists `�ԣ�`;
10drop table if exists `�ԣ�`;
11drop table if exists `�ԣ�`;
12drop table if exists `�ԣ�`;
13drop table if exists `�ԣ�`;
14--enable_warnings
15
16#
17# Test LTRIM() function with Japanese characters in ucs2 encoding
18#
19
20SET NAMES ujis;
21SET character_set_database = ucs2;
22SET collation_connection = ucs2_general_ci;
23
24CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb;
25CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb;
26CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb;
27CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam;
28CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam;
29CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam;
30CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
31CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
32CREATE TABLE `�ԣ�` (`�ã�` char(8), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
33
34INSERT INTO `�ԣ�` VALUES ('����������');
35INSERT INTO `�ԣ�` VALUES (' ����������');
36INSERT INTO `�ԣ�` VALUES ('  ����������');
37INSERT INTO `�ԣ�` VALUES ('   ����������');
38# Double byte spaces are not supposed to be trimed
39INSERT INTO `�ԣ�` VALUES ('������������');
40INSERT INTO `�ԣ�` VALUES ('��������������');
41INSERT INTO `�ԣ�` VALUES ('����������������');
42INSERT INTO `�ԣ�` VALUES ('����������');
43INSERT INTO `�ԣ�` VALUES (' ����������');
44INSERT INTO `�ԣ�` VALUES ('  ����������');
45INSERT INTO `�ԣ�` VALUES ('   ����������');
46# Double byte spaces are not supposed to be trimed
47INSERT INTO `�ԣ�` VALUES ('������������');
48INSERT INTO `�ԣ�` VALUES ('��������������');
49INSERT INTO `�ԣ�` VALUES ('����������������');
50INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
51INSERT INTO `�ԣ�` VALUES (' ��܏�ݏ�ޏ�ߏ��');
52INSERT INTO `�ԣ�` VALUES ('  ��܏�ݏ�ޏ�ߏ��');
53INSERT INTO `�ԣ�` VALUES ('   ��܏�ݏ�ޏ�ߏ��');
54# Double byte spaces are not supposed to be trimed
55INSERT INTO `�ԣ�` VALUES ('����܏�ݏ�ޏ�ߏ��');
56INSERT INTO `�ԣ�` VALUES ('������܏�ݏ�ޏ�ߏ��');
57INSERT INTO `�ԣ�` VALUES ('��������܏�ݏ�ޏ�ߏ��');
58INSERT INTO `�ԣ�` VALUES ('����������');
59INSERT INTO `�ԣ�` VALUES (' ����������');
60INSERT INTO `�ԣ�` VALUES ('  ����������');
61INSERT INTO `�ԣ�` VALUES ('   ����������');
62# Double byte spaces are not supposed to be trimed
63INSERT INTO `�ԣ�` VALUES ('������������');
64INSERT INTO `�ԣ�` VALUES ('��������������');
65INSERT INTO `�ԣ�` VALUES ('����������������');
66INSERT INTO `�ԣ�` VALUES ('����������');
67INSERT INTO `�ԣ�` VALUES (' ����������');
68INSERT INTO `�ԣ�` VALUES ('  ����������');
69INSERT INTO `�ԣ�` VALUES ('   ����������');
70# Double byte spaces are not supposed to be trimed
71INSERT INTO `�ԣ�` VALUES ('������������');
72INSERT INTO `�ԣ�` VALUES ('��������������');
73INSERT INTO `�ԣ�` VALUES ('����������������');
74INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
75INSERT INTO `�ԣ�` VALUES (' ��܏�ݏ�ޏ�ߏ��');
76INSERT INTO `�ԣ�` VALUES ('  ��܏�ݏ�ޏ�ߏ��');
77INSERT INTO `�ԣ�` VALUES ('   ��܏�ݏ�ޏ�ߏ��');
78# Double byte spaces are not supposed to be trimed
79INSERT INTO `�ԣ�` VALUES ('����܏�ݏ�ޏ�ߏ��');
80INSERT INTO `�ԣ�` VALUES ('������܏�ݏ�ޏ�ߏ��');
81INSERT INTO `�ԣ�` VALUES ('��������܏�ݏ�ޏ�ߏ��');
82INSERT INTO `�ԣ�` VALUES ('����������');
83INSERT INTO `�ԣ�` VALUES (' ����������');
84INSERT INTO `�ԣ�` VALUES ('  ����������');
85INSERT INTO `�ԣ�` VALUES ('   ����������');
86# Double byte spaces are not supposed to be trimed
87INSERT INTO `�ԣ�` VALUES ('������������');
88INSERT INTO `�ԣ�` VALUES ('��������������');
89INSERT INTO `�ԣ�` VALUES ('����������������');
90INSERT INTO `�ԣ�` VALUES ('����������');
91INSERT INTO `�ԣ�` VALUES (' ����������');
92INSERT INTO `�ԣ�` VALUES ('  ����������');
93INSERT INTO `�ԣ�` VALUES ('   ����������');
94# Double byte spaces are not supposed to be trimed
95INSERT INTO `�ԣ�` VALUES ('������������');
96INSERT INTO `�ԣ�` VALUES ('��������������');
97INSERT INTO `�ԣ�` VALUES ('����������������');
98INSERT INTO `�ԣ�` VALUES ('��܏�ݏ�ޏ�ߏ��');
99INSERT INTO `�ԣ�` VALUES (' ��܏�ݏ�ޏ�ߏ��');
100INSERT INTO `�ԣ�` VALUES ('  ��܏�ݏ�ޏ�ߏ��');
101INSERT INTO `�ԣ�` VALUES ('   ��܏�ݏ�ޏ�ߏ��');
102# Double byte spaces are not supposed to be trimed
103INSERT INTO `�ԣ�` VALUES ('����܏�ݏ�ޏ�ߏ��');
104INSERT INTO `�ԣ�` VALUES ('������܏�ݏ�ޏ�ߏ��');
105INSERT INTO `�ԣ�` VALUES ('��������܏�ݏ�ޏ�ߏ��');
106
107#InnoDB
108SELECT LTRIM(`�ã�`) from `�ԣ�`;
109SELECT LTRIM(`�ã�`) from `�ԣ�`;
110SELECT LTRIM(`�ã�`) from `�ԣ�`;
111
112#MyISAM
113SELECT LTRIM(`�ã�`) from `�ԣ�`;
114SELECT LTRIM(`�ã�`) from `�ԣ�`;
115SELECT LTRIM(`�ã�`) from `�ԣ�`;
116
117#MEMORY
118SELECT LTRIM(`�ã�`) from `�ԣ�`;
119SELECT LTRIM(`�ã�`) from `�ԣ�`;
120SELECT LTRIM(`�ã�`) from `�ԣ�`;
121
122DROP TABLE `�ԣ�`;
123DROP TABLE `�ԣ�`;
124DROP TABLE `�ԣ�`;
125DROP TABLE `�ԣ�`;
126DROP TABLE `�ԣ�`;
127DROP TABLE `�ԣ�`;
128DROP TABLE `�ԣ�`;
129DROP TABLE `�ԣ�`;
130DROP TABLE `�ԣ�`;
131