1select regexp_like('abc','abc') /* Result: y */;
2regexp_like('abc','abc')
31
4select regexp_like('xbc','abc') /* Result: n */;
5regexp_like('xbc','abc')
60
7select regexp_like('axc','abc') /* Result: n */;
8regexp_like('axc','abc')
90
10select regexp_like('abx','abc') /* Result: n */;
11regexp_like('abx','abc')
120
13select regexp_like('xabcy','abc') /* Result: y */;
14regexp_like('xabcy','abc')
151
16select regexp_like('ababc','abc') /* Result: y */;
17regexp_like('ababc','abc')
181
19select regexp_like('abc','ab*c') /* Result: y */;
20regexp_like('abc','ab*c')
211
22select regexp_like('abc','ab*bc') /* Result: y */;
23regexp_like('abc','ab*bc')
241
25select regexp_like('abbc','ab*bc') /* Result: y */;
26regexp_like('abbc','ab*bc')
271
28select regexp_like('abbbbc','ab*bc') /* Result: y */;
29regexp_like('abbbbc','ab*bc')
301
31select regexp_like('abbbbc','.{1}') /* Result: y */;
32regexp_like('abbbbc','.{1}')
331
34select regexp_like('abbbbc','.{3,4}') /* Result: y */;
35regexp_like('abbbbc','.{3,4}')
361
37select regexp_like('abbbbc','ab{0,}bc') /* Result: y */;
38regexp_like('abbbbc','ab{0,}bc')
391
40select regexp_like('abbc','ab+bc') /* Result: y */;
41regexp_like('abbc','ab+bc')
421
43select regexp_like('abc','ab+bc') /* Result: n */;
44regexp_like('abc','ab+bc')
450
46select regexp_like('abq','ab+bc') /* Result: n */;
47regexp_like('abq','ab+bc')
480
49select regexp_like('abq','ab{1,}bc') /* Result: n */;
50regexp_like('abq','ab{1,}bc')
510
52select regexp_like('abbbbc','ab+bc') /* Result: y */;
53regexp_like('abbbbc','ab+bc')
541
55select regexp_like('abbbbc','ab{1,}bc') /* Result: y */;
56regexp_like('abbbbc','ab{1,}bc')
571
58select regexp_like('abbbbc','ab{1,3}bc') /* Result: y */;
59regexp_like('abbbbc','ab{1,3}bc')
601
61select regexp_like('abbbbc','ab{3,4}bc') /* Result: y */;
62regexp_like('abbbbc','ab{3,4}bc')
631
64select regexp_like('abbbbc','ab{4,5}bc') /* Result: n */;
65regexp_like('abbbbc','ab{4,5}bc')
660
67select regexp_like('abbc','ab?bc') /* Result: y */;
68regexp_like('abbc','ab?bc')
691
70select regexp_like('abc','ab?bc') /* Result: y */;
71regexp_like('abc','ab?bc')
721
73select regexp_like('abc','ab{0,1}bc') /* Result: y */;
74regexp_like('abc','ab{0,1}bc')
751
76select regexp_like('abbbbc','ab?bc') /* Result: n */;
77regexp_like('abbbbc','ab?bc')
780
79select regexp_like('abc','ab?c') /* Result: y */;
80regexp_like('abc','ab?c')
811
82select regexp_like('abc','ab{0,1}c') /* Result: y */;
83regexp_like('abc','ab{0,1}c')
841
85select regexp_like('abc','^abc$') /* Result: y */;
86regexp_like('abc','^abc$')
871
88select regexp_like('abcc','^abc$') /* Result: n */;
89regexp_like('abcc','^abc$')
900
91select regexp_like('abcc','^abc') /* Result: y */;
92regexp_like('abcc','^abc')
931
94select regexp_like('aabc','^abc$') /* Result: n */;
95regexp_like('aabc','^abc$')
960
97select regexp_like('aabc','abc$') /* Result: y */;
98regexp_like('aabc','abc$')
991
100select regexp_like('aabcd','abc$') /* Result: n */;
101regexp_like('aabcd','abc$')
1020
103select regexp_like('abc','^') /* Result: y */;
104regexp_like('abc','^')
1051
106select regexp_like('abc','$') /* Result: y */;
107regexp_like('abc','$')
1081
109select regexp_like('abc','a.c') /* Result: y */;
110regexp_like('abc','a.c')
1111
112select regexp_like('axc','a.c') /* Result: y */;
113regexp_like('axc','a.c')
1141
115select regexp_like('axyzc','a.*c') /* Result: y */;
116regexp_like('axyzc','a.*c')
1171
118select regexp_like('axyzd','a.*c') /* Result: n */;
119regexp_like('axyzd','a.*c')
1200
121select regexp_like('abc','a[bc]d') /* Result: n */;
122regexp_like('abc','a[bc]d')
1230
124select regexp_like('abd','a[bc]d') /* Result: y */;
125regexp_like('abd','a[bc]d')
1261
127select regexp_like('abd','a[b-d]e') /* Result: n */;
128regexp_like('abd','a[b-d]e')
1290
130select regexp_like('ace','a[b-d]e') /* Result: y */;
131regexp_like('ace','a[b-d]e')
1321
133select regexp_like('aac','a[b-d]') /* Result: y */;
134regexp_like('aac','a[b-d]')
1351
136select regexp_like('a-','a[-b]') /* Result: y */;
137regexp_like('a-','a[-b]')
1381
139select regexp_like('a-','a[b-]') /* Result: y */;
140regexp_like('a-','a[b-]')
1411
142select regexp_like('-','a[b-a]') /* Result: c */;
143ERROR HY000: The regular expression contains an [x-y] character range where x comes after y.
144select regexp_like('-','a[]b') /* Result: ci */;
145ERROR HY000: The regular expression contains an unclosed bracket expression.
146select regexp_like('-','a[') /* Result: c */;
147ERROR HY000: The regular expression contains an unclosed bracket expression.
148select regexp_like('a]','a]') /* Result: y */;
149regexp_like('a]','a]')
1501
151select regexp_like('a]b','a[]]b') /* Result: y */;
152regexp_like('a]b','a[]]b')
1531
154select regexp_like('aed','a[^bc]d') /* Result: y */;
155regexp_like('aed','a[^bc]d')
1561
157select regexp_like('abd','a[^bc]d') /* Result: n */;
158regexp_like('abd','a[^bc]d')
1590
160select regexp_like('adc','a[^-b]c') /* Result: y */;
161regexp_like('adc','a[^-b]c')
1621
163select regexp_like('a-c','a[^-b]c') /* Result: n */;
164regexp_like('a-c','a[^-b]c')
1650
166select regexp_like('a]c','a[^]b]c') /* Result: n */;
167regexp_like('a]c','a[^]b]c')
1680
169select regexp_like('adc','a[^]b]c') /* Result: y */;
170regexp_like('adc','a[^]b]c')
1711
172select regexp_like('a-','\\ba\\b') /* Result: y */;
173regexp_like('a-','\\ba\\b')
1741
175select regexp_like('-a','\\ba\\b') /* Result: y */;
176regexp_like('-a','\\ba\\b')
1771
178select regexp_like('-a-','\\ba\\b') /* Result: y */;
179regexp_like('-a-','\\ba\\b')
1801
181select regexp_like('xy','\\by\\b') /* Result: n */;
182regexp_like('xy','\\by\\b')
1830
184select regexp_like('yz','\\by\\b') /* Result: n */;
185regexp_like('yz','\\by\\b')
1860
187select regexp_like('xyz','\\by\\b') /* Result: n */;
188regexp_like('xyz','\\by\\b')
1890
190select regexp_like('a-','\\Ba\\B') /* Result: n */;
191regexp_like('a-','\\Ba\\B')
1920
193select regexp_like('-a','\\Ba\\B') /* Result: n */;
194regexp_like('-a','\\Ba\\B')
1950
196select regexp_like('-a-','\\Ba\\B') /* Result: n */;
197regexp_like('-a-','\\Ba\\B')
1980
199select regexp_like('xy','\\By\\b') /* Result: y */;
200regexp_like('xy','\\By\\b')
2011
202select regexp_like('yz','\\by\\B') /* Result: y */;
203regexp_like('yz','\\by\\B')
2041
205select regexp_like('xyz','\\By\\B') /* Result: y */;
206regexp_like('xyz','\\By\\B')
2071
208select regexp_like('a','\\w') /* Result: y */;
209regexp_like('a','\\w')
2101
211select regexp_like('-','\\w') /* Result: n */;
212regexp_like('-','\\w')
2130
214select regexp_like('a','\\W') /* Result: n */;
215regexp_like('a','\\W')
2160
217select regexp_like('-','\\W') /* Result: y */;
218regexp_like('-','\\W')
2191
220select regexp_like('a b','a\\sb') /* Result: y */;
221regexp_like('a b','a\\sb')
2221
223select regexp_like('a-b','a\\sb') /* Result: n */;
224regexp_like('a-b','a\\sb')
2250
226select regexp_like('a b','a\\Sb') /* Result: n */;
227regexp_like('a b','a\\Sb')
2280
229select regexp_like('a-b','a\\Sb') /* Result: y */;
230regexp_like('a-b','a\\Sb')
2311
232select regexp_like('1','\\d') /* Result: y */;
233regexp_like('1','\\d')
2341
235select regexp_like('-','\\d') /* Result: n */;
236regexp_like('-','\\d')
2370
238select regexp_like('1','\\D') /* Result: n */;
239regexp_like('1','\\D')
2400
241select regexp_like('-','\\D') /* Result: y */;
242regexp_like('-','\\D')
2431
244select regexp_like('a','[\\w]') /* Result: y */;
245regexp_like('a','[\\w]')
2461
247select regexp_like('-','[\\w]') /* Result: n */;
248regexp_like('-','[\\w]')
2490
250select regexp_like('a','[\\W]') /* Result: n */;
251regexp_like('a','[\\W]')
2520
253select regexp_like('-','[\\W]') /* Result: y */;
254regexp_like('-','[\\W]')
2551
256select regexp_like('a b','a[\\s]b') /* Result: y */;
257regexp_like('a b','a[\\s]b')
2581
259select regexp_like('a-b','a[\\s]b') /* Result: n */;
260regexp_like('a-b','a[\\s]b')
2610
262select regexp_like('a b','a[\\S]b') /* Result: n */;
263regexp_like('a b','a[\\S]b')
2640
265select regexp_like('a-b','a[\\S]b') /* Result: y */;
266regexp_like('a-b','a[\\S]b')
2671
268select regexp_like('1','[\\d]') /* Result: y */;
269regexp_like('1','[\\d]')
2701
271select regexp_like('-','[\\d]') /* Result: n */;
272regexp_like('-','[\\d]')
2730
274select regexp_like('1','[\\D]') /* Result: n */;
275regexp_like('1','[\\D]')
2760
277select regexp_like('-','[\\D]') /* Result: y */;
278regexp_like('-','[\\D]')
2791
280select regexp_like('abc','ab|cd') /* Result: y */;
281regexp_like('abc','ab|cd')
2821
283select regexp_like('abcd','ab|cd') /* Result: y */;
284regexp_like('abcd','ab|cd')
2851
286select regexp_like('def','()ef') /* Result: y */;
287regexp_like('def','()ef')
2881
289select regexp_like('-','*a') /* Result: c */;
290ERROR HY000: Syntax error in regular expression on line 1, character 1.
291select regexp_like('-','(*)b') /* Result: c */;
292ERROR HY000: Syntax error in regular expression on line 1, character 2.
293select regexp_like('b','$b') /* Result: n */;
294regexp_like('b','$b')
2950
296select regexp_like('-','a\\') /* Result: c */;
297ERROR HY000: Unrecognized escape sequence in regular expression.
298select regexp_like('a(b','a\\(b') /* Result: y */;
299regexp_like('a(b','a\\(b')
3001
301select regexp_like('ab','a\\(*b') /* Result: y */;
302regexp_like('ab','a\\(*b')
3031
304select regexp_like('a((b','a\\(*b') /* Result: y */;
305regexp_like('a((b','a\\(*b')
3061
307select regexp_like('a\\b','a\\\\b') /* Result: y */;
308regexp_like('a\\b','a\\\\b')
3091
310select regexp_like('-','abc)') /* Result: c */;
311ERROR HY000: Mismatched parenthesis in regular expression.
312select regexp_like('-','(abc') /* Result: c */;
313ERROR HY000: Mismatched parenthesis in regular expression.
314select regexp_like('abc','((a))') /* Result: y */;
315regexp_like('abc','((a))')
3161
317select regexp_like('abc','(a)b(c)') /* Result: y */;
318regexp_like('abc','(a)b(c)')
3191
320select regexp_like('aabbabc','a+b+c') /* Result: y */;
321regexp_like('aabbabc','a+b+c')
3221
323select regexp_like('aabbabc','a{1,}b{1,}c') /* Result: y */;
324regexp_like('aabbabc','a{1,}b{1,}c')
3251
326select regexp_like('-','a**') /* Result: c */;
327ERROR HY000: Syntax error in regular expression on line 1, character 3.
328select regexp_like('abcabc','a.+?c') /* Result: y */;
329regexp_like('abcabc','a.+?c')
3301
331select regexp_like('ab','(a+|b)*') /* Result: y */;
332regexp_like('ab','(a+|b)*')
3331
334select regexp_like('ab','(a+|b){0,}') /* Result: y */;
335regexp_like('ab','(a+|b){0,}')
3361
337select regexp_like('ab','(a+|b)+') /* Result: y */;
338regexp_like('ab','(a+|b)+')
3391
340select regexp_like('ab','(a+|b){1,}') /* Result: y */;
341regexp_like('ab','(a+|b){1,}')
3421
343select regexp_like('ab','(a+|b)?') /* Result: y */;
344regexp_like('ab','(a+|b)?')
3451
346select regexp_like('ab','(a+|b){0,1}') /* Result: y */;
347regexp_like('ab','(a+|b){0,1}')
3481
349select regexp_like('-',')(') /* Result: c */;
350ERROR HY000: Mismatched parenthesis in regular expression.
351select regexp_like('cde','[^ab]*') /* Result: y */;
352regexp_like('cde','[^ab]*')
3531
354select regexp_like('','abc') /* Result: n */;
355regexp_like('','abc')
3560
357select regexp_like('','a*') /* Result: y */;
358regexp_like('','a*')
3591
360select regexp_like('abbbcd','([abc])*d') /* Result: y */;
361regexp_like('abbbcd','([abc])*d')
3621
363select regexp_like('abcd','([abc])*bcd') /* Result: y */;
364regexp_like('abcd','([abc])*bcd')
3651
366select regexp_like('e','a|b|c|d|e') /* Result: y */;
367regexp_like('e','a|b|c|d|e')
3681
369select regexp_like('ef','(a|b|c|d|e)f') /* Result: y */;
370regexp_like('ef','(a|b|c|d|e)f')
3711
372select regexp_like('abcdefg','abcd*efg') /* Result: y */;
373regexp_like('abcdefg','abcd*efg')
3741
375select regexp_like('xabyabbbz','ab*') /* Result: y */;
376regexp_like('xabyabbbz','ab*')
3771
378select regexp_like('xayabbbz','ab*') /* Result: y */;
379regexp_like('xayabbbz','ab*')
3801
381select regexp_like('abcde','(ab|cd)e') /* Result: y */;
382regexp_like('abcde','(ab|cd)e')
3831
384select regexp_like('hij','[abhgefdc]ij') /* Result: y */;
385regexp_like('hij','[abhgefdc]ij')
3861
387select regexp_like('abcde','^(ab|cd)e') /* Result: n */;
388regexp_like('abcde','^(ab|cd)e')
3890
390select regexp_like('abcdef','(abc|)ef') /* Result: y */;
391regexp_like('abcdef','(abc|)ef')
3921
393select regexp_like('abcd','(a|b)c*d') /* Result: y */;
394regexp_like('abcd','(a|b)c*d')
3951
396select regexp_like('abc','(ab|ab*)bc') /* Result: y */;
397regexp_like('abc','(ab|ab*)bc')
3981
399select regexp_like('abc','a([bc]*)c*') /* Result: y */;
400regexp_like('abc','a([bc]*)c*')
4011
402select regexp_like('abcd','a([bc]*)(c*d)') /* Result: y */;
403regexp_like('abcd','a([bc]*)(c*d)')
4041
405select regexp_like('abcd','a([bc]+)(c*d)') /* Result: y */;
406regexp_like('abcd','a([bc]+)(c*d)')
4071
408select regexp_like('abcd','a([bc]*)(c+d)') /* Result: y */;
409regexp_like('abcd','a([bc]*)(c+d)')
4101
411select regexp_like('adcdcde','a[bcd]*dcdcde') /* Result: y */;
412regexp_like('adcdcde','a[bcd]*dcdcde')
4131
414select regexp_like('adcdcde','a[bcd]+dcdcde') /* Result: n */;
415regexp_like('adcdcde','a[bcd]+dcdcde')
4160
417select regexp_like('abc','(ab|a)b*c') /* Result: y */;
418regexp_like('abc','(ab|a)b*c')
4191
420select regexp_like('abcd','((a)(b)c)(d)') /* Result: y */;
421regexp_like('abcd','((a)(b)c)(d)')
4221
423select regexp_like('alpha','[a-zA-Z_][a-zA-Z0-9_]*') /* Result: y */;
424regexp_like('alpha','[a-zA-Z_][a-zA-Z0-9_]*')
4251
426select regexp_like('abh','^a(bc+|b[eh])g|.h$') /* Result: y */;
427regexp_like('abh','^a(bc+|b[eh])g|.h$')
4281
429select regexp_like('effgz','(bc+d$|ef*g.|h?i(j|k))') /* Result: y */;
430regexp_like('effgz','(bc+d$|ef*g.|h?i(j|k))')
4311
432select regexp_like('ij','(bc+d$|ef*g.|h?i(j|k))') /* Result: y */;
433regexp_like('ij','(bc+d$|ef*g.|h?i(j|k))')
4341
435select regexp_like('effg','(bc+d$|ef*g.|h?i(j|k))') /* Result: n */;
436regexp_like('effg','(bc+d$|ef*g.|h?i(j|k))')
4370
438select regexp_like('bcdd','(bc+d$|ef*g.|h?i(j|k))') /* Result: n */;
439regexp_like('bcdd','(bc+d$|ef*g.|h?i(j|k))')
4400
441select regexp_like('reffgz','(bc+d$|ef*g.|h?i(j|k))') /* Result: y */;
442regexp_like('reffgz','(bc+d$|ef*g.|h?i(j|k))')
4431
444select regexp_like('a','((((((((((a))))))))))') /* Result: y */;
445regexp_like('a','((((((((((a))))))))))')
4461
447select regexp_like('aa','((((((((((a))))))))))\\10') /* Result: y */;
448regexp_like('aa','((((((((((a))))))))))\\10')
4491
450select regexp_like('a','(((((((((a)))))))))') /* Result: y */;
451regexp_like('a','(((((((((a)))))))))')
4521
453select regexp_like('uh-uh','multiple words of text') /* Result: n */;
454regexp_like('uh-uh','multiple words of text')
4550
456select regexp_like('multiple words, yeah','multiple words') /* Result: y */;
457regexp_like('multiple words, yeah','multiple words')
4581
459select regexp_like('abcde','(.*)c(.*)') /* Result: y */;
460regexp_like('abcde','(.*)c(.*)')
4611
462select regexp_like('(a, b)','\\((.*), (.*)\\)') /* Result: y */;
463regexp_like('(a, b)','\\((.*), (.*)\\)')
4641
465select regexp_like('ab','[k]') /* Result: n */;
466regexp_like('ab','[k]')
4670
468select regexp_like('abcd','abcd') /* Result: y */;
469regexp_like('abcd','abcd')
4701
471select regexp_like('abcd','a(bc)d') /* Result: y */;
472regexp_like('abcd','a(bc)d')
4731
474select regexp_like('ac','a[-]?c') /* Result: y */;
475regexp_like('ac','a[-]?c')
4761
477select regexp_like('abcabc','(abc)\\1') /* Result: y */;
478regexp_like('abcabc','(abc)\\1')
4791
480select regexp_like('abcabc','([a-c]*)\\1') /* Result: y */;
481regexp_like('abcabc','([a-c]*)\\1')
4821
483select regexp_like('-','\\1') /* Result: c */;
484ERROR HY000: Invalid back-reference in regular expression.
485select regexp_like('-','\\2') /* Result: c */;
486ERROR HY000: Invalid back-reference in regular expression.
487select regexp_like('a','(a)|\\1') /* Result: y */;
488regexp_like('a','(a)|\\1')
4891
490select regexp_like('x','(a)|\\1') /* Result: n */;
491regexp_like('x','(a)|\\1')
4920
493select regexp_like('-','(a)|\\2') /* Result: c */;
494ERROR HY000: Invalid back-reference in regular expression.
495select regexp_like('ababbbcbc','(([a-c])b*?\\2)*') /* Result: y */;
496regexp_like('ababbbcbc','(([a-c])b*?\\2)*')
4971
498select regexp_like('ababbbcbc','(([a-c])b*?\\2){3}') /* Result: y */;
499regexp_like('ababbbcbc','(([a-c])b*?\\2){3}')
5001
501select regexp_like('aaxabxbaxbbx','((\\3|b)\\2(a)x)+') /* Result: n */;
502regexp_like('aaxabxbaxbbx','((\\3|b)\\2(a)x)+')
5030
504select regexp_like('aaaxabaxbaaxbbax','((\\3|b)\\2(a)x)+') /* Result: y */;
505regexp_like('aaaxabaxbaaxbbax','((\\3|b)\\2(a)x)+')
5061
507select regexp_like('bbaababbabaaaaabbaaaabba','((\\3|b)\\2(a)){2,}') /* Result: y */;
508regexp_like('bbaababbabaaaaabbaaaabba','((\\3|b)\\2(a)){2,}')
5091
510select regexp_like('b','(a)|(b)') /* Result: y */;
511regexp_like('b','(a)|(b)')
5121
513select regexp_like('ABC','(?i)abc') /* Result: y */;
514regexp_like('ABC','(?i)abc')
5151
516select regexp_like('XBC','(?i)abc') /* Result: n */;
517regexp_like('XBC','(?i)abc')
5180
519select regexp_like('AXC','(?i)abc') /* Result: n */;
520regexp_like('AXC','(?i)abc')
5210
522select regexp_like('ABX','(?i)abc') /* Result: n */;
523regexp_like('ABX','(?i)abc')
5240
525select regexp_like('XABCY','(?i)abc') /* Result: y */;
526regexp_like('XABCY','(?i)abc')
5271
528select regexp_like('ABABC','(?i)abc') /* Result: y */;
529regexp_like('ABABC','(?i)abc')
5301
531select regexp_like('ABC','(?i)ab*c') /* Result: y */;
532regexp_like('ABC','(?i)ab*c')
5331
534select regexp_like('ABC','(?i)ab*bc') /* Result: y */;
535regexp_like('ABC','(?i)ab*bc')
5361
537select regexp_like('ABBC','(?i)ab*bc') /* Result: y */;
538regexp_like('ABBC','(?i)ab*bc')
5391
540select regexp_like('ABBBBC','(?i)ab*?bc') /* Result: y */;
541regexp_like('ABBBBC','(?i)ab*?bc')
5421
543select regexp_like('ABBBBC','(?i)ab{0,}?bc') /* Result: y */;
544regexp_like('ABBBBC','(?i)ab{0,}?bc')
5451
546select regexp_like('ABBC','(?i)ab+?bc') /* Result: y */;
547regexp_like('ABBC','(?i)ab+?bc')
5481
549select regexp_like('ABC','(?i)ab+bc') /* Result: n */;
550regexp_like('ABC','(?i)ab+bc')
5510
552select regexp_like('ABQ','(?i)ab+bc') /* Result: n */;
553regexp_like('ABQ','(?i)ab+bc')
5540
555select regexp_like('ABQ','(?i)ab{1,}bc') /* Result: n */;
556regexp_like('ABQ','(?i)ab{1,}bc')
5570
558select regexp_like('ABBBBC','(?i)ab+bc') /* Result: y */;
559regexp_like('ABBBBC','(?i)ab+bc')
5601
561select regexp_like('ABBBBC','(?i)ab{1,}?bc') /* Result: y */;
562regexp_like('ABBBBC','(?i)ab{1,}?bc')
5631
564select regexp_like('ABBBBC','(?i)ab{1,3}?bc') /* Result: y */;
565regexp_like('ABBBBC','(?i)ab{1,3}?bc')
5661
567select regexp_like('ABBBBC','(?i)ab{3,4}?bc') /* Result: y */;
568regexp_like('ABBBBC','(?i)ab{3,4}?bc')
5691
570select regexp_like('ABBBBC','(?i)ab{4,5}?bc') /* Result: n */;
571regexp_like('ABBBBC','(?i)ab{4,5}?bc')
5720
573select regexp_like('ABBC','(?i)ab??bc') /* Result: y */;
574regexp_like('ABBC','(?i)ab??bc')
5751
576select regexp_like('ABC','(?i)ab??bc') /* Result: y */;
577regexp_like('ABC','(?i)ab??bc')
5781
579select regexp_like('ABC','(?i)ab{0,1}?bc') /* Result: y */;
580regexp_like('ABC','(?i)ab{0,1}?bc')
5811
582select regexp_like('ABBBBC','(?i)ab??bc') /* Result: n */;
583regexp_like('ABBBBC','(?i)ab??bc')
5840
585select regexp_like('ABC','(?i)ab??c') /* Result: y */;
586regexp_like('ABC','(?i)ab??c')
5871
588select regexp_like('ABC','(?i)ab{0,1}?c') /* Result: y */;
589regexp_like('ABC','(?i)ab{0,1}?c')
5901
591select regexp_like('ABC','(?i)^abc$') /* Result: y */;
592regexp_like('ABC','(?i)^abc$')
5931
594select regexp_like('ABCC','(?i)^abc$') /* Result: n */;
595regexp_like('ABCC','(?i)^abc$')
5960
597select regexp_like('ABCC','(?i)^abc') /* Result: y */;
598regexp_like('ABCC','(?i)^abc')
5991
600select regexp_like('AABC','(?i)^abc$') /* Result: n */;
601regexp_like('AABC','(?i)^abc$')
6020
603select regexp_like('AABC','(?i)abc$') /* Result: y */;
604regexp_like('AABC','(?i)abc$')
6051
606select regexp_like('ABC','(?i)^') /* Result: y */;
607regexp_like('ABC','(?i)^')
6081
609select regexp_like('ABC','(?i)$') /* Result: y */;
610regexp_like('ABC','(?i)$')
6111
612select regexp_like('ABC','(?i)a.c') /* Result: y */;
613regexp_like('ABC','(?i)a.c')
6141
615select regexp_like('AXC','(?i)a.c') /* Result: y */;
616regexp_like('AXC','(?i)a.c')
6171
618select regexp_like('AXYZC','(?i)a.*?c') /* Result: y */;
619regexp_like('AXYZC','(?i)a.*?c')
6201
621select regexp_like('AXYZD','(?i)a.*c') /* Result: n */;
622regexp_like('AXYZD','(?i)a.*c')
6230
624select regexp_like('ABC','(?i)a[bc]d') /* Result: n */;
625regexp_like('ABC','(?i)a[bc]d')
6260
627select regexp_like('ABD','(?i)a[bc]d') /* Result: y */;
628regexp_like('ABD','(?i)a[bc]d')
6291
630select regexp_like('ABD','(?i)a[b-d]e') /* Result: n */;
631regexp_like('ABD','(?i)a[b-d]e')
6320
633select regexp_like('ACE','(?i)a[b-d]e') /* Result: y */;
634regexp_like('ACE','(?i)a[b-d]e')
6351
636select regexp_like('AAC','(?i)a[b-d]') /* Result: y */;
637regexp_like('AAC','(?i)a[b-d]')
6381
639select regexp_like('A-','(?i)a[-b]') /* Result: y */;
640regexp_like('A-','(?i)a[-b]')
6411
642select regexp_like('A-','(?i)a[b-]') /* Result: y */;
643regexp_like('A-','(?i)a[b-]')
6441
645select regexp_like('-','(?i)a[b-a]') /* Result: c */;
646ERROR HY000: The regular expression contains an [x-y] character range where x comes after y.
647select regexp_like('-','(?i)a[]b') /* Result: ci */;
648ERROR HY000: The regular expression contains an unclosed bracket expression.
649select regexp_like('-','(?i)a[') /* Result: c */;
650ERROR HY000: The regular expression contains an unclosed bracket expression.
651select regexp_like('A]','(?i)a]') /* Result: y */;
652regexp_like('A]','(?i)a]')
6531
654select regexp_like('A]B','(?i)a[]]b') /* Result: y */;
655regexp_like('A]B','(?i)a[]]b')
6561
657select regexp_like('AED','(?i)a[^bc]d') /* Result: y */;
658regexp_like('AED','(?i)a[^bc]d')
6591
660select regexp_like('ABD','(?i)a[^bc]d') /* Result: n */;
661regexp_like('ABD','(?i)a[^bc]d')
6620
663select regexp_like('ADC','(?i)a[^-b]c') /* Result: y */;
664regexp_like('ADC','(?i)a[^-b]c')
6651
666select regexp_like('A-C','(?i)a[^-b]c') /* Result: n */;
667regexp_like('A-C','(?i)a[^-b]c')
6680
669select regexp_like('A]C','(?i)a[^]b]c') /* Result: n */;
670regexp_like('A]C','(?i)a[^]b]c')
6710
672select regexp_like('ADC','(?i)a[^]b]c') /* Result: y */;
673regexp_like('ADC','(?i)a[^]b]c')
6741
675select regexp_like('ABC','(?i)ab|cd') /* Result: y */;
676regexp_like('ABC','(?i)ab|cd')
6771
678select regexp_like('ABCD','(?i)ab|cd') /* Result: y */;
679regexp_like('ABCD','(?i)ab|cd')
6801
681select regexp_like('DEF','(?i)()ef') /* Result: y */;
682regexp_like('DEF','(?i)()ef')
6831
684select regexp_like('-','(?i)*a') /* Result: c */;
685ERROR HY000: Syntax error in regular expression on line 1, character 5.
686select regexp_like('-','(?i)(*)b') /* Result: c */;
687ERROR HY000: Syntax error in regular expression on line 1, character 6.
688select regexp_like('B','(?i)$b') /* Result: n */;
689regexp_like('B','(?i)$b')
6900
691select regexp_like('-','(?i)a\\') /* Result: c */;
692ERROR HY000: Unrecognized escape sequence in regular expression.
693select regexp_like('A(B','(?i)a\\(b') /* Result: y */;
694regexp_like('A(B','(?i)a\\(b')
6951
696select regexp_like('AB','(?i)a\\(*b') /* Result: y */;
697regexp_like('AB','(?i)a\\(*b')
6981
699select regexp_like('A((B','(?i)a\\(*b') /* Result: y */;
700regexp_like('A((B','(?i)a\\(*b')
7011
702select regexp_like('A\\B','(?i)a\\\\b') /* Result: y */;
703regexp_like('A\\B','(?i)a\\\\b')
7041
705select regexp_like('-','(?i)abc)') /* Result: c */;
706ERROR HY000: Mismatched parenthesis in regular expression.
707select regexp_like('-','(?i)(abc') /* Result: c */;
708ERROR HY000: Mismatched parenthesis in regular expression.
709select regexp_like('ABC','(?i)((a))') /* Result: y */;
710regexp_like('ABC','(?i)((a))')
7111
712select regexp_like('ABC','(?i)(a)b(c)') /* Result: y */;
713regexp_like('ABC','(?i)(a)b(c)')
7141
715select regexp_like('AABBABC','(?i)a+b+c') /* Result: y */;
716regexp_like('AABBABC','(?i)a+b+c')
7171
718select regexp_like('AABBABC','(?i)a{1,}b{1,}c') /* Result: y */;
719regexp_like('AABBABC','(?i)a{1,}b{1,}c')
7201
721select regexp_like('-','(?i)a**') /* Result: c */;
722ERROR HY000: Syntax error in regular expression on line 1, character 7.
723select regexp_like('ABCABC','(?i)a.+?c') /* Result: y */;
724regexp_like('ABCABC','(?i)a.+?c')
7251
726select regexp_like('ABCABC','(?i)a.*?c') /* Result: y */;
727regexp_like('ABCABC','(?i)a.*?c')
7281
729select regexp_like('ABCABC','(?i)a.{0,5}?c') /* Result: y */;
730regexp_like('ABCABC','(?i)a.{0,5}?c')
7311
732select regexp_like('AB','(?i)(a+|b)*') /* Result: y */;
733regexp_like('AB','(?i)(a+|b)*')
7341
735select regexp_like('AB','(?i)(a+|b){0,}') /* Result: y */;
736regexp_like('AB','(?i)(a+|b){0,}')
7371
738select regexp_like('AB','(?i)(a+|b)+') /* Result: y */;
739regexp_like('AB','(?i)(a+|b)+')
7401
741select regexp_like('AB','(?i)(a+|b){1,}') /* Result: y */;
742regexp_like('AB','(?i)(a+|b){1,}')
7431
744select regexp_like('AB','(?i)(a+|b)?') /* Result: y */;
745regexp_like('AB','(?i)(a+|b)?')
7461
747select regexp_like('AB','(?i)(a+|b){0,1}') /* Result: y */;
748regexp_like('AB','(?i)(a+|b){0,1}')
7491
750select regexp_like('AB','(?i)(a+|b){0,1}?') /* Result: y */;
751regexp_like('AB','(?i)(a+|b){0,1}?')
7521
753select regexp_like('-','(?i))(') /* Result: c */;
754ERROR HY000: Mismatched parenthesis in regular expression.
755select regexp_like('CDE','(?i)[^ab]*') /* Result: y */;
756regexp_like('CDE','(?i)[^ab]*')
7571
758select regexp_like('','(?i)abc') /* Result: n */;
759regexp_like('','(?i)abc')
7600
761select regexp_like('','(?i)a*') /* Result: y */;
762regexp_like('','(?i)a*')
7631
764select regexp_like('ABBBCD','(?i)([abc])*d') /* Result: y */;
765regexp_like('ABBBCD','(?i)([abc])*d')
7661
767select regexp_like('ABCD','(?i)([abc])*bcd') /* Result: y */;
768regexp_like('ABCD','(?i)([abc])*bcd')
7691
770select regexp_like('E','(?i)a|b|c|d|e') /* Result: y */;
771regexp_like('E','(?i)a|b|c|d|e')
7721
773select regexp_like('EF','(?i)(a|b|c|d|e)f') /* Result: y */;
774regexp_like('EF','(?i)(a|b|c|d|e)f')
7751
776select regexp_like('ABCDEFG','(?i)abcd*efg') /* Result: y */;
777regexp_like('ABCDEFG','(?i)abcd*efg')
7781
779select regexp_like('XABYABBBZ','(?i)ab*') /* Result: y */;
780regexp_like('XABYABBBZ','(?i)ab*')
7811
782select regexp_like('XAYABBBZ','(?i)ab*') /* Result: y */;
783regexp_like('XAYABBBZ','(?i)ab*')
7841
785select regexp_like('ABCDE','(?i)(ab|cd)e') /* Result: y */;
786regexp_like('ABCDE','(?i)(ab|cd)e')
7871
788select regexp_like('HIJ','(?i)[abhgefdc]ij') /* Result: y */;
789regexp_like('HIJ','(?i)[abhgefdc]ij')
7901
791select regexp_like('ABCDE','(?i)^(ab|cd)e') /* Result: n */;
792regexp_like('ABCDE','(?i)^(ab|cd)e')
7930
794select regexp_like('ABCDEF','(?i)(abc|)ef') /* Result: y */;
795regexp_like('ABCDEF','(?i)(abc|)ef')
7961
797select regexp_like('ABCD','(?i)(a|b)c*d') /* Result: y */;
798regexp_like('ABCD','(?i)(a|b)c*d')
7991
800select regexp_like('ABC','(?i)(ab|ab*)bc') /* Result: y */;
801regexp_like('ABC','(?i)(ab|ab*)bc')
8021
803select regexp_like('ABC','(?i)a([bc]*)c*') /* Result: y */;
804regexp_like('ABC','(?i)a([bc]*)c*')
8051
806select regexp_like('ABCD','(?i)a([bc]*)(c*d)') /* Result: y */;
807regexp_like('ABCD','(?i)a([bc]*)(c*d)')
8081
809select regexp_like('ABCD','(?i)a([bc]+)(c*d)') /* Result: y */;
810regexp_like('ABCD','(?i)a([bc]+)(c*d)')
8111
812select regexp_like('ABCD','(?i)a([bc]*)(c+d)') /* Result: y */;
813regexp_like('ABCD','(?i)a([bc]*)(c+d)')
8141
815select regexp_like('ADCDCDE','(?i)a[bcd]*dcdcde') /* Result: y */;
816regexp_like('ADCDCDE','(?i)a[bcd]*dcdcde')
8171
818select regexp_like('ADCDCDE','(?i)a[bcd]+dcdcde') /* Result: n */;
819regexp_like('ADCDCDE','(?i)a[bcd]+dcdcde')
8200
821select regexp_like('ABC','(?i)(ab|a)b*c') /* Result: y */;
822regexp_like('ABC','(?i)(ab|a)b*c')
8231
824select regexp_like('ABCD','(?i)((a)(b)c)(d)') /* Result: y */;
825regexp_like('ABCD','(?i)((a)(b)c)(d)')
8261
827select regexp_like('ALPHA','(?i)[a-zA-Z_][a-zA-Z0-9_]*') /* Result: y */;
828regexp_like('ALPHA','(?i)[a-zA-Z_][a-zA-Z0-9_]*')
8291
830select regexp_like('ABH','(?i)^a(bc+|b[eh])g|.h$') /* Result: y */;
831regexp_like('ABH','(?i)^a(bc+|b[eh])g|.h$')
8321
833select regexp_like('EFFGZ','(?i)(bc+d$|ef*g.|h?i(j|k))') /* Result: y */;
834regexp_like('EFFGZ','(?i)(bc+d$|ef*g.|h?i(j|k))')
8351
836select regexp_like('IJ','(?i)(bc+d$|ef*g.|h?i(j|k))') /* Result: y */;
837regexp_like('IJ','(?i)(bc+d$|ef*g.|h?i(j|k))')
8381
839select regexp_like('EFFG','(?i)(bc+d$|ef*g.|h?i(j|k))') /* Result: n */;
840regexp_like('EFFG','(?i)(bc+d$|ef*g.|h?i(j|k))')
8410
842select regexp_like('BCDD','(?i)(bc+d$|ef*g.|h?i(j|k))') /* Result: n */;
843regexp_like('BCDD','(?i)(bc+d$|ef*g.|h?i(j|k))')
8440
845select regexp_like('REFFGZ','(?i)(bc+d$|ef*g.|h?i(j|k))') /* Result: y */;
846regexp_like('REFFGZ','(?i)(bc+d$|ef*g.|h?i(j|k))')
8471
848select regexp_like('A','(?i)((((((((((a))))))))))') /* Result: y */;
849regexp_like('A','(?i)((((((((((a))))))))))')
8501
851select regexp_like('AA','(?i)((((((((((a))))))))))\\10') /* Result: y */;
852regexp_like('AA','(?i)((((((((((a))))))))))\\10')
8531
854select regexp_like('A','(?i)(((((((((a)))))))))') /* Result: y */;
855regexp_like('A','(?i)(((((((((a)))))))))')
8561
857select regexp_like('A','(?i)(?:(?:(?:(?:(?:(?:(?:(?:(?:(a))))))))))') /* Result: y */;
858regexp_like('A','(?i)(?:(?:(?:(?:(?:(?:(?:(?:(?:(a))))))))))')
8591
860select regexp_like('C','(?i)(?:(?:(?:(?:(?:(?:(?:(?:(?:(a|b|c))))))))))') /* Result: y */;
861regexp_like('C','(?i)(?:(?:(?:(?:(?:(?:(?:(?:(?:(a|b|c))))))))))')
8621
863select regexp_like('UH-UH','(?i)multiple words of text') /* Result: n */;
864regexp_like('UH-UH','(?i)multiple words of text')
8650
866select regexp_like('MULTIPLE WORDS, YEAH','(?i)multiple words') /* Result: y */;
867regexp_like('MULTIPLE WORDS, YEAH','(?i)multiple words')
8681
869select regexp_like('ABCDE','(?i)(.*)c(.*)') /* Result: y */;
870regexp_like('ABCDE','(?i)(.*)c(.*)')
8711
872select regexp_like('(A, B)','(?i)\\((.*), (.*)\\)') /* Result: y */;
873regexp_like('(A, B)','(?i)\\((.*), (.*)\\)')
8741
875select regexp_like('AB','(?i)[k]') /* Result: n */;
876regexp_like('AB','(?i)[k]')
8770
878select regexp_like('ABCD','(?i)abcd') /* Result: y */;
879regexp_like('ABCD','(?i)abcd')
8801
881select regexp_like('ABCD','(?i)a(bc)d') /* Result: y */;
882regexp_like('ABCD','(?i)a(bc)d')
8831
884select regexp_like('AC','(?i)a[-]?c') /* Result: y */;
885regexp_like('AC','(?i)a[-]?c')
8861
887select regexp_like('ABCABC','(?i)(abc)\\1') /* Result: y */;
888regexp_like('ABCABC','(?i)(abc)\\1')
8891
890select regexp_like('ABCABC','(?i)([a-c]*)\\1') /* Result: y */;
891regexp_like('ABCABC','(?i)([a-c]*)\\1')
8921
893select regexp_like('abad','a(?!b).') /* Result: y */;
894regexp_like('abad','a(?!b).')
8951
896select regexp_like('abad','a(?=d).') /* Result: y */;
897regexp_like('abad','a(?=d).')
8981
899select regexp_like('abad','a(?=c|d).') /* Result: y */;
900regexp_like('abad','a(?=c|d).')
9011
902select regexp_like('ace','a(?:b|c|d)(.)') /* Result: y */;
903regexp_like('ace','a(?:b|c|d)(.)')
9041
905select regexp_like('ace','a(?:b|c|d)*(.)') /* Result: y */;
906regexp_like('ace','a(?:b|c|d)*(.)')
9071
908select regexp_like('ace','a(?:b|c|d)+?(.)') /* Result: y */;
909regexp_like('ace','a(?:b|c|d)+?(.)')
9101
911select regexp_like('acdbcdbe','a(?:b|c|d)+?(.)') /* Result: y */;
912regexp_like('acdbcdbe','a(?:b|c|d)+?(.)')
9131
914select regexp_like('acdbcdbe','a(?:b|c|d)+(.)') /* Result: y */;
915regexp_like('acdbcdbe','a(?:b|c|d)+(.)')
9161
917select regexp_like('acdbcdbe','a(?:b|c|d){2}(.)') /* Result: y */;
918regexp_like('acdbcdbe','a(?:b|c|d){2}(.)')
9191
920select regexp_like('acdbcdbe','a(?:b|c|d){4,5}(.)') /* Result: y */;
921regexp_like('acdbcdbe','a(?:b|c|d){4,5}(.)')
9221
923select regexp_like('acdbcdbe','a(?:b|c|d){4,5}?(.)') /* Result: y */;
924regexp_like('acdbcdbe','a(?:b|c|d){4,5}?(.)')
9251
926select regexp_like('foobar','((foo)|(bar))*') /* Result: y */;
927regexp_like('foobar','((foo)|(bar))*')
9281
929select regexp_like('-',':(?:') /* Result: c */;
930ERROR HY000: Mismatched parenthesis in regular expression.
931select regexp_like('acdbcdbe','a(?:b|c|d){6,7}(.)') /* Result: y */;
932regexp_like('acdbcdbe','a(?:b|c|d){6,7}(.)')
9331
934select regexp_like('acdbcdbe','a(?:b|c|d){6,7}?(.)') /* Result: y */;
935regexp_like('acdbcdbe','a(?:b|c|d){6,7}?(.)')
9361
937select regexp_like('acdbcdbe','a(?:b|c|d){5,6}(.)') /* Result: y */;
938regexp_like('acdbcdbe','a(?:b|c|d){5,6}(.)')
9391
940select regexp_like('acdbcdbe','a(?:b|c|d){5,6}?(.)') /* Result: y */;
941regexp_like('acdbcdbe','a(?:b|c|d){5,6}?(.)')
9421
943select regexp_like('acdbcdbe','a(?:b|c|d){5,7}(.)') /* Result: y */;
944regexp_like('acdbcdbe','a(?:b|c|d){5,7}(.)')
9451
946select regexp_like('acdbcdbe','a(?:b|c|d){5,7}?(.)') /* Result: y */;
947regexp_like('acdbcdbe','a(?:b|c|d){5,7}?(.)')
9481
949select regexp_like('ace','a(?:b|(c|e){1,2}?|d)+?(.)') /* Result: y */;
950regexp_like('ace','a(?:b|(c|e){1,2}?|d)+?(.)')
9511
952select regexp_like('AB','^(.+)?B') /* Result: y */;
953regexp_like('AB','^(.+)?B')
9541
955select regexp_like('.','^([^a-z])|(\\^)$') /* Result: y */;
956regexp_like('.','^([^a-z])|(\\^)$')
9571
958select regexp_like('<&OUT','^[<>]&') /* Result: y */;
959regexp_like('<&OUT','^[<>]&')
9601
961select regexp_like('aaaaaaaaaa','^(a\\1?){4}$') /* Result: y */;
962regexp_like('aaaaaaaaaa','^(a\\1?){4}$')
9631
964select regexp_like('aaaaaaaaa','^(a\\1?){4}$') /* Result: n */;
965regexp_like('aaaaaaaaa','^(a\\1?){4}$')
9660
967select regexp_like('aaaaaaaaaaa','^(a\\1?){4}$') /* Result: n */;
968regexp_like('aaaaaaaaaaa','^(a\\1?){4}$')
9690
970select regexp_like('aaaaaaaaaa','^(a(?(1)\\1)){4}$') /* Result: y */;
971ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
972select regexp_like('aaaaaaaaa','^(a(?(1)\\1)){4}$') /* Result: n */;
973ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
974select regexp_like('aaaaaaaaaaa','^(a(?(1)\\1)){4}$') /* Result: n */;
975ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
976select regexp_like('aaaaaaaaa','((a{4})+)') /* Result: y */;
977regexp_like('aaaaaaaaa','((a{4})+)')
9781
979select regexp_like('aaaaaaaaaa','(((aa){2})+)') /* Result: y */;
980regexp_like('aaaaaaaaaa','(((aa){2})+)')
9811
982select regexp_like('aaaaaaaaaa','(((a{2}){2})+)') /* Result: y */;
983regexp_like('aaaaaaaaaa','(((a{2}){2})+)')
9841
985select regexp_like('foobar','(?:(f)(o)(o)|(b)(a)(r))*') /* Result: y */;
986regexp_like('foobar','(?:(f)(o)(o)|(b)(a)(r))*')
9871
988select regexp_like('ab','(?<=a)b') /* Result: y */;
989regexp_like('ab','(?<=a)b')
9901
991select regexp_like('cb','(?<=a)b') /* Result: n */;
992regexp_like('cb','(?<=a)b')
9930
994select regexp_like('b','(?<=a)b') /* Result: n */;
995regexp_like('b','(?<=a)b')
9960
997select regexp_like('ab','(?<!c)b') /* Result: y */;
998regexp_like('ab','(?<!c)b')
9991
1000select regexp_like('cb','(?<!c)b') /* Result: n */;
1001regexp_like('cb','(?<!c)b')
10020
1003select regexp_like('b','(?<!c)b') /* Result: y */;
1004regexp_like('b','(?<!c)b')
10051
1006select regexp_like('-','(?<%)b') /* Result: c */;
1007ERROR HY000: Syntax error in regular expression on line 1, character 4.
1008select regexp_like('aba','(?:..)*a') /* Result: y */;
1009regexp_like('aba','(?:..)*a')
10101
1011select regexp_like('aba','(?:..)*?a') /* Result: y */;
1012regexp_like('aba','(?:..)*?a')
10131
1014select regexp_like('abc','^(?:b|a(?=(.)))*\\1') /* Result: y */;
1015regexp_like('abc','^(?:b|a(?=(.)))*\\1')
10161
1017select regexp_like('abc','^(){3,5}') /* Result: y */;
1018regexp_like('abc','^(){3,5}')
10191
1020select regexp_like('aax','^(a+)*ax') /* Result: y */;
1021regexp_like('aax','^(a+)*ax')
10221
1023select regexp_like('aax','^((a|b)+)*ax') /* Result: y */;
1024regexp_like('aax','^((a|b)+)*ax')
10251
1026select regexp_like('aax','^((a|bc)+)*ax') /* Result: y */;
1027regexp_like('aax','^((a|bc)+)*ax')
10281
1029select regexp_like('cab','(a|x)*ab') /* Result: y */;
1030regexp_like('cab','(a|x)*ab')
10311
1032select regexp_like('cab','(a)*ab') /* Result: y */;
1033regexp_like('cab','(a)*ab')
10341
1035select regexp_like('ab','(?:(?i)a)b') /* Result: y */;
1036regexp_like('ab','(?:(?i)a)b')
10371
1038select regexp_like('ab','((?i)a)b') /* Result: y */;
1039regexp_like('ab','((?i)a)b')
10401
1041select regexp_like('Ab','(?:(?i)a)b') /* Result: y */;
1042regexp_like('Ab','(?:(?i)a)b')
10431
1044select regexp_like('Ab','((?i)a)b') /* Result: y */;
1045regexp_like('Ab','((?i)a)b')
10461
1047select regexp_like('aB','(?:(?i)a)b') /* Result: n */;
1048regexp_like('aB','(?:(?i)a)b')
10491
1050select regexp_like('aB','((?i)a)b') /* Result: n */;
1051regexp_like('aB','((?i)a)b')
10521
1053select regexp_like('ab','(?i:a)b') /* Result: y */;
1054regexp_like('ab','(?i:a)b')
10551
1056select regexp_like('ab','((?i:a))b') /* Result: y */;
1057regexp_like('ab','((?i:a))b')
10581
1059select regexp_like('Ab','(?i:a)b') /* Result: y */;
1060regexp_like('Ab','(?i:a)b')
10611
1062select regexp_like('Ab','((?i:a))b') /* Result: y */;
1063regexp_like('Ab','((?i:a))b')
10641
1065select regexp_like('aB','(?i:a)b') /* Result: n */;
1066regexp_like('aB','(?i:a)b')
10671
1068select regexp_like('aB','((?i:a))b') /* Result: n */;
1069regexp_like('aB','((?i:a))b')
10701
1071select regexp_like('ab','(?i)(?:(?-i)a)b') /* Result: y */;
1072regexp_like('ab','(?i)(?:(?-i)a)b')
10731
1074select regexp_like('ab','(?i)((?-i)a)b') /* Result: y */;
1075regexp_like('ab','(?i)((?-i)a)b')
10761
1077select regexp_like('aB','(?i)(?:(?-i)a)b') /* Result: y */;
1078regexp_like('aB','(?i)(?:(?-i)a)b')
10791
1080select regexp_like('aB','(?i)((?-i)a)b') /* Result: y */;
1081regexp_like('aB','(?i)((?-i)a)b')
10821
1083select regexp_like('Ab','(?i)(?:(?-i)a)b') /* Result: n */;
1084regexp_like('Ab','(?i)(?:(?-i)a)b')
10850
1086select regexp_like('Ab','(?i)((?-i)a)b') /* Result: n */;
1087regexp_like('Ab','(?i)((?-i)a)b')
10880
1089select regexp_like('AB','(?i)(?:(?-i)a)b') /* Result: n */;
1090regexp_like('AB','(?i)(?:(?-i)a)b')
10910
1092select regexp_like('AB','(?i)((?-i)a)b') /* Result: n */;
1093regexp_like('AB','(?i)((?-i)a)b')
10940
1095select regexp_like('ab','(?i)(?-i:a)b') /* Result: y */;
1096regexp_like('ab','(?i)(?-i:a)b')
10971
1098select regexp_like('ab','(?i)((?-i:a))b') /* Result: y */;
1099regexp_like('ab','(?i)((?-i:a))b')
11001
1101select regexp_like('aB','(?i)(?-i:a)b') /* Result: y */;
1102regexp_like('aB','(?i)(?-i:a)b')
11031
1104select regexp_like('aB','(?i)((?-i:a))b') /* Result: y */;
1105regexp_like('aB','(?i)((?-i:a))b')
11061
1107select regexp_like('Ab','(?i)(?-i:a)b') /* Result: n */;
1108regexp_like('Ab','(?i)(?-i:a)b')
11090
1110select regexp_like('Ab','(?i)((?-i:a))b') /* Result: n */;
1111regexp_like('Ab','(?i)((?-i:a))b')
11120
1113select regexp_like('AB','(?i)(?-i:a)b') /* Result: n */;
1114regexp_like('AB','(?i)(?-i:a)b')
11150
1116select regexp_like('AB','(?i)((?-i:a))b') /* Result: n */;
1117regexp_like('AB','(?i)((?-i:a))b')
11180
1119select regexp_like('a\nB','(?i)((?-i:a.))b') /* Result: n */;
1120regexp_like('a\nB','(?i)((?-i:a.))b')
11210
1122select regexp_like('a\nB','(?i)((?s-i:a.))b') /* Result: y */;
1123regexp_like('a\nB','(?i)((?s-i:a.))b')
11241
1125select regexp_like('B\nB','(?i)((?s-i:a.))b') /* Result: n */;
1126regexp_like('B\nB','(?i)((?s-i:a.))b')
11270
1128select regexp_like('cabbbb','(?:c|d)(?:)(?:a(?:)(?:b)(?:b(?:))(?:b(?:)(?:b)))') /* Result: y */;
1129regexp_like('cabbbb','(?:c|d)(?:)(?:a(?:)(?:b)(?:b(?:))(?:b(?:)(?:b)))')
11301
1131select regexp_like('caaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','(?:c|d)(?:)(?:aaaaaaaa(?:)(?:bbbbbbbb)(?:bbbbbbbb(?:))(?:bbbbbbbb(?:)(?:bbbbbbbb)))') /* Result: y */;
1132regexp_like('caaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb','(?:c|d)(?:)(?:aaaaaaaa(?:)(?:bbbbbbbb)(?:bbbbbbbb(?:))(?:bbbbbbbb(?:)(?:bbbbbbbb)))')
11331
1134select regexp_like('Ab4ab','(?i)(ab)\\d\\1') /* Result: y */;
1135regexp_like('Ab4ab','(?i)(ab)\\d\\1')
11361
1137select regexp_like('ab4Ab','(?i)(ab)\\d\\1') /* Result: y */;
1138regexp_like('ab4Ab','(?i)(ab)\\d\\1')
11391
1140select regexp_like('foobar1234baz','foo\\w*\\d{4}baz') /* Result: y */;
1141regexp_like('foobar1234baz','foo\\w*\\d{4}baz')
11421
1143select regexp_like('cabd','a(?{})b') /* Result: y */;
1144ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1145select regexp_like('-','a(?{)b') /* Result: c */;
1146ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1147select regexp_like('-','a(?{{})b') /* Result: c */;
1148ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1149select regexp_like('-','a(?{}})b') /* Result: c */;
1150ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1151select regexp_like('-','a(?{"{"})b') /* Result: c */;
1152ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1153select regexp_like('cabd','a(?{"\\{"})b') /* Result: y */;
1154ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1155select regexp_like('-','a(?{"{"}})b') /* Result: c */;
1156ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1157select regexp_like('caxbd','a(?{$bl="\\{"}).b') /* Result: y */;
1158ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1159select regexp_like('x~~','x(~~)*(?:(?:F)?)?') /* Result: y */;
1160regexp_like('x~~','x(~~)*(?:(?:F)?)?')
11611
1162select regexp_like('aaac','^a(?#xxx){3}c') /* Result: y */;
1163regexp_like('aaac','^a(?#xxx){3}c')
11641
1165select regexp_like('aaac','(?x)^a (?#xxx) (?#yyy) {3}c') /* Result: y */;
1166regexp_like('aaac','(?x)^a (?#xxx) (?#yyy) {3}c')
11671
1168select regexp_like('dbcb','(?<![cd])b') /* Result: n */;
1169regexp_like('dbcb','(?<![cd])b')
11700
1171select regexp_like('dbaacb','(?<![cd])[ab]') /* Result: y */;
1172regexp_like('dbaacb','(?<![cd])[ab]')
11731
1174select regexp_like('dbcb','(?<!(c|d))b') /* Result: n */;
1175regexp_like('dbcb','(?<!(c|d))b')
11760
1177select regexp_like('dbaacb','(?<!(c|d))[ab]') /* Result: y */;
1178regexp_like('dbaacb','(?<!(c|d))[ab]')
11791
1180select regexp_like('cdaccb','(?<!cd)[ab]') /* Result: y */;
1181regexp_like('cdaccb','(?<!cd)[ab]')
11821
1183select regexp_like('a--','^(?:a?b?)*$') /* Result: n */;
1184regexp_like('a--','^(?:a?b?)*$')
11850
1186select regexp_like('a\nb\nc\n','((?s)^a(.))((?m)^b$)') /* Result: y */;
1187regexp_like('a\nb\nc\n','((?s)^a(.))((?m)^b$)')
11881
1189select regexp_like('a\nb\nc\n','((?m)^b$)') /* Result: y */;
1190regexp_like('a\nb\nc\n','((?m)^b$)')
11911
1192select regexp_like('a\nb\n','(?m)^b') /* Result: y */;
1193regexp_like('a\nb\n','(?m)^b')
11941
1195select regexp_like('a\nb\n','(?m)^(b)') /* Result: y */;
1196regexp_like('a\nb\n','(?m)^(b)')
11971
1198select regexp_like('a\nb\n','((?m)^b)') /* Result: y */;
1199regexp_like('a\nb\n','((?m)^b)')
12001
1201select regexp_like('a\nb\n','\n((?m)^b)') /* Result: y */;
1202regexp_like('a\nb\n','\n((?m)^b)')
12031
1204select regexp_like('a\nb\nc\n','((?s).)c(?!.)') /* Result: y */;
1205regexp_like('a\nb\nc\n','((?s).)c(?!.)')
12061
1207select regexp_like('a\nb\nc\n','((?s)b.)c(?!.)') /* Result: y */;
1208regexp_like('a\nb\nc\n','((?s)b.)c(?!.)')
12091
1210select regexp_like('a\nb\nc\n','^b') /* Result: n */;
1211regexp_like('a\nb\nc\n','^b')
12120
1213select regexp_like('a\nb\nc\n','()^b') /* Result: n */;
1214regexp_like('a\nb\nc\n','()^b')
12150
1216select regexp_like('a\nb\nc\n','((?m)^b)') /* Result: y */;
1217regexp_like('a\nb\nc\n','((?m)^b)')
12181
1219select regexp_like('a','(?(1)a|b)') /* Result: n */;
1220ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1221select regexp_like('a','(?(1)b|a)') /* Result: y */;
1222ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1223select regexp_like('a','(x)?(?(1)a|b)') /* Result: n */;
1224ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1225select regexp_like('a','(x)?(?(1)b|a)') /* Result: y */;
1226ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1227select regexp_like('a','()?(?(1)b|a)') /* Result: y */;
1228ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1229select regexp_like('a','()(?(1)b|a)') /* Result: n */;
1230ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1231select regexp_like('a','()?(?(1)a|b)') /* Result: y */;
1232ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1233select regexp_like('(blah)','^(\\()?blah(?(1)(\\)))$') /* Result: y */;
1234ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1235select regexp_like('blah','^(\\()?blah(?(1)(\\)))$') /* Result: y */;
1236ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1237select regexp_like('blah)','^(\\()?blah(?(1)(\\)))$') /* Result: n */;
1238ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1239select regexp_like('(blah','^(\\()?blah(?(1)(\\)))$') /* Result: n */;
1240ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1241select regexp_like('(blah)','^(\\(+)?blah(?(1)(\\)))$') /* Result: y */;
1242ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1243select regexp_like('blah','^(\\(+)?blah(?(1)(\\)))$') /* Result: y */;
1244ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1245select regexp_like('blah)','^(\\(+)?blah(?(1)(\\)))$') /* Result: n */;
1246ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1247select regexp_like('(blah','^(\\(+)?blah(?(1)(\\)))$') /* Result: n */;
1248ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1249select regexp_like('a','(?(1?)a|b)') /* Result: c */;
1250ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1251select regexp_like('a','(?(1)a|b|c)') /* Result: c */;
1252ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1253select regexp_like('a','(?(?{0})a|b)') /* Result: n */;
1254ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1255select regexp_like('a','(?(?{0})b|a)') /* Result: y */;
1256ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1257select regexp_like('a','(?(?{1})b|a)') /* Result: n */;
1258ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1259select regexp_like('a','(?(?{1})a|b)') /* Result: y */;
1260ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1261select regexp_like('a','(?(?!a)a|b)') /* Result: n */;
1262ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1263select regexp_like('a','(?(?!a)b|a)') /* Result: y */;
1264ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1265select regexp_like('a','(?(?=a)b|a)') /* Result: n */;
1266ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1267select regexp_like('a','(?(?=a)a|b)') /* Result: y */;
1268ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1269select regexp_like('aaab','(?=(a+?))(\\1ab)') /* Result: y */;
1270regexp_like('aaab','(?=(a+?))(\\1ab)')
12711
1272select regexp_like('aaab','^(?=(a+?))\\1ab') /* Result: n */;
1273regexp_like('aaab','^(?=(a+?))\\1ab')
12740
1275select regexp_like('one:','(\\w+:)+') /* Result: y */;
1276regexp_like('one:','(\\w+:)+')
12771
1278select regexp_like('a','$(?<=^(a))') /* Result: y */;
1279regexp_like('a','$(?<=^(a))')
12801
1281select regexp_like('abcd:','([\\w:]+::)?(\\w+)$') /* Result: n */;
1282regexp_like('abcd:','([\\w:]+::)?(\\w+)$')
12830
1284select regexp_like('abcd','([\\w:]+::)?(\\w+)$') /* Result: y */;
1285regexp_like('abcd','([\\w:]+::)?(\\w+)$')
12861
1287select regexp_like('xy:z:::abcd','([\\w:]+::)?(\\w+)$') /* Result: y */;
1288regexp_like('xy:z:::abcd','([\\w:]+::)?(\\w+)$')
12891
1290select regexp_like('aexycd','^[^bcd]*(c+)') /* Result: y */;
1291regexp_like('aexycd','^[^bcd]*(c+)')
12921
1293select regexp_like('caab','(a*)b+') /* Result: y */;
1294regexp_like('caab','(a*)b+')
12951
1296select regexp_like('yaaxxaaaacd','(?{$a=2})a*aa(?{local$a=$a+1})k*c(?{$b=$a})') /* Result: y */;
1297ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1298select regexp_like('yaaxxaaaacd','(?{$a=2})(a(?{local$a=$a+1}))*aak*c(?{$b=$a})') /* Result: y */;
1299ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
1300select regexp_like('aaab','(>a+)ab') /* Result: n */;
1301regexp_like('aaab','(>a+)ab')
13020
1303select regexp_like('aaab','(?>a+)b') /* Result: y */;
1304regexp_like('aaab','(?>a+)b')
13051
1306select regexp_like('a:[b]:','([\\[:]+)') /* Result: yi */;
1307regexp_like('a:[b]:','([\\[:]+)')
13081
1309select regexp_like('a=[b]=','([\\[=]+)') /* Result: yi */;
1310regexp_like('a=[b]=','([\\[=]+)')
13111
1312select regexp_like('a.[b].','([\\[.]+)') /* Result: yi */;
1313regexp_like('a.[b].','([\\[.]+)')
13141
1315select regexp_like('-','[a[:xyz:') /* Result: c */;
1316ERROR HY000: The regular expression contains an unclosed bracket expression.
1317select regexp_like('-','[a[:xyz:]') /* Result: c */;
1318ERROR HY000: Illegal argument to a regular expression.
1319select regexp_like('abc','[a\\[:]b[:c]') /* Result: yi */;
1320regexp_like('abc','[a\\[:]b[:c]')
13211
1322select regexp_like('pbaq','([a[:xyz:]b]+)') /* Result: c */;
1323ERROR HY000: Illegal argument to a regular expression.
1324select regexp_like('abc','[a\\[:]b[:c]') /* Result: iy */;
1325regexp_like('abc','[a\\[:]b[:c]')
13261
1327select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:alpha:]]+)') /* Result: y */;
1328regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:alpha:]]+)')
13291
1330select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:alnum:]]+)') /* Result: y */;
1331regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:alnum:]]+)')
13321
1333select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:ascii:]]+)') /* Result: y */;
1334regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:ascii:]]+)')
13351
1336select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:cntrl:]]+)') /* Result: y */;
1337regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:cntrl:]]+)')
13381
1339select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:digit:]]+)') /* Result: y */;
1340regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:digit:]]+)')
13411
1342select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:graph:]]+)') /* Result: y */;
1343regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:graph:]]+)')
13441
1345select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:lower:]]+)') /* Result: y */;
1346regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:lower:]]+)')
13471
1348select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:print:]]+)') /* Result: y */;
1349regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:print:]]+)')
13501
1351select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:punct:]]+)') /* Result: y */;
1352regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:punct:]]+)')
13531
1354select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:space:]]+)') /* Result: y */;
1355regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:space:]]+)')
13561
1357select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:word:]]+)') /* Result: yi */;
1358regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:word:]]+)')
13591
1360select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:upper:]]+)') /* Result: y */;
1361regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:upper:]]+)')
13621
1363select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:xdigit:]]+)') /* Result: y */;
1364regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:xdigit:]]+)')
13651
1366select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^alpha:]]+)') /* Result: y */;
1367regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^alpha:]]+)')
13681
1369select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^alnum:]]+)') /* Result: y */;
1370regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^alnum:]]+)')
13711
1372select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^ascii:]]+)') /* Result: y */;
1373regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^ascii:]]+)')
13741
1375select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^cntrl:]]+)') /* Result: y */;
1376regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^cntrl:]]+)')
13771
1378select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^digit:]]+)') /* Result: y */;
1379regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^digit:]]+)')
13801
1381select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^lower:]]+)') /* Result: y */;
1382regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^lower:]]+)')
13831
1384select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^print:]]+)') /* Result: y */;
1385regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^print:]]+)')
13861
1387select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^punct:]]+)') /* Result: y */;
1388regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^punct:]]+)')
13891
1390select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^space:]]+)') /* Result: y */;
1391regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^space:]]+)')
13921
1393select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^word:]]+)') /* Result: yi */;
1394regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^word:]]+)')
13951
1396select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^upper:]]+)') /* Result: y */;
1397regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^upper:]]+)')
13981
1399select regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^xdigit:]]+)') /* Result: y */;
1400regexp_like(concat('ABcd01Xy__--  ', _utf16 x'0000ffff'),'([[:^xdigit:]]+)')
14011
1402select regexp_like('-','[[:foo:]]') /* Result: c */;
1403ERROR HY000: Illegal argument to a regular expression.
1404select regexp_like('-','[[:^foo:]]') /* Result: c */;
1405ERROR HY000: Illegal argument to a regular expression.
1406select regexp_like('aaab','((?>a+)b)') /* Result: y */;
1407regexp_like('aaab','((?>a+)b)')
14081
1409select regexp_like('aaab','(?>(a+))b') /* Result: y */;
1410regexp_like('aaab','(?>(a+))b')
14111
1412select regexp_like('((abc(ade)ufh()()x','((?>[^()]+)|\\([^()]*\\))+') /* Result: y */;
1413regexp_like('((abc(ade)ufh()()x','((?>[^()]+)|\\([^()]*\\))+')
14141
1415select regexp_like('-','(?<=x+)y') /* Result: c */;
1416ERROR HY000: The look-behind assertion exceeds the limit in regular expression.
1417select regexp_like('-','a{37,17}') /* Result: c */;
1418ERROR HY000: The maximum is less than the minumum in a {min,max} interval.
1419select regexp_like('a\nb\n','\\Z') /* Result: y */;
1420regexp_like('a\nb\n','\\Z')
14211
1422select regexp_like('a\nb\n','\\z') /* Result: y */;
1423regexp_like('a\nb\n','\\z')
14241
1425select regexp_like('a\nb\n','$') /* Result: y */;
1426regexp_like('a\nb\n','$')
14271
1428select regexp_like('b\na\n','\\Z') /* Result: y */;
1429regexp_like('b\na\n','\\Z')
14301
1431select regexp_like('b\na\n','\\z') /* Result: y */;
1432regexp_like('b\na\n','\\z')
14331
1434select regexp_like('b\na\n','$') /* Result: y */;
1435regexp_like('b\na\n','$')
14361
1437select regexp_like('b\na','\\Z') /* Result: y */;
1438regexp_like('b\na','\\Z')
14391
1440select regexp_like('b\na','\\z') /* Result: y */;
1441regexp_like('b\na','\\z')
14421
1443select regexp_like('b\na','$') /* Result: y */;
1444regexp_like('b\na','$')
14451
1446select regexp_like('a\nb\n','(?m)\\Z') /* Result: y */;
1447regexp_like('a\nb\n','(?m)\\Z')
14481
1449select regexp_like('a\nb\n','(?m)\\z') /* Result: y */;
1450regexp_like('a\nb\n','(?m)\\z')
14511
1452select regexp_like('a\nb\n','(?m)$') /* Result: y */;
1453regexp_like('a\nb\n','(?m)$')
14541
1455select regexp_like('b\na\n','(?m)\\Z') /* Result: y */;
1456regexp_like('b\na\n','(?m)\\Z')
14571
1458select regexp_like('b\na\n','(?m)\\z') /* Result: y */;
1459regexp_like('b\na\n','(?m)\\z')
14601
1461select regexp_like('b\na\n','(?m)$') /* Result: y */;
1462regexp_like('b\na\n','(?m)$')
14631
1464select regexp_like('b\na','(?m)\\Z') /* Result: y */;
1465regexp_like('b\na','(?m)\\Z')
14661
1467select regexp_like('b\na','(?m)\\z') /* Result: y */;
1468regexp_like('b\na','(?m)\\z')
14691
1470select regexp_like('b\na','(?m)$') /* Result: y */;
1471regexp_like('b\na','(?m)$')
14721
1473select regexp_like('a\nb\n','a\\Z') /* Result: n */;
1474regexp_like('a\nb\n','a\\Z')
14750
1476select regexp_like('a\nb\n','a\\z') /* Result: n */;
1477regexp_like('a\nb\n','a\\z')
14780
1479select regexp_like('a\nb\n','a$') /* Result: n */;
1480regexp_like('a\nb\n','a$')
14810
1482select regexp_like('b\na\n','a\\Z') /* Result: y */;
1483regexp_like('b\na\n','a\\Z')
14841
1485select regexp_like('b\na\n','a\\z') /* Result: n */;
1486regexp_like('b\na\n','a\\z')
14870
1488select regexp_like('b\na\n','a$') /* Result: y */;
1489regexp_like('b\na\n','a$')
14901
1491select regexp_like('b\na','a\\Z') /* Result: y */;
1492regexp_like('b\na','a\\Z')
14931
1494select regexp_like('b\na','a\\z') /* Result: y */;
1495regexp_like('b\na','a\\z')
14961
1497select regexp_like('b\na','a$') /* Result: y */;
1498regexp_like('b\na','a$')
14991
1500select regexp_like('a\nb\n','(?m)a\\Z') /* Result: n */;
1501regexp_like('a\nb\n','(?m)a\\Z')
15020
1503select regexp_like('a\nb\n','(?m)a\\z') /* Result: n */;
1504regexp_like('a\nb\n','(?m)a\\z')
15050
1506select regexp_like('a\nb\n','(?m)a$') /* Result: y */;
1507regexp_like('a\nb\n','(?m)a$')
15081
1509select regexp_like('b\na\n','(?m)a\\Z') /* Result: y */;
1510regexp_like('b\na\n','(?m)a\\Z')
15111
1512select regexp_like('b\na\n','(?m)a\\z') /* Result: n */;
1513regexp_like('b\na\n','(?m)a\\z')
15140
1515select regexp_like('b\na\n','(?m)a$') /* Result: y */;
1516regexp_like('b\na\n','(?m)a$')
15171
1518select regexp_like('b\na','(?m)a\\Z') /* Result: y */;
1519regexp_like('b\na','(?m)a\\Z')
15201
1521select regexp_like('b\na','(?m)a\\z') /* Result: y */;
1522regexp_like('b\na','(?m)a\\z')
15231
1524select regexp_like('b\na','(?m)a$') /* Result: y */;
1525regexp_like('b\na','(?m)a$')
15261
1527select regexp_like('aa\nb\n','aa\\Z') /* Result: n */;
1528regexp_like('aa\nb\n','aa\\Z')
15290
1530select regexp_like('aa\nb\n','aa\\z') /* Result: n */;
1531regexp_like('aa\nb\n','aa\\z')
15320
1533select regexp_like('aa\nb\n','aa$') /* Result: n */;
1534regexp_like('aa\nb\n','aa$')
15350
1536select regexp_like('b\naa\n','aa\\Z') /* Result: y */;
1537regexp_like('b\naa\n','aa\\Z')
15381
1539select regexp_like('b\naa\n','aa\\z') /* Result: n */;
1540regexp_like('b\naa\n','aa\\z')
15410
1542select regexp_like('b\naa\n','aa$') /* Result: y */;
1543regexp_like('b\naa\n','aa$')
15441
1545select regexp_like('b\naa','aa\\Z') /* Result: y */;
1546regexp_like('b\naa','aa\\Z')
15471
1548select regexp_like('b\naa','aa\\z') /* Result: y */;
1549regexp_like('b\naa','aa\\z')
15501
1551select regexp_like('b\naa','aa$') /* Result: y */;
1552regexp_like('b\naa','aa$')
15531
1554select regexp_like('aa\nb\n','(?m)aa\\Z') /* Result: n */;
1555regexp_like('aa\nb\n','(?m)aa\\Z')
15560
1557select regexp_like('aa\nb\n','(?m)aa\\z') /* Result: n */;
1558regexp_like('aa\nb\n','(?m)aa\\z')
15590
1560select regexp_like('aa\nb\n','(?m)aa$') /* Result: y */;
1561regexp_like('aa\nb\n','(?m)aa$')
15621
1563select regexp_like('b\naa\n','(?m)aa\\Z') /* Result: y */;
1564regexp_like('b\naa\n','(?m)aa\\Z')
15651
1566select regexp_like('b\naa\n','(?m)aa\\z') /* Result: n */;
1567regexp_like('b\naa\n','(?m)aa\\z')
15680
1569select regexp_like('b\naa\n','(?m)aa$') /* Result: y */;
1570regexp_like('b\naa\n','(?m)aa$')
15711
1572select regexp_like('b\naa','(?m)aa\\Z') /* Result: y */;
1573regexp_like('b\naa','(?m)aa\\Z')
15741
1575select regexp_like('b\naa','(?m)aa\\z') /* Result: y */;
1576regexp_like('b\naa','(?m)aa\\z')
15771
1578select regexp_like('b\naa','(?m)aa$') /* Result: y */;
1579regexp_like('b\naa','(?m)aa$')
15801
1581select regexp_like('ac\nb\n','aa\\Z') /* Result: n */;
1582regexp_like('ac\nb\n','aa\\Z')
15830
1584select regexp_like('ac\nb\n','aa\\z') /* Result: n */;
1585regexp_like('ac\nb\n','aa\\z')
15860
1587select regexp_like('ac\nb\n','aa$') /* Result: n */;
1588regexp_like('ac\nb\n','aa$')
15890
1590select regexp_like('b\nac\n','aa\\Z') /* Result: n */;
1591regexp_like('b\nac\n','aa\\Z')
15920
1593select regexp_like('b\nac\n','aa\\z') /* Result: n */;
1594regexp_like('b\nac\n','aa\\z')
15950
1596select regexp_like('b\nac\n','aa$') /* Result: n */;
1597regexp_like('b\nac\n','aa$')
15980
1599select regexp_like('b\nac','aa\\Z') /* Result: n */;
1600regexp_like('b\nac','aa\\Z')
16010
1602select regexp_like('b\nac','aa\\z') /* Result: n */;
1603regexp_like('b\nac','aa\\z')
16040
1605select regexp_like('b\nac','aa$') /* Result: n */;
1606regexp_like('b\nac','aa$')
16070
1608select regexp_like('ac\nb\n','(?m)aa\\Z') /* Result: n */;
1609regexp_like('ac\nb\n','(?m)aa\\Z')
16100
1611select regexp_like('ac\nb\n','(?m)aa\\z') /* Result: n */;
1612regexp_like('ac\nb\n','(?m)aa\\z')
16130
1614select regexp_like('ac\nb\n','(?m)aa$') /* Result: n */;
1615regexp_like('ac\nb\n','(?m)aa$')
16160
1617select regexp_like('b\nac\n','(?m)aa\\Z') /* Result: n */;
1618regexp_like('b\nac\n','(?m)aa\\Z')
16190
1620select regexp_like('b\nac\n','(?m)aa\\z') /* Result: n */;
1621regexp_like('b\nac\n','(?m)aa\\z')
16220
1623select regexp_like('b\nac\n','(?m)aa$') /* Result: n */;
1624regexp_like('b\nac\n','(?m)aa$')
16250
1626select regexp_like('b\nac','(?m)aa\\Z') /* Result: n */;
1627regexp_like('b\nac','(?m)aa\\Z')
16280
1629select regexp_like('b\nac','(?m)aa\\z') /* Result: n */;
1630regexp_like('b\nac','(?m)aa\\z')
16310
1632select regexp_like('b\nac','(?m)aa$') /* Result: n */;
1633regexp_like('b\nac','(?m)aa$')
16340
1635select regexp_like('ca\nb\n','aa\\Z') /* Result: n */;
1636regexp_like('ca\nb\n','aa\\Z')
16370
1638select regexp_like('ca\nb\n','aa\\z') /* Result: n */;
1639regexp_like('ca\nb\n','aa\\z')
16400
1641select regexp_like('ca\nb\n','aa$') /* Result: n */;
1642regexp_like('ca\nb\n','aa$')
16430
1644select regexp_like('b\nca\n','aa\\Z') /* Result: n */;
1645regexp_like('b\nca\n','aa\\Z')
16460
1647select regexp_like('b\nca\n','aa\\z') /* Result: n */;
1648regexp_like('b\nca\n','aa\\z')
16490
1650select regexp_like('b\nca\n','aa$') /* Result: n */;
1651regexp_like('b\nca\n','aa$')
16520
1653select regexp_like('b\nca','aa\\Z') /* Result: n */;
1654regexp_like('b\nca','aa\\Z')
16550
1656select regexp_like('b\nca','aa\\z') /* Result: n */;
1657regexp_like('b\nca','aa\\z')
16580
1659select regexp_like('b\nca','aa$') /* Result: n */;
1660regexp_like('b\nca','aa$')
16610
1662select regexp_like('ca\nb\n','(?m)aa\\Z') /* Result: n */;
1663regexp_like('ca\nb\n','(?m)aa\\Z')
16640
1665select regexp_like('ca\nb\n','(?m)aa\\z') /* Result: n */;
1666regexp_like('ca\nb\n','(?m)aa\\z')
16670
1668select regexp_like('ca\nb\n','(?m)aa$') /* Result: n */;
1669regexp_like('ca\nb\n','(?m)aa$')
16700
1671select regexp_like('b\nca\n','(?m)aa\\Z') /* Result: n */;
1672regexp_like('b\nca\n','(?m)aa\\Z')
16730
1674select regexp_like('b\nca\n','(?m)aa\\z') /* Result: n */;
1675regexp_like('b\nca\n','(?m)aa\\z')
16760
1677select regexp_like('b\nca\n','(?m)aa$') /* Result: n */;
1678regexp_like('b\nca\n','(?m)aa$')
16790
1680select regexp_like('b\nca','(?m)aa\\Z') /* Result: n */;
1681regexp_like('b\nca','(?m)aa\\Z')
16820
1683select regexp_like('b\nca','(?m)aa\\z') /* Result: n */;
1684regexp_like('b\nca','(?m)aa\\z')
16850
1686select regexp_like('b\nca','(?m)aa$') /* Result: n */;
1687regexp_like('b\nca','(?m)aa$')
16880
1689select regexp_like('ab\nb\n','ab\\Z') /* Result: n */;
1690regexp_like('ab\nb\n','ab\\Z')
16910
1692select regexp_like('ab\nb\n','ab\\z') /* Result: n */;
1693regexp_like('ab\nb\n','ab\\z')
16940
1695select regexp_like('ab\nb\n','ab$') /* Result: n */;
1696regexp_like('ab\nb\n','ab$')
16970
1698select regexp_like('b\nab\n','ab\\Z') /* Result: y */;
1699regexp_like('b\nab\n','ab\\Z')
17001
1701select regexp_like('b\nab\n','ab\\z') /* Result: n */;
1702regexp_like('b\nab\n','ab\\z')
17030
1704select regexp_like('b\nab\n','ab$') /* Result: y */;
1705regexp_like('b\nab\n','ab$')
17061
1707select regexp_like('b\nab','ab\\Z') /* Result: y */;
1708regexp_like('b\nab','ab\\Z')
17091
1710select regexp_like('b\nab','ab\\z') /* Result: y */;
1711regexp_like('b\nab','ab\\z')
17121
1713select regexp_like('b\nab','ab$') /* Result: y */;
1714regexp_like('b\nab','ab$')
17151
1716select regexp_like('ab\nb\n','(?m)ab\\Z') /* Result: n */;
1717regexp_like('ab\nb\n','(?m)ab\\Z')
17180
1719select regexp_like('ab\nb\n','(?m)ab\\z') /* Result: n */;
1720regexp_like('ab\nb\n','(?m)ab\\z')
17210
1722select regexp_like('ab\nb\n','(?m)ab$') /* Result: y */;
1723regexp_like('ab\nb\n','(?m)ab$')
17241
1725select regexp_like('b\nab\n','(?m)ab\\Z') /* Result: y */;
1726regexp_like('b\nab\n','(?m)ab\\Z')
17271
1728select regexp_like('b\nab\n','(?m)ab\\z') /* Result: n */;
1729regexp_like('b\nab\n','(?m)ab\\z')
17300
1731select regexp_like('b\nab\n','(?m)ab$') /* Result: y */;
1732regexp_like('b\nab\n','(?m)ab$')
17331
1734select regexp_like('b\nab','(?m)ab\\Z') /* Result: y */;
1735regexp_like('b\nab','(?m)ab\\Z')
17361
1737select regexp_like('b\nab','(?m)ab\\z') /* Result: y */;
1738regexp_like('b\nab','(?m)ab\\z')
17391
1740select regexp_like('b\nab','(?m)ab$') /* Result: y */;
1741regexp_like('b\nab','(?m)ab$')
17421
1743select regexp_like('ac\nb\n','ab\\Z') /* Result: n */;
1744regexp_like('ac\nb\n','ab\\Z')
17450
1746select regexp_like('ac\nb\n','ab\\z') /* Result: n */;
1747regexp_like('ac\nb\n','ab\\z')
17480
1749select regexp_like('ac\nb\n','ab$') /* Result: n */;
1750regexp_like('ac\nb\n','ab$')
17510
1752select regexp_like('b\nac\n','ab\\Z') /* Result: n */;
1753regexp_like('b\nac\n','ab\\Z')
17540
1755select regexp_like('b\nac\n','ab\\z') /* Result: n */;
1756regexp_like('b\nac\n','ab\\z')
17570
1758select regexp_like('b\nac\n','ab$') /* Result: n */;
1759regexp_like('b\nac\n','ab$')
17600
1761select regexp_like('b\nac','ab\\Z') /* Result: n */;
1762regexp_like('b\nac','ab\\Z')
17630
1764select regexp_like('b\nac','ab\\z') /* Result: n */;
1765regexp_like('b\nac','ab\\z')
17660
1767select regexp_like('b\nac','ab$') /* Result: n */;
1768regexp_like('b\nac','ab$')
17690
1770select regexp_like('ac\nb\n','(?m)ab\\Z') /* Result: n */;
1771regexp_like('ac\nb\n','(?m)ab\\Z')
17720
1773select regexp_like('ac\nb\n','(?m)ab\\z') /* Result: n */;
1774regexp_like('ac\nb\n','(?m)ab\\z')
17750
1776select regexp_like('ac\nb\n','(?m)ab$') /* Result: n */;
1777regexp_like('ac\nb\n','(?m)ab$')
17780
1779select regexp_like('b\nac\n','(?m)ab\\Z') /* Result: n */;
1780regexp_like('b\nac\n','(?m)ab\\Z')
17810
1782select regexp_like('b\nac\n','(?m)ab\\z') /* Result: n */;
1783regexp_like('b\nac\n','(?m)ab\\z')
17840
1785select regexp_like('b\nac\n','(?m)ab$') /* Result: n */;
1786regexp_like('b\nac\n','(?m)ab$')
17870
1788select regexp_like('b\nac','(?m)ab\\Z') /* Result: n */;
1789regexp_like('b\nac','(?m)ab\\Z')
17900
1791select regexp_like('b\nac','(?m)ab\\z') /* Result: n */;
1792regexp_like('b\nac','(?m)ab\\z')
17930
1794select regexp_like('b\nac','(?m)ab$') /* Result: n */;
1795regexp_like('b\nac','(?m)ab$')
17960
1797select regexp_like('ca\nb\n','ab\\Z') /* Result: n */;
1798regexp_like('ca\nb\n','ab\\Z')
17990
1800select regexp_like('ca\nb\n','ab\\z') /* Result: n */;
1801regexp_like('ca\nb\n','ab\\z')
18020
1803select regexp_like('ca\nb\n','ab$') /* Result: n */;
1804regexp_like('ca\nb\n','ab$')
18050
1806select regexp_like('b\nca\n','ab\\Z') /* Result: n */;
1807regexp_like('b\nca\n','ab\\Z')
18080
1809select regexp_like('b\nca\n','ab\\z') /* Result: n */;
1810regexp_like('b\nca\n','ab\\z')
18110
1812select regexp_like('b\nca\n','ab$') /* Result: n */;
1813regexp_like('b\nca\n','ab$')
18140
1815select regexp_like('b\nca','ab\\Z') /* Result: n */;
1816regexp_like('b\nca','ab\\Z')
18170
1818select regexp_like('b\nca','ab\\z') /* Result: n */;
1819regexp_like('b\nca','ab\\z')
18200
1821select regexp_like('b\nca','ab$') /* Result: n */;
1822regexp_like('b\nca','ab$')
18230
1824select regexp_like('ca\nb\n','(?m)ab\\Z') /* Result: n */;
1825regexp_like('ca\nb\n','(?m)ab\\Z')
18260
1827select regexp_like('ca\nb\n','(?m)ab\\z') /* Result: n */;
1828regexp_like('ca\nb\n','(?m)ab\\z')
18290
1830select regexp_like('ca\nb\n','(?m)ab$') /* Result: n */;
1831regexp_like('ca\nb\n','(?m)ab$')
18320
1833select regexp_like('b\nca\n','(?m)ab\\Z') /* Result: n */;
1834regexp_like('b\nca\n','(?m)ab\\Z')
18350
1836select regexp_like('b\nca\n','(?m)ab\\z') /* Result: n */;
1837regexp_like('b\nca\n','(?m)ab\\z')
18380
1839select regexp_like('b\nca\n','(?m)ab$') /* Result: n */;
1840regexp_like('b\nca\n','(?m)ab$')
18410
1842select regexp_like('b\nca','(?m)ab\\Z') /* Result: n */;
1843regexp_like('b\nca','(?m)ab\\Z')
18440
1845select regexp_like('b\nca','(?m)ab\\z') /* Result: n */;
1846regexp_like('b\nca','(?m)ab\\z')
18470
1848select regexp_like('b\nca','(?m)ab$') /* Result: n */;
1849regexp_like('b\nca','(?m)ab$')
18500
1851select regexp_like('abb\nb\n','abb\\Z') /* Result: n */;
1852regexp_like('abb\nb\n','abb\\Z')
18530
1854select regexp_like('abb\nb\n','abb\\z') /* Result: n */;
1855regexp_like('abb\nb\n','abb\\z')
18560
1857select regexp_like('abb\nb\n','abb$') /* Result: n */;
1858regexp_like('abb\nb\n','abb$')
18590
1860select regexp_like('b\nabb\n','abb\\Z') /* Result: y */;
1861regexp_like('b\nabb\n','abb\\Z')
18621
1863select regexp_like('b\nabb\n','abb\\z') /* Result: n */;
1864regexp_like('b\nabb\n','abb\\z')
18650
1866select regexp_like('b\nabb\n','abb$') /* Result: y */;
1867regexp_like('b\nabb\n','abb$')
18681
1869select regexp_like('b\nabb','abb\\Z') /* Result: y */;
1870regexp_like('b\nabb','abb\\Z')
18711
1872select regexp_like('b\nabb','abb\\z') /* Result: y */;
1873regexp_like('b\nabb','abb\\z')
18741
1875select regexp_like('b\nabb','abb$') /* Result: y */;
1876regexp_like('b\nabb','abb$')
18771
1878select regexp_like('abb\nb\n','(?m)abb\\Z') /* Result: n */;
1879regexp_like('abb\nb\n','(?m)abb\\Z')
18800
1881select regexp_like('abb\nb\n','(?m)abb\\z') /* Result: n */;
1882regexp_like('abb\nb\n','(?m)abb\\z')
18830
1884select regexp_like('abb\nb\n','(?m)abb$') /* Result: y */;
1885regexp_like('abb\nb\n','(?m)abb$')
18861
1887select regexp_like('b\nabb\n','(?m)abb\\Z') /* Result: y */;
1888regexp_like('b\nabb\n','(?m)abb\\Z')
18891
1890select regexp_like('b\nabb\n','(?m)abb\\z') /* Result: n */;
1891regexp_like('b\nabb\n','(?m)abb\\z')
18920
1893select regexp_like('b\nabb\n','(?m)abb$') /* Result: y */;
1894regexp_like('b\nabb\n','(?m)abb$')
18951
1896select regexp_like('b\nabb','(?m)abb\\Z') /* Result: y */;
1897regexp_like('b\nabb','(?m)abb\\Z')
18981
1899select regexp_like('b\nabb','(?m)abb\\z') /* Result: y */;
1900regexp_like('b\nabb','(?m)abb\\z')
19011
1902select regexp_like('b\nabb','(?m)abb$') /* Result: y */;
1903regexp_like('b\nabb','(?m)abb$')
19041
1905select regexp_like('ac\nb\n','abb\\Z') /* Result: n */;
1906regexp_like('ac\nb\n','abb\\Z')
19070
1908select regexp_like('ac\nb\n','abb\\z') /* Result: n */;
1909regexp_like('ac\nb\n','abb\\z')
19100
1911select regexp_like('ac\nb\n','abb$') /* Result: n */;
1912regexp_like('ac\nb\n','abb$')
19130
1914select regexp_like('b\nac\n','abb\\Z') /* Result: n */;
1915regexp_like('b\nac\n','abb\\Z')
19160
1917select regexp_like('b\nac\n','abb\\z') /* Result: n */;
1918regexp_like('b\nac\n','abb\\z')
19190
1920select regexp_like('b\nac\n','abb$') /* Result: n */;
1921regexp_like('b\nac\n','abb$')
19220
1923select regexp_like('b\nac','abb\\Z') /* Result: n */;
1924regexp_like('b\nac','abb\\Z')
19250
1926select regexp_like('b\nac','abb\\z') /* Result: n */;
1927regexp_like('b\nac','abb\\z')
19280
1929select regexp_like('b\nac','abb$') /* Result: n */;
1930regexp_like('b\nac','abb$')
19310
1932select regexp_like('ac\nb\n','(?m)abb\\Z') /* Result: n */;
1933regexp_like('ac\nb\n','(?m)abb\\Z')
19340
1935select regexp_like('ac\nb\n','(?m)abb\\z') /* Result: n */;
1936regexp_like('ac\nb\n','(?m)abb\\z')
19370
1938select regexp_like('ac\nb\n','(?m)abb$') /* Result: n */;
1939regexp_like('ac\nb\n','(?m)abb$')
19400
1941select regexp_like('b\nac\n','(?m)abb\\Z') /* Result: n */;
1942regexp_like('b\nac\n','(?m)abb\\Z')
19430
1944select regexp_like('b\nac\n','(?m)abb\\z') /* Result: n */;
1945regexp_like('b\nac\n','(?m)abb\\z')
19460
1947select regexp_like('b\nac\n','(?m)abb$') /* Result: n */;
1948regexp_like('b\nac\n','(?m)abb$')
19490
1950select regexp_like('b\nac','(?m)abb\\Z') /* Result: n */;
1951regexp_like('b\nac','(?m)abb\\Z')
19520
1953select regexp_like('b\nac','(?m)abb\\z') /* Result: n */;
1954regexp_like('b\nac','(?m)abb\\z')
19550
1956select regexp_like('b\nac','(?m)abb$') /* Result: n */;
1957regexp_like('b\nac','(?m)abb$')
19580
1959select regexp_like('ca\nb\n','abb\\Z') /* Result: n */;
1960regexp_like('ca\nb\n','abb\\Z')
19610
1962select regexp_like('ca\nb\n','abb\\z') /* Result: n */;
1963regexp_like('ca\nb\n','abb\\z')
19640
1965select regexp_like('ca\nb\n','abb$') /* Result: n */;
1966regexp_like('ca\nb\n','abb$')
19670
1968select regexp_like('b\nca\n','abb\\Z') /* Result: n */;
1969regexp_like('b\nca\n','abb\\Z')
19700
1971select regexp_like('b\nca\n','abb\\z') /* Result: n */;
1972regexp_like('b\nca\n','abb\\z')
19730
1974select regexp_like('b\nca\n','abb$') /* Result: n */;
1975regexp_like('b\nca\n','abb$')
19760
1977select regexp_like('b\nca','abb\\Z') /* Result: n */;
1978regexp_like('b\nca','abb\\Z')
19790
1980select regexp_like('b\nca','abb\\z') /* Result: n */;
1981regexp_like('b\nca','abb\\z')
19820
1983select regexp_like('b\nca','abb$') /* Result: n */;
1984regexp_like('b\nca','abb$')
19850
1986select regexp_like('ca\nb\n','(?m)abb\\Z') /* Result: n */;
1987regexp_like('ca\nb\n','(?m)abb\\Z')
19880
1989select regexp_like('ca\nb\n','(?m)abb\\z') /* Result: n */;
1990regexp_like('ca\nb\n','(?m)abb\\z')
19910
1992select regexp_like('ca\nb\n','(?m)abb$') /* Result: n */;
1993regexp_like('ca\nb\n','(?m)abb$')
19940
1995select regexp_like('b\nca\n','(?m)abb\\Z') /* Result: n */;
1996regexp_like('b\nca\n','(?m)abb\\Z')
19970
1998select regexp_like('b\nca\n','(?m)abb\\z') /* Result: n */;
1999regexp_like('b\nca\n','(?m)abb\\z')
20000
2001select regexp_like('b\nca\n','(?m)abb$') /* Result: n */;
2002regexp_like('b\nca\n','(?m)abb$')
20030
2004select regexp_like('b\nca','(?m)abb\\Z') /* Result: n */;
2005regexp_like('b\nca','(?m)abb\\Z')
20060
2007select regexp_like('b\nca','(?m)abb\\z') /* Result: n */;
2008regexp_like('b\nca','(?m)abb\\z')
20090
2010select regexp_like('b\nca','(?m)abb$') /* Result: n */;
2011regexp_like('b\nca','(?m)abb$')
20120
2013select regexp_like('ca','(^|x)(c)') /* Result: y */;
2014regexp_like('ca','(^|x)(c)')
20151
2016select regexp_like('x','a*abc?xyz+pqr{3}ab{2,}xy{4,5}pq{0,6}AB{0,}zz') /* Result: n */;
2017regexp_like('x','a*abc?xyz+pqr{3}ab{2,}xy{4,5}pq{0,6}AB{0,}zz')
20180
2019select regexp_like('yabz','a(?{$a=2;$b=3;($b)=$a})b') /* Result: y */;
2020ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
2021select regexp_like('_I(round(xs * sz),1)','round\\(((?>[^()]+))\\)') /* Result: y */;
2022regexp_like('_I(round(xs * sz),1)','round\\(((?>[^()]+))\\)')
20231
2024select regexp_like('x ','(?x)((?x:.) )') /* Result: y */;
2025regexp_like('x ','(?x)((?x:.) )')
20261
2027select regexp_like('x ','(?x)((?-x:.) )') /* Result: y */;
2028regexp_like('x ','(?x)((?-x:.) )')
20291
2030select regexp_like('foo.bart','foo.bart') /* Result: y */;
2031regexp_like('foo.bart','foo.bart')
20321
2033select regexp_like('abcd\ndxxx','(?m)^d[x][x][x]') /* Result: y */;
2034regexp_like('abcd\ndxxx','(?m)^d[x][x][x]')
20351
2036select regexp_like('xxxtt','tt+$') /* Result: y */;
2037regexp_like('xxxtt','tt+$')
20381
2039select regexp_like('za-9z','([a\\-\\d]+)') /* Result: yi */;
2040regexp_like('za-9z','([a\\-\\d]+)')
20411
2042select regexp_like('a0-za','([\\d-z]+)') /* Result: y */;
2043regexp_like('a0-za','([\\d-z]+)')
20441
2045select regexp_like('a0- z','([\\d-\\s]+)') /* Result: y */;
2046regexp_like('a0- z','([\\d-\\s]+)')
20471
2048select regexp_like('za-9z','([a-[:digit:]]+)') /* Result: y */;
2049regexp_like('za-9z','([a-[:digit:]]+)')
20501
2051select regexp_like('=0-z=','([[:digit:]-z]+)') /* Result: y */;
2052regexp_like('=0-z=','([[:digit:]-z]+)')
20531
2054select regexp_like('=0-z=','([[:digit:]-[:alpha:]]+)') /* Result: iy */;
2055regexp_like('=0-z=','([[:digit:]-[:alpha:]]+)')
20561
2057select regexp_like('aaaXbX','\\GX.*X') /* Result: n */;
2058regexp_like('aaaXbX','\\GX.*X')
20590
2060select regexp_like('3.1415926','(\\d+\\.\\d+)') /* Result: y */;
2061regexp_like('3.1415926','(\\d+\\.\\d+)')
20621
2063select regexp_like('have a web browser','(\\ba.{0,10}br)') /* Result: y */;
2064regexp_like('have a web browser','(\\ba.{0,10}br)')
20651
2066select regexp_like('Changes','(?i)\\.c(pp|xx|c)?$') /* Result: n */;
2067regexp_like('Changes','(?i)\\.c(pp|xx|c)?$')
20680
2069select regexp_like('IO.c','(?i)\\.c(pp|xx|c)?$') /* Result: y */;
2070regexp_like('IO.c','(?i)\\.c(pp|xx|c)?$')
20711
2072select regexp_like('IO.c','(?i)(\\.c(pp|xx|c)?$)') /* Result: y */;
2073regexp_like('IO.c','(?i)(\\.c(pp|xx|c)?$)')
20741
2075select regexp_like('C:/','^([a-z]:)') /* Result: n */;
2076regexp_like('C:/','^([a-z]:)')
20771
2078select regexp_like('\nx aa','(?m)^\\S\\s+aa$') /* Result: y */;
2079regexp_like('\nx aa','(?m)^\\S\\s+aa$')
20801
2081select regexp_like('ab','(^|a)b') /* Result: y */;
2082regexp_like('ab','(^|a)b')
20831
2084select regexp_like('abac','^([ab]*?)(b)?(c)$') /* Result: y */;
2085regexp_like('abac','^([ab]*?)(b)?(c)$')
20861
2087select regexp_like('abcab','(\\w)?(abc)\\1b') /* Result: n */;
2088regexp_like('abcab','(\\w)?(abc)\\1b')
20890
2090select regexp_like('a,b,c','^(?:.,){2}c') /* Result: y */;
2091regexp_like('a,b,c','^(?:.,){2}c')
20921
2093select regexp_like('a,b,c','^(.,){2}c') /* Result: y */;
2094regexp_like('a,b,c','^(.,){2}c')
20951
2096select regexp_like('a,b,c','^(?:[^,]*,){2}c') /* Result: y */;
2097regexp_like('a,b,c','^(?:[^,]*,){2}c')
20981
2099select regexp_like('a,b,c','^([^,]*,){2}c') /* Result: y */;
2100regexp_like('a,b,c','^([^,]*,){2}c')
21011
2102select regexp_like('aaa,b,c,d','^([^,]*,){3}d') /* Result: y */;
2103regexp_like('aaa,b,c,d','^([^,]*,){3}d')
21041
2105select regexp_like('aaa,b,c,d','^([^,]*,){3,}d') /* Result: y */;
2106regexp_like('aaa,b,c,d','^([^,]*,){3,}d')
21071
2108select regexp_like('aaa,b,c,d','^([^,]*,){0,3}d') /* Result: y */;
2109regexp_like('aaa,b,c,d','^([^,]*,){0,3}d')
21101
2111select regexp_like('aaa,b,c,d','^([^,]{1,3},){3}d') /* Result: y */;
2112regexp_like('aaa,b,c,d','^([^,]{1,3},){3}d')
21131
2114select regexp_like('aaa,b,c,d','^([^,]{1,3},){3,}d') /* Result: y */;
2115regexp_like('aaa,b,c,d','^([^,]{1,3},){3,}d')
21161
2117select regexp_like('aaa,b,c,d','^([^,]{1,3},){0,3}d') /* Result: y */;
2118regexp_like('aaa,b,c,d','^([^,]{1,3},){0,3}d')
21191
2120select regexp_like('aaa,b,c,d','^([^,]{1,},){3}d') /* Result: y */;
2121regexp_like('aaa,b,c,d','^([^,]{1,},){3}d')
21221
2123select regexp_like('aaa,b,c,d','^([^,]{1,},){3,}d') /* Result: y */;
2124regexp_like('aaa,b,c,d','^([^,]{1,},){3,}d')
21251
2126select regexp_like('aaa,b,c,d','^([^,]{1,},){0,3}d') /* Result: y */;
2127regexp_like('aaa,b,c,d','^([^,]{1,},){0,3}d')
21281
2129select regexp_like('aaa,b,c,d','^([^,]{0,3},){3}d') /* Result: y */;
2130regexp_like('aaa,b,c,d','^([^,]{0,3},){3}d')
21311
2132select regexp_like('aaa,b,c,d','^([^,]{0,3},){3,}d') /* Result: y */;
2133regexp_like('aaa,b,c,d','^([^,]{0,3},){3,}d')
21341
2135select regexp_like('aaa,b,c,d','^([^,]{0,3},){0,3}d') /* Result: y */;
2136regexp_like('aaa,b,c,d','^([^,]{0,3},){0,3}d')
21371
2138select regexp_like('','(?i)') /* Result: y */;
2139regexp_like('','(?i)')
21401
2141select regexp_like('a\nxb\n','(?m)(?!\\A)x') /* Result: y */;
2142regexp_like('a\nxb\n','(?m)(?!\\A)x')
21431
2144select regexp_like('aba','^(a(b)?)+$') /* Result: yi */;
2145regexp_like('aba','^(a(b)?)+$')
21461
2147select regexp_like('123\nabcabcabcabc\n','(?m)^.{9}abc.*\n') /* Result: y */;
2148regexp_like('123\nabcabcabcabc\n','(?m)^.{9}abc.*\n')
21491
2150select regexp_like('a','^(a)?a$') /* Result: y */;
2151regexp_like('a','^(a)?a$')
21521
2153select regexp_like('a','^(a)?(?(1)a|b)+$') /* Result: n */;
2154ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
2155select regexp_like('aaaaaa','^(a\\1?)(a\\1?)(a\\2?)(a\\3?)$') /* Result: y */;
2156regexp_like('aaaaaa','^(a\\1?)(a\\1?)(a\\2?)(a\\3?)$')
21571
2158select regexp_like('aaaaaa','^(a\\1?){4}$') /* Result: y */;
2159regexp_like('aaaaaa','^(a\\1?){4}$')
21601
2161select regexp_like('x1','^(0+)?(?:x(1))?') /* Result: y */;
2162regexp_like('x1','^(0+)?(?:x(1))?')
21631
2164select regexp_like('012cxx0190','^([0-9a-fA-F]+)(?:x([0-9a-fA-F]+)?)(?:x([0-9a-fA-F]+))?') /* Result: y */;
2165regexp_like('012cxx0190','^([0-9a-fA-F]+)(?:x([0-9a-fA-F]+)?)(?:x([0-9a-fA-F]+))?')
21661
2167select regexp_like('bbbac','^(b+?|a){1,2}c') /* Result: y */;
2168regexp_like('bbbac','^(b+?|a){1,2}c')
21691
2170select regexp_like('bbbbac','^(b+?|a){1,2}c') /* Result: y */;
2171regexp_like('bbbbac','^(b+?|a){1,2}c')
21721
2173select regexp_like('cd. (A. Tw)','\\((\\w\\. \\w+)\\)') /* Result: y */;
2174regexp_like('cd. (A. Tw)','\\((\\w\\. \\w+)\\)')
21751
2176select regexp_like('aaaacccc','((?:aaaa|bbbb)cccc)?') /* Result: y */;
2177regexp_like('aaaacccc','((?:aaaa|bbbb)cccc)?')
21781
2179select regexp_like('bbbbcccc','((?:aaaa|bbbb)cccc)?') /* Result: y */;
2180regexp_like('bbbbcccc','((?:aaaa|bbbb)cccc)?')
21811
2182select regexp_like('a','(a)?(a)+') /* Result: y */;
2183regexp_like('a','(a)?(a)+')
21841
2185select regexp_like('ab','(ab)?(ab)+') /* Result: y */;
2186regexp_like('ab','(ab)?(ab)+')
21871
2188select regexp_like('abc','(abc)?(abc)+') /* Result: y */;
2189regexp_like('abc','(abc)?(abc)+')
21901
2191select regexp_like('a\nb\n','(?m)b\\s^') /* Result: n */;
2192regexp_like('a\nb\n','(?m)b\\s^')
21930
2194select regexp_like('a','\\ba') /* Result: y */;
2195regexp_like('a','\\ba')
21961
2197select regexp_like('ab','^(a(??{"(?!)"})|(a)(?{1}))b') /* Result: yi */;
2198ERROR HY000: Syntax error in regular expression on line 1, character 6.
2199select regexp_like('AbCd','ab(?i)cd') /* Result: n */;
2200regexp_like('AbCd','ab(?i)cd')
22011
2202select regexp_like('abCd','ab(?i)cd') /* Result: y */;
2203regexp_like('abCd','ab(?i)cd')
22041
2205select regexp_like('CD','(A|B)*(?(1)(CD)|(CD))') /* Result: y */;
2206ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
2207select regexp_like('ABCD','(A|B)*(?(1)(CD)|(CD))') /* Result: y */;
2208ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
2209select regexp_like('CD','(A|B)*?(?(1)(CD)|(CD))') /* Result: y */;
2210ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
2211select regexp_like('ABCD','(A|B)*?(?(1)(CD)|(CD))') /* Result: y */;
2212ERROR HY000: The regular expression contains a feature that is not implemented in this library version.
2213select regexp_like('Oo','(?i)^(o)(?!.*\\1)') /* Result: n */;
2214regexp_like('Oo','(?i)^(o)(?!.*\\1)')
22150
2216select regexp_like('abc12bc','(.*)\\d+\\1') /* Result: y */;
2217regexp_like('abc12bc','(.*)\\d+\\1')
22181
2219select regexp_like('foo\n bar','(?m:(foo\\s*$))') /* Result: y */;
2220regexp_like('foo\n bar','(?m:(foo\\s*$))')
22211
2222select regexp_like('abcd','(.*)c') /* Result: y */;
2223regexp_like('abcd','(.*)c')
22241
2225select regexp_like('abcd','(.*)(?=c)') /* Result: y */;
2226regexp_like('abcd','(.*)(?=c)')
22271
2228select regexp_like('abcd','(.*)(?=c)c') /* Result: yB */;
2229regexp_like('abcd','(.*)(?=c)c')
22301
2231select regexp_like('abcd','(.*)(?=b|c)') /* Result: y */;
2232regexp_like('abcd','(.*)(?=b|c)')
22331
2234select regexp_like('abcd','(.*)(?=b|c)c') /* Result: y */;
2235regexp_like('abcd','(.*)(?=b|c)c')
22361
2237select regexp_like('abcd','(.*)(?=c|b)') /* Result: y */;
2238regexp_like('abcd','(.*)(?=c|b)')
22391
2240select regexp_like('abcd','(.*)(?=c|b)c') /* Result: y */;
2241regexp_like('abcd','(.*)(?=c|b)c')
22421
2243select regexp_like('abcd','(.*)(?=[bc])') /* Result: y */;
2244regexp_like('abcd','(.*)(?=[bc])')
22451
2246select regexp_like('abcd','(.*)(?=[bc])c') /* Result: yB */;
2247regexp_like('abcd','(.*)(?=[bc])c')
22481
2249select regexp_like('abcd','(.*)(?<=b)') /* Result: y */;
2250regexp_like('abcd','(.*)(?<=b)')
22511
2252select regexp_like('abcd','(.*)(?<=b)c') /* Result: y */;
2253regexp_like('abcd','(.*)(?<=b)c')
22541
2255select regexp_like('abcd','(.*)(?<=b|c)') /* Result: y */;
2256regexp_like('abcd','(.*)(?<=b|c)')
22571
2258select regexp_like('abcd','(.*)(?<=b|c)c') /* Result: y */;
2259regexp_like('abcd','(.*)(?<=b|c)c')
22601
2261select regexp_like('abcd','(.*)(?<=c|b)') /* Result: y */;
2262regexp_like('abcd','(.*)(?<=c|b)')
22631
2264select regexp_like('abcd','(.*)(?<=c|b)c') /* Result: y */;
2265regexp_like('abcd','(.*)(?<=c|b)c')
22661
2267select regexp_like('abcd','(.*)(?<=[bc])') /* Result: y */;
2268regexp_like('abcd','(.*)(?<=[bc])')
22691
2270select regexp_like('abcd','(.*)(?<=[bc])c') /* Result: y */;
2271regexp_like('abcd','(.*)(?<=[bc])c')
22721
2273select regexp_like('abcd','(.*?)c') /* Result: y */;
2274regexp_like('abcd','(.*?)c')
22751
2276select regexp_like('abcd','(.*?)(?=c)') /* Result: y */;
2277regexp_like('abcd','(.*?)(?=c)')
22781
2279select regexp_like('abcd','(.*?)(?=c)c') /* Result: yB */;
2280regexp_like('abcd','(.*?)(?=c)c')
22811
2282select regexp_like('abcd','(.*?)(?=b|c)') /* Result: y */;
2283regexp_like('abcd','(.*?)(?=b|c)')
22841
2285select regexp_like('abcd','(.*?)(?=b|c)c') /* Result: y */;
2286regexp_like('abcd','(.*?)(?=b|c)c')
22871
2288select regexp_like('abcd','(.*?)(?=c|b)') /* Result: y */;
2289regexp_like('abcd','(.*?)(?=c|b)')
22901
2291select regexp_like('abcd','(.*?)(?=c|b)c') /* Result: y */;
2292regexp_like('abcd','(.*?)(?=c|b)c')
22931
2294select regexp_like('abcd','(.*?)(?=[bc])') /* Result: y */;
2295regexp_like('abcd','(.*?)(?=[bc])')
22961
2297select regexp_like('abcd','(.*?)(?=[bc])c') /* Result: yB */;
2298regexp_like('abcd','(.*?)(?=[bc])c')
22991
2300select regexp_like('abcd','(.*?)(?<=b)') /* Result: y */;
2301regexp_like('abcd','(.*?)(?<=b)')
23021
2303select regexp_like('abcd','(.*?)(?<=b)c') /* Result: y */;
2304regexp_like('abcd','(.*?)(?<=b)c')
23051
2306select regexp_like('abcd','(.*?)(?<=b|c)') /* Result: y */;
2307regexp_like('abcd','(.*?)(?<=b|c)')
23081
2309select regexp_like('abcd','(.*?)(?<=b|c)c') /* Result: y */;
2310regexp_like('abcd','(.*?)(?<=b|c)c')
23111
2312select regexp_like('abcd','(.*?)(?<=c|b)') /* Result: y */;
2313regexp_like('abcd','(.*?)(?<=c|b)')
23141
2315select regexp_like('abcd','(.*?)(?<=c|b)c') /* Result: y */;
2316regexp_like('abcd','(.*?)(?<=c|b)c')
23171
2318select regexp_like('abcd','(.*?)(?<=[bc])') /* Result: y */;
2319regexp_like('abcd','(.*?)(?<=[bc])')
23201
2321select regexp_like('abcd','(.*?)(?<=[bc])c') /* Result: y */;
2322regexp_like('abcd','(.*?)(?<=[bc])c')
23231
2324select regexp_like('2','2(]*)?$\\1') /* Result: y */;
2325regexp_like('2','2(]*)?$\\1')
23261
2327select regexp_like('x','(??{})') /* Result: yi */;
2328ERROR HY000: Syntax error in regular expression on line 1, character 3.
2329