AWS redshift documentation change
Summary
Added CS/CI abbreviations to COLLATE clause and updated case sensitivity description
Security assessment
Syntax update for database creation COLLATE options and clarification of default case sensitivity behavior. No security implications identified.
Diff
diff --git a/redshift/latest/dg/r_CREATE_DATABASE.md b/redshift/latest/dg/r_CREATE_DATABASE.md index 79314b41a..0682ff65e 100644 --- a//redshift/latest/dg/r_CREATE_DATABASE.md +++ b//redshift/latest/dg/r_CREATE_DATABASE.md @@ -33 +33 @@ You can't run CREATE DATABASE within a transaction block (BEGIN ... END). For mo - [ COLLATE { CASE_SENSITIVE | CASE_INSENSITIVE } ] + [ COLLATE { CASE_SENSITIVE | CS | CASE_INSENSITIVE | CI } ] @@ -106 +106 @@ If both user and database connection limits apply, an unused connection slot mus -COLLATE { CASE_SENSITIVE | CASE_INSENSITIVE } +COLLATE { CASE_SENSITIVE | CS | CASE_INSENSITIVE | CI } @@ -109 +109 @@ COLLATE { CASE_SENSITIVE | CASE_INSENSITIVE } -A clause that specifies whether string search or comparison is CASE_SENSITIVE or CASE_INSENSITIVE. The default is CASE_SENSITIVE. +A clause that specifies whether string search or comparison is case sensitive or case insensitive. The default is case sensitive. @@ -112,0 +113,2 @@ COLLATE is not supported when you create a database from a datashare. +CASE_SENSITIVE and CS are interchangeable and yield the same results. Similarly, CASE_INSENSITIVE and CI are interchangeable and yield the same results. +