oceanbase

1
SELECT SUBSTRING_INDEX(NULL, NULL, NULL);
2
SUBSTRING_INDEX(NULL, NULL, NULL)
3
NULL
4
SELECT SUBSTRING_INDEX(NULL, NULL, 0);
5
SUBSTRING_INDEX(NULL, NULL, 0)
6
NULL
7
SELECT SUBSTRING_INDEX(NULL, NULL, 3);
8
SUBSTRING_INDEX(NULL, NULL, 3)
9
NULL
10
SELECT SUBSTRING_INDEX(NULL, NULL, -3);
11
SUBSTRING_INDEX(NULL, NULL, -3)
12
NULL
13
SELECT SUBSTRING_INDEX('abcdabcdabc', NULL, NULL);
14
SUBSTRING_INDEX('abcdabcdabc', NULL, NULL)
15
NULL
16
SELECT SUBSTRING_INDEX('abcdabcdabc', NULL, 0);
17
SUBSTRING_INDEX('abcdabcdabc', NULL, 0)
18
NULL
19
SELECT SUBSTRING_INDEX('abcdabcdabc', NULL, 3);
20
SUBSTRING_INDEX('abcdabcdabc', NULL, 3)
21
NULL
22
SELECT SUBSTRING_INDEX('abcdabcdabc', NULL, -3);
23
SUBSTRING_INDEX('abcdabcdabc', NULL, -3)
24
NULL
25
SELECT SUBSTRING_INDEX(NULL, 'abc', NULL);
26
SUBSTRING_INDEX(NULL, 'abc', NULL)
27
NULL
28
SELECT SUBSTRING_INDEX(NULL, 'abc', 0);
29
SUBSTRING_INDEX(NULL, 'abc', 0)
30
NULL
31
SELECT SUBSTRING_INDEX(NULL, 'abc', 3);
32
SUBSTRING_INDEX(NULL, 'abc', 3)
33
NULL
34
SELECT SUBSTRING_INDEX(NULL, 'abc', -3);
35
SUBSTRING_INDEX(NULL, 'abc', -3)
36
NULL
37
SELECT SUBSTRING_INDEX('', '', 0);
38
SUBSTRING_INDEX('', '', 0)
39

40
SELECT SUBSTRING_INDEX('', '', 3);
41
SUBSTRING_INDEX('', '', 3)
42

43
SELECT SUBSTRING_INDEX('', '', -3);
44
SUBSTRING_INDEX('', '', -3)
45

46
SELECT SUBSTRING_INDEX('abcdabcdabc', '', 0);
47
SUBSTRING_INDEX('abcdabcdabc', '', 0)
48

49
SELECT SUBSTRING_INDEX('abcdabcdabc', '', 3);
50
SUBSTRING_INDEX('abcdabcdabc', '', 3)
51

52
SELECT SUBSTRING_INDEX('abcdabcdabc', '', -3);
53
SUBSTRING_INDEX('abcdabcdabc', '', -3)
54

55
SELECT SUBSTRING_INDEX('', 'abc', 0);
56
SUBSTRING_INDEX('', 'abc', 0)
57

58
SELECT SUBSTRING_INDEX('', 'abc', 3);
59
SUBSTRING_INDEX('', 'abc', 3)
60

61
SELECT SUBSTRING_INDEX('', 'abc', -3);
62
SUBSTRING_INDEX('', 'abc', -3)
63

64
SELECT SUBSTRING_INDEX('abcdabcdabc', 'abc', 0);
65
SUBSTRING_INDEX('abcdabcdabc', 'abc', 0)
66

67
SELECT SUBSTRING_INDEX('abcdabcdabc', 'abc', 3);
68
SUBSTRING_INDEX('abcdabcdabc', 'abc', 3)
69
abcdabcd
70
SELECT SUBSTRING_INDEX('abcdabcdabc', 'abc', -3);
71
SUBSTRING_INDEX('abcdabcdabc', 'abc', -3)
72
dabcdabc
73
SELECT SUBSTRING_INDEX('abcdabcdabc', 'abc', '0');
74
SUBSTRING_INDEX('abcdabcdabc', 'abc', '0')
75

76
SELECT SUBSTRING_INDEX('abcdabcdabc', 'abc', '3');
77
SUBSTRING_INDEX('abcdabcdabc', 'abc', '3')
78
abcdabcd
79
SELECT SUBSTRING_INDEX('abcdabcdabc', 'abc', '-3');
80
SUBSTRING_INDEX('abcdabcdabc', 'abc', '-3')
81
dabcdabc
82
SELECT SUBSTRING_INDEX(1.414, 1, '-1');
83
SUBSTRING_INDEX(1.414, 1, '-1')
84
4
85
select SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775806);
86
SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775806)
87
www.mysql.com
88
select SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775807);
89
SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775807)
90
www.mysql.com
91
select SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775808);
92
SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775808)
93
www.mysql.com
94
select SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775809);
95
SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775809)
96
www.mysql.com
97
select SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775810);
98
SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775810)
99
www.mysql.com
100
select SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775811);
101
SUBSTRING_INDEX( 'www.mysql.com','.', 9223372036854775811)
102
www.mysql.com
103
select SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775806);
104
SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775806)
105
www.mysql.com
106
select SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775807);
107
SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775807)
108
www.mysql.com
109
select SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775808);
110
SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775808)
111
www.mysql.com
112
select SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775809);
113
SUBSTRING_INDEX( 'www.mysql.com','.', -9223372036854775809)
114
www.mysql.com
115
select substring_index('aaaaaaaaa1','aa',5);
116
substring_index('aaaaaaaaa1','aa',5)
117
aaaaaaaaa1
118
select substring_index('aaaaaaaaa1','aa',4);
119
substring_index('aaaaaaaaa1','aa',4)
120
aaaaaa
121
select substring_index('aaaaaaaaa1','aa',3);
122
substring_index('aaaaaaaaa1','aa',3)
123
aaaa
124
select substring_index('aaaaaaaaa1','aa',2);
125
substring_index('aaaaaaaaa1','aa',2)
126
aa
127
select substring_index('aaaaaaaaa1','aa',1);
128
substring_index('aaaaaaaaa1','aa',1)
129

130
select substring_index('aaaaaaaaa1','aa',0);
131
substring_index('aaaaaaaaa1','aa',0)
132

133
select substring_index('aaaaaaaaa1','aa',-1);
134
substring_index('aaaaaaaaa1','aa',-1)
135
1
136
select substring_index('aaaaaaaaa1','aa',-2);
137
substring_index('aaaaaaaaa1','aa',-2)
138
aa1
139
select substring_index('aaaaaaaaa1','aa',-3);
140
substring_index('aaaaaaaaa1','aa',-3)
141
aaaa1
142
select substring_index('aaaaaaaaa1','aa',-4);
143
substring_index('aaaaaaaaa1','aa',-4)
144
aaaaaa1
145
select substring_index('aaaaaaaaa1','aa',-5);
146
substring_index('aaaaaaaaa1','aa',-5)
147
aaaaaaaaa1
148
select substring_index('aaaaaaaaa1','aaaa',3);
149
substring_index('aaaaaaaaa1','aaaa',3)
150
aaaaaaaaa1
151
select substring_index('aaaaaaaaa1','aaaa',2);
152
substring_index('aaaaaaaaa1','aaaa',2)
153
aaaa
154
select substring_index('aaaaaaaaa1','aaaa',-1);
155
substring_index('aaaaaaaaa1','aaaa',-1)
156
1
157
select substring_index('aaaaaaaaa1','aaaa',0);
158
substring_index('aaaaaaaaa1','aaaa',0)
159

160
select substring_index('aaaaaaaaa1','aaaa',-1);
161
substring_index('aaaaaaaaa1','aaaa',-1)
162
1
163
select substring_index('aaaaaaaaa1','aaaa',-2);
164
substring_index('aaaaaaaaa1','aaaa',-2)
165
aaaa1
166
select substring_index('aaaaaaaaa1','aaaa',-3);
167
substring_index('aaaaaaaaa1','aaaa',-3)
168
aaaaaaaaa1
169