AWS redshift documentation change
Summary
Added CS/CI abbreviations to COLLATE clause and clarified case sensitivity description
Security assessment
Syntax update for COLLATE options and clarification of case sensitivity behavior. No security-related context provided in changes.
Diff
diff --git a/redshift/latest/dg/r_ALTER_TABLE.md b/redshift/latest/dg/r_ALTER_TABLE.md index fc58a31b9..ec980a1fb 100644 --- a//redshift/latest/dg/r_ALTER_TABLE.md +++ b//redshift/latest/dg/r_ALTER_TABLE.md @@ -57 +57 @@ The user that alters a table needs the proper privilege for the command to succe - [ COLLATE { CASE_SENSITIVE | CASE_INSENSITIVE } ] | + [ COLLATE { CASE_SENSITIVE | CS | CASE_INSENSITIVE | CI } ] | @@ -482 +482 @@ NOT NULL and NULL aren't supported for external tables. -COLLATE { CASE_SENSITIVE | CASE_INSENSITIVE } +COLLATE { CASE_SENSITIVE | CS | CASE_INSENSITIVE | CI } @@ -485 +485 @@ COLLATE { CASE_SENSITIVE | CASE_INSENSITIVE } -A clause that specifies whether string search or comparison on the column is CASE_SENSITIVE or CASE_INSENSITIVE. The default value is the same as the current case sensitivity configuration of the database. +A clause that specifies whether string search or comparison on the column is case sensitive or case insensitive. The default value is the same as the current case sensitivity configuration of the database. @@ -496,0 +497,2 @@ To find the database collation information, use the following command: +CASE_SENSITIVE and CS are interchangeable and yield the same results. Similarly, CASE_INSENSITIVE and CI are interchangeable and yield the same results. +