update Message guide and rewording of error message body
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/c83581ca Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/c83581ca Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/c83581ca Branch: refs/heads/master Commit: c83581ca08384bbd1936274ac92eb7c583defc40 Parents: 5f5808a Author: Liu Ming <[email protected]> Authored: Tue Feb 6 07:33:11 2018 +0000 Committer: Liu Ming <[email protected]> Committed: Tue Feb 6 07:33:11 2018 +0000 ---------------------------------------------------------------------- core/sql/bin/SqlciErrors.txt | 2 +- .../src/asciidoc/_chapters/ddl_msgs.adoc | 18 ++++++++++++++++++ 2 files changed, 19 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/c83581ca/core/sql/bin/SqlciErrors.txt ---------------------------------------------------------------------- diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt index 4ef465a..c79010b 100644 --- a/core/sql/bin/SqlciErrors.txt +++ b/core/sql/bin/SqlciErrors.txt @@ -140,7 +140,7 @@ 1138 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused --- 1139 ZZZZZ 99999 BEGINNER MAJOR DBADMIN System-generated column $0~ColumnName of base table $1~TableName cannot appear in the search condition of a check constraint definition. 1140 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Row-length $0~int0 exceeds the maximum allowed row-length of $1~int1 for table $2~TableName. -1141 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Key-length $0~int0 exceeds the maximum allowed rowkey length $1~int1. +1141 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Key length $0-int0 exceeds the maximum allowed key length of $1~int1 1142 0A000 99999 BEGINNER MAJOR DBADMIN --- unused --- 1143 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Validation for constraint $0~ConstraintName failed; incompatible data exists in referencing base table $1~TableName and referenced base table $2~String0. To display the data that violates the constraint, please use the following DML statement: $3~String1 1144 ZZZZZ 99999 BEGINNER MAJOR DBADMIN A quoted string was expected in first key clause for column $0~ColumnName on table $1~TableName, but the value detected is ($2~String0). http://git-wip-us.apache.org/repos/asf/trafodion/blob/c83581ca/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc ---------------------------------------------------------------------- diff --git a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc index e9ce886..5d2b6b3 100644 --- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc +++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc @@ -1526,6 +1526,24 @@ exceeds the maximum allowed row size. *Recovery:* See the {docs-url}/sql_reference/index.html[_{project-name} SQL Reference Manual_] for row size limit calculations. Change the column definitions and reissue the statement. +[[SQL-1141]] +== SQL 1141 + +``` +Key length <actual-key-length> exceeds the maximum allowed key length of <maximum-key-length>. +``` + +Where <actual-key-length> is the summary length of all the primary key for the given table. + +Where <maximum-key-length> is the largest key size allowed according to the underlying storage engine. + +*Cause:* On a CREATE TABLE statement, the size of the primary key total size in bytes +exceeds the maximum allowed key size. + +*Effect:* The operation fails. + +*Recovery:* See the error message for the maximum allowed key size, change the column definitions and reissue the statement. + <<< [[SQL-1143]] == SQL 1143
