linkisp.internetsul.org.br

Linux roncon.redesul.com.br 3.10.0-514.16.1.el7.x86_64 #1 SMP Wed Apr 12 15:04:24 UTC 2017 x86_64
Apache
186.195.16.34
338 Domain

URL to Upload

File Name

Upload Method

Upload from URL

func_str.test

# Description
# -----------
# Testing string functions

--disable_warnings
drop table if exists t1,t2;
--enable_warnings

set names latin1;

select 'hello',"'hello'",'""hello""','''h''e''l''l''o''',"hel""lo",'hel\'lo';
select 'hello' 'monty';
select length('\n\t\r\b\0\_\%\\');
select bit_length('\n\t\r\b\0\_\%\\');
select char_length('\n\t\r\b\0\_\%\\');
select length(_latin1'\n\t\n\b\0\\_\\%\\');
select concat('monty',' was here ','again'),length('hello'),char(ascii('h')),ord('h');
select hex(char(256));
select locate('he','hello'),locate('he','hello',2),locate('lo','hello',2) ;
select instr('hello','HE'), instr('hello',binary 'HE'), instr(binary 'hello','HE'); 
select position(binary 'll' in 'hello'),position('a' in binary 'hello');
#
# Bug#11728 string function LEFT,
# strange undocumented behaviour, strict mode
#
select left('hello',null), right('hello',null);
select left('hello',2),right('hello',2),substring('hello',2,2),mid('hello',1,5) ;
select concat('',left(right(concat('what ',concat('is ','happening')),9),4),'',substring('monty',5,1)) ;
select substring_index('www.tcx.se','.',-2),substring_index('www.tcx.se','.',1);
select substring_index('www.tcx.se','tcx',1),substring_index('www.tcx.se','tcx',-1);
select substring_index('.tcx.se','.',-2),substring_index('.tcx.se','.tcx',-1);
select substring_index('aaaaaaaaa1','a',1);
select substring_index('aaaaaaaaa1','aa',1);
select substring_index('aaaaaaaaa1','aa',2);
select substring_index('aaaaaaaaa1','aa',3);
select substring_index('aaaaaaaaa1','aa',4);
select substring_index('aaaaaaaaa1','aa',5);
select substring_index('aaaaaaaaa1','aaa',1);
select substring_index('aaaaaaaaa1','aaa',2);
select substring_index('aaaaaaaaa1','aaa',3);
select substring_index('aaaaaaaaa1','aaa',4);
select substring_index('aaaaaaaaa1','aaaa',1);
select substring_index('aaaaaaaaa1','aaaa',2);
select substring_index('aaaaaaaaa1','1',1);
select substring_index('aaaaaaaaa1','a',-1);
select substring_index('aaaaaaaaa1','aa',-1);
select substring_index('aaaaaaaaa1','aa',-2);
select substring_index('aaaaaaaaa1','aa',-3);
select substring_index('aaaaaaaaa1','aa',-4);
select substring_index('aaaaaaaaa1','aa',-5);
select substring_index('aaaaaaaaa1','aaa',-1);
select substring_index('aaaaaaaaa1','aaa',-2);
select substring_index('aaaaaaaaa1','aaa',-3);
select substring_index('aaaaaaaaa1','aaa',-4);
select substring_index('the king of thethe hill','the',-2);
select substring_index('the king of the the hill','the',-2);
select substring_index('the king of the  the hill','the',-2);
select substring_index('the king of the  the hill',' the ',-1);
select substring_index('the king of the  the hill',' the ',-2);
select substring_index('the king of the  the hill',' ',-1);
select substring_index('the king of the  the hill',' ',-2);
select substring_index('the king of the  the hill',' ',-3);
select substring_index('the king of the  the hill',' ',-4);
select substring_index('the king of the  the hill',' ',-5);
select substring_index('the king of the.the hill','the',-2);
select substring_index('the king of thethethe.the hill','the',-3);
select substring_index('the king of thethethe.the hill','the',-1);
select substring_index('the king of the the hill','the',1);
select substring_index('the king of the the hill','the',2);
select substring_index('the king of the the hill','the',3);

select concat(':',ltrim('  left  '),':',rtrim('  right  '),':');
select concat(':',trim(leading from '  left  '),':',trim(trailing from '  right  '),':');
select concat(':',trim(LEADING FROM ' left'),':',trim(TRAILING FROM ' right '),':');
select concat(':',trim(' m '),':',trim(BOTH FROM ' y '),':',trim('*' FROM '*s*'),':');
select concat(':',trim(BOTH 'ab' FROM 'ababmyabab'),':',trim(BOTH '*' FROM '***sql'),':');
select concat(':',trim(LEADING '.*' FROM '.*my'),':',trim(TRAILING '.*' FROM 'sql.*.*'),':');
select TRIM("foo" FROM "foo"), TRIM("foo" FROM "foook"), TRIM("foo" FROM "okfoo");

select concat_ws(', ','monty','was here','again');
select concat_ws(NULL,'a'),concat_ws(',',NULL,'');
select concat_ws(',','',NULL,'a');
SELECT CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),repeat('d',100)), '"');

select insert('txs',2,1,'hi'),insert('is ',4,0,'a'),insert('txxxxt',2,4,'es');
select replace('aaaa','a','b'),replace('aaaa','aa','b'),replace('aaaa','a','bb'),replace('aaaa','','b'),replace('bbbb','a','c');
select replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL') ;
select soundex(''),soundex('he'),soundex('hello all folks'),soundex('#3556 in bugdb');
select 'mood' sounds like 'mud';
select 'Glazgo' sounds like 'Liverpool';
select null sounds like 'null';
select 'null' sounds like null;
select null sounds like null;
select md5('hello');
select crc32("123");
select sha('abc');
select sha1('abc');
select aes_decrypt(aes_encrypt('abc','1'),'1');
select aes_decrypt(aes_encrypt('abc','1'),1);
select aes_encrypt(NULL,"a");
select aes_encrypt("a",NULL);
select aes_decrypt(NULL,"a");
select aes_decrypt("a",NULL);
select aes_decrypt("a","a");
select aes_decrypt(aes_encrypt("","a"),"a");
select repeat('monty',5),concat('*',space(5),'*');
select reverse('abc'),reverse('abcd');
select rpad('a',4,'1'),rpad('a',4,'12'),rpad('abcd',3,'12'), rpad(11, 10 , 22), rpad("ab", 10, 22);
select lpad('a',4,'1'),lpad('a',4,'12'),lpad('abcd',3,'12'), lpad(11, 10 , 22);
select rpad(741653838,17,'0'),lpad(741653838,17,'0');
select rpad('abcd',7,'ab'),lpad('abcd',7,'ab');
select rpad('abcd',1,'ab'),lpad('abcd',1,'ab');
select rpad('STRING', 20, CONCAT('p','a','d') );
select lpad('STRING', 20, CONCAT('p','a','d') );

select LEAST(NULL,'HARRY','HARRIOT',NULL,'HAROLD'),GREATEST(NULL,'HARRY','HARRIOT',NULL,'HAROLD');
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");

select decode(encode(repeat("a",100000),"monty"),"monty")=repeat("a",100000);
select decode(encode("abcdef","monty"),"monty")="abcdef";

select quote('\'\"\\test');
select quote(concat('abc\'', '\\cba'));
select quote(1/0), quote('\0\Z');
select length(quote(concat(char(0),"test")));
select hex(quote(concat(char(224),char(227),char(230),char(231),char(232),char(234),char(235))));
select unhex(hex("foobar")), hex(unhex("1234567890ABCDEF")), unhex("345678"), unhex(NULL);
select hex(unhex("1")), hex(unhex("12")), hex(unhex("123")), hex(unhex("1234")), hex(unhex("12345")), hex(unhex("123456"));
select length(unhex(md5("abrakadabra")));

#
# Bug #6564: QUOTE(NULL
#

select concat('a', quote(NULL));

#
# Wrong usage of functions
#

select reverse("");
select insert("aa",100,1,"b"),insert("aa",1,3,"b"),left("aa",-1),substring("a",1,2);
select elt(2,1),field(NULL,"a","b","c"),reverse("");
select locate("a","b",2),locate("","a",1);
select ltrim("a"),rtrim("a"),trim(BOTH "" from "a"),trim(BOTH " " from "a");
select concat("1","2")|0,concat("1",".5")+0.0;
select substring_index("www.tcx.se","",3);
select length(repeat("a",100000000)),length(repeat("a",1000*64));
select position("0" in "baaa" in (1)),position("0" in "1" in (1,2,3)),position("sql" in ("mysql"));
select position(("1" in (1,2,3)) in "01");
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)));
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)));

#
# Problem med concat
#

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';
select domain from t1 where concat('@', trim(leading '.' from concat('.', domain))) = '@test.de';
drop table t1;

#
# Test bug in concat_ws
#

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 NOT NULL,
  bugstatus int(10) unsigned default NULL,
  submitter int(10) unsigned default NULL
) ENGINE=MyISAM;

INSERT INTO t1 VALUES (1,'Link',1,1,1,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa','2001-02-28 08:40:16',20010228084016,0,4);
SELECT CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified+0,bugstatus,submitter), '"') FROM t1;
SELECT CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter), '"') FROM t1;
SELECT CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified+0,bugstatus,submitter) FROM t1;
SELECT bugdesc, REPLACE(bugdesc, 'xxxxxxxxxxxxxxxxxxxx', 'bbbbbbbbbbbbbbbbbbbb') from t1 group by bugdesc;
drop table t1;

#
# Test bug in AES_DECRYPT() when called with wrong argument
#

CREATE TABLE t1 (id int(11) NOT NULL auto_increment, tmp text NOT NULL, KEY id (id)) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1, 'a545f661efdd1fb66fdee3aab79945bf');
SELECT 1 FROM t1 WHERE tmp=AES_DECRYPT(tmp,"password");
DROP TABLE t1;

CREATE TABLE t1 (
  wid int(10) unsigned NOT NULL auto_increment,
  data_podp date default NULL,
  status_wnio enum('nowy','podp','real','arch') NOT NULL default 'nowy',
  PRIMARY KEY(wid)
);

INSERT INTO t1 VALUES (8,NULL,'real');
INSERT INTO t1 VALUES (9,NULL,'nowy');
SELECT elt(status_wnio,data_podp) FROM t1 GROUP BY wid;
DROP TABLE t1;

#
# test for #739

CREATE TABLE t1 (title text) ENGINE=MyISAM;
INSERT INTO t1 VALUES ('Congress reconvenes in September to debate welfare and adult education');
INSERT INTO t1 VALUES ('House passes the CAREERS bill');
SELECT CONCAT("</a>",RPAD("",(55 - LENGTH(title)),".")) from t1;
DROP TABLE t1;

#
# test for Bug #2290 "output truncated with ELT when using DISTINCT"
#

CREATE TABLE t1 (i int, j int);
INSERT INTO t1 VALUES (1,1),(2,2);
SELECT DISTINCT i, ELT(j, '345', '34') FROM t1;
DROP TABLE t1;

#
# bug #3756: quote and NULL
#

create table t1(a char(4));
insert into t1 values ('one'),(NULL),('two'),('four');
select a, quote(a), isnull(quote(a)), quote(a) is null, ifnull(quote(a), 'n') from t1;
drop table t1;

#
# Bug #5498: TRIM fails with LEADING or TRAILING if remstr = str
#

select trim(trailing 'foo' from 'foo');
select trim(leading 'foo' from 'foo');

#
# crashing bug with QUOTE() and LTRIM() or TRIM() fixed
# Bug #7495
#

select quote(ltrim(concat('    ', 'a')));
select quote(trim(concat('    ', 'a')));

# Bad results from QUOTE(). Bug #8248
CREATE TABLE t1 SELECT 1 UNION SELECT 2 UNION SELECT 3;
SELECT QUOTE('A') FROM t1;
DROP TABLE t1;

# Test collation and coercibility
#

select 1=_latin1'1';
select _latin1'1'=1;
select _latin2'1'=1;
select 1=_latin2'1';
--error 1267
select _latin1'1'=_latin2'1';
select row('a','b','c') = row('a','b','c');
select row('A','b','c') = row('a','b','c');
select row('A' COLLATE latin1_bin,'b','c') = row('a','b','c');
select row('A','b','c') = row('a' COLLATE latin1_bin,'b','c');
--error 1267
select row('A' COLLATE latin1_general_ci,'b','c') = row('a' COLLATE latin1_bin,'b','c');

--error 1267
select concat(_latin1'a',_latin2'a');
--error 1270
select concat(_latin1'a',_latin2'a',_latin5'a');
--error 1271
select concat(_latin1'a',_latin2'a',_latin5'a',_latin7'a');
--error 1267
select concat_ws(_latin1'a',_latin2'a');

#
# Test FIELD() and collations
#
select FIELD('b','A','B');
select FIELD('B','A','B');
select FIELD('b' COLLATE latin1_bin,'A','B');
select FIELD('b','A' COLLATE latin1_bin,'B');
--error 1270
select FIELD(_latin2'b','A','B');
--error 1270
select FIELD('b',_latin2'A','B');
select FIELD('1',_latin2'3','2',1);

select POSITION(_latin1'B' IN _latin1'abcd');
select POSITION(_latin1'B' IN _latin1'abcd' COLLATE latin1_bin);
select POSITION(_latin1'B' COLLATE latin1_bin IN _latin1'abcd');
--error 1267
select POSITION(_latin1'B' COLLATE latin1_general_ci IN _latin1'abcd' COLLATE latin1_bin);
--error 1267
select POSITION(_latin1'B' IN _latin2'abcd');

select FIND_IN_SET(_latin1'B',_latin1'a,b,c,d');

# fix this:
--disable_parsing
select FIND_IN_SET(_latin1'B',_latin1'a,b,c,d' COLLATE latin1_bin);
select FIND_IN_SET(_latin1'B' COLLATE latin1_bin,_latin1'a,b,c,d');
--enable_parsing

--error 1267
select FIND_IN_SET(_latin1'B' COLLATE latin1_general_ci,_latin1'a,b,c,d' COLLATE latin1_bin);
--error 1267
select FIND_IN_SET(_latin1'B',_latin2'a,b,c,d');

select SUBSTRING_INDEX(_latin1'abcdabcdabcd',_latin1'd',2);

# fix this:
--disable_parsing
select SUBSTRING_INDEX(_latin1'abcdabcdabcd' COLLATE latin1_bin,_latin1'd',2);
select SUBSTRING_INDEX(_latin1'abcdabcdabcd',_latin1'd' COLLATE latin1_bin,2);
--enable_parsing

