github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/prepare/prepare_like.result (about)

     1  drop table if exists t1;
     2  create table t1 (str1 varchar(25),str2 char(25));
     3  insert into t1 values('a1','b1'),('a2', 'b2'),('%str1%', '%str2%'),('?','???');
     4  prepare p1 from 'select * from t1 where str1 like "%\%%"';
     5  execute p1;
     6  str1    str2
     7  %str1%    %str2%
     8  deallocate prepare p1;
     9  prepare p2 from 'select * from t1 where str1 like "%\%"';
    10  execute p2;
    11  str1    str2
    12  %str1%    %str2%
    13  deallocate prepare p2;
    14  prepare p3 from 'select * from t1 where str1 like "\%%"';
    15  execute p3;
    16  str1    str2
    17  %str1%    %str2%
    18  deallocate prepare p3;
    19  prepare p4 from 'select * from t1 where str1 like "%"';
    20  execute p4;
    21  str1    str2
    22  a1    b1
    23  a2    b2
    24  %str1%    %str2%
    25  ?    ???
    26  deallocate prepare p4;
    27  prepare p5 from 'select * from t1 where str1 like "\%str1\%"';
    28  execute p5;
    29  str1    str2
    30  %str1%    %str2%
    31  deallocate prepare p5;
    32  prepare p6 from 'select * from t1 where str1 like "%?%"';
    33  execute p6;
    34  str1    str2
    35  ?    ???
    36  deallocate prepare p6;
    37  prepare p7 from 'select * from t1 where str1 like ?';
    38  execute p7;
    39  invalid input: Incorrect arguments to EXECUTE
    40  deallocate prepare p7;
    41  prepare p8 from 'select * from t1 where str1 like "?"';
    42  execute p8;
    43  str1    str2
    44  ?    ???
    45  deallocate prepare p8;
    46  prepare s2 from 'select * from t1 where str1 like ?';
    47  set @b1='%1%';
    48  execute s2 using @b1;
    49  str1    str2
    50  a1    b1
    51  %str1%    %str2%
    52  set @b2='%1';
    53  execute s2 using @b2;
    54  str1    str2
    55  a1    b1
    56  set @b3='1%';
    57  execute s2 using @b3;
    58  str1    str2
    59  set @b4='%str%';
    60  execute s2 using @b4;
    61  str1    str2
    62  %str1%    %str2%
    63  set @b5='%str';
    64  execute s2 using @b5;
    65  str1    str2
    66  set @b6='str%';
    67  execute s2 using @b6;
    68  str1    str2
    69  set @b7='\%str%';
    70  execute s2 using @b7;
    71  str1    str2
    72  %str1%    %str2%
    73  set @b8='%str1\%';
    74  execute s2 using @b8;
    75  str1    str2
    76  %str1%    %str2%
    77  set @b9='%\%str%';
    78  execute s2 using @b9;
    79  str1    str2
    80  %str1%    %str2%
    81  set @b10='%str1\%%';
    82  execute s2 using @b10;
    83  str1    str2
    84  %str1%    %str2%
    85  set @b11='%\%str%\%';
    86  execute s2 using @b11;
    87  str1    str2
    88  %str1%    %str2%
    89  deallocate prepare s2;