~drizzle-trunk/drizzle/development : contents of tests/suite/jp/t/jp_ltrim

~drizzle-trunk/drizzle/development : (revision 1273.12.4)

--source include/have_ujis.inc

--disable_warnings
drop table if exists `£Ô£±`;
drop table if exists `£Ô£²`;
drop table if exists `£Ô£³`;
drop table if exists `£Ô£Ž`;
drop table if exists `£Ô£µ`;
drop table if exists `£Ô£¶`;
drop table if exists `£Ô£·`;
drop table if exists `£Ô£ž`;
drop table if exists `£Ô£¹`;
drop table if exists `£Ô£±£°`;
--enable_warnings

#
# Test LTRIM() function with Japanese characters in ujis encoding
#

SET NAMES ujis;
SET character_set_database = ujis;

CREATE TABLE `£Ô£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£³` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `£Ô£Ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£µ` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£¶` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `£Ô£·` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `£Ô£ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `£Ô£¹` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `£Ô£±£°` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
CREATE TABLE `£Ô£±£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
CREATE TABLE `£Ô£±£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;

INSERT INTO `£Ô£±` VALUES ('±²³Žµ');
INSERT INTO `£Ô£±` VALUES (' ±²³Žµ');
INSERT INTO `£Ô£±` VALUES ('  ±²³Žµ');
INSERT INTO `£Ô£±` VALUES ('   ±²³Žµ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£±` VALUES ('¡¡±²³Žµ');
INSERT INTO `£Ô£±` VALUES ('¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£±` VALUES ('¡¡¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£²` VALUES ('€¢€€€Š€š€ª');
INSERT INTO `£Ô£²` VALUES (' €¢€€€Š€š€ª');
INSERT INTO `£Ô£²` VALUES ('  €¢€€€Š€š€ª');
INSERT INTO `£Ô£²` VALUES ('   €¢€€€Š€š€ª');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£²` VALUES ('¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£²` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£²` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£³` VALUES ('íÜíÝíÞíßíà');
INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
INSERT INTO `£Ô£³` VALUES ('  íÜíÝíÞíßíà');
INSERT INTO `£Ô£³` VALUES ('   íÜíÝíÞíßíà');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£³` VALUES ('¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£³` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£³` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£Ž` VALUES ('±²³Žµ');
INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
INSERT INTO `£Ô£Ž` VALUES ('  ±²³Žµ');
INSERT INTO `£Ô£Ž` VALUES ('   ±²³Žµ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£Ž` VALUES ('¡¡±²³Žµ');
INSERT INTO `£Ô£Ž` VALUES ('¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£Ž` VALUES ('¡¡¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª');
INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
INSERT INTO `£Ô£µ` VALUES ('  €¢€€€Š€š€ª');
INSERT INTO `£Ô£µ` VALUES ('   €¢€€€Š€š€ª');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£µ` VALUES ('¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£µ` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£µ` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£¶` VALUES ('íÜíÝíÞíßíà');
INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
INSERT INTO `£Ô£¶` VALUES ('  íÜíÝíÞíßíà');
INSERT INTO `£Ô£¶` VALUES ('   íÜíÝíÞíßíà');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£¶` VALUES ('¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£¶` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£¶` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£·` VALUES ('±²³Žµ');
INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
INSERT INTO `£Ô£·` VALUES ('  ±²³Žµ');
INSERT INTO `£Ô£·` VALUES ('   ±²³Žµ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£·` VALUES ('¡¡±²³Žµ');
INSERT INTO `£Ô£·` VALUES ('¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£·` VALUES ('¡¡¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª');
INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
INSERT INTO `£Ô£ž` VALUES ('  €¢€€€Š€š€ª');
INSERT INTO `£Ô£ž` VALUES ('   €¢€€€Š€š€ª');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£ž` VALUES ('¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£ž` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£ž` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£¹` VALUES ('íÜíÝíÞíßíà');
INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
INSERT INTO `£Ô£¹` VALUES ('  íÜíÝíÞíßíà');
INSERT INTO `£Ô£¹` VALUES ('   íÜíÝíÞíßíà');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£¹` VALUES ('¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£¹` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£¹` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£±£°` VALUES ('±²³Žµ');
INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
INSERT INTO `£Ô£±£°` VALUES ('  ±²³Žµ');
INSERT INTO `£Ô£±£°` VALUES ('   ±²³Žµ');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£±£°` VALUES ('¡¡±²³Žµ');
INSERT INTO `£Ô£±£°` VALUES ('¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£±£°` VALUES ('¡¡¡¡¡¡±²³Žµ');
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª');
INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
INSERT INTO `£Ô£±£±` VALUES ('  €¢€€€Š€š€ª');
INSERT INTO `£Ô£±£±` VALUES ('   €¢€€€Š€š€ª');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£±£±` VALUES ('¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£±£±` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£±£±` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
INSERT INTO `£Ô£±£²` VALUES ('íÜíÝíÞíßíà');
INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
INSERT INTO `£Ô£±£²` VALUES ('  íÜíÝíÞíßíà');
INSERT INTO `£Ô£±£²` VALUES ('   íÜíÝíÞíßíà');
# Double byte spaces are not supposed to be trimed
INSERT INTO `£Ô£±£²` VALUES ('¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£±£²` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
INSERT INTO `£Ô£±£²` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');

#InnoDB
SELECT LTRIM(`£Ã£±`) from `£Ô£±`;
SELECT LTRIM(`£Ã£±`) from `£Ô£²`;
SELECT LTRIM(`£Ã£±`) from `£Ô£³`;

#MyISAM
SELECT LTRIM(`£Ã£±`) from `£Ô£Ž`;
SELECT LTRIM(`£Ã£±`) from `£Ô£µ`;
SELECT LTRIM(`£Ã£±`) from `£Ô£¶`;

#MEMORY
SELECT LTRIM(`£Ã£±`) from `£Ô£·`;
SELECT LTRIM(`£Ã£±`) from `£Ô£ž`;
SELECT LTRIM(`£Ã£±`) from `£Ô£¹`;

#BDB
SELECT LTRIM(`£Ã£±`) from `£Ô£±£°`;
SELECT LTRIM(`£Ã£±`) from `£Ô£±£±`;
SELECT LTRIM(`£Ã£±`) from `£Ô£±£²`;

DROP TABLE `£Ô£±`;
DROP TABLE `£Ô£²`;
DROP TABLE `£Ô£³`;
DROP TABLE `£Ô£Ž`;
DROP TABLE `£Ô£µ`;
DROP TABLE `£Ô£¶`;
DROP TABLE `£Ô£·`;
DROP TABLE `£Ô£ž`;
DROP TABLE `£Ô£¹`;
DROP TABLE `£Ô£±£°`;
DROP TABLE `£Ô£±£±`;
DROP TABLE `£Ô£±£²`;

1 by brian clean slate	1	--source include/have_ujis.inc
	2
	3	--disable_warnings
	4	drop table if exists `£Ô£±`;
	5	drop table if exists `£Ô£²`;
	6	drop table if exists `£Ô£³`;
	7	drop table if exists `£Ô£Ž`;
	8	drop table if exists `£Ô£µ`;
	9	drop table if exists `£Ô£¶`;
	10	drop table if exists `£Ô£·`;
	11	drop table if exists `£Ô£ž`;
	12	drop table if exists `£Ô£¹`;
	13	drop table if exists `£Ô£±£°`;
	14	--enable_warnings
	15
	16	#
	17	# Test LTRIM() function with Japanese characters in ujis encoding
	18	#
	19
	20	SET NAMES ujis;
	21	SET character_set_database = ujis;
	22
	23	CREATE TABLE `£Ô£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
	24	CREATE TABLE `£Ô£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
	25	CREATE TABLE `£Ô£³` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
	26	CREATE TABLE `£Ô£Ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
	27	CREATE TABLE `£Ô£µ` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
	28	CREATE TABLE `£Ô£¶` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
1233.2.1 by Monty Taylor Renamed instances of HEAP engine to MEMORY. Removed the alias.	29	CREATE TABLE `£Ô£·` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
	30	CREATE TABLE `£Ô£ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
	31	CREATE TABLE `£Ô£¹` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = MEMORY;
1 by brian clean slate	32	CREATE TABLE `£Ô£±£°` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
	33	CREATE TABLE `£Ô£±£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
	34	CREATE TABLE `£Ô£±£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
	35
	36	INSERT INTO `£Ô£±` VALUES ('±²³Žµ');
	37	INSERT INTO `£Ô£±` VALUES (' ±²³Žµ');
	38	INSERT INTO `£Ô£±` VALUES (' ±²³Žµ');
	39	INSERT INTO `£Ô£±` VALUES (' ±²³Žµ');
	40	# Double byte spaces are not supposed to be trimed
	41	INSERT INTO `£Ô£±` VALUES ('¡¡±²³Žµ');
	42	INSERT INTO `£Ô£±` VALUES ('¡¡¡¡±²³Žµ');
	43	INSERT INTO `£Ô£±` VALUES ('¡¡¡¡¡¡±²³Žµ');
	44	INSERT INTO `£Ô£²` VALUES ('€¢€€€Š€š€ª');
	45	INSERT INTO `£Ô£²` VALUES (' €¢€€€Š€š€ª');
	46	INSERT INTO `£Ô£²` VALUES (' €¢€€€Š€š€ª');
	47	INSERT INTO `£Ô£²` VALUES (' €¢€€€Š€š€ª');
	48	# Double byte spaces are not supposed to be trimed
	49	INSERT INTO `£Ô£²` VALUES ('¡¡€¢€€€Š€š€ª');
	50	INSERT INTO `£Ô£²` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
	51	INSERT INTO `£Ô£²` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
	52	INSERT INTO `£Ô£³` VALUES ('íÜíÝíÞíßíà');
	53	INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
	54	INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
	55	INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
	56	# Double byte spaces are not supposed to be trimed
	57	INSERT INTO `£Ô£³` VALUES ('¡¡íÜíÝíÞíßíà');
	58	INSERT INTO `£Ô£³` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
	59	INSERT INTO `£Ô£³` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
	60	INSERT INTO `£Ô£Ž` VALUES ('±²³Žµ');
	61	INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
	62	INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
	63	INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
	64	# Double byte spaces are not supposed to be trimed
	65	INSERT INTO `£Ô£Ž` VALUES ('¡¡±²³Žµ');
	66	INSERT INTO `£Ô£Ž` VALUES ('¡¡¡¡±²³Žµ');
	67	INSERT INTO `£Ô£Ž` VALUES ('¡¡¡¡¡¡±²³Žµ');
	68	INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª');
	69	INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
	70	INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
	71	INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
	72	# Double byte spaces are not supposed to be trimed
	73	INSERT INTO `£Ô£µ` VALUES ('¡¡€¢€€€Š€š€ª');
	74	INSERT INTO `£Ô£µ` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
	75	INSERT INTO `£Ô£µ` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
	76	INSERT INTO `£Ô£¶` VALUES ('íÜíÝíÞíßíà');
	77	INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
	78	INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
	79	INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
	80	# Double byte spaces are not supposed to be trimed
	81	INSERT INTO `£Ô£¶` VALUES ('¡¡íÜíÝíÞíßíà');
	82	INSERT INTO `£Ô£¶` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
	83	INSERT INTO `£Ô£¶` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
	84	INSERT INTO `£Ô£·` VALUES ('±²³Žµ');
	85	INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
	86	INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
	87	INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
	88	# Double byte spaces are not supposed to be trimed
	89	INSERT INTO `£Ô£·` VALUES ('¡¡±²³Žµ');
	90	INSERT INTO `£Ô£·` VALUES ('¡¡¡¡±²³Žµ');
	91	INSERT INTO `£Ô£·` VALUES ('¡¡¡¡¡¡±²³Žµ');
	92	INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª');
	93	INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
	94	INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
	95	INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
96	# Double byte spaces are not supposed to be trimed
97	INSERT INTO `£Ô£ž` VALUES ('¡¡€¢€€€Š€š€ª');
98	INSERT INTO `£Ô£ž` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
99	INSERT INTO `£Ô£ž` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
100	INSERT INTO `£Ô£¹` VALUES ('íÜíÝíÞíßíà');
101	INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
102	INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
103	INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
104	# Double byte spaces are not supposed to be trimed
105	INSERT INTO `£Ô£¹` VALUES ('¡¡íÜíÝíÞíßíà');
106	INSERT INTO `£Ô£¹` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
107	INSERT INTO `£Ô£¹` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
108	INSERT INTO `£Ô£±£°` VALUES ('±²³Žµ');
109	INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
110	INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
111	INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
112	# Double byte spaces are not supposed to be trimed
113	INSERT INTO `£Ô£±£°` VALUES ('¡¡±²³Žµ');
114	INSERT INTO `£Ô£±£°` VALUES ('¡¡¡¡±²³Žµ');
115	INSERT INTO `£Ô£±£°` VALUES ('¡¡¡¡¡¡±²³Žµ');
116	INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª');
117	INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
118	INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
119	INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
120	# Double byte spaces are not supposed to be trimed
121	INSERT INTO `£Ô£±£±` VALUES ('¡¡€¢€€€Š€š€ª');
122	INSERT INTO `£Ô£±£±` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
123	INSERT INTO `£Ô£±£±` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
124	INSERT INTO `£Ô£±£²` VALUES ('íÜíÝíÞíßíà');
125	INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
126	INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
127	INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
128	# Double byte spaces are not supposed to be trimed
129	INSERT INTO `£Ô£±£²` VALUES ('¡¡íÜíÝíÞíßíà');
130	INSERT INTO `£Ô£±£²` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
131	INSERT INTO `£Ô£±£²` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
132
133	#InnoDB
134	SELECT LTRIM(`£Ã£±`) from `£Ô£±`;
135	SELECT LTRIM(`£Ã£±`) from `£Ô£²`;
136	SELECT LTRIM(`£Ã£±`) from `£Ô£³`;
137
138	#MyISAM
139	SELECT LTRIM(`£Ã£±`) from `£Ô£Ž`;
140	SELECT LTRIM(`£Ã£±`) from `£Ô£µ`;
141	SELECT LTRIM(`£Ã£±`) from `£Ô£¶`;
142
1233.2.1 by Monty Taylor Renamed instances of HEAP engine to MEMORY. Removed the alias.	143	#MEMORY
1 by brian clean slate	144	SELECT LTRIM(`£Ã£±`) from `£Ô£·`;
	145	SELECT LTRIM(`£Ã£±`) from `£Ô£ž`;
	146	SELECT LTRIM(`£Ã£±`) from `£Ô£¹`;
	147
	148	#BDB
	149	SELECT LTRIM(`£Ã£±`) from `£Ô£±£°`;
	150	SELECT LTRIM(`£Ã£±`) from `£Ô£±£±`;
	151	SELECT LTRIM(`£Ã£±`) from `£Ô£±£²`;
	152
	153	DROP TABLE `£Ô£±`;
	154	DROP TABLE `£Ô£²`;
	155	DROP TABLE `£Ô£³`;
	156	DROP TABLE `£Ô£Ž`;
	157	DROP TABLE `£Ô£µ`;
	158	DROP TABLE `£Ô£¶`;
	159	DROP TABLE `£Ô£·`;
	160	DROP TABLE `£Ô£ž`;
	161	DROP TABLE `£Ô£¹`;
	162	DROP TABLE `£Ô£±£°`;
	163	DROP TABLE `£Ô£±£±`;
	164	DROP TABLE `£Ô£±£²`;