oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#### owner: jim.wjh
5
#### owner group: sql3
6
#### description: 测试position函数
7
--echo ================ expression position ================
8
select position(' ' in 'abc');
9
select position('abcd' in 'abc');
10
select position('abc' in 'abc');
11
select position('a' in 'abc');
12
select position('b' in 'abc');
13
select position('c' in 'abc');
14
select position('bc' in 'abc');
15
select position('bc' in 'abcbc');
16
select position('BC' in 'abcbc');
17
select position('bC' in 'abcbc');
18
select position('阿里' in '阿里巴巴');
19
select position('巴巴' in '阿里巴巴巴巴');
20
select position('阿里巴巴' in '阿里巴巴');
21
select position(true in '123');
22
select position(true in '23');
23
select position(23 in 123);
24
select position('' in 23);
25
select position('23' in 123);
26
select position(123.4 in '123.400000');
27
select position('123.400000' in 123.4);
28
select position('123.400000' in null);
29
select position(null in '巴巴');
30
select position('巴巴' in null);
31
select position(null in null);
32

33

34
select position(false in true);
35
select position(true in true);
36
select position(true in 123);
37
select position(false in 123);
38
select position(false in 0123);
39
select position(false in 1023);
40
select position(23 in 123);
41
select position(123456 in 123);
42
select position(123 in 123.4);
43
select position(123.4 in 1234);
44
select position(123 in null);
45
select position(null in 123);
46

47
--disable_warnings
48
drop table if exists test;
49
--enable_warnings
50
create table test(c1 datetime primary key);
51
sleep 5;
52
insert into test values('2015-5-5');
53
select position('201' in c1) from test;
54
select position('' in c1) from test;
55
select position('haha' in c1) from test;
56
select position('-5' in c1) from test;
57
select position('2015-5-5' in c1) from test;
58
select position(true in c1) from test;
59
select position(201 in c1) from test;
60
select position(201.1 in c1) from test;
61
select position(c1 in null) from test;
62
select position(null in c1) from test;
63
--disable_warnings
64
drop table if exists test;
65
--enable_warnings
66