63 lines
1.9 KiB
Plaintext
63 lines
1.9 KiB
Plaintext
--disable_query_log
|
|
set @@session.explicit_defaults_for_timestamp=off;
|
|
--enable_query_log
|
|
--echo ================ expression position ================
|
|
select position(' ' in 'abc');
|
|
select position('abcd' in 'abc');
|
|
select position('abc' in 'abc');
|
|
select position('a' in 'abc');
|
|
select position('b' in 'abc');
|
|
select position('c' in 'abc');
|
|
select position('bc' in 'abc');
|
|
select position('bc' in 'abcbc');
|
|
select position('BC' in 'abcbc');
|
|
select position('bC' in 'abcbc');
|
|
select position('阿里' in '阿里巴巴');
|
|
select position('巴巴' in '阿里巴巴巴巴');
|
|
select position('阿里巴巴' in '阿里巴巴');
|
|
select position(true in '123');
|
|
select position(true in '23');
|
|
select position(23 in 123);
|
|
select position('' in 23);
|
|
select position('23' in 123);
|
|
select position(123.4 in '123.400000');
|
|
select position('123.400000' in 123.4);
|
|
select position('123.400000' in null);
|
|
select position(null in '巴巴');
|
|
select position('巴巴' in null);
|
|
select position(null in null);
|
|
|
|
|
|
select position(false in true);
|
|
select position(true in true);
|
|
select position(true in 123);
|
|
select position(false in 123);
|
|
select position(false in 0123);
|
|
select position(false in 1023);
|
|
select position(23 in 123);
|
|
select position(123456 in 123);
|
|
select position(123 in 123.4);
|
|
select position(123.4 in 1234);
|
|
select position(123 in null);
|
|
select position(null in 123);
|
|
|
|
--disable_warnings
|
|
drop table if exists test;
|
|
--enable_warnings
|
|
create table test(c1 datetime primary key);
|
|
sleep 5;
|
|
insert into test values('2015-5-5');
|
|
select position('201' in c1) from test;
|
|
select position('' in c1) from test;
|
|
select position('haha' in c1) from test;
|
|
select position('-5' in c1) from test;
|
|
select position('2015-5-5' in c1) from test;
|
|
select position(true in c1) from test;
|
|
select position(201 in c1) from test;
|
|
select position(201.1 in c1) from test;
|
|
select position(c1 in null) from test;
|
|
select position(null in c1) from test;
|
|
--disable_warnings
|
|
drop table if exists test;
|
|
--enable_warnings
|