--error 1267
select SUBSTRING_INDEX(_latin1'abcdabcdabcd',_latin2'd',2);
--error 1267
select SUBSTRING_INDEX(_latin1'abcdabcdabcd' COLLATE latin1_general_ci,_latin1'd' COLLATE latin1_bin,2);

select _latin1'B' between _latin1'a' and _latin1'c';
select _latin1'B' collate latin1_bin between _latin1'a' and _latin1'c';
select _latin1'B' between _latin1'a' collate latin1_bin and _latin1'c';
select _latin1'B' between _latin1'a' and _latin1'c' collate latin1_bin;
--error 1270
select _latin2'B' between _latin1'a' and _latin1'b';
--error 1270
select _latin1'B' between _latin2'a' and _latin1'b';
--error 1270
select _latin1'B' between _latin1'a' and _latin2'b';
--error 1270
select _latin1'B' collate latin1_general_ci between _latin1'a' collate latin1_bin and _latin1'b';

select _latin1'B' in (_latin1'a',_latin1'b');
select _latin1'B' collate latin1_bin in (_latin1'a',_latin1'b');
select _latin1'B' in (_latin1'a' collate latin1_bin,_latin1'b');
select _latin1'B' in (_latin1'a',_latin1'b' collate latin1_bin);
--error 1270
select _latin2'B' in (_latin1'a',_latin1'b');
--error 1270
select _latin1'B' in (_latin2'a',_latin1'b');
--error 1270
select _latin1'B' in (_latin1'a',_latin2'b');
--error 1270
select _latin1'B' COLLATE latin1_general_ci in (_latin1'a' COLLATE latin1_bin,_latin1'b');
--error 1270
select _latin1'B' COLLATE latin1_general_ci in (_latin1'a',_latin1'b' COLLATE latin1_bin);

select collation(bin(130)), coercibility(bin(130));
select collation(oct(130)), coercibility(oct(130));
select collation(conv(130,16,10)), coercibility(conv(130,16,10));
select collation(hex(130)), coercibility(hex(130));
select collation(char(130)), coercibility(hex(130));
select collation(format(130,10)), coercibility(format(130,10));
select collation(lcase(_latin2'a')), coercibility(lcase(_latin2'a'));
select collation(ucase(_latin2'a')), coercibility(ucase(_latin2'a'));
select collation(left(_latin2'a',1)), coercibility(left(_latin2'a',1));
select collation(right(_latin2'a',1)), coercibility(right(_latin2'a',1));
select collation(substring(_latin2'a',1,1)), coercibility(substring(_latin2'a',1,1));
select collation(concat(_latin2'a',_latin2'b')), coercibility(concat(_latin2'a',_latin2'b'));
select collation(lpad(_latin2'a',4,_latin2'b')), coercibility(lpad(_latin2'a',4,_latin2'b'));
select collation(rpad(_latin2'a',4,_latin2'b')), coercibility(rpad(_latin2'a',4,_latin2'b'));
select collation(concat_ws(_latin2'a',_latin2'b')), coercibility(concat_ws(_latin2'a',_latin2'b'));
select collation(make_set(255,_latin2'a',_latin2'b',_latin2'c')), coercibility(make_set(255,_latin2'a',_latin2'b',_latin2'c'));
select collation(export_set(255,_latin2'y',_latin2'n',_latin2' ')), coercibility(export_set(255,_latin2'y',_latin2'n',_latin2' '));
select collation(trim(_latin2' a ')), coercibility(trim(_latin2' a '));
select collation(ltrim(_latin2' a ')), coercibility(ltrim(_latin2' a '));
select collation(rtrim(_latin2' a ')), coercibility(rtrim(_latin2' a '));
select collation(trim(LEADING _latin2' ' FROM _latin2'a')), coercibility(trim(LEADING _latin2'a' FROM _latin2'a'));
select collation(trim(TRAILING _latin2' ' FROM _latin2'a')), coercibility(trim(TRAILING _latin2'a' FROM _latin2'a'));
select collation(trim(BOTH _latin2' ' FROM _latin2'a')), coercibility(trim(BOTH _latin2'a' FROM _latin2'a'));
select collation(repeat(_latin2'a',10)), coercibility(repeat(_latin2'a',10));
select collation(reverse(_latin2'ab')), coercibility(reverse(_latin2'ab'));
select collation(quote(_latin2'ab')), coercibility(quote(_latin2'ab'));
select collation(soundex(_latin2'ab')), coercibility(soundex(_latin2'ab'));
select collation(substring(_latin2'ab',1)), coercibility(substring(_latin2'ab',1));
select collation(insert(_latin2'abcd',2,3,_latin2'ef')), coercibility(insert(_latin2'abcd',2,3,_latin2'ef'));
select collation(replace(_latin2'abcd',_latin2'b',_latin2'B')), coercibility(replace(_latin2'abcd',_latin2'b',_latin2'B'));
select collation(encode('abcd','ab')), coercibility(encode('abcd','ab'));

create table t1 
select
  bin(130),
  oct(130),
  conv(130,16,10),
  hex(130),
  char(130),
  format(130,10),
  left(_latin2'a',1),
  right(_latin2'a',1), 
  lcase(_latin2'a'), 
  ucase(_latin2'a'),
  substring(_latin2'a',1,1),
  concat(_latin2'a',_latin2'b'),
  lpad(_latin2'a',4,_latin2'b'),
  rpad(_latin2'a',4,_latin2'b'),
  concat_ws(_latin2'a',_latin2'b'),
  make_set(255,_latin2'a',_latin2'b',_latin2'c'),
  export_set(255,_latin2'y',_latin2'n',_latin2' '),
  trim(_latin2' a '),
  ltrim(_latin2' a '),
  rtrim(_latin2' a '),
  trim(LEADING _latin2' ' FROM _latin2' a '),
  trim(TRAILING _latin2' ' FROM _latin2' a '),
  trim(BOTH _latin2' ' FROM _latin2' a '),
  repeat(_latin2'a',10),
  reverse(_latin2'ab'),
  quote(_latin2'ab'),
  soundex(_latin2'ab'),
  substring(_latin2'ab',1),
  insert(_latin2'abcd',2,3,_latin2'ef'),
  replace(_latin2'abcd',_latin2'b',_latin2'B'),
  encode('abcd','ab')
;
show create table t1;
drop table t1;

#
# Bug#9129
#
create table t1 (a char character set latin2);
insert into t1 values (null);
select charset(a), collation(a), coercibility(a) from t1;
drop table t1;
select charset(null), collation(null), coercibility(null);
#
# Make sure OUTER JOIN is not replaced with a regular joun
#
CREATE TABLE t1 (a int, b int);
CREATE TABLE t2 (a int, b int);
INSERT INTO t1 VALUES (1,1),(2,2);
INSERT INTO t2 VALUES (2,2),(3,3);
select t1.*,t2.* from t1 left join t2 on (t1.b=t2.b)
where collation(t2.a) = _utf8'binary' order by t1.a,t2.a;
select t1.*,t2.* from t1 left join t2 on (t1.b=t2.b)
where charset(t2.a) = _utf8'binary' order by t1.a,t2.a;
select t1.*,t2.* from t1 left join t2 on (t1.b=t2.b)
where coercibility(t2.a) = 5 order by t1.a,t2.a;
DROP TABLE t1, t2;

#
# test for SUBSTR
#
select SUBSTR('abcdefg',3,2);
select SUBSTRING('abcdefg',3,2);
select SUBSTR('abcdefg',-3,2) FROM DUAL;
select SUBSTR('abcdefg',-1,5) FROM DUAL;
select SUBSTR('abcdefg',0,0) FROM DUAL;
select SUBSTR('abcdefg',-1,-1) FROM DUAL;
select SUBSTR('abcdefg',1,-1) FROM DUAL;

#
# Test that fix_fields doesn't follow to upper level (to comparison)
# when an error on a lower level (in concat) has accured:
#
create table t7 (s1 char);
--error 1267
select * from t7
where concat(s1 collate latin1_general_ci,s1 collate latin1_swedish_ci) = 'AA';
drop table t7;

select substring_index("1abcd;2abcd;3abcd;4abcd", ';', 2),substring_index("1abcd;2abcd;3abcd;4abcd", ';', -2);

explain extended select md5('hello');
explain extended select sha('abc');
explain extended select sha1('abc');
explain extended select soundex('');
explain extended select 'mood' sounds like 'mud';
explain extended select aes_decrypt(aes_encrypt('abc','1'),'1');
explain extended select concat('*',space(5),'*');
explain extended select reverse('abc');
explain extended select rpad('a',4,'1');
explain extended select lpad('a',4,'1');
explain extended select concat_ws(',','',NULL,'a');
explain extended select make_set(255,_latin2'a', _latin2'b', _latin2'c');
explain extended select elt(2,1);
explain extended select locate("a","b",2);
explain extended select format(130,10);
explain extended select char(0);
explain extended select conv(130,16,10);
explain extended select hex(130);
explain extended select binary 'HE';
explain extended select export_set(255,_latin2'y', _latin2'n', _latin2' ');
explain extended select FIELD('b' COLLATE latin1_bin,'A','B');
explain extended select FIND_IN_SET(_latin1'B', _latin1'a,b,c,d');
explain extended select collation(conv(130,16,10));
explain extended select coercibility(conv(130,16,10));
explain extended select length('\n\t\r\b\0\_\%\\');
explain extended select bit_length('\n\t\r\b\0\_\%\\');
explain extended select bit_length('\n\t\r\b\0\_\%\\');
explain extended select concat('monty',' was here ','again');
explain extended select length('hello');
explain extended select char(ascii('h'));
explain extended select ord('h');
explain extended select quote(1/0);
explain extended select crc32("123");
explain extended select replace('aaaa','a','b');
explain extended select insert('txs',2,1,'hi');
explain extended select left(_latin2'a',1);
explain extended select right(_latin2'a',1);
explain extended select lcase(_latin2'a');
explain extended select ucase(_latin2'a');
explain extended select SUBSTR('abcdefg',3,2);
explain extended select substring_index("1abcd;2abcd;3abcd;4abcd", ';', 2);
explain extended select trim(_latin2' a ');
explain extended select ltrim(_latin2' a ');
explain extended select rtrim(_latin2' a ');
explain extended select decode(encode(repeat("a",100000),"monty"),"monty");

#
# lpad returns incorrect result (Bug #2182)
#

SELECT lpad(12345, 5, "#");

#
# Problem the the CONV() function (Bug #2972)
#
 
SELECT conv(71, 10, 36), conv('1Z', 36, 10);
SELECT conv(71, 10, 37), conv('1Z', 37, 10), conv(0,1,10),conv(0,0,10), conv(0,-1,10);

#
# Bug in SUBSTRING when mixed with CONCAT and ORDER BY (Bug #3089)
#

create table t1 (id int(1), str varchar(10)) DEFAULT CHARSET=utf8;
insert into t1 values (1,'aaaaaaaaaa'), (2,'bbbbbbbbbb');
create table t2 (id int(1), str varchar(10)) DEFAULT CHARSET=utf8;
insert into t2 values (1,'cccccccccc'), (2,'dddddddddd');
select substring(concat(t1.str, t2.str), 1, 15) "name" from t1, t2 
where t2.id=t1.id order by name;
drop table t1, t2;

#
# Test case for conversion of long string value to integer (Bug #3472)
#

create table t1 (c1 INT, c2 INT UNSIGNED);
insert into t1 values ('21474836461','21474836461');
insert into t1 values ('-21474836461','-21474836461');
show warnings;
select * from t1;
drop table t1;

#
# Bug #4878: LEFT() in integer/float context
#

select left(1234, 3) + 0;

#
# Bug #7101: bug with LEFT() when used as a field in GROUP BY aggregation
#
create table t1 (a int not null primary key, b varchar(40), c datetime);
insert into t1 (a,b,c) values (1,'Tom','2004-12-10 12:13:14'),(2,'ball games','2004-12-10 12:13:14'), (3,'Basil','2004-12-10 12:13:14'), (4,'Dean','2004-12-10 12:13:14'),(5,'Ellis','2004-12-10 12:13:14'), (6,'Serg','2004-12-10 12:13:14'), (7,'Sergei','2004-12-10 12:13:14'),(8,'Georg','2004-12-10 12:13:14'),(9,'Salle','2004-12-10 12:13:14'),(10,'Sinisa','2004-12-10 12:13:14'); 
select count(*) as total, left(c,10) as reg from t1 group by reg order by reg desc limit 0,12;
drop table t1;

#
# Bug#7455 unexpected result: TRIM(<NULL> FROM <whatever>) gives NOT NULL
# According to ANSI if one of the TRIM arguments is NULL, then the result
# must be NULL too.
#
select trim(null from 'kate') as "must_be_null";
select trim('xyz' from null) as "must_be_null";
select trim(leading NULL from 'kate') as "must_be_null";
select trim(trailing NULL from 'xyz') as "must_be_null";

#
# Bug #7751 - conversion for a bigint unsigned constant 
#

