func_str.result 18.8 KB
Newer Older
unknown's avatar
unknown committed
1 2
drop table if exists t1;
select 'hello',"'hello'",'""hello""','''h''e''l''l''o''',"hel""lo",'hel\'lo';
3 4
hello	'hello'	""hello""	'h'e'l'l'o'	hel"lo	hel'lo
hello	'hello'	""hello""	'h'e'l'l'o'	hel"lo	hel'lo
unknown's avatar
unknown committed
5
select 'hello' 'monty';
6 7
hello
hellomonty
unknown's avatar
unknown committed
8
select length('\n\t\r\b\0\_\%\\');
9 10
length('\n\t\r\b\0\_\%\\')
10
unknown's avatar
unknown committed
11 12 13
select bit_length('\n\t\r\b\0\_\%\\');
bit_length('\n\t\r\b\0\_\%\\')
80
unknown's avatar
unknown committed
14
select concat('monty',' was here ','again'),length('hello'),char(ascii('h'));
15 16
concat('monty',' was here ','again')	length('hello')	char(ascii('h'))
monty was here again	5	h
unknown's avatar
unknown committed
17
select locate('he','hello'),locate('he','hello',2),locate('lo','hello',2) ;
18 19
locate('he','hello')	locate('he','hello',2)	locate('lo','hello',2)
1	0	4
20 21 22 23 24
select instr('hello','HE'), instr('hello',binary 'HE'), instr(binary 'hello','HE');
instr('hello','HE')	instr('hello',binary 'HE')	instr(binary 'hello','HE')
1	0	0
select position(binary 'll' in 'hello'),position('a' in binary 'hello');
position(binary 'll' in 'hello')	position('a' in binary 'hello')
25
3	0
unknown's avatar
unknown committed
26
select left('hello',2),right('hello',2),substring('hello',2,2),mid('hello',1,5) ;
27 28
left('hello',2)	right('hello',2)	substring('hello',2,2)	mid('hello',1,5)
he	lo	el	hello
unknown's avatar
unknown committed
29
select concat('',left(right(concat('what ',concat('is ','happening')),9),4),'',substring('monty',5,1)) ;
30 31
concat('',left(right(concat('what ',concat('is ','happening')),9),4),'',substring('monty',5,1))
happy
unknown's avatar
unknown committed
32
select substring_index('www.tcx.se','.',-2),substring_index('www.tcx.se','.',1);
33 34
substring_index('www.tcx.se','.',-2)	substring_index('www.tcx.se','.',1)
tcx.se	www
unknown's avatar
unknown committed
35
select substring_index('www.tcx.se','tcx',1),substring_index('www.tcx.se','tcx',-1);
36 37
substring_index('www.tcx.se','tcx',1)	substring_index('www.tcx.se','tcx',-1)
www.	.se
unknown's avatar
unknown committed
38
select substring_index('.tcx.se','.',-2),substring_index('.tcx.se','.tcx',-1);
39 40
substring_index('.tcx.se','.',-2)	substring_index('.tcx.se','.tcx',-1)
tcx.se	.se
unknown's avatar
unknown committed
41
select concat(':',ltrim('  left  '),':',rtrim('  right  '),':');
42 43
concat(':',ltrim('  left  '),':',rtrim('  right  '),':')
:left  :  right:
unknown's avatar
unknown committed
44
select concat(':',trim(LEADING FROM ' left'),':',trim(TRAILING FROM ' right '),':');
45 46
concat(':',trim(LEADING FROM ' left'),':',trim(TRAILING FROM ' right '),':')
:left: right:
unknown's avatar
unknown committed
47
select concat(':',trim(' m '),':',trim(BOTH FROM ' y '),':',trim('*' FROM '*s*'),':');
48 49
concat(':',trim(' m '),':',trim(BOTH FROM ' y '),':',trim('*' FROM '*s*'),':')
:m:y:s:
unknown's avatar
unknown committed
50
select concat(':',trim(BOTH 'ab' FROM 'ababmyabab'),':',trim(BOTH '*' FROM '***sql'),':');
51 52
concat(':',trim(BOTH 'ab' FROM 'ababmyabab'),':',trim(BOTH '*' FROM '***sql'),':')
:my:sql:
unknown's avatar
unknown committed
53
select concat(':',trim(LEADING '.*' FROM '.*my'),':',trim(TRAILING '.*' FROM 'sql.*.*'),':');
54 55
concat(':',trim(LEADING '.*' FROM '.*my'),':',trim(TRAILING '.*' FROM 'sql.*.*'),':')
:my:sql:
unknown's avatar
unknown committed
56
select TRIM("foo" FROM "foo"), TRIM("foo" FROM "foook"), TRIM("foo" FROM "okfoo");
57 58
TRIM("foo" FROM "foo")	TRIM("foo" FROM "foook")	TRIM("foo" FROM "okfoo")
	ok	ok
