github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/custom_escape_character (about)

     1  query B
     2  SELECT '%' LIKE 't%' ESCAPE CASE WHEN (SELECT '-A' SIMILAR TO '--A' ESCAPE '-') THEN 't' ELSE 'f' END
     3  ----
     4  true
     5  
     6  query B
     7  SELECT '%' LIKE 't%' ESCAPE CASE WHEN (SELECT 'A' SIMILAR TO '-A' ESCAPE '') THEN 't' ELSE 'f' END
     8  ----
     9  false
    10  
    11  query B
    12  SELECT '%bC' ILIKE 't%Bc' ESCAPE CASE WHEN (SELECT 'A' ILIKE '-a' ESCAPE '-') THEN 't' ELSE 'f' END
    13  ----
    14  true
    15  
    16  query B
    17  SELECT 'A' LIKE '\A' ESCAPE '\'
    18  ----
    19  true
    20  
    21  query B
    22  SELECT 'A' LIKE '\A' ESCAPE ''
    23  ----
    24  false
    25  
    26  query B
    27  SELECT '%A' LIKE '_A' ESCAPE '%'
    28  ----
    29  true
    30  
    31  query B
    32  SELECT '%A' LIKE '%A' ESCAPE '%'
    33  ----
    34  false
    35  
    36  query B
    37  SELECT '%A' LIKE '%%A' ESCAPE '%'
    38  ----
    39  true
    40  
    41  query B
    42  SELECT '春A' LIKE '春春_' ESCAPE '春'
    43  ----
    44  true
    45  
    46  query error invalid escape string
    47  SELECT 'A' LIKE 'AA' ESCAPE 'AA'
    48  
    49  query error invalid escape string
    50  SELECT '春A' LIKE '春春_' ESCAPE '春春'
    51  
    52  query B
    53  SELECT 'A' SIMILAR TO '\A' ESCAPE '\'
    54  ----
    55  false
    56  
    57  query B
    58  SELECT '\A' SIMILAR TO '\A' ESCAPE ''
    59  ----
    60  true
    61  
    62  query B
    63  SELECT '%A' SIMILAR TO '_A' ESCAPE '%'
    64  ----
    65  true
    66  
    67  query B
    68  SELECT '%A' SIMILAR TO '%A' ESCAPE '%'
    69  ----
    70  false
    71  
    72  query B
    73  SELECT '123A_' SIMILAR TO '%A_' ESCAPE '_'
    74  ----
    75  false
    76  
    77  query B
    78  SELECT '123A_' SIMILAR TO '%A__' ESCAPE '_'
    79  ----
    80  true
    81  
    82  query B
    83  SELECT '春A' SIMILAR TO '春春_' ESCAPE '春'
    84  ----
    85  true
    86  
    87  query B
    88  SELECT '春A_春春' SIMILAR TO '%_春_%' ESCAPE '春'
    89  ----
    90  true
    91  
    92  query error invalid escape string
    93  SELECT 'A' SIMILAR TO 'AA' ESCAPE 'AA'
    94  
    95  query error invalid escape string
    96  SELECT '春A' SIMILAR TO '春春_' ESCAPE '春春'