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