unknown's avatar
unknown committed
59
select concat_ws(', ','monty','was here','again');
60 61
concat_ws(', ','monty','was here','again')
monty, was here, again
unknown's avatar
unknown committed
62
select concat_ws(NULL,'a'),concat_ws(',',NULL,'');
63 64
concat_ws(NULL,'a')	concat_ws(',',NULL,'')
NULL	
unknown's avatar
unknown committed
65
select concat_ws(',','',NULL,'a');
66
concat_ws(',','',NULL,'a')
67
,a
unknown's avatar
unknown committed
68
SELECT CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),repeat('d',100)), '"');
69 70
CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),repeat('d',100)), '"')
"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb";"cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc";"dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd"
unknown's avatar
unknown committed
71
select insert('txs',2,1,'hi'),insert('is ',4,0,'a'),insert('txxxxt',2,4,'es');
72 73
insert('txs',2,1,'hi')	insert('is ',4,0,'a')	insert('txxxxt',2,4,'es')
this	is a	test
unknown's avatar
unknown committed
74
select replace('aaaa','a','b'),replace('aaaa','aa','b'),replace('aaaa','a','bb'),replace('aaaa','','b'),replace('bbbb','a','c');
75 76
replace('aaaa','a','b')	replace('aaaa','aa','b')	replace('aaaa','a','bb')	replace('aaaa','','b')	replace('bbbb','a','c')
bbbb	bb	bbbbbbbb	aaaa	bbbb
unknown's avatar
unknown committed
77
select replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL') ;
78 79
replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL')
this is a REAL test
unknown's avatar
unknown committed
80
select soundex(''),soundex('he'),soundex('hello all folks');
81 82
soundex('')	soundex('he')	soundex('hello all folks')
	H000	H4142
unknown's avatar
unknown committed
83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
select 'mood' sounds like 'mud';
'mood' sounds like 'mud'
1
select 'Glazgo' sounds like 'Liverpool';
'Glazgo' sounds like 'Liverpool'
0
select null sounds like 'null';
null sounds like 'null'
NULL
select 'null' sounds like null;
'null' sounds like null
NULL
select null sounds like null;
null sounds like null
NULL
unknown's avatar
unknown committed
98
select md5('hello');
99 100
md5('hello')
5d41402abc4b2a76b9719d911017c592
101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130
select sha('abc');
sha('abc')
a9993e364706816aba3e25717850c26c9cd0d89d
select sha1('abc');
sha1('abc')
a9993e364706816aba3e25717850c26c9cd0d89d
select aes_decrypt(aes_encrypt('abc','1'),'1');
aes_decrypt(aes_encrypt('abc','1'),'1')
abc
select aes_decrypt(aes_encrypt('abc','1'),1);
aes_decrypt(aes_encrypt('abc','1'),1)
abc
select aes_encrypt(NULL,"a");
aes_encrypt(NULL,"a")
NULL
select aes_encrypt("a",NULL);
aes_encrypt("a",NULL)
NULL
select aes_decrypt(NULL,"a");
aes_decrypt(NULL,"a")
NULL
select aes_decrypt("a",NULL);
aes_decrypt("a",NULL)
NULL
select aes_decrypt("a","a");
aes_decrypt("a","a")
NULL
select aes_decrypt(aes_encrypt("","a"),"a");
aes_decrypt(aes_encrypt("","a"),"a")

unknown's avatar
unknown committed
131
select repeat('monty',5),concat('*',space(5),'*');
132 133
repeat('monty',5)	concat('*',space(5),'*')
montymontymontymontymonty	*     *
unknown's avatar
unknown committed
134
select reverse('abc'),reverse('abcd');
135 136
reverse('abc')	reverse('abcd')
cba	dcba
unknown's avatar
unknown committed
137
select rpad('a',4,'1'),rpad('a',4,'12'),rpad('abcd',3,'12');
138 139
rpad('a',4,'1')	rpad('a',4,'12')	rpad('abcd',3,'12')
a111	a121	abc
unknown's avatar
unknown committed
140
select lpad('a',4,'1'),lpad('a',4,'12'),lpad('abcd',3,'12');
141 142
lpad('a',4,'1')	lpad('a',4,'12')	lpad('abcd',3,'12')
111a	121a	abc
unknown's avatar
unknown committed
143
select rpad(741653838,17,'0'),lpad(741653838,17,'0');
144 145
rpad(741653838,17,'0')	lpad(741653838,17,'0')
74165383800000000	00000000741653838
unknown's avatar
unknown committed
146
select rpad('abcd',7,'ab'),lpad('abcd',7,'ab');
147 148
rpad('abcd',7,'ab')	lpad('abcd',7,'ab')
abcdaba	abaabcd
unknown's avatar
unknown committed
149
select rpad('abcd',1,'ab'),lpad('abcd',1,'ab');
150 151
rpad('abcd',1,'ab')	lpad('abcd',1,'ab')
a	a
unknown's avatar
unknown committed
152
select LEAST(NULL,'HARRY','HARRIOT',NULL,'HAROLD'),GREATEST(NULL,'HARRY','HARRIOT',NULL,'HAROLD');
153 154
LEAST(NULL,'HARRY','HARRIOT',NULL,'HAROLD')	GREATEST(NULL,'HARRY','HARRIOT',NULL,'HAROLD')
HAROLD	HARRY
unknown's avatar
unknown committed
155
select least(1,2,3) | greatest(16,32,8), least(5,4)*1,greatest(-1.0,1.0)*1,least(3,2,1)*1.0,greatest(1,1.1,1.0),least("10",9),greatest("A","B","0");
156 157
least(1,2,3) | greatest(16,32,8)	least(5,4)*1	greatest(-1.0,1.0)*1	least(3,2,1)*1.0	greatest(1,1.1,1.0)	least("10",9)	greatest("A","B","0")
33	4	1.0	1.0	1.1	9	B
unknown's avatar
unknown committed
158
select decode(encode(repeat("a",100000),"monty"),"monty")=repeat("a",100000);
159 160
decode(encode(repeat("a",100000),"monty"),"monty")=repeat("a",100000)
1
unknown's avatar
unknown committed
161
select decode(encode("abcdef","monty"),"monty")="abcdef";
162 163
decode(encode("abcdef","monty"),"monty")="abcdef"
1
unknown's avatar
unknown committed
164 165
select quote('\'\"\\test');
quote('\'\"\\test')
unknown's avatar
unknown committed
166
'\'"\\test'
unknown's avatar
unknown committed
167 168 169
select quote(concat('abc\'', '\\cba'));
quote(concat('abc\'', '\\cba'))
'abc\'\\cba'
170 171 172
select quote(1/0), quote('\0\Z');
quote(1/0)	quote('\0\Z')
NULL	'\0\Z'
unknown's avatar
unknown committed
173 174
select length(quote(concat(char(0),"test")));
length(quote(concat(char(0),"test")))
unknown's avatar
unknown committed
175
8
unknown's avatar
unknown committed
176
select reverse("");
177 178
reverse("")

unknown's avatar
unknown committed
179
select insert("aa",100,1,"b"),insert("aa",1,3,"b"),left("aa",-1),substring("a",1,2);
180 181
insert("aa",100,1,"b")	insert("aa",1,3,"b")	left("aa",-1)	substring("a",1,2)
aa	b		a
unknown's avatar
unknown committed
182
select elt(2,1),field(NULL,"a","b","c"),reverse("");
183 184
elt(2,1)	field(NULL,"a","b","c")	reverse("")
NULL	0	
unknown's avatar
unknown committed
185
select locate("a","b",2),locate("","a",1);
186 187
locate("a","b",2)	locate("","a",1)
0	1
unknown's avatar
unknown committed
188
select ltrim("a"),rtrim("a"),trim(BOTH "" from "a"),trim(BOTH " " from "a");
189 190
ltrim("a")	rtrim("a")	trim(BOTH "" from "a")	trim(BOTH " " from "a")
a	a	a	a
unknown's avatar
unknown committed
191
select concat("1","2")|0,concat("1",".5")+0.0;
192 193
concat("1","2")|0	concat("1",".5")+0.0
12	1.5
unknown's avatar
unknown committed
194
select substring_index("www.tcx.se","",3);
195 196
substring_index("www.tcx.se","",3)

unknown's avatar
unknown committed
197
select length(repeat("a",100000000)),length(repeat("a",1000*64));
198 199
length(repeat("a",100000000))	length(repeat("a",1000*64))
NULL	64000
unknown's avatar
unknown committed
200
select position("0" in "baaa" in (1)),position("0" in "1" in (1,2,3)),position("sql" in ("mysql"));
201 202
position("0" in "baaa" in (1))	position("0" in "1" in (1,2,3))	position("sql" in ("mysql"))
1	0	3
unknown's avatar
unknown committed
203
select position(("1" in (1,2,3)) in "01");
204 205
position(("1" in (1,2,3)) in "01")
2
unknown's avatar
unknown committed
206
select length(repeat("a",65500)),length(concat(repeat("a",32000),repeat("a",32000))),length(replace("aaaaa","a",concat(repeat("a",10000)))),length(insert(repeat("a",40000),1,30000,repeat("b",50000)));
207 208
length(repeat("a",65500))	length(concat(repeat("a",32000),repeat("a",32000)))	length(replace("aaaaa","a",concat(repeat("a",10000))))	length(insert(repeat("a",40000),1,30000,repeat("b",50000)))
65500	64000	50000	60000
unknown's avatar
unknown committed
209
select length(repeat("a",1000000)),length(concat(repeat("a",32000),repeat("a",32000),repeat("a",32000))),length(replace("aaaaa","a",concat(repeat("a",32000)))),length(insert(repeat("a",48000),1,1000,repeat("a",48000)));
210 211
length(repeat("a",1000000))	length(concat(repeat("a",32000),repeat("a",32000),repeat("a",32000)))	length(replace("aaaaa","a",concat(repeat("a",32000))))	length(insert(repeat("a",48000),1,1000,repeat("a",48000)))
1000000	96000	160000	95000
unknown's avatar
unknown committed
212 213 214
create table t1 ( domain char(50) );
insert into t1 VALUES ("hello.de" ), ("test.de" );
select domain from t1 where concat('@', trim(leading '.' from concat('.', domain))) = '@hello.de';
215 216
domain
hello.de
unknown's avatar
unknown committed
217
select domain from t1 where concat('@', trim(leading '.' from concat('.', domain))) = '@test.de';
218 219
domain
test.de
unknown's avatar
unknown committed
220 221 222 223 224 225 226 227 228 229 230 231 232 233
drop table t1;
CREATE TABLE t1 (
id int(10) unsigned NOT NULL,
title varchar(255) default NULL,
prio int(10) unsigned default NULL,
category int(10) unsigned default NULL,
program int(10) unsigned default NULL,
bugdesc text,
created datetime default NULL,
modified timestamp(14) NOT NULL,
bugstatus int(10) unsigned default NULL,
submitter int(10) unsigned default NULL
) TYPE=MyISAM;
INSERT INTO t1 VALUES (1,'Link',1,1,1,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2001-02-28 08:40:16',20010228084016,0,4);
234 235
SELECT CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified+0,bugstatus,submitter), '"') FROM t1;
CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified+0,bugstatus,submitter), '"')
236
"Link";"1";"1";"1";"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"2001-02-28 08:40:16";"20010228084016";"0";"4"
unknown's avatar
unknown committed
237
SELECT CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter), '"') FROM t1;
238 239
CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter), '"')
"Link";"1";"1";"1";"0";"4"
240 241
SELECT CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified+0,bugstatus,submitter) FROM t1;
CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified+0,bugstatus,submitter)
242
Link";"1";"1";"1";"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"2001-02-28 08:40:16";"20010228084016";"0";"4
unknown's avatar
unknown committed
243 244 245
SELECT bugdesc, REPLACE(bugdesc, 'xxxxxxxxxxxxxxxxxxxx', 'bbbbbbbbbbbbbbbbbbbb') from t1 group by bugdesc;
bugdesc	REPLACE(bugdesc, 'xxxxxxxxxxxxxxxxxxxx', 'bbbbbbbbbbbbbbbbbbbb')
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa	aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
unknown's avatar
unknown committed
246
drop table t1;
247 248 249 250 251
CREATE TABLE t1 (id int(11) NOT NULL auto_increment, tmp text NOT NULL, KEY id (id)) TYPE=MyISAM;
INSERT INTO t1 VALUES (1, 'a545f661efdd1fb66fdee3aab79945bf');
SELECT 1 FROM t1 WHERE tmp=AES_DECRYPT(tmp,"password");
1
DROP TABLE t1;
252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269
select collation(bin(130)), coercibility(bin(130));
collation(bin(130))	coercibility(bin(130))
latin1_swedish_ci	3
select collation(oct(130)), coercibility(oct(130));
collation(oct(130))	coercibility(oct(130))
latin1_swedish_ci	3
select collation(conv(130,16,10)), coercibility(conv(130,16,10));
collation(conv(130,16,10))	coercibility(conv(130,16,10))
latin1_swedish_ci	3
select collation(hex(130)), coercibility(hex(130));
collation(hex(130))	coercibility(hex(130))
latin1_swedish_ci	3
select collation(char(130)), coercibility(hex(130));
collation(char(130))	coercibility(hex(130))
binary	3
select collation(format(130,10)), coercibility(format(130,10));
collation(format(130,10))	coercibility(format(130,10))
latin1_swedish_ci	3
270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290
select collation(lcase(_latin2'a')), coercibility(lcase(_latin2'a'));
collation(lcase(_latin2'a'))	coercibility(lcase(_latin2'a'))
latin2_general_ci	3
select collation(ucase(_latin2'a')), coercibility(ucase(_latin2'a'));
collation(ucase(_latin2'a'))	coercibility(ucase(_latin2'a'))
latin2_general_ci	3
select collation(left(_latin2'a',1)), coercibility(left(_latin2'a',1));
collation(left(_latin2'a',1))	coercibility(left(_latin2'a',1))
latin2_general_ci	3
select collation(right(_latin2'a',1)), coercibility(right(_latin2'a',1));
collation(right(_latin2'a',1))	coercibility(right(_latin2'a',1))
latin2_general_ci	3
select collation(substring(_latin2'a',1,1)), coercibility(substring(_latin2'a',1,1));
collation(substring(_latin2'a',1,1))	coercibility(substring(_latin2'a',1,1))
latin2_general_ci	3
select collation(concat(_latin2'a',_latin2'b')), coercibility(concat(_latin2'a',_latin2'b'));
collation(concat(_latin2'a',_latin2'b'))	coercibility(concat(_latin2'a',_latin2'b'))
latin2_general_ci	3
select collation(concat_ws(_latin2'a',_latin2'b')), coercibility(concat_ws(_latin2'a',_latin2'b'));
collation(concat_ws(_latin2'a',_latin2'b'))	coercibility(concat_ws(_latin2'a',_latin2'b'))
latin2_general_ci	3
291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308
select collation(trim(_latin2' a ')), coercibility(trim(_latin2' a '));
collation(trim(_latin2' a '))	coercibility(trim(_latin2' a '))
latin2_general_ci	3
select collation(ltrim(_latin2' a ')), coercibility(ltrim(_latin2' a '));
collation(ltrim(_latin2' a '))	coercibility(ltrim(_latin2' a '))
latin2_general_ci	3
select collation(rtrim(_latin2' a ')), coercibility(rtrim(_latin2' a '));
collation(rtrim(_latin2' a '))	coercibility(rtrim(_latin2' a '))
latin2_general_ci	3
select collation(trim(LEADING _latin2' ' FROM _latin2'a')), coercibility(trim(LEADING _latin2'a' FROM _latin2'a'));
collation(trim(LEADING _latin2' ' FROM _latin2'a'))	coercibility(trim(LEADING _latin2'a' FROM _latin2'a'))
latin2_general_ci	3
select collation(trim(TRAILING _latin2' ' FROM _latin2'a')), coercibility(trim(TRAILING _latin2'a' FROM _latin2'a'));
collation(trim(TRAILING _latin2' ' FROM _latin2'a'))	coercibility(trim(TRAILING _latin2'a' FROM _latin2'a'))
latin2_general_ci	3
select collation(trim(BOTH _latin2' ' FROM _latin2'a')), coercibility(trim(BOTH _latin2'a' FROM _latin2'a'));
collation(trim(BOTH _latin2' ' FROM _latin2'a'))	coercibility(trim(BOTH _latin2'a' FROM _latin2'a'))
latin2_general_ci	3
309 310 311 312 313 314 315 316 317 318 319 320 321 322 323
select collation(repeat(_latin2'a',10)), coercibility(repeat(_latin2'a',10));
collation(repeat(_latin2'a',10))	coercibility(repeat(_latin2'a',10))
latin2_general_ci	3
select collation(reverse(_latin2'ab')), coercibility(reverse(_latin2'ab'));
collation(reverse(_latin2'ab'))	coercibility(reverse(_latin2'ab'))
latin2_general_ci	3
select collation(quote(_latin2'ab')), coercibility(quote(_latin2'ab'));
collation(quote(_latin2'ab'))	coercibility(quote(_latin2'ab'))
latin2_general_ci	3
select collation(soundex(_latin2'ab')), coercibility(soundex(_latin2'ab'));
collation(soundex(_latin2'ab'))	coercibility(soundex(_latin2'ab'))
latin2_general_ci	3
select collation(substring(_latin2'ab',1)), coercibility(substring(_latin2'ab',1));
collation(substring(_latin2'ab',1))	coercibility(substring(_latin2'ab',1))
latin2_general_ci	3
324 325 326
select collation(insert(_latin2'abcd',2,3,_latin2'ef')), coercibility(insert(_latin2'abcd',2,3,_latin2'ef'));
collation(insert(_latin2'abcd',2,3,_latin2'ef'))	coercibility(insert(_latin2'abcd',2,3,_latin2'ef'))
latin2_general_ci	3
327 328 329
select collation(replace(_latin2'abcd',_latin2'b',_latin2'B')), coercibility(replace(_latin2'abcd',_latin2'b',_latin2'B'));
collation(replace(_latin2'abcd',_latin2'b',_latin2'B'))	coercibility(replace(_latin2'abcd',_latin2'b',_latin2'B'))
latin2_general_ci	3
330 331
create table t1 
select
332 333 334 335 336 337
bin(130),
oct(130),
conv(130,16,10),
hex(130),
char(130),
format(130,10),
338 339 340 341 342 343
left(_latin2'a',1),
right(_latin2'a',1), 
lcase(_latin2'a'), 
ucase(_latin2'a'),
substring(_latin2'a',1,1),
concat(_latin2'a',_latin2'b'),
344 345 346 347 348 349
concat_ws(_latin2'a',_latin2'b'),
trim(_latin2' a '),
ltrim(_latin2' a '),
rtrim(_latin2' a '),
trim(LEADING _latin2' ' FROM _latin2' a '),
trim(TRAILING _latin2' ' FROM _latin2' a '),
350 351 352 353 354
trim(BOTH _latin2' ' FROM _latin2' a '),
repeat(_latin2'a',10),
reverse(_latin2'ab'),
quote(_latin2'ab'),
soundex(_latin2'ab'),
355
substring(_latin2'ab',1),
356 357
insert(_latin2'abcd',2,3,_latin2'ef'),
replace(_latin2'abcd',_latin2'b',_latin2'B')
358
;
359 360
Warnings:
Warning	1263	Data truncated for column 'format(130,10)' at row 1
361 362 363
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
364 365 366 367 368 369
  `bin(130)` char(64) NOT NULL default '',
  `oct(130)` char(64) NOT NULL default '',
  `conv(130,16,10)` char(64) NOT NULL default '',
  `hex(130)` char(6) NOT NULL default '',
  `char(130)` char(1) NOT NULL default '',
  `format(130,10)` char(4) NOT NULL default '',
370 371 372 373 374 375
  `left(_latin2'a',1)` char(1) character set latin2 NOT NULL default '',
  `right(_latin2'a',1)` char(1) character set latin2 NOT NULL default '',
  `lcase(_latin2'a')` char(1) character set latin2 NOT NULL default '',
  `ucase(_latin2'a')` char(1) character set latin2 NOT NULL default '',
  `substring(_latin2'a',1,1)` char(1) character set latin2 NOT NULL default '',
  `concat(_latin2'a',_latin2'b')` char(2) character set latin2 NOT NULL default '',
376 377 378 379 380 381
  `concat_ws(_latin2'a',_latin2'b')` char(1) character set latin2 NOT NULL default '',
  `trim(_latin2' a ')` char(3) character set latin2 NOT NULL default '',
  `ltrim(_latin2' a ')` char(3) character set latin2 NOT NULL default '',
  `rtrim(_latin2' a ')` char(3) character set latin2 NOT NULL default '',
  `trim(LEADING _latin2' ' FROM _latin2' a ')` char(3) character set latin2 NOT NULL default '',
  `trim(TRAILING _latin2' ' FROM _latin2' a ')` char(3) character set latin2 NOT NULL default '',
382 383 384 385 386
  `trim(BOTH _latin2' ' FROM _latin2' a ')` char(3) character set latin2 NOT NULL default '',
  `repeat(_latin2'a',10)` char(10) character set latin2 NOT NULL default '',
  `reverse(_latin2'ab')` char(2) character set latin2 NOT NULL default '',
  `quote(_latin2'ab')` char(6) character set latin2 NOT NULL default '',
  `soundex(_latin2'ab')` char(4) character set latin2 NOT NULL default '',
387
  `substring(_latin2'ab',1)` char(2) character set latin2 NOT NULL default '',
388 389
  `insert(_latin2'abcd',2,3,_latin2'ef')` char(6) character set latin2 NOT NULL default '',
  `replace(_latin2'abcd',_latin2'b',_latin2'B')` char(4) character set latin2 NOT NULL default ''
390 391
) TYPE=MyISAM CHARSET=latin1
drop table t1;