CREATE TABLE t1 (
  id int(11) NOT NULL auto_increment,
  a bigint(20) unsigned default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;

INSERT INTO t1 VALUES
('0','16307858876001849059');

SELECT CONV('e251273eb74a8ee3', 16, 10);

EXPLAIN 
SELECT id
  FROM t1
  WHERE a = 16307858876001849059;

EXPLAIN 
  SELECT id
  FROM t1
  WHERE a = CONV('e251273eb74a8ee3', 16, 10);

DROP TABLE t1;

#
# Bug #6317: string function CHAR, parameter is NULL, wrong result
#
SELECT CHAR(NULL,121,83,81,'76') as my_column;
SELECT CHAR_LENGTH(CHAR(NULL,121,83,81,'76')) as my_column;
#
# Test case for bug #8669: null aes_decrypt result in order by query
#

CREATE TABLE t1 (id int PRIMARY KEY, str char(255) NOT NULL);
CREATE TABLE t2 (id int NOT NULL UNIQUE);
INSERT INTO t2 VALUES (1),(2);
INSERT INTO t1 VALUES (1, aes_encrypt('foo', 'bar'));
INSERT INTO t1 VALUES (2, 'not valid');

SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id;
SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id
 ORDER BY t1.id;

DROP TABLE t1, t2;

#
# Bug #10944: Mishandling of NULL arguments in FIELD()
#
select field(0,NULL,1,0), field("",NULL,"bar",""), field(0.0,NULL,1.0,0.0);
select field(NULL,1,2,NULL), field(NULL,1,2,0);

#
# Bug #10124: access by integer index with a string key that is not a number  
#

CREATE TABLE t1 (str varchar(20) PRIMARY KEY);
CREATE TABLE t2 (num int primary key);
INSERT INTO t1 VALUES ('notnumber');
INSERT INTO t2 VALUES (0), (1);

SELECT * FROM t1, t2 WHERE num=str;
SELECT * FROM t1, t2 WHERE num=substring(str from 1 for 6);

DROP TABLE t1,t2;

#
# Bug #11469: NOT NULL optimization wrongly used for arguments of CONCAT_WS  
#

CREATE TABLE t1(
  id int(11) NOT NULL auto_increment,
  pc int(11) NOT NULL default '0',
  title varchar(20) default NULL,
  PRIMARY KEY (id)
);

INSERT INTO t1 VALUES
  (1, 0, 'Main'),
  (2, 1, 'Toys'),
  (3, 1, 'Games');

SELECT t1.id, CONCAT_WS('->', t3.title, t2.title, t1.title) as col1
  FROM t1 LEFT JOIN t1 AS t2 ON t1.pc=t2.id
          LEFT JOIN t1 AS t3 ON t2.pc=t3.id;
SELECT t1.id, CONCAT_WS('->', t3.title, t2.title, t1.title) as col1
  FROM t1 LEFT JOIN t1 AS t2 ON t1.pc=t2.id
          LEFT JOIN t1 AS t3 ON t2.pc=t3.id
    WHERE CONCAT_WS('->', t3.title, t2.title, t1.title) LIKE '%Toys%';

DROP TABLE t1;

CREATE TABLE t1(
  trackid     int(10) unsigned NOT NULL auto_increment,
  trackname   varchar(100) NOT NULL default '',
  PRIMARY KEY (trackid)
);

CREATE TABLE t2(
  artistid    int(10) unsigned NOT NULL auto_increment,
  artistname  varchar(100) NOT NULL default '',
  PRIMARY KEY (artistid)
);

CREATE TABLE t3(
  trackid     int(10) unsigned NOT NULL,
  artistid    int(10) unsigned NOT NULL,
  PRIMARY KEY (trackid,artistid)
);

INSERT INTO t1 VALUES (1, 'April In Paris'), (2, 'Autumn In New York');
INSERT INTO t2 VALUES (1, 'Vernon Duke');
INSERT INTO t3 VALUES (1,1);

SELECT CONCAT_WS(' ', trackname, artistname) trackname, artistname
  FROM t1 LEFT JOIN t3 ON t1.trackid=t3.trackid
          LEFT JOIN t2 ON t2.artistid=t3.artistid
    WHERE CONCAT_WS(' ', trackname, artistname) LIKE '%In%';

DROP TABLE t1,t2,t3;

#
# Correct length reporting from substring() (BUG#10269)
#
create table t1 (b varchar(5));
insert t1 values ('ab'), ('abc'), ('abcd'), ('abcde');
select *,substring(b,1),substring(b,-1),substring(b,-2),substring(b,-3),substring(b,-4),substring(b,-5) from t1;
select * from (select *,substring(b,1),substring(b,-1),substring(b,-2),substring(b,-3),substring(b,-4),substring(b,-5) from t1) t;
drop table t1;

#
# Bug #9854  hex() and out of range handling
#
select hex(29223372036854775809), hex(-29223372036854775809);

#
# Bug #11311: Incorrect length returned from LPAD() and RPAD()
#
create table t1 (i int);
insert into t1 values (1000000000),(1);
--enable_metadata
select lpad(i, 7, ' ') as t from t1;
select rpad(i, 7, ' ') as t from t1;
--disable_metadata
drop table t1;

#
# Bug #10418: LOAD_FILE does not behave like in manual if file does not exist
#

select load_file("lkjlkj");
select ifnull(load_file("lkjlkj"),"it's null");

#
# Bug#15351: Wrong collation used for comparison of md5() and sha()
# parameter can lead to a wrong result.
#
create table t1 (f1 varchar(4), f2 varchar(64), unique key k1 (f1,f2));
insert into t1 values ( 'test',md5('test')), ('test', sha('test'));
select * from t1 where f1='test' and (f2= md5("test") or f2= md5("TEST"));
select * from t1 where f1='test' and (f2= md5("TEST") or f2= md5("test"));
select * from t1 where f1='test' and (f2= sha("test") or f2= sha("TEST"));
select * from t1 where f1='test' and (f2= sha("TEST") or f2= sha("test"));
drop table t1;

#
# Bug#18243: REVERSE changes its argument
#

CREATE TABLE t1 (a varchar(10));
INSERT INTO t1 VALUES ('abc'), ('xyz');

SELECT a, CONCAT(a,' ',a) AS c FROM t1
  HAVING LEFT(c,LENGTH(c)-INSTR(REVERSE(c)," ")) = a;

SELECT a, CONCAT(a,' ',a) AS c FROM t1
  HAVING LEFT(CONCAT(a,' ',a),
              LENGTH(CONCAT(a,' ',a))-
                     INSTR(REVERSE(CONCAT(a,' ',a))," ")) = a;

DROP TABLE t1;

#
# Bug#17526: WRONG PRINT for TRIM FUNCTION with two arguments
#

CREATE TABLE t1 (s varchar(10));
INSERT INTO t1 VALUES ('yadda'), ('yaddy');

EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(s) > 'ab';
EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM('y' FROM s) > 'ab';
EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(LEADING 'y' FROM s) > 'ab';
EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(TRAILING 'y' FROM s) > 'ab';
EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(BOTH 'y' FROM s) > 'ab';

DROP TABLE t1;
 
#
# Bug#23409: ENCODE() and DECODE() functions aren't printed correctly
#
create table t1(f1 varchar(4));
explain extended select encode(f1,'zxcv') as 'enc' from t1;
explain extended select decode(f1,'zxcv') as 'enc' from t1;
drop table t1;

#
# Bug #31758 inet_ntoa, oct, crashes server with null + filesort 
#
create table t1 (a bigint not null)engine=myisam;
insert into t1 set a = 1024*1024*1024*4;
delete from t1 order by (inet_ntoa(a)) desc limit 10;
drop table t1;
create table t1 (a char(36) not null)engine=myisam;
insert ignore into t1 set a = ' ';
insert ignore into t1 set a = ' ';
select * from t1 order by (oct(a));
drop table t1;

--echo End of 4.1 tests

#
# Bug #13361: SELECT FORMAT(<decimal field with null>, 2) crashes
#
create table t1 (d decimal default null);
insert into t1 values (null);
select format(d, 2) from t1;
drop table t1;

#
# Bug #14676: substring_index() returns incorrect results
#
create table t1 (c varchar(40));
insert into t1 values ('y,abc'),('y,abc');
select c, substring_index(lcase(c), @q:=',', -1) as res from t1;
drop table t1;

#
# Bug #17043: Casting trimmed string to decimal loses precision
#
select cast(rtrim('  20.06 ') as decimal(19,2));
select cast(ltrim('  20.06 ') as decimal(19,2));
select cast(rtrim(ltrim('  20.06 ')) as decimal(19,2));

#
# Bug #13975: "same string" + 0 has 2 different results
#
select conv("18383815659218730760",10,10) + 0;
select "18383815659218730760" + 0;

#
# Bug #21698: substitution of a string field for a constant under a function 
#

CREATE TABLE t1 (code varchar(10));
INSERT INTO t1 VALUES ('a12'), ('A12'), ('a13');

SELECT ASCII(code), code FROM t1 WHERE code='A12';
SELECT ASCII(code), code FROM t1 WHERE code='A12' AND ASCII(code)=65;

INSERT INTO t1 VALUES ('a12 '), ('A12  ');

SELECT LENGTH(code), code FROM t1 WHERE code='A12';
SELECT LENGTH(code), code FROM t1 WHERE code='A12' AND LENGTH(code)=5;

ALTER TABLE t1 ADD INDEX (code);
CREATE TABLE t2 (id varchar(10) PRIMARY KEY);
INSERT INTO t2 VALUES ('a11'), ('a12'), ('a13'), ('a14');

SELECT * FROM t1 INNER JOIN t2 ON t1.code=t2.id 
  WHERE t2.id='a12' AND (LENGTH(code)=5 OR code < 'a00');
EXPLAIN EXTENDED 
SELECT * FROM t1 INNER JOIN t2 ON code=id 
  WHERE id='a12' AND (LENGTH(code)=5 OR code < 'a00');

DROP TABLE t1,t2;

#
# Bug#22684: The Functions ENCODE, DECODE and FORMAT are not real functions
#

select encode(NULL, NULL);
select encode("data", NULL);
select encode(NULL, "password");

select decode(NULL, NULL);
select decode("data", NULL);
select decode(NULL, "password");

select format(NULL, NULL);
select format(pi(), NULL);
select format(NULL, 2);

select benchmark(NULL, NULL);
select benchmark(0, NULL);
select benchmark(100, NULL);
select benchmark(NULL, 1+1);

#
# Bug #20752: BENCHMARK with many iterations returns too quickly
#

# not a string, but belongs with the above Bug#22684
select benchmark(-1, 1);

#
# Please note:
# 1) The collation of the password is irrelevant, the encryption uses
# the binary representation of the string without charset/collation.
# 2) These tests can not print the encoded text directly, because it's binary,
# and doing this would cause problems with source control.
# Instead, an md5() checksum is used, to verify the result indirectly.
# 3) Each md5() result must be identical.
# 4) The md5() result must never change, and must be stable across releases.
#
set @password="password";
set @my_data="clear text to encode";
select md5(encode(@my_data, "password"));
select md5(encode(@my_data, _utf8 "password"));
select md5(encode(@my_data, binary "password"));
select md5(encode(@my_data, _latin1 "password"));
select md5(encode(@my_data, _koi8r "password"));
select md5(encode(@my_data, (select "password" from dual)));
select md5(encode(@my_data, concat("pass", "word")));
select md5(encode(@my_data, @password));

set @my_data="binary encoded data";
select md5(decode(@my_data, "password"));
select md5(decode(@my_data, _utf8 "password"));
select md5(decode(@my_data, binary "password"));
select md5(decode(@my_data, _latin1 "password"));
select md5(decode(@my_data, _koi8r "password"));
select md5(decode(@my_data, (select "password" from dual)));
select md5(decode(@my_data, concat("pass", "word")));
select md5(decode(@my_data, @password));

set @dec=5;
select format(pi(), (1+1));
select format(pi(), (select 3 from dual));
select format(pi(), @dec);

set @bench_count=10;
select benchmark(10, pi());
select benchmark(5+5, pi());
select benchmark((select 10 from dual), pi());
select benchmark(@bench_count, pi());

#
# Bug #10963
# 4294967296 18446744073709551616

select locate('he','hello',-2);
select locate('lo','hello',-4294967295);
select locate('lo','hello',4294967295);
select locate('lo','hello',-4294967296);
select locate('lo','hello',4294967296);
select locate('lo','hello',-4294967297);
select locate('lo','hello',4294967297);
select locate('lo','hello',-18446744073709551615);
select locate('lo','hello',18446744073709551615);
select locate('lo','hello',-18446744073709551616);
select locate('lo','hello',18446744073709551616);
select locate('lo','hello',-18446744073709551617);
select locate('lo','hello',18446744073709551617);

select left('hello', 10);
select left('hello', 0);
select left('hello', -1);
select left('hello', -4294967295);
select left('hello', 4294967295);
select left('hello', -4294967296);
select left('hello', 4294967296);
select left('hello', -4294967297);
select left('hello', 4294967297);
select left('hello', -18446744073709551615);
select left('hello', 18446744073709551615);
select left('hello', -18446744073709551616);
select left('hello', 18446744073709551616);
select left('hello', -18446744073709551617);
select left('hello', 18446744073709551617);

select right('hello', 10);
select right('hello', 0);
select right('hello', -1);
select right('hello', -4294967295);
select right('hello', 4294967295);
select right('hello', -4294967296);
select right('hello', 4294967296);
select right('hello', -4294967297);
select right('hello', 4294967297);
select right('hello', -18446744073709551615);
select right('hello', 18446744073709551615);
select right('hello', -18446744073709551616);
select right('hello', 18446744073709551616);
select right('hello', -18446744073709551617);
select right('hello', 18446744073709551617);

select substring('hello', 2, -1);

select substring('hello', -1, 1);
select substring('hello', -2, 1);
select substring('hello', -4294967295, 1);
select substring('hello', 4294967295, 1);
select substring('hello', -4294967296, 1);
select substring('hello', 4294967296, 1);
select substring('hello', -4294967297, 1);
select substring('hello', 4294967297, 1);
select substring('hello', -18446744073709551615, 1);
select substring('hello', 18446744073709551615, 1);
select substring('hello', -18446744073709551616, 1);
select substring('hello', 18446744073709551616, 1);
select substring('hello', -18446744073709551617, 1);
select substring('hello', 18446744073709551617, 1);
select substring('hello', 1, -1);
select substring('hello', 1, -4294967295);
select substring('hello', 1, 4294967295);
select substring('hello', 1, -4294967296);
select substring('hello', 1, 4294967296);
select substring('hello', 1, -4294967297);
select substring('hello', 1, 4294967297);
select substring('hello', 1, -18446744073709551615);
select substring('hello', 1, 18446744073709551615);
select substring('hello', 1, -18446744073709551616);
select substring('hello', 1, 18446744073709551616);
select substring('hello', 1, -18446744073709551617);
select substring('hello', 1, 18446744073709551617);
select substring('hello', -1, -1);
select substring('hello', -4294967295, -4294967295);
select substring('hello', 4294967295, 4294967295);
select substring('hello', -4294967296, -4294967296);
select substring('hello', 4294967296, 4294967296);
select substring('hello', -4294967297, -4294967297);
select substring('hello', 4294967297, 4294967297);
select substring('hello', -18446744073709551615, -18446744073709551615);
select substring('hello', 18446744073709551615, 18446744073709551615);
select substring('hello', -18446744073709551616, -18446744073709551616);
select substring('hello', 18446744073709551616, 18446744073709551616);
select substring('hello', -18446744073709551617, -18446744073709551617);
select substring('hello', 18446744073709551617, 18446744073709551617);

select insert('hello', -1, 1, 'hi');
select insert('hello', -4294967295, 1, 'hi');
select insert('hello', 4294967295, 1, 'hi');
select insert('hello', -4294967296, 1, 'hi');
select insert('hello', 4294967296, 1, 'hi');
select insert('hello', -4294967297, 1, 'hi');
select insert('hello', 4294967297, 1, 'hi');
select insert('hello', -18446744073709551615, 1, 'hi');
select insert('hello', 18446744073709551615, 1, 'hi');
select insert('hello', -18446744073709551616, 1, 'hi');
select insert('hello', 18446744073709551616, 1, 'hi');
select insert('hello', -18446744073709551617, 1, 'hi');
select insert('hello', 18446744073709551617, 1, 'hi');
select insert('hello', 1, -1, 'hi');
select insert('hello', 1, -4294967295, 'hi');
select insert('hello', 1, 4294967295, 'hi');
select insert('hello', 1, -4294967296, 'hi');
select insert('hello', 1, 4294967296, 'hi');
select insert('hello', 1, -4294967297, 'hi');
select insert('hello', 1, 4294967297, 'hi');
select insert('hello', 1, -18446744073709551615, 'hi');
select insert('hello', 1, 18446744073709551615, 'hi');
select insert('hello', 1, -18446744073709551616, 'hi');
select insert('hello', 1, 18446744073709551616, 'hi');
select insert('hello', 1, -18446744073709551617, 'hi');
select insert('hello', 1, 18446744073709551617, 'hi');
select insert('hello', -1, -1, 'hi');
select insert('hello', -4294967295, -4294967295, 'hi');
select insert('hello', 4294967295, 4294967295, 'hi');
select insert('hello', -4294967296, -4294967296, 'hi');
select insert('hello', 4294967296, 4294967296, 'hi');
select insert('hello', -4294967297, -4294967297, 'hi');
select insert('hello', 4294967297, 4294967297, 'hi');
select insert('hello', -18446744073709551615, -18446744073709551615, 'hi');
select insert('hello', 18446744073709551615, 18446744073709551615, 'hi');
select insert('hello', -18446744073709551616, -18446744073709551616, 'hi');
select insert('hello', 18446744073709551616, 18446744073709551616, 'hi');
select insert('hello', -18446744073709551617, -18446744073709551617, 'hi');
select insert('hello', 18446744073709551617, 18446744073709551617, 'hi');

select repeat('hello', -1);
select repeat('hello', -4294967295);
select repeat('hello', 4294967295);
select repeat('hello', -4294967296);
select repeat('hello', 4294967296);
select repeat('hello', -4294967297);
select repeat('hello', 4294967297);
select repeat('hello', -18446744073709551615);
select repeat('hello', 18446744073709551615);
select repeat('hello', -18446744073709551616);
select repeat('hello', 18446744073709551616);
select repeat('hello', -18446744073709551617);
select repeat('hello', 18446744073709551617);

select space(-1);
select space(-4294967295);
select space(4294967295);
select space(-4294967296);
select space(4294967296);
select space(-4294967297);
select space(4294967297);
select space(-18446744073709551615);
select space(18446744073709551615);
select space(-18446744073709551616);
select space(18446744073709551616);
select space(-18446744073709551617);
select space(18446744073709551617);

select rpad('hello', -1, '1');
select rpad('hello', -4294967295, '1');
select rpad('hello', 4294967295, '1');
select rpad('hello', -4294967296, '1');
select rpad('hello', 4294967296, '1');
select rpad('hello', -4294967297, '1');
select rpad('hello', 4294967297, '1');
select rpad('hello', -18446744073709551615, '1');
select rpad('hello', 18446744073709551615, '1');
select rpad('hello', -18446744073709551616, '1');
select rpad('hello', 18446744073709551616, '1');
select rpad('hello', -18446744073709551617, '1');
select rpad('hello', 18446744073709551617, '1');

select lpad('hello', -1, '1');
select lpad('hello', -4294967295, '1');
select lpad('hello', 4294967295, '1');
select lpad('hello', -4294967296, '1');
select lpad('hello', 4294967296, '1');
select lpad('hello', -4294967297, '1');
select lpad('hello', 4294967297, '1');
select lpad('hello', -18446744073709551615, '1');
select lpad('hello', 18446744073709551615, '1');
select lpad('hello', -18446744073709551616, '1');
select lpad('hello', 18446744073709551616, '1');
select lpad('hello', -18446744073709551617, '1');
select lpad('hello', 18446744073709551617, '1');

#
# BUG#17047: CHAR() and IN() can return NULL without signaling NULL
# result
#
SET @orig_sql_mode = @@SQL_MODE;
SET SQL_MODE=traditional;

SELECT CHAR(0xff,0x8f USING utf8);
SELECT CHAR(0xff,0x8f USING utf8) IS NULL;

SET SQL_MODE=@orig_sql_mode;

#
# Bug #24947: problem with some string function with unsigned int parameters
#

select substring('abc', cast(2 as unsigned int));
select repeat('a', cast(2 as unsigned int));
select rpad('abc', cast(5 as unsigned integer), 'x');
select lpad('abc', cast(5 as unsigned integer), 'x');

#
# Bug#15757: Wrong SUBSTRING() result when a tmp table was employed.
#
create table t1(f1 longtext);
insert into t1 values ("123"),("456");
select substring(f1,1,1) from t1 group by 1;
create table t2(f1 varchar(3));
insert into t1 values ("123"),("456");
select substring(f1,4,1), substring(f1,-4,1) from t2;
drop table t1,t2;

#
# Bug #25197 :repeat function returns null when using table field directly as count
#

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE `t1` (
  `id` varchar(20) NOT NULL,
  `tire` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `t1` (`id`, `tire`) VALUES ('A', 0), ('B', 1),('C', 2);

SELECT REPEAT( '#', tire ) AS A,
       REPEAT( '#', tire % 999 ) AS B, tire FROM `t1`;

SELECT REPEAT('0', CAST(0 AS UNSIGNED));
SELECT REPEAT('0', -2);
SELECT REPEAT('0', 2);

DROP TABLE t1;

#
# Bug #26537: UNHEX() IS NULL comparison fails
#
SELECT UNHEX('G');
SELECT UNHEX('G') IS NULL;

#
# Bug #26281: INSERT() function mishandles NUL on boundary condition
#
SELECT INSERT('abc', 3, 3, '1234');
SELECT INSERT('abc', 4, 3, '1234');
SELECT INSERT('abc', 5, 3, '1234');
SELECT INSERT('abc', 6, 3, '1234');

#
# Bug #27530: Grouping on crc32, or create table select crc32
#
CREATE TABLE t1 (a INT);
CREATE VIEW v1 AS SELECT CRC32(a) AS C FROM t1;

INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
SELECT CRC32(a), COUNT(*) FROM t1 GROUP BY 1;
SELECT CRC32(a), COUNT(*) FROM t1 GROUP BY 1 ORDER BY 1;
SELECT * FROM (SELECT CRC32(a) FROM t1) t2;
CREATE TABLE t2 SELECT CRC32(a) FROM t1;
desc t2;
SELECT * FROM v1;
SELECT * FROM (SELECT * FROM v1) x;

DROP TABLE t1, t2;
DROP VIEW v1;

#
# Bug #27932: LOCATE with argument evaluated to NULL
#

SELECT LOCATE('foo', NULL) FROM DUAL;
SELECT LOCATE(NULL, 'o') FROM DUAL;
SELECT LOCATE(NULL, NULL) FROM DUAL;
SELECT LOCATE('foo', NULL) IS NULL FROM DUAL;
SELECT LOCATE(NULL, 'o') IS NULL FROM DUAL;
SELECT LOCATE(NULL, NULL) IS NULL FROM DUAL;
SELECT ISNULL(LOCATE('foo', NULL)) FROM DUAL;
SELECT ISNULL(LOCATE(NULL, 'o')) FROM DUAL;
SELECT ISNULL(LOCATE(NULL, NULL)) FROM DUAL;
SELECT LOCATE('foo', NULL) <=> NULL FROM DUAL;
SELECT LOCATE(NULL, 'o') <=> NULL FROM DUAL;
SELECT LOCATE(NULL, NULL) <=> NULL FROM DUAL;

CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a varchar(10), p varchar(10));

INSERT INTO t1 VALUES (1, 'foo', 'o');
INSERT INTO t1 VALUES (2, 'foo', NULL);
INSERT INTO t1 VALUES (3, NULL, 'o');
INSERT INTO t1 VALUES (4, NULL, NULL);

SELECT id, LOCATE(a,p) FROM t1;
SELECT id, LOCATE(a,p) IS NULL FROM t1;
SELECT id, ISNULL(LOCATE(a,p)) FROM t1;
SELECT id, LOCATE(a,p) <=> NULL FROM t1;
SELECT id FROM t1 WHERE LOCATE(a,p) IS NULL;
SELECT id FROM t1 WHERE LOCATE(a,p) <=> NULL;

DROP TABLE t1;

#
# Bug #27130: SUBSTR with UNSIGNED 0 as the last argument
#

SELECT SUBSTR('foo',1,0) FROM DUAL;
SELECT SUBSTR('foo',1,CAST(0 AS SIGNED)) FROM DUAL;
SELECT SUBSTR('foo',1,CAST(0 AS UNSIGNED)) FROM DUAL;

CREATE TABLE t1 (a varchar(10), len int unsigned);
INSERT INTO t1 VALUES ('bar', 2), ('foo', 0);

SELECT SUBSTR(a,1,len) FROM t1;

DROP TABLE t1;

#
# Bug #28850: Potential bugs related to the return type of the CHAR function
#

CREATE TABLE t1 AS SELECT CHAR(0x414243) as c1;
SELECT HEX(c1) from t1;
DROP TABLE t1;

CREATE VIEW v1 AS SELECT CHAR(0x414243) as c1;
SELECT HEX(c1) from v1;
DROP VIEW v1;

#
# Bug #35558 Wrong server metadata blows up the client
#
create table t1(a float);
insert into t1 values (1.33);
--enable_metadata
select format(a, 2) from t1;
--disable_metadata
drop table t1;

#
# Bug #41868: crash or memory overrun with concat + upper, date_format functions
#

CREATE TABLE t1 (c DATE, aa VARCHAR(30));
INSERT INTO t1 VALUES ('2008-12-31','aaaaaa');
SELECT DATE_FORMAT(c, GET_FORMAT(DATE, 'eur')) h, CONCAT(UPPER(aa),', ', aa) i FROM t1;
DROP TABLE t1;

--echo #
--echo # BUG#44774: load_file function produces valgrind warnings
--echo #
CREATE TABLE t1 (a TINYBLOB);
INSERT INTO t1 VALUES ('aaaaaaaa');
SELECT LOAD_FILE(a) FROM t1;
DROP TABLE t1;

#
# Bug#46815 CONCAT_WS returning wrong data
#
CREATE TABLE t1 (f2 VARCHAR(20));
CREATE TABLE t2 (f2 VARCHAR(20));

INSERT INTO t1 VALUES ('MIN'),('MAX');
INSERT INTO t2 VALUES ('LOAD');

SELECT CONCAT_WS('_', (SELECT t2.f2 FROM t2), t1.f2) AS concat_name FROM t1;

DROP TABLE t1, t2;

--echo End of 5.0 tests

#
# Bug#44358 valgrind errors with decode() function
#
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1(f1 tinyint default null)engine=myisam;
insert into t1 values (-1),(null);
explain select 1 as a from t1,(select decode(f1,f1) as b from t1) a;
explain select 1 as a from t1,(select encode(f1,f1) as b from t1) a;
drop table t1;

--echo #
--echo # Bug#49141: Encode function is significantly slower in 5.1 compared to 5.0
--echo #

--disable_warnings
DROP TABLE IF EXISTS t1, t2;
--enable_warnings

CREATE TABLE t1 (a VARCHAR(20), b INT);
CREATE TABLE t2 (a VARCHAR(20), b INT);

INSERT INTO t1 VALUES ('ABC', 1);
INSERT INTO t2 VALUES ('ABC', 1);

SELECT DECODE((SELECT ENCODE('secret', t1.a) FROM t1,t2 WHERE t1.a = t2.a GROUP BY t1.b), t2.a)
  FROM t1,t2 WHERE t1.b = t1.b > 0 GROUP BY t2.b;

SELECT DECODE((SELECT ENCODE('secret', 'ABC') FROM t1,t2 WHERE t1.a = t2.a GROUP BY t1.b), t2.a)
  FROM t1,t2 WHERE t1.b = t1.b > 0 GROUP BY t2.b;

SELECT DECODE((SELECT ENCODE('secret', t1.a) FROM t1,t2 WHERE t1.a = t2.a GROUP BY t1.b), 'ABC')
  FROM t1,t2 WHERE t1.b = t1.b > 0 GROUP BY t2.b;

TRUNCATE TABLE t1;
TRUNCATE TABLE t2;

INSERT INTO t1 VALUES ('EDF', 3), ('BCD', 2), ('ABC', 1);
INSERT INTO t2 VALUES ('EDF', 3), ('BCD', 2), ('ABC', 1);

SELECT DECODE((SELECT ENCODE('secret', t1.a) FROM t1,t2 WHERE t1.a = t2.a GROUP BY t1.b LIMIT 1), t2.a)
  FROM t2 WHERE t2.b = 1 GROUP BY t2.b;

DROP TABLE t1, t2;

--echo #
--echo # Bug#52164 Assertion failed: param.sort_length, file .\filesort.cc, line 149
--echo #
CREATE TABLE t1 (a LONGBLOB NOT NULL);
INSERT INTO t1 VALUES (''),('');
SELECT 1 FROM t1, t1 t2
ORDER BY QUOTE(t1.a);
DROP TABLE t1;

--echo #
--echo # Bug#57913 large negative number to string conversion functions crash
--echo # Bug#57810 case/when/then : Assertion failed: length || !scale
--echo #
SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1));
SELECT CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3));

--echo # 
--echo # Bug#58165: "my_empty_string" gets modified and causes LOAD DATA to fail
--echo # and other crashes
--echo #
CREATE TABLE t1 ( a TEXT );
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
--eval SELECT 'aaaaaaaaaaaaaa' INTO OUTFILE '$MYSQLTEST_VARDIR/tmp/bug58165.txt';
SELECT insert( substring_index( 'a', 'a', 'b' ), 1, 0, 'x' );
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
--eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/bug58165.txt' INTO TABLE t1;
SELECT * FROM t1;
DROP TABLE t1;

--echo #
--echo # Bug#12634989 VALGRIND WARNING ABOUT UNINITIALIZED VALUES CREATED IN ITEM_FUNC_DAYOFMONTH
--echo #

SELECT SUBSTRING('1', DAY(FROM_UNIXTIME(-1)));
SELECT LEFT('1', DAY(FROM_UNIXTIME(-1)));
SELECT RIGHT('1', DAY(FROM_UNIXTIME(-1)));
SELECT REPEAT('1', DAY(FROM_UNIXTIME(-1)));
SELECT RPAD('hi', DAY(FROM_UNIXTIME(-1)),'?');
SELECT LPAD('hi', DAY(FROM_UNIXTIME(-1)),'?');

CREATE TABLE t1
SELECT SUBSTRING('1', DAY(FROM_UNIXTIME(-1))) AS f1,
       LEFT('1', DAY(FROM_UNIXTIME(-1))) AS f2,
       RIGHT('1', DAY(FROM_UNIXTIME(-1))) AS f3,
       REPEAT('1', DAY(FROM_UNIXTIME(-1))) AS f4,
       RPAD('hi', DAY(FROM_UNIXTIME(-1)),'?') AS f5,
       LPAD('hi', DAY(FROM_UNIXTIME(-1)),'?') AS f6;
SHOW CREATE TABLE t1;
DROP TABLE t1;

--echo #
--echo # Bug#11766684 59851: UNINITIALISED VALUE IN ITEM_FUNC_LIKE::SELECT_OPTIMIZE WITH SUBQUERY AND
--echo #

CREATE TABLE t2(a INT, KEY(a));
INSERT INTO t2 VALUES (1),(2);
CREATE TABLE t1(b INT, PRIMARY KEY(b));
INSERT INTO t1 VALUES (0),(254);
SELECT 1 FROM t2 WHERE a LIKE
(SELECT  EXPORT_SET(1, b, b, b, b) FROM t1 LIMIT 1);
DROP TABLE t1, t2;

--echo End of 5.1 tests

--echo Start of 5.4 tests
#
# WL#4584 Internationalized number format
#
SELECT format(12345678901234567890.123, 3);
SELECT format(12345678901234567890.123, 3, NULL);
SELECT format(12345678901234567890.123, 3, 'ar_AE');
SELECT format(12345678901234567890.123, 3, 'ar_SA');
SELECT format(12345678901234567890.123, 3, 'be_BY');
SELECT format(12345678901234567890.123, 3, 'de_DE');
SELECT format(12345678901234567890.123, 3, 'en_IN');
SELECT format(12345678901234567890.123, 3, 'en_US');
SELECT format(12345678901234567890.123, 3, 'it_CH');
SELECT format(12345678901234567890.123, 3, 'ru_RU');
SELECT format(12345678901234567890.123, 3, 'ta_IN');

CREATE TABLE t1 (fmt CHAR(5) NOT NULL);
INSERT INTO t1 VALUES ('ar_AE');
INSERT INTO t1 VALUES ('ar_SA');
INSERT INTO t1 VALUES ('be_BY');
INSERT INTO t1 VALUES ('de_DE');
INSERT INTO t1 VALUES ('en_IN');
INSERT INTO t1 VALUES ('en_US');
INSERT INTO t1 VALUES ('it_CH');
INSERT INTO t1 VALUES ('ru_RU');
INSERT INTO t1 VALUES ('ta_IN');
SELECT fmt, format(12345678901234567890.123, 3, fmt) FROM t1 ORDER BY fmt;
SELECT fmt, format(12345678901234567890.123, 0, fmt) FROM t1 ORDER BY fmt;
SELECT fmt, format(12345678901234567890,     3, fmt) FROM t1 ORDER BY fmt;
SELECT fmt, format(-12345678901234567890,    3, fmt) FROM t1 ORDER BY fmt;
SELECT fmt, format(-02345678901234567890,    3, fmt) FROM t1 ORDER BY fmt;
SELECT fmt, format(-00345678901234567890,    3, fmt) FROM t1 ORDER BY fmt;
SELECT fmt, format(-00045678901234567890,    3, fmt) FROM t1 ORDER BY fmt;
DROP TABLE t1;

SELECT format(123, 1, 'Non-existent-locale');

--echo End of 5.4 tests

--echo #
--echo # Start of 5.5 tests
--echo #

--echo #
--echo # Bug#55912 FORMAT with locale set fails for numbers < 1000
--echo #
SELECT FORMAT(123.33, 2, 'no_NO'), FORMAT(1123.33, 2, 'no_NO');
SELECT FORMAT(12333e-2, 2, 'no_NO'), FORMAT(112333e-2, 2, 'no_NO');
CREATE TABLE t1 AS SELECT format(123,2,'no_NO');
SHOW CREATE TABLE t1;
SELECT * FROM t1;
DROP TABLE t1;

--echo #
--echo # Bug#11764310 conv function crashes, negative argument to memcpy
--echo #
SELECT CONV(1,-2147483648,-2147483648);

--echo #
--echo # Bug#12985030 SIMPLE QUERY WITH DECIMAL NUMBERS LEAKS MEMORY
--echo #

SELECT (rpad(1.0,2048,1)) IS NOT FALSE;
SELECT ((+0) IN
((0b111111111111111111111111111111111111111111111111111),(rpad(1.0,2048,1)),
(32767.1)));
SELECT ((rpad(1.0,2048,1)) = ('4(') ^ (0.1));

--error 1690
SELECT
pow((rpad(10.0,2048,1)),(b'1111111111111111111111111111111111111111111'));
SELECT ((rpad(1.0,2048,1)) + (0) ^ ('../'));
SELECT stddev_samp(rpad(1.0,2048,1));
SELECT ((127.1) not in ((rpad(1.0,2048,1)),(''),(-1.1)));
SELECT ((0xf3) * (rpad(1.0,2048,1)) << (0xcc));

--echo #
--echo # Bug#13359121 LARGE NUMBERS, /STRINGS/DTOA.C:662:
--echo #              BALLOC: ASSERTION `K <= 15' FAILED.
--echo # Bug#12985021 SIMPLE QUERY WITH DECIMAL NUMBERS TAKE AN 
--echo #              EXTRAORDINARY LONG TIME TO EXECUTE

SELECT @tmp_max:= @@global.max_allowed_packet;
SET @@global.max_allowed_packet=1024*1024*1024;
# switching connection to allow the new max_allowed_packet take effect
--connect (newconn, localhost, root,,)

SELECT @@global.max_allowed_packet;

do
format(rpad('111111111.1',
             1111111,
             '999999999999999999999999999999999999999999'),0,'be_BY')
;

DO
round(
  concat( (
    coalesce( (
      linefromwkb('2147483648',
                  -b'1111111111111111111111111111111111111111111')),
      ( convert('[.DC2.]',decimal(30,30)) ),
      bit_count('')
    ) ),
    ( lpad( ( elt('01','}:K5')),
              sha1('P'),
              ( ( select '-9223372036854775808.1' > all (select '')))
          )
    )
  )
);

--connection default
SET @@global.max_allowed_packet:= @tmp_max;
--disconnect newconn

--echo #
--echo # End of 5.5 tests
--echo #

--echo #
--echo # Start of 5.6 tests
--echo #

--echo #
--echo # WL#5510 Functions to_base64 and from_base64
--echo #
let $1=64;
while($1)
{
  dec $1;
  eval CREATE TABLE t1 AS SELECT TO_BASE64(REPEAT('a',$1)) AS to_base64;
  SHOW CREATE TABLE t1;
  SELECT to_base64, LENGTH(to_base64) FROM t1;
  CREATE TABLE t2 AS SELECT from_base64(to_base64) AS from_base64 FROM t1;
  SHOW CREATE TABLE t2;
  SELECT from_base64, LENGTH(from_base64) FROM t2;
  DROP TABLE t2;
  DROP TABLE t1;
  --echo
}
CREATE TABLE t1 (a VARBINARY(64));
INSERT INTO t1 VALUES (0x00), (0x0000), (0x000000), (0x00000000);
INSERT INTO t1 VALUES (0x00010203040506070809);
SELECT TO_BASE64(a), hex(a) FROM t1 ORDER BY a;
DROP TABLE t1;

--echo #
--echo # Test NULL output for NULL input
--echo #
SELECT TO_BASE64(NULL);
SELECT FROM_BASE64(NULL);

--echo #
--echo # RFC4648 test vectors
--echo #
SELECT @b:= TO_BASE64(''), FROM_BASE64(@b);       # ""
SELECT @b:= TO_BASE64('f'), FROM_BASE64(@b);      # "Zg=="
SELECT @b:= TO_BASE64('fo'), FROM_BASE64(@b);     # "Zm8="
SELECT @b:= TO_BASE64('foo'), FROM_BASE64(@b);    # "Zm9v"
SELECT @b:= TO_BASE64('foob'), FROM_BASE64(@b);   # "Zm9vYg=="
SELECT @b:= TO_BASE64('fooba'), FROM_BASE64(@b);  # "Zm9vYmE="
SELECT @b:= TO_BASE64('foobar'), FROM_BASE64(@b); # "Zm9vYmFy"

--echo #
--echo # Invalid characters - return NULL
--echo #
SELECT hex(FROM_BASE64('#'));
SELECT hex(FROM_BASE64('A#'));
SELECT hex(FROM_BASE64('AB#'));
SELECT hex(FROM_BASE64('ABC#'));
SELECT hex(FROM_BASE64('ABCD#'));

--echo #
--echo # "=" is not valid on the first and second positions of a quadruple
--echo #
SELECT hex(FROM_BASE64('='));
SELECT hex(FROM_BASE64('A='));
SELECT hex(FROM_BASE64('ABCD='));
SELECT hex(FROM_BASE64('ABCDE='));

--echo #
--echo # Incomplete sequences - return NULL
--echo #
SELECT hex(FROM_BASE64('A'));
SELECT hex(FROM_BASE64('AB'));
SELECT hex(FROM_BASE64('ABC'));

--echo #
--echo # Unexpected input after pad characters - return NULL
--echo #
SELECT hex(FROM_BASE64('AAA=x'));
SELECT hex(FROM_BASE64('AA==x'));

--echo #
--echo # Delimiters are allowed at any position
--echo #
SELECT hex(FROM_BASE64('  A B C D  '));
SELECT hex(FROM_BASE64('  A A = = '));
SELECT hex(FROM_BASE64('  A A A = '));
SELECT hex(FROM_BASE64('  A  \n  B  \r  C  \t D  '));

--echo #
--echo # Testing that to_base64 respects max_allowed_packet
--echo #
SELECT LENGTH(TO_BASE64(REPEAT('a', @@max_allowed_packet-10)));

--echo #
--echo # Testing base64 with various data types
--echo #
CREATE TABLE t1 (
  i1 INT, 
  f1 FLOAT,
  dc1 DECIMAL(10,5),
  e1 ENUM('enum11','enum12','enum13'),
  s1 SET('set1','set2','set3'),
  t1 TIME,
  d1 DATE,
  dt1 DATETIME
);
INSERT INTO t1 VALUES
(-12345, -456.789, 123.45, 'enum13', 'set1,set3',
'01:02:03', '2010-01-01', '2011-01-01 02:03:04');
SELECT FROM_BASE64(TO_BASE64(i1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(f1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(dc1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(e1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(s1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(t1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(d1)) FROM t1;
SELECT FROM_BASE64(TO_BASE64(dt1)) FROM t1;
DROP TABLE t1;

--echo #
--echo # Bug#11765562 58545:
--echo # EXPORT_SET() CAN BE USED TO MAKE ENTIRE SERVER COMPLETELY UNRESPONSIVE
--echo #

SELECT @@global.max_allowed_packet;
SELECT CHAR_LENGTH(EXPORT_SET(1,1,1,REPEAT(1,100000000)));

--connection default
SET @@global.max_allowed_packet:= @tmp_max;
--disconnect newconn

#
# BUG #12735829: SPACE() FUNCTION WARNING REFERS TO REPEAT() IN ER_WARN_ALLOWED_PACKET_OVERFLOWED 
#

SELECT SPACE(@@global.max_allowed_packet*2);

#
# BUG #11746123-23637: CHARSET AND COLLATION OF THE FUNCTION SPACE()  
#

SET NAMES latin1;
PREPARE stmt FROM "SELECT COLLATION(space(2))";
EXECUTE stmt;
SET NAMES latin2;
EXECUTE stmt;

--echo #
--echo # Bug#11829861: SUBSTRING_INDEX() RESULTS IN MISSING CHARACTERS WHEN USED
--echo # INSIDE LOWER()
--echo #

SET @user_at_host = 'root@mytinyhost-PC.local';
SELECT LOWER(SUBSTRING_INDEX(@user_at_host, '@', -1));

--echo # End of test  BUG#11829861

--echo #
--echo # Bug#42404: SUBSTRING_INDEX() RESULTS ARE INCONSISTENT
--echo #

CREATE TABLE t (i INT NOT NULL, c CHAR(255) NOT NULL);
INSERT INTO t VALUES (0,'.www.mysql.com'),(1,'.wwwmysqlcom');
SELECT i, SUBSTRING_INDEX(c, '.', -2) FROM t WHERE i = 1;
SELECT i, SUBSTRING_INDEX(c, '.', -2) FROM t;

DROP TABLE t;

--echo # End of test  BUG#42404

--echo #
--echo # Bug#13812875 ILLEGAL MIX OF COLLATIONS WITH FUNCTIONS THAT USED TO WORK
--echo #
SET NAMES utf8;
CREATE TABLE t1 (a varchar(1));
SELECT * FROM t1 WHERE a=md5('a');
SELECT * FROM t1 WHERE a=hex('a');
SELECT * FROM t1 WHERE a=to_base64('a');
DROP TABLE t1;
SET NAMES latin1;

--echo #
--echo # Bug #21056907: CONTENTS OF NOT REQUESTED CHAR/VARCHAR COLUMN ARE
--echo #                REVEALED

CREATE TABLE t1 (id INT, d TEXT);
INSERT INTO t1 VALUES (1, 'this is a secret'), (2, 'public data');
SELECT id, insert(':', 1, 0, d) FROM t1;
SELECT id, insert(0x3a, 1, 0, d) FROM t1;
DROP TABLE t1;

--echo #
--echo # Bug#22888420 CONCAT_WS: ASSERTION FAILED: !S.USES_BUFFER_OWNED_BY(THIS)
--echo #

do concat('a',concat_ws('a', 0x2859, 'a' ,
                        trim(period_add('a',1) from (1&''))
                        )
          );

--echo #
--echo # End of 5.6 tests
--echo #

--echo #
--echo # Bug 31413167 - PLEASE BACKPORT FIX FOR BUG 31320716 TO 5.6
--echo #

# expect empty string and not NULL
SELECT @var:=CONCAT('');
SELECT @var:=CONCAT_WS('','');

# shouldn't cause an assertion to fail
SET NAMES utf8;
CREATE TABLE t(a INT) engine=innodb;
INSERT INTO t VALUES(1);
SELECT 1 FROM t WHERE WEIGHT_STRING(CONCAT_WS('1',''));
SELECT 1 FROM t WHERE WEIGHT_STRING(CONCAT('',''));
SET NAMES DEFAULT;
DROP TABLE t;

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxr-xr-x	2021-02-10 03:22:45
..	dir	-	root/root	drwxr-xr-x	2021-02-10 03:22:45
1st.test	file	102 B	root/root	-rw-r--r--	2021-01-05 10:19:59
alias.test	file	9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
almost_full.test	file	848 B	root/root	-rw-r--r--	2021-01-05 10:19:59
alter_table-big.test	file	5.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
alter_table.test	file	68.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
analyze.test	file	2.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ansi.test	file	847 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive-big.test	file	41.09 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
archive.test	file	106.4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_bitfield.test	file	3.94 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_debug.test	file	395 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_gis.test	file	103 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_no_symlink-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_no_symlink.test	file	810 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_plugin-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_plugin.test	file	972 B	root/root	-rw-r--r--	2021-01-05 10:19:59
archive_symlink.test	file	2.48 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
audit_plugin-master.opt	file	17 B	root/root	-rw-r--r--	2021-01-05 10:19:59
audit_plugin.test	file	1.48 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
auth_rpl-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
auth_rpl-slave.opt	file	36 B	root/root	-rw-r--r--	2021-01-05 10:19:59
auth_rpl.test	file	1.86 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
auto_increment.test	file	10.98 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bench_count_distinct.test	file	416 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bigint.test	file	13.32 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
binary.test	file	4.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
binary_to_hex.test	file	2.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
blackhole.test	file	762 B	root/root	-rw-r--r--	2021-01-05 10:19:59
blackhole_plugin-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
blackhole_plugin.test	file	1009 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bool.test	file	2.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bootstrap-master.opt	file	98 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bootstrap.test	file	1.64 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bug12427262.test	file	1.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bug12969156-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug12969156.test	file	498 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug17076131-master.opt	file	57 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug17076131.test	file	1.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bug33509-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug33509.test	file	2.52 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bug39022.test	file	1.62 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
bug46080-master.opt	file	69 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug46080.test	file	723 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug46261-master.opt	file	40 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug46261.test	file	405 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug46760-master.opt	file	53 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug46760.test	file	970 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug47671-master.opt	file	66 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug47671.test	file	448 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug58669-master.opt	file	12 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bug58669.test	file	495 B	root/root	-rw-r--r--	2021-01-05 10:19:59
bulk_replace.test	file	311 B	root/root	-rw-r--r--	2021-01-05 10:19:59
cache_innodb-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
cache_innodb.test	file	707 B	root/root	-rw-r--r--	2021-01-05 10:19:59
case.test	file	6.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
cast.test	file	9.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
change_user-master.opt	file	16 B	root/root	-rw-r--r--	2021-01-05 10:19:59
change_user.test	file	3.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
check.test	file	1.59 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
check_auto_permission.test	file	2.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
client_xml.test	file	1.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
comment_column.test	file	36.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
comment_column2.test	file	131.05 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
comment_index.test	file	22.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
comment_table.test	file	13.99 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
comments.test	file	1.37 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
commit.test	file	15.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
commit_1innodb.test	file	255 B	root/root	-rw-r--r--	2021-01-05 10:19:59
compare.test	file	2.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
compress.test	file	827 B	root/root	-rw-r--r--	2021-01-05 10:19:59
concurrent_innodb_safelog-master.opt	file	29 B	root/root	-rw-r--r--	2021-01-05 10:19:59
concurrent_innodb_safelog.test	file	716 B	root/root	-rw-r--r--	2021-01-05 10:19:59
concurrent_innodb_unsafelog-master.opt	file	62 B	root/root	-rw-r--r--	2021-01-05 10:19:59
concurrent_innodb_unsafelog.test	file	718 B	root/root	-rw-r--r--	2021-01-05 10:19:59
connect.test	file	14.32 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
connect_debug.test	file	2.12 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
consistent_snapshot.test	file	2.02 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
constraints.test	file	1.65 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
count_distinct.test	file	7.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
count_distinct2-master.opt	file	28 B	root/root	-rw-r--r--	2021-01-05 10:19:59
count_distinct2.test	file	1.83 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
count_distinct3.test	file	1.35 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
create-big.test	file	16.96 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
create.test	file	65.6 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
create_not_windows.test	file	1.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
create_select_tmp.test	file	1.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
csv.test	file	106.78 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
csv_alter_table.test	file	1.81 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
csv_not_null.test	file	3.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ascii.test	file	1.2 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_big5.test	file	4.99 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_binary.test	file	395 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_collate.test	file	9.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_cp1250_ch.test	file	2.96 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_cp1251.test	file	2.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_cp932.test	file	1.01 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_cp932_binlog_row.test	file	236 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_cp932_binlog_stm.test	file	4.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_create.test	file	2.76 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_errors.test	file	1.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_eucjpms.test	file	29.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_euckr.test	file	5.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_filename.test	file	367 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_filesystem-master.opt	file	73 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_filesystem.test	file	233 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_gb2312.test	file	4.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_gbk.test	file	5.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_gbk_binlog.test	file	961 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_hebrew.test	file	398 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_latin1.test	file	7.15 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_latin1_de-master.opt	file	67 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_latin1_de.test	file	5.79 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_latin2.test	file	3.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_latin2_ch.test	file	7.49 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ldml-master.opt	file	100 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ldml.test	file	16.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_like_range.test	file	3.91 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_many.test	file	14.98 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_mb.test	file	692 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_recoding.test	file	6.6 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_sjis.test	file	5.71 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_tis620.test	file	64.63 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_uca.test	file	27.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ucs.test	file	23.66 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ucs2_def-master.opt	file	70 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ucs2_def.test	file	1.49 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ujis.test	file	40.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_ujis_ucs2.test	file	83.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf16.test	file	22.01 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf16_def-master.opt	file	36 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf16_def.test	file	227 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf16_uca.test	file	6.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf16le.test	file	21.66 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf32.test	file	24.79 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf32_uca.test	file	7.31 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8.test	file	52.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4-master.opt	file	68 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4.test	file	58.88 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4_heap.test	file	107 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4_innodb-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4_innodb.test	file	162 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4_myisam.test	file	92 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ctype_utf8mb4_uca.test	file	2.74 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
date_formats-master.opt	file	46 B	root/root	-rw-r--r--	2021-01-05 10:19:59
date_formats.test	file	12.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ddl_i18n_koi8r.test	file	23.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ddl_i18n_utf8.test	file	23.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
deadlock_innodb.test	file	358 B	root/root	-rw-r--r--	2021-01-05 10:19:59
debug_sync.test	file	13.71 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
debug_sync2-master.opt	file	29 B	root/root	-rw-r--r--	2021-01-05 10:19:59
debug_sync2.test	file	559 B	root/root	-rw-r--r--	2021-01-05 10:19:59
default.test	file	5.76 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
delayed.test	file	17.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
delete.test	file	15.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
deprecated_features.test	file	642 B	root/root	-rw-r--r--	2021-01-05 10:19:59
derived.test	file	46.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
dirty_close.test	file	1.55 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
disabled.def	file	1.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
disabled_replication-master.opt	file	29 B	root/root	-rw-r--r--	2021-01-05 10:19:59
disabled_replication.test	file	2.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
disconnect_on_expired_password_default.test	file	1.35 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
disconnect_on_expired_password_off-master.opt	file	37 B	root/root	-rw-r--r--	2021-01-05 10:19:59
disconnect_on_expired_password_off.test	file	1.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
distinct.test	file	24.88 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
drop-no_root.test	file	2.38 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
drop.test	file	7.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
drop_debug.test	file	779 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ds_mrr-big.test	file	1.99 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
dynamic_tracing.test	file	3.92 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
empty_table.test	file	302 B	root/root	-rw-r--r--	2021-01-05 10:19:59
enable_cleartext_plugin-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
enable_cleartext_plugin.test	file	2.48 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
endspace.test	file	4.36 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
eq_range_idx_stat.test	file	2.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
error_simulation.test	file	3.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
errors.test	file	4.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_1.test	file	16.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_2.test	file	15.97 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_bugs-master.opt	file	18 B	root/root	-rw-r--r--	2021-01-05 10:19:59
events_bugs.test	file	41.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_embedded.test	file	79 B	root/root	-rw-r--r--	2021-01-05 10:19:59
events_grant.test	file	5.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_logs_tests-master.opt	file	41 B	root/root	-rw-r--r--	2021-01-05 10:19:59
events_logs_tests.test	file	3.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_microsec.test	file	748 B	root/root	-rw-r--r--	2021-01-05 10:19:59
events_restart-master.opt	file	18 B	root/root	-rw-r--r--	2021-01-05 10:19:59
events_restart.test	file	4.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_scheduling.test	file	4.36 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_stress.test	file	4.37 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_time_zone.test	file	11.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_trans.test	file	3.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
events_trans_notembedded.test	file	1.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
execution_constants.test	file	3.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
explain.test	file	11.65 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
explain_json_all.test	file	485 B	root/root	-rw-r--r--	2021-01-05 10:19:59
explain_json_none.test	file	616 B	root/root	-rw-r--r--	2021-01-05 10:19:59
file_contents.test	file	2.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
filesort_debug.test	file	2.83 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fix_priv_tables.test	file	2.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
flush.test	file	17.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
flush2-master.opt	file	15 B	root/root	-rw-r--r--	2021-01-05 10:19:59
flush2.test	file	360 B	root/root	-rw-r--r--	2021-01-05 10:19:59
flush_block_commit.test	file	2.87 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
flush_block_commit_notembedded.test	file	1.84 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
flush_read_lock.test	file	72.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
flush_read_lock_kill.test	file	2.32 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
flush_table.test	file	15.58 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
foreign_key.test	file	2.41 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext.test	file	22.48 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext2.test	file	8.12 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext3.test	file	781 B	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_cache.test	file	1.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_distinct.test	file	1.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_left_join.test	file	3.82 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_multi.test	file	666 B	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_order_by.test	file	5.31 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_plugin-master.opt	file	19 B	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_plugin.test	file	374 B	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_update.test	file	907 B	root/root	-rw-r--r--	2021-01-05 10:19:59
fulltext_var.test	file	1.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_aes.test	file	5.76 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_aes_cfb1.test	file	445 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_aes_cfb128.test	file	455 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_aes_cfb8.test	file	445 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_aes_misc.test	file	6.11 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_aes_ofb.test	file	440 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_analyse.test	file	9.37 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_compress.test	file	3.3 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_concat.test	file	3.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_crypt.test	file	2.09 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_date_add.test	file	3.28 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_default.test	file	1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_des_encrypt.test	file	899 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_digest.test	file	109.12 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_encrypt-master.opt	file	59 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_encrypt.test	file	5.4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_encrypt_nossl.test	file	1.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_encrypt_ucs2.test	file	459 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_equal.test	file	1.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_gconcat.test	file	26.84 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_group.test	file	37.03 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_group_innodb.test	file	3.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_group_innodb_16k.test	file	605 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_if.test	file	5.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_in_all.test	file	494 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_in_icp.test	file	567 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_in_icp_mrr.test	file	540 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_in_mrr.test	file	565 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_in_mrr_cost.test	file	575 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_in_none.test	file	607 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_isnull.test	file	1009 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_like.test	file	3.71 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_math.test	file	17.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_misc-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_misc.test	file	25.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_op.test	file	964 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_regexp.test	file	2.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_rollback.test	file	14.3 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_sapdb.test	file	7.58 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_set.test	file	5.69 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_str.test	file	58.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_str_debug.test	file	421 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_str_no_ps.test	file	1.02 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_system.test	file	1.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_test.test	file	9.14 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_time.test	file	43.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
func_timestamp.test	file	661 B	root/root	-rw-r--r--	2021-01-05 10:19:59
func_weight_string.test	file	3.07 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
function_defaults.test	file	737 B	root/root	-rw-r--r--	2021-01-05 10:19:59
function_defaults_notembedded.test	file	478 B	root/root	-rw-r--r--	2021-01-05 10:19:59
gcc296.test	file	526 B	root/root	-rw-r--r--	2021-01-05 10:19:59
get_diagnostics.test	file	18.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
gis-debug.test	file	126 B	root/root	-rw-r--r--	2021-01-05 10:19:59
gis-precise.test	file	8.72 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
gis-rt-precise.test	file	1.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
gis-rtree.test	file	43.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
gis.test	file	47.91 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
grant.test	file	65.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
grant2.test	file	32.51 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
grant3-master.opt	file	19 B	root/root	-rw-r--r--	2021-01-05 10:19:59
grant3.test	file	6.59 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
grant4.test	file	8.05 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
grant_cache-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
grant_cache.test	file	590 B	root/root	-rw-r--r--	2021-01-05 10:19:59
grant_explain_non_select.test	file	7.34 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
grant_lowercase_fs.test	file	702 B	root/root	-rw-r--r--	2021-01-05 10:19:59
greedy_optimizer.test	file	30.6 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
greedy_search.test	file	9.5 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
group_by.test	file	64.36 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
group_min_max.test	file	58.59 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
group_min_max_innodb.test	file	13.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
handler_innodb.test	file	571 B	root/root	-rw-r--r--	2021-01-05 10:19:59
handler_myisam.test	file	4.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
handler_read_last.test	file	523 B	root/root	-rw-r--r--	2021-01-05 10:19:59
having.test	file	20.63 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
heap.test	file	15.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
heap_auto_increment.test	file	926 B	root/root	-rw-r--r--	2021-01-05 10:19:59
heap_btree.test	file	8.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
heap_hash.test	file	9.69 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
help.test	file	4.83 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
host_cache_size_functionality.test	file	7.62 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
implicit_char_to_num_conversion.test	file	7.63 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
implicit_commit-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
implicit_commit.test	file	19.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
import_schema_mismatch.test	file	1018 B	root/root	-rw-r--r--	2021-01-05 10:19:59
index_merge_delete.test	file	261 B	root/root	-rw-r--r--	2021-01-05 10:19:59
index_merge_innodb.test	file	1.79 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
index_merge_insert-and-replace.test	file	284 B	root/root	-rw-r--r--	2021-01-05 10:19:59
index_merge_intersect_dml.test	file	113 B	root/root	-rw-r--r--	2021-01-05 10:19:59
index_merge_myisam.test	file	5.38 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
index_merge_update.test	file	261 B	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema-big.test	file	1.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema.test	file	57.95 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema_chmod.test	file	834 B	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema_db.test	file	7.01 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema_inno.test	file	3.6 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema_parameters.test	file	12.58 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema_part.test	file	3.95 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
information_schema_routines.test	file	13.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
init_connect-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
init_connect.test	file	5.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
init_file-master.opt	file	51 B	root/root	-rw-r--r--	2021-01-05 10:19:59
init_file.test	file	944 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_explain_json_non_select_all.test	file	1.02 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_explain_json_non_select_none.test	file	1.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_explain_non_select_all.test	file	924 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_explain_non_select_none.test	file	960 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_icp.test	file	784 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_icp_all.test	file	679 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_icp_none.test	file	817 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_ignore_builtin-master.opt	file	38 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_ignore_builtin.test	file	441 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_log_file_size_functionality.test	file	5.4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr.test	file	825 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_all-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_all.test	file	711 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_cost-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_cost.test	file	824 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_cost_all-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_cost_all.test	file	710 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_cost_icp-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_cost_icp.test	file	779 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_icp-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_icp.test	file	780 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_none-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mrr_none.test	file	831 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mysql_lock-master.opt	file	31 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mysql_lock.test	file	8.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mysql_lock2.test	file	29.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_mysql_sync.test	file	21.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_pk_extension_off.test	file	298 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_pk_extension_on.test	file	296 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_recovery_with_upper_case_names-master.opt	file	25 B	root/root	-rw-r--r--	2021-01-05 10:19:59
innodb_recovery_with_upper_case_names.test	file	1.75 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
insert.test	file	17.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
insert_debug-master.opt	file	29 B	root/root	-rw-r--r--	2021-01-05 10:19:59
insert_debug.test	file	2.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
insert_notembedded.test	file	6.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
insert_select.test	file	13.83 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
insert_update.test	file	9.07 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ipv4_as_ipv6-master.opt	file	43 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ipv4_as_ipv6.test	file	2.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ipv6-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ipv6.test	file	1.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join.test	file	40.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join_cache_bka.test	file	131 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_cache_bka_nixbnl.test	file	153 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_cache_bkaunique.test	file	198 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_cache_bnl.test	file	225 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_cache_nojb.test	file	249 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_crash.test	file	4.92 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join_nested.test	file	33.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join_nested_bka.test	file	2.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join_nested_bka_nixbnl.test	file	2.32 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join_outer.test	file	47.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
join_outer_bka.test	file	169 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_outer_bka_nixbnl.test	file	191 B	root/root	-rw-r--r--	2021-01-05 10:19:59
join_outer_innodb.test	file	1.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
key.test	file	16.98 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
key_cache-master.opt	file	95 B	root/root	-rw-r--r--	2021-01-05 10:19:59
key_cache.test	file	8.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
key_diff.test	file	554 B	root/root	-rw-r--r--	2021-01-05 10:19:59
key_primary.test	file	460 B	root/root	-rw-r--r--	2021-01-05 10:19:59
keywords.test	file	5.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
kill.test	file	16.07 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
kill_debug.test	file	1.34 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
limit.test	file	3.54 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
loaddata.test	file	20.75 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
loaddata_autocom_innodb.test	file	98 B	root/root	-rw-r--r--	2021-01-05 10:19:59
loadxml.test	file	3.76 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
locale.test	file	3.22 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lock.test	file	14.81 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_multi.test	file	27.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_multi_bug38499.test	file	4.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_multi_bug38691.test	file	2.77 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_sync-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_sync.test	file	40.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_tables_lost_commit-master.opt	file	24 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lock_tables_lost_commit.test	file	845 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_empty_name.opt	file	43 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_empty_name.test	file	290 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_errchk.test	file	2.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
log_state-master.opt	file	59 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_state.test	file	9.97 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
log_state_bug33693-master.opt	file	60 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_state_bug33693.test	file	568 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_tables-big-master.opt	file	17 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_tables-big.test	file	1.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
log_tables-master.opt	file	41 B	root/root	-rw-r--r--	2021-01-05 10:19:59
log_tables.test	file	30.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
log_tables_debug.test	file	2.65 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
log_tables_upgrade.test	file	1002 B	root/root	-rw-r--r--	2021-01-05 10:19:59
long_tmpdir-master.opt	file	141 B	root/root	-rw-r--r--	2021-01-05 10:19:59
long_tmpdir-master.sh	file	190 B	root/root	-rwxr-xr-x	2021-01-05 10:19:59
long_tmpdir.test	file	215 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_fs_off.test	file	2.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_fs_on.test	file	1.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_mixed_tmpdir-master.opt	file	68 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_mixed_tmpdir-master.sh	file	179 B	root/root	-rwxr-xr-x	2021-01-05 10:19:59
lowercase_mixed_tmpdir.test	file	305 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_mixed_tmpdir_innodb-master.opt	file	68 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_mixed_tmpdir_innodb-master.sh	file	180 B	root/root	-rwxr-xr-x	2021-01-05 10:19:59
lowercase_mixed_tmpdir_innodb.test	file	299 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table-master.opt	file	25 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table.test	file	2.74 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table2.test	file	8.28 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table4-master.opt	file	27 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table4.test	file	3.14 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table_grant-master.opt	file	25 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table_grant.test	file	948 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table_qcache-master.opt	file	46 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_table_qcache.test	file	697 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_utf8-master.opt	file	58 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_utf8.test	file	206 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_view-master.opt	file	27 B	root/root	-rw-r--r--	2021-01-05 10:19:59
lowercase_view.test	file	6.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
main.lowercase_table_qcache-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mdl_sync-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mdl_sync.test	file	144.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
merge-big.test	file	3.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
merge.test	file	84.28 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
merge_innodb.test	file	1.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
merge_mmap-master.opt	file	18 B	root/root	-rw-r--r--	2021-01-05 10:19:59
merge_mmap.test	file	4.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
metadata.test	file	5.96 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mix2_myisam-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mix2_myisam.test	file	864 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mix2_myisam_ucs2.test	file	847 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_plugin_load-master.opt	file	92 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_plugin_load.test	file	412 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_plugin_load_add-master.opt	file	68 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_plugin_load_add.test	file	495 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_plugin_load_add2-master.opt	file	111 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_plugin_load_add2.test	file	495 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_statement-master.opt	file	80 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_statement.test	file	761 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update.test	file	24.38 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update2-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update2.test	file	1.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update_innodb.test	file	2.22 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update_tiny_hash-master.opt	file	28 B	root/root	-rw-r--r--	2021-01-05 10:19:59
multi_update_tiny_hash.test	file	1.6 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam-blob-master.opt	file	80 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam-blob.test	file	1.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam-system.test	file	593 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam.test	file	67.22 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_crash_before_flush_keys-master.opt	file	36 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_crash_before_flush_keys.test	file	1.49 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_debug.test	file	1.37 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_explain_json_non_select_all.test	file	825 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_explain_json_non_select_none.test	file	938 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_explain_non_select_all.test	file	696 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_explain_non_select_none.test	file	809 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_icp.test	file	612 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_icp_all.test	file	507 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_icp_none.test	file	644 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr.test	file	789 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr_all.test	file	675 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr_cost.test	file	799 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr_cost_all.test	file	674 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr_cost_icp.test	file	753 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr_icp.test	file	743 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_mrr_none.test	file	793 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_recover-master.opt	file	23 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_recover.test	file	5.61 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_row_rpl-master.opt	file	54 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_row_rpl-slave.opt	file	54 B	root/root	-rw-r--r--	2021-01-05 10:19:59
myisam_row_rpl.test	file	1.82 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
myisampack.test	file	12.31 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql-bug41486.test	file	1.54 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql-bug45236.test	file	1.41 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql.test	file	21.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_binary_mode.test	file	5.52 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_client_test-master.opt	file	150 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_client_test.test	file	1.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_client_test_embedded.cnf	file	156 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_client_test_embedded.test	file	677 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_client_test_qcache-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_client_test_qcache.test	file	858 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_comments.sql	file	4.58 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_comments.test	file	1.44 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_config_editor.test	file	7.44 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_cp932.test	file	1.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_delimiter.sql	file	1.48 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_delimiter_19799.sql	file	13 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_delimiter_source.sql	file	122 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_embedded-master.opt	file	98 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_embedded.test	file	481 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_embedded_client_test.test	file	1.34 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_locale_posix.test	file	6.97 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_not_windows.test	file	399 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_plugin-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_plugin.test	file	11.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_protocols.test	file	715 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_upgrade.test	file	7.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysql_upgrade_ssl.test	file	279 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqladmin.test	file	2.5 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqladmin_shutdown.test	file	868 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog-master.opt	file	39 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog.test	file	19.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog_debug.test	file	963 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog_mixed_or_statment.test	file	1.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog_raw_mode.test	file	1.98 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog_raw_mode_win.test	file	146 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlbinlog_row_big.test	file	4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlcheck.test	file	9.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqld--defaults-file.test	file	1.03 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqld--help-notwin.test	file	160 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqld--help-win.test	file	156 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump-compat.opt	file	31 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump-compat.test	file	446 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump-max-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump-max.test	file	40 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump-no-binlog-master.opt	file	15 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump-no-binlog.test	file	194 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump.test	file	86.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqldump_restore.test	file	3.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlhotcopy_archive.test	file	180 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlhotcopy_myisam.test	file	145 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlimport.test	file	689 B	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlshow.test	file	1.63 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqlslap.test	file	5.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
mysqltest.test	file	75.5 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
named_pipe-master.opt	file	26 B	root/root	-rw-r--r--	2021-01-05 10:19:59
named_pipe.test	file	597 B	root/root	-rw-r--r--	2021-01-05 10:19:59
negation_elimination.test	file	3.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
no-threads-master.opt	file	29 B	root/root	-rw-r--r--	2021-01-05 10:19:59
no-threads.test	file	373 B	root/root	-rw-r--r--	2021-01-05 10:19:59
no_binlog.test	file	165 B	root/root	-rw-r--r--	2021-01-05 10:19:59
not_embedded_server-master.opt	file	16 B	root/root	-rw-r--r--	2021-01-05 10:19:59
not_embedded_server.test	file	5.61 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
not_partition.test	file	3 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
null.test	file	8.55 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
null_key_all.test	file	477 B	root/root	-rw-r--r--	2021-01-05 10:19:59
null_key_icp.test	file	569 B	root/root	-rw-r--r--	2021-01-05 10:19:59
null_key_none.test	file	609 B	root/root	-rw-r--r--	2021-01-05 10:19:59
odbc.test	file	923 B	root/root	-rw-r--r--	2021-01-05 10:19:59
olap.test	file	13.63 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
openssl_1.test	file	9.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
optimizer_bug12837084.test	file	14.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
optimizer_debug_sync.test	file	2.23 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
optimizer_switch.test	file	10.28 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
order_by_all.test	file	497 B	root/root	-rw-r--r--	2021-01-05 10:19:59
order_by_icp_mrr.test	file	542 B	root/root	-rw-r--r--	2021-01-05 10:19:59
order_by_none.test	file	609 B	root/root	-rw-r--r--	2021-01-05 10:19:59
order_by_sortkey.test	file	2.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
order_fill_sortbuf-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
order_fill_sortbuf.test	file	578 B	root/root	-rw-r--r--	2021-01-05 10:19:59
outfile.test	file	4.03 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
outfile_loaddata.test	file	10.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
overflow.test	file	577 B	root/root	-rw-r--r--	2021-01-05 10:19:59
packet.test	file	3.49 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
parser.test	file	21.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
parser_bug21114_innodb.test	file	11.75 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
parser_not_embedded.test	file	2.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
parser_precedence.test	file	12.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
parser_stack.test	file	12.07 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition.test	file	66.34 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_archive.test	file	4.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_binlog.test	file	1.2 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_binlog_stmt.test	file	760 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_blackhole.test	file	634 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_bug18198.test	file	7.88 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_cache-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_cache.test	file	1.41 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_charset.test	file	675 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_column.test	file	16.15 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_column_prune.test	file	2.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_csv.test	file	2.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_datatype.test	file	18.97 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_debug_sync.test	file	3.99 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_disabled-master.opt	file	23 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_disabled.test	file	3.02 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_error.test	file	61.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_exchange.test	file	15.55 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_explicit_prune.test	file	30.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_federated.test	file	531 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_grant.test	file	2.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_hash.test	file	5.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_index_innodb.test	file	5.81 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_index_myisam.test	file	3.88 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_innodb.test	file	29.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_innodb_plugin.test	file	5 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_innodb_semi_consistent-master.opt	file	61 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_innodb_semi_consistent.test	file	4.09 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_innodb_stmt.test	file	1.17 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_innodb_tablespace.test	file	11.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_key_cache.test	file	10.82 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_list.test	file	8.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_locking.test	file	71.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_locking_4.test	file	1.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_mgm.test	file	3.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_mgm_err.test	file	6.18 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_mgm_err2.test	file	861 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_myisam.test	file	8.14 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_not_blackhole-master.opt	file	23 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_not_blackhole.test	file	875 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_not_windows-master.opt	file	19 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_not_windows.test	file	7.59 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_open_files_limit-master.opt	file	62 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_open_files_limit.test	file	1.61 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_order.test	file	17.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_pruning.test	file	57.82 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_range.test	file	31.14 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_rename_longfilename.test	file	2.02 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_symlink.test	file	7.35 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_sync.test	file	2.15 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_truncate.test	file	806 B	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_utf8.test	file	1.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
partition_windows.test	file	1.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
perror-win.test	file	915 B	root/root	-rw-r--r--	2021-01-05 10:19:59
perror.test	file	777 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin.test	file	7.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth.test	file	19.86 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa.test	file	14.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa_1-master.opt	file	35 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa_1.test	file	15.1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa_2-master.opt	file	55 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa_2.test	file	8.31 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa_3-master.opt	file	49 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_qa_3.test	file	1.51 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256-master.opt	file	170 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256.test	file	4.76 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_2-master.opt	file	217 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_2.test	file	2.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_server_default-master.opt	file	224 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_server_default.test	file	3.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_server_default_tls-master.opt	file	48 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_server_default_tls.test	file	3.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_auth_sha256_tls.test	file	2.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_load-master.opt	file	76 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_load.test	file	125 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_load_option-master.opt	file	85 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_load_option.test	file	265 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_not_embedded-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
plugin_not_embedded.test	file	896 B	root/root	-rw-r--r--	2021-01-05 10:19:59
preload.test	file	2.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
profiling.test	file	8.83 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps-master.opt	file	73 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ps.test	file	92.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_10nestset.test	file	2.75 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_11bugs.test	file	7.05 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_1general.test	file	28.22 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_2myisam.test	file	1.15 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_3innodb-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_3innodb.test	file	760 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_4heap.test	file	1.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_5merge.test	file	2.71 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_ddl.test	file	52.87 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_ddl1.test	file	11.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_grant.test	file	3.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ps_not_windows.test	file	755 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache.test	file	43.88 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_28249-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_28249.test	file	4.2 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_debug-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_debug.test	file	10.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_disabled-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_disabled.test	file	496 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_merge-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_merge.test	file	4.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_notembedded-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_notembedded.test	file	6.97 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_ps_no_prot-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_ps_no_prot.test	file	906 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_ps_ps_prot-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_ps_ps_prot.test	file	840 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_size_functionality.test	file	10.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_type_functionality.test	file	10.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_with_views-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
query_cache_with_views.test	file	3.98 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
range_all.test	file	490 B	root/root	-rw-r--r--	2021-01-05 10:19:59
range_icp.test	file	563 B	root/root	-rw-r--r--	2021-01-05 10:19:59
range_icp_mrr.test	file	536 B	root/root	-rw-r--r--	2021-01-05 10:19:59
range_mrr.test	file	561 B	root/root	-rw-r--r--	2021-01-05 10:19:59
range_mrr_cost.test	file	571 B	root/root	-rw-r--r--	2021-01-05 10:19:59
range_none.test	file	603 B	root/root	-rw-r--r--	2021-01-05 10:19:59
read_many_rows_innodb.test	file	417 B	root/root	-rw-r--r--	2021-01-05 10:19:59
read_only.test	file	8.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
read_only_innodb.test	file	5.38 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rename.test	file	2.26 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
renamedb.test	file	1.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
repair.test	file	5.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
replace.test	file	1.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rewrite_general_log.test	file	5.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rewrite_slow_log.test	file	3.23 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rollback.test	file	490 B	root/root	-rw-r--r--	2021-01-05 10:19:59
round.test	file	4.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
row.test	file	9.01 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rowid_order_innodb.test	file	382 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_mysqldump_slave.test	file	1.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
schema.test	file	4.68 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
secure_file_priv_win-master.opt	file	34 B	root/root	-rw-r--r--	2021-01-05 10:19:59
secure_file_priv_win.test	file	2.77 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
select_all.test	file	591 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_all_bka.test	file	268 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_all_bka_nixbnl.test	file	290 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_found.test	file	5.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
select_icp_mrr.test	file	637 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_icp_mrr_bka.test	file	276 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_icp_mrr_bka_nixbnl.test	file	298 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_none.test	file	704 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_none_bka.test	file	270 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_none_bka_nixbnl.test	file	292 B	root/root	-rw-r--r--	2021-01-05 10:19:59
select_safe.test	file	2.31 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
server_uuid.test	file	2.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
server_uuid_embedded.test	file	1.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
shm-master.opt	file	173 B	root/root	-rw-r--r--	2021-01-05 10:19:59
shm.test	file	1.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
show_check-master.opt	file	93 B	root/root	-rw-r--r--	2021-01-05 10:19:59
show_check.test	file	32.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
show_processlist.test	file	2.51 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
show_processlist_state.test	file	208 B	root/root	-rw-r--r--	2021-01-05 10:19:59
show_profile.test	file	495 B	root/root	-rw-r--r--	2021-01-05 10:19:59
signal.test	file	55.55 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
signal_code.test	file	854 B	root/root	-rw-r--r--	2021-01-05 10:19:59
signal_demo1.test	file	6.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
signal_demo2.test	file	3.34 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
signal_demo3-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
signal_demo3.test	file	2.67 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
signal_sqlmode.test	file	1.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
single_delete_update.test	file	13.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
skip_grants-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
skip_grants.test	file	2.74 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
skip_log_bin-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
skip_log_bin.test	file	645 B	root/root	-rw-r--r--	2021-01-05 10:19:59
skip_name_resolve-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
skip_name_resolve.test	file	1.56 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sort_buffer_size_functionality.test	file	9.2 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-big.test	file	2.15 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-bugs.test	file	5.3 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-code.test	file	20.71 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-destruct.test	file	8.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-dynamic.test	file	9.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-error.test	file	85.68 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-fib-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-fib.test	file	1.33 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-lock-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-lock.test	file	31.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-master.opt	file	54 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-no-code.test	file	216 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-prelocking-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-prelocking.test	file	8.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-security.test	file	25.06 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-threads.test	file	4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-ucs2.test	file	3.38 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp-vars.test	file	28.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp.test	file	191.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_debug.test	file	1.03 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_gis.test	file	754 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_notembedded-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_notembedded.test	file	13.09 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_stress_case.test	file	2.07 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_sync.test	file	4.88 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_trans.test	file	17.08 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_trans_log.test	file	1.35 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sp_validation.test	file	40.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sql_mode.test	file	12.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl-big.test	file	1.68 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl-sha512-master.opt	file	164 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl-sha512.test	file	371 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl.test	file	1.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_8k_key-master.opt	file	118 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_8k_key.test	file	546 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_and_innodb.test	file	261 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_ca-master.opt	file	160 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_ca.test	file	2.07 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_cipher-master.opt	file	24 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_cipher.test	file	588 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_compress.test	file	1.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_connect.test	file	339 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl-master.opt	file	218 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl.test	file	2.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl_clients-master.opt	file	234 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl_clients.test	file	1.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl_clients_valid-master.opt	file	218 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl_clients_valid.test	file	1.24 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl_crlpath-master.opt	file	206 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_crl_crlpath.test	file	1.4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_mode.test	file	1.78 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_mode_no_ssl-master.opt	file	11 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_mode_no_ssl.test	file	1.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_verify_identity-master.opt	file	181 B	root/root	-rw-r--r--	2021-01-05 10:19:59
ssl_verify_identity.test	file	4.04 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
status-master.opt	file	24 B	root/root	-rw-r--r--	2021-01-05 10:19:59
status.test	file	12.91 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
status2.test	file	1.54 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
status_bug17954.test	file	1.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
status_debug.test	file	1.42 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
strict-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
strict.test	file	43.22 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
strict_autoinc_1myisam.test	file	117 B	root/root	-rw-r--r--	2021-01-05 10:19:59
strict_autoinc_2innodb.test	file	152 B	root/root	-rw-r--r--	2021-01-05 10:19:59
strict_autoinc_3heap.test	file	117 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_all.test	file	496 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_all_bka.test	file	173 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_all_bka_nixbnl.test	file	195 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_bugs.test	file	1.7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_mat.test	file	576 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_mat_all.test	file	484 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_mat_none.test	file	617 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_nomat_nosj.test	file	564 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_nomat_nosj_bka.test	file	187 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_nomat_nosj_bka_nixbnl.test	file	209 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_none.test	file	609 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_none_bka.test	file	175 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_none_bka_nixbnl.test	file	197 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all.test	file	502 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all_bka-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all_bka.test	file	179 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all_bka_nixbnl-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all_bka_nixbnl.test	file	201 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all_bkaunique-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_all_bkaunique.test	file	252 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed.test	file	809 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed_bka-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed_bka.test	file	189 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed_bka_nixbnl-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed_bka_nixbnl.test	file	211 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed_bkaunique-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_dupsweed_bkaunique.test	file	262 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_firstmatch-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_firstmatch.test	file	2.36 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_firstmatch_bka-master.opt	file	22 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_firstmatch_bka.test	file	193 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_firstmatch_bka_nixbnl.test	file	215 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_firstmatch_bkaunique.test	file	266 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_all.test	file	550 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_all_bka.test	file	193 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_all_bka_nixbnl.test	file	215 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_all_bkaunique.test	file	266 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_none.test	file	663 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_none_bka.test	file	195 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_none_bka_nixbnl.test	file	217 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_innodb_none_bkaunique.test	file	268 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_loosescan.test	file	755 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_loosescan_bka.test	file	191 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_loosescan_bka_nixbnl.test	file	213 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_loosescan_bkaunique.test	file	264 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_mat.test	file	761 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_mat_bka.test	file	179 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_mat_bka_nixbnl.test	file	201 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_mat_bkaunique.test	file	252 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_mat_nosj.test	file	595 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_none.test	file	615 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_none_bka.test	file	181 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_none_bka_nixbnl.test	file	203 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subquery_sj_none_bkaunique.test	file	254 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subselect_debug.test	file	508 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subselect_gis.test	file	455 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subselect_innodb.test	file	24.35 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
subselect_notembedded-master.opt	file	33 B	root/root	-rw-r--r--	2021-01-05 10:19:59
subselect_notembedded.test	file	1.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sum_distinct-big.test	file	2 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sum_distinct.test	file	3.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
symlink.test	file	9.68 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
symlink_windows.test	file	2.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
synchronization.test	file	1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
sysdate_is_now-master.opt	file	17 B	root/root	-rw-r--r--	2021-01-05 10:19:59
sysdate_is_now.test	file	297 B	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db.test	file	452 B	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix30020-master.opt	file	30 B	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix40123-master.opt	file	30 B	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix40123.test	file	9.61 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix50030-master.opt	file	30 B	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix50030.test	file	14.11 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix50117-master.opt	file	30 B	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_fix50117.test	file	14.87 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
system_mysql_db_refs.test	file	3.29 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
table_definition_cache_functionality.test	file	8.56 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
table_open_cache_functionality.test	file	12.95 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
tablelock.test	file	1.37 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
tablespace.test	file	5.17 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
temp_pool-master.opt	file	31 B	root/root	-rw-r--r--	2021-01-05 10:19:59
temp_pool.test	file	1.05 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
temp_table-master.opt	file	32 B	root/root	-rw-r--r--	2021-01-05 10:19:59
temp_table.test	file	7.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
temporal_literal.test	file	6.05 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone-master.opt	file	15 B	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone.test	file	1.83 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone2.test	file	9.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone3-master.opt	file	49 B	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone3.test	file	2.54 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone4-master.opt	file	18 B	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone4.test	file	310 B	root/root	-rw-r--r--	2021-01-05 10:19:59
timezone_grant.test	file	4.51 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
trans_read_only-master.opt	file	29 B	root/root	-rw-r--r--	2021-01-05 10:19:59
trans_read_only.test	file	1.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
trigger-compat.test	file	8.38 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
trigger-trans.test	file	7 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
trigger.test	file	73.28 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
trigger_notembedded.test	file	24.73 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
truncate.test	file	3.36 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
truncate_coverage.test	file	5.58 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_binary.test	file	3.19 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_bit.test	file	12.96 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_bit_innodb.test	file	4.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_blob.test	file	22.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_date.test	file	13.89 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_datetime.test	file	21.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_decimal.test	file	29.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_enum.test	file	88.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_float.test	file	9.26 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_nchar.test	file	650 B	root/root	-rw-r--r--	2021-01-05 10:19:59
type_newdecimal-big.test	file	977 B	root/root	-rw-r--r--	2021-01-05 10:19:59
type_newdecimal.test	file	40.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_ranges.test	file	8.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_set.test	file	3.27 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_temporal_fractional.test	file	287.94 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_temporal_upgrade.test	file	3.51 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_time.test	file	11.61 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_timestamp-master.opt	file	36 B	root/root	-rw-r--r--	2021-01-05 10:19:59
type_timestamp.test	file	18.32 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_timestamp_explicit-master.opt	file	34 B	root/root	-rw-r--r--	2021-01-05 10:19:59
type_timestamp_explicit.test	file	1.97 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_uint.test	file	294 B	root/root	-rw-r--r--	2021-01-05 10:19:59
type_varchar.test	file	6.63 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
type_year.test	file	4.64 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
udf-master.opt	file	42 B	root/root	-rw-r--r--	2021-01-05 10:19:59
udf.test	file	15.87 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
udf_services-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
udf_services.test	file	765 B	root/root	-rw-r--r--	2021-01-05 10:19:59
udf_skip_grants-master.opt	file	41 B	root/root	-rw-r--r--	2021-01-05 10:19:59
udf_skip_grants.test	file	1.25 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
union-master.opt	file	49 B	root/root	-rw-r--r--	2021-01-05 10:19:59
union.test	file	41.49 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
unsafe_binlog_innodb-master.opt	file	67 B	root/root	-rw-r--r--	2021-01-05 10:19:59
unsafe_binlog_innodb.test	file	432 B	root/root	-rw-r--r--	2021-01-05 10:19:59
update.test	file	15.61 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
upgrade.test	file	5.09 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
user_limits.test	file	5.4 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
user_var-binlog.test	file	924 B	root/root	-rw-r--r--	2021-01-05 10:19:59
user_var.test	file	12.64 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
validate_password_plugin-master.opt	file	23 B	root/root	-rw-r--r--	2021-01-05 10:19:59
validate_password_plugin.test	file	11.44 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
varbinary.test	file	2.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
variables-big.test	file	1.93 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
variables-master.opt	file	21 B	root/root	-rw-r--r--	2021-01-05 10:19:59
variables-notembedded-master.opt	file	47 B	root/root	-rw-r--r--	2021-01-05 10:19:59
variables-notembedded.test	file	10.74 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
variables-win.test	file	393 B	root/root	-rw-r--r--	2021-01-05 10:19:59
variables.test	file	48.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
variables_community.test	file	241 B	root/root	-rw-r--r--	2021-01-05 10:19:59
variables_debug.test	file	2.75 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
view.test	file	114.56 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
view_alias.test	file	4.03 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
view_grant.test	file	63.28 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
wait_timeout.test	file	5.31 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
warnings-master.opt	file	34 B	root/root	-rw-r--r--	2021-01-05 10:19:59
warnings.test	file	5.53 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
warnings_engine_disabled.test	file	762 B	root/root	-rw-r--r--	2021-01-05 10:19:59
windows.test	file	2.21 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
wl4435_generated.inc	file	10.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6219-csv.test	file	109 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6219-innodb.test	file	112 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6219-memory.test	file	112 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6219-merge.test	file	111 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6219-myisam.test	file	112 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6219-upgrade.test	file	3.92 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6301_1_not_windows-master.opt	file	20 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6301_1_not_windows.test	file	455 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6301_2_not_windows-master.opt	file	43 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6301_2_not_windows.test	file	493 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6301_3-master.opt	file	52 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6301_3.test	file	903 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6443_deprecation-master.opt	file	23 B	root/root	-rw-r--r--	2021-01-05 10:19:59
wl6443_deprecation.test	file	3.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
xa.test	file	7.87 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
xml.test	file	24.9 KB	root/root	-rw-r--r--	2021-01-05 10:19:59