AWS redshift documentation change
Summary
Updated COLLATE syntax documentation to include abbreviations (CS/CI) and clarify case sensitivity terminology
Security assessment
Changes are syntax clarifications and documentation improvements without any security-specific context or vulnerability mentions
Diff
diff --git a/redshift/latest/dg/r_CREATE_TABLE_NEW.md b/redshift/latest/dg/r_CREATE_TABLE_NEW.md index 32fc4bbb2..20779ecb2 100644 --- a//redshift/latest/dg/r_CREATE_TABLE_NEW.md +++ b//redshift/latest/dg/r_CREATE_TABLE_NEW.md @@ -43 +43 @@ Following are required privileges for CREATE TABLE: - [ COLLATE CASE_SENSITIVE | COLLATE CASE_INSENSITIVE ] + [ COLLATE { CASE_SENSITIVE | CS | CASE_INSENSITIVE | CI } ] @@ -248 +248 @@ The data type of a sort key column can be: BOOLEAN, REAL, DOUBLE PRECISION, SMAL -COLLATE CASE_SENSITIVE | COLLATE CASE_INSENSITIVE +COLLATE { CASE_SENSITIVE | CS | CASE_INSENSITIVE | CI } @@ -251 +251 @@ COLLATE CASE_SENSITIVE | COLLATE 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. @@ -262,0 +263,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. + @@ -450 +452 @@ COLLATE CASE_SENSITIVE | COLLATE CASE_INSENSITIVE -Amazon Redshift doesn't support altering case-sensitivity configuration for a column. When you append a new column to the table, Amazon Redshift uses the default value for case-sensitivity. Amazon Redshift doesn't support the COLLATE key word when appending a new column. +Amazon Redshift doesn't support altering case sensitivity configuration for a column. When you append a new column to the table, Amazon Redshift uses the default value for case sensitivity. Amazon Redshift doesn't support the COLLATE key word when appending a new column.