AWS clean-rooms documentation change
Summary
Removed ILIKE operator documentation and related examples, aligning with case-sensitive LIKE operator changes
Security assessment
Consistency update to remove ILIKE references. No security implications identified in the change details.
Diff
diff --git a/clean-rooms/latest/sql-reference/r_patternmatching_condition_like.md b/clean-rooms/latest/sql-reference/r_patternmatching_condition_like.md index 5b22929ee..2daaeb050 100644 --- a//clean-rooms/latest/sql-reference/r_patternmatching_condition_like.md +++ b//clean-rooms/latest/sql-reference/r_patternmatching_condition_like.md @@ -11 +11 @@ The LIKE operator compares a string expression, such as a column name, with a pa -LIKE is case-sensitive; ILIKE is case-insensitive. +LIKE is case-sensitive. @@ -16 +16 @@ LIKE is case-sensitive; ILIKE is case-insensitive. - _expression_ [ NOT ] LIKE | ILIKE _pattern_ [ ESCAPE '_escape_char_ ' ] + _expression_ [ NOT ] LIKE | _pattern_ [ ESCAPE '_escape_char_ ' ] @@ -25 +25 @@ A valid UTF-8 character expression, such as a column name. -LIKE | ILIKE +LIKE @@ -28 +28 @@ LIKE | ILIKE -LIKE performs a case-sensitive pattern match. ILIKE performs a case-insensitive pattern match for single-byte UTF-8 (ASCII) characters. To perform a case-insensitive pattern match for multibyte characters, use the [LOWER](./r_LOWER.html) function on _expression_ and _pattern_ with a LIKE condition. +LIKE performs a case-sensitive pattern match. To perform a case-insensitive pattern match for multibyte characters, use the [LOWER](./r_LOWER.html) function on _expression_ and _pattern_ with a LIKE condition. @@ -30 +30 @@ LIKE performs a case-sensitive pattern match. ILIKE performs a case-insensitive -In contrast to comparison predicates, such as = and <>, LIKE and ILIKE predicates do not implicitly ignore trailing spaces. To ignore trailing spaces, use RTRIM or explicitly cast a CHAR column to VARCHAR. +In contrast to comparison predicates, such as = and <>, LIKE predicates don't implicitly ignore trailing spaces. To ignore trailing spaces, use RTRIM or explicitly cast a CHAR column to VARCHAR. @@ -32 +32 @@ In contrast to comparison predicates, such as = and <>, LIKE and ILIKE predicate -The `~~` operator is equivalent to LIKE, and `~~*` is equivalent to ILIKE. Also the `!~~` and `!~~*` operators are equivalent to NOT LIKE and NOT ILIKE. +The `~~` operator is equivalent to LIKE. Also the `!~~` operator is equivalent to NOT LIKE. @@ -64 +63,0 @@ Expression | Returns -`'abc' ILIKE '_B_'` | True @@ -97,15 +95,0 @@ The following example finds users whose last name contains "ten" : -The following example finds cities whose third and fourth characters are "ea". The command uses ILIKE to demonstrate case insensitivity: - - - select distinct city from users where city ilike '__EA%' order by city; - city - ------------- - Brea - Clearwater - Great Falls - Ocean City - Olean - Wheaton - (6 rows) - - @@ -147,13 +130,0 @@ The following example specifies '^' as the escape character, then uses the escap -The following example uses the `~~*` operator to do a case-insensitive (ILIKE) search for cities that start with "Ag". - - - select distinct city from users where city ~~* 'Ag%' order by city; - - city - ------------ - Agat - Agawam - Agoura Hills - Aguadilla - -