github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_regular_replace.result (about)

     1  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat','Cat', 'Tiger') 'Result';
     2  Result 
     3  Tiger Dog Tiger Dog Tiger
     4  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', 'Cow', 'Tiger') 'Result';
     5  Result
     6  Cat Dog Cat Dog Cat
     7  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', 'Cat', 'Tiger', 1, 2) 'Result';
     8  Result
     9  Cat Dog Tiger Dog Cat
    10  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', 'Cat', 'Tiger', 2, 1) 'Result';
    11  Result 
    12  Cat Dog Tiger Dog Cat
    13  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', 'Cat', 'Tiger', 2, 2) 'Result';
    14  Result
    15  Cat Dog Cat Dog Tiger
    16  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', 'Cat', 'Tiger', 1, 0) 'Result';
    17  Result
    18  Tiger Dog Tiger Dog Tiger
    19  SELECT REGEXP_REPLACE(NULL, 'Cow', 'Tiger');
    20  regexp_replace(null, Cow, Tiger)
    21  NULL
    22  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', NULL, 'Tiger');
    23  regexp_replace(Cat Dog Cat Dog Cat, null, Tiger)
    24  NULL
    25  SELECT REGEXP_REPLACE('Cat Dog Cat Dog Cat', 'Cow', NULL);
    26  regexp_replace(Cat Dog Cat Dog Cat, Cow, null) 
    27  NULL
    28  create table t1(a int, b varchar(100));
    29  insert into t1 values(1 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    30  insert into t1 values(2 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    31  insert into t1 values(3 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    32  insert into t1 values(4 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    33  insert into t1 values(5 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    34  insert into t1 values(6 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    35  insert into t1 values(7 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    36  insert into t1 values(8 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    37  SELECT a, REGEXP_REPLACE(b, 'Cat', 'tiger') from t1;
    38  a    regexp_replace(b, Cat, tiger)
    39  1    tiger Dog tiger Dog tiger tiger Dog tiger Dog tiger
    40  2    tiger Dog tiger Dog tiger tiger Dog tiger Dog tiger
    41  3    tiger Dog tiger Dog tiger tiger Dog tiger Dog tiger
    42  4    tiger Dog tiger Dog tiger tiger Dog tiger Dog tiger
    43  5    Dog tiger Dog tiger tiger Dog tiger Dog tiger tiger
    44  6    Dog tiger Dog tiger tiger Dog tiger Dog tiger tiger
    45  7    Dog tiger Dog tiger tiger Dog tiger Dog tiger tiger
    46  8    Dog tiger Dog tiger tiger Dog tiger Dog tiger tiger
    47  drop table t1;
    48  create table t1(a int, b varchar(100));
    49  insert into t1 values(1 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    50  insert into t1 values(2 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    51  insert into t1 values(3 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    52  insert into t1 values(4 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    53  insert into t1 values(5 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    54  insert into t1 values(6 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    55  insert into t1 values(7 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    56  insert into t1 values(8 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    57  SELECT a, REGEXP_REPLACE(b, 'Cat', 'pig', 3) from t1;
    58  a    regexp_replace(b, Cat, pig, 3)
    59  1    pig Dog pig Dog pig pig Dog pig Dog pig
    60  2    pig Dog pig Dog pig pig Dog pig Dog pig
    61  3    pig Dog pig Dog pig pig Dog pig Dog pig
    62  4    pig Dog pig Dog pig pig Dog pig Dog pig
    63  5    Dog pig Dog pig pig Dog pig Dog pig pig
    64  6    Dog pig Dog pig pig Dog pig Dog pig pig
    65  7    Dog pig Dog pig pig Dog pig Dog pig pig
    66  8    Dog pig Dog pig pig Dog pig Dog pig pig
    67  drop table t1;
    68  create table t1(a int, b varchar(100));
    69  insert into t1 values(1 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    70  insert into t1 values(2 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    71  insert into t1 values(3 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    72  insert into t1 values(4 , 'Cat Dog Cat Dog Cat Cat Dog Cat Dog Cat');
    73  insert into t1 values(5 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    74  insert into t1 values(6 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    75  insert into t1 values(7 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    76  insert into t1 values(8 , 'Dog Cat Dog Cat Cat Dog Cat Dog Cat Cat');
    77  SELECT a, REGEXP_REPLACE(b, 'Cat', 'taC', 3, 2) from t1;
    78  a    regexp_replace(b, Cat, taC, 3, 2)
    79  1    Cat Dog Cat Dog taC Cat Dog Cat Dog Cat
    80  2    Cat Dog Cat Dog taC Cat Dog Cat Dog Cat
    81  3    Cat Dog Cat Dog taC Cat Dog Cat Dog Cat
    82  4    Cat Dog Cat Dog taC Cat Dog Cat Dog Cat
    83  5    Dog Cat Dog taC Cat Dog Cat Dog Cat Cat
    84  6    Dog Cat Dog taC Cat Dog Cat Dog Cat Cat
    85  7    Dog Cat Dog taC Cat Dog Cat Dog Cat Cat
    86  8    Dog Cat Dog taC Cat Dog Cat Dog Cat Cat
    87  drop table t1;
    88  DROP TABLE IF EXISTS t;
    89  CREATE TABLE t(str1 VARCHAR(20), str2 CHAR(20));
    90  INSERT INTO t VALUES ('W * P', 'W + Z - O'), ('have has having', 'do does doing');
    91  INSERT INTO t VALUES ('XV*XZ', 'PP-ZZ-DXA'), ('aa bbb cc ddd', 'k ii lll oooo');
    92  SELECT REGEXP_REPLACE(str1, '*', 'i'), REGEXP_REPLACE(str2,'hav','hiv') FROM t;
    93  invalid argument regexp_replace have invalid regexp pattern arg, bad value [*]
    94  drop table t;