AWS clean-rooms documentation change
Summary
Removed all references to ILIKE operator and case-insensitive pattern matching, consolidating documentation around case-sensitive LIKE operator
Security assessment
Changes remove deprecated ILIKE functionality but do not address security vulnerabilities or introduce security features. This is a documentation refinement for functionality deprecation.
Diff
diff --git a/clean-rooms/latest/sql-reference/patternmatching_condition_like.md b/clean-rooms/latest/sql-reference/patternmatching_condition_like.md index 83e5b49cb..6d3910477 100644 --- a//clean-rooms/latest/sql-reference/patternmatching_condition_like.md +++ b//clean-rooms/latest/sql-reference/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](./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](./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 +96 @@ 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: +The following example finds cities whose third and fourth characters are "ea". : @@ -100 +99 @@ The following example finds cities whose third and fourth characters are "ea". T - select distinct city from users where city ilike '__EA%' order by city; + select distinct city from users where city like '__EA%' order by city; @@ -147,13 +145,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 - -