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

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