Repository: incubator-trafodion Updated Branches: refs/heads/master 660c80e33 -> ad6e7528a
[TRAFODION-2398] Update Messages Guide for messages 1100-1108 as needed Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/7c3ae27b Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/7c3ae27b Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/7c3ae27b Branch: refs/heads/master Commit: 7c3ae27b4634ef1a26b39f7a92fbff58c94f8ee9 Parents: 660c80e Author: Dave Birdsall <[email protected]> Authored: Thu Jan 26 00:31:04 2017 +0000 Committer: Dave Birdsall <[email protected]> Committed: Thu Jan 26 00:31:04 2017 +0000 ---------------------------------------------------------------------- core/sql/bin/SqlciErrors.txt | 16 +++---- core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 15 +++--- .../src/asciidoc/_chapters/ddl_msgs.adoc | 48 +++----------------- 3 files changed, 22 insertions(+), 57 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7c3ae27b/core/sql/bin/SqlciErrors.txt ---------------------------------------------------------------------- diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt index da97b54..beaf34c 100644 --- a/core/sql/bin/SqlciErrors.txt +++ b/core/sql/bin/SqlciErrors.txt @@ -99,14 +99,14 @@ 1097 ZZZZZ 99999 BEGINNER MINOR DBADMIN The specified partition $0~String0 does not exist. 1098 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Partition key ($0~String0) already specified for object $1~TableName. 1099 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Column $0~Int0 is unnamed. You must specify an AS clause for that column expression, or name all the columns by specifying a view column list. -1100 ZZZZZ 99999 ADVANCED MAJOR DBADMIN LOB Column $0~ColumnName cannot be specified in alter operation -1101 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Table $0~TableName could not be updated. $1~String0$2~String1 -1102 ZZZZZ 99999 ADVANCED CRTCL DIALOUT Rows could not be inserted into table $0~TableName. $1~String0$2~String1 -1103 ZZZZZ 99999 ADVANCED CRTCL DIALOUT Rows could not be deleted from table $0~TableName. $1~String0$2~String1 -1104 ZZZZZ 99999 BEGINNER MINOR DBADMIN Default value string is too long for column $0~ColumnName. -1105 ZZZZZ 99999 BEGINNER MINOR DBADMIN CREATE TABLE LIKE statement cannot contain both HORIZONTAL PARTITIONS and STORE BY clauses. -1106 ZZZZZ 99999 BEGINNER MINOR DBADMIN The specified partition $0~String0 of object $1~TableName does not exist. -1107 ZZZZZ 99999 BEGINNER MINOR DBADMIN SQL was not able to prepare the statement. +1100 ZZZZZ 99999 ADVANCED MAJOR DBADMIN LOB column $0~ColumnName cannot be specified in an alter operation. +1101 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused --- +1102 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused --- +1103 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused --- +1104 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused --- +1105 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused --- +1106 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused --- +1107 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused --- 1108 ZZZZZ 99999 BEGINNER MINOR DBADMIN The number of columns specified in the view column list, $0~Int0, does not match the degree of the query expression, $1~Int1. 1109 44000 99999 BEGINNER MINOR DBADMIN The WITH CHECK OPTION clause appears in the definition of view $0~TableName, but the view is not updatable. 1110 ZZZZZ 99999 ADVANCED MAJOR DIALOUT $0~String0 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7c3ae27b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h index fdfe6c3..2e99e09 100644 --- a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h +++ b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h @@ -132,14 +132,13 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000 , CAT_PARTITION_KEY_DUPLICATED = 1098 , CAT_VIEW_COLUMN_UNNAMED = 1099 , CAT_LOB_COLUMN_ALTER = 1100 - , CAT_SMDIO_UPDATE_ERROR = 1101 - , CAT_SMDIO_INSERT_ERROR = 1102 - , CAT_SMDIO_DELETE_ERROR = 1103 - , CAT_DEFAULT_VALUE_TOO_LONG = 1104 - , CAT_LIKE_CANNOT_CONTAIN_BOTH_STORE_BY_AND_HORIZONTAL_PARTITION - = 1105 - , CAT_PARTITION_KEY_OF_OBJ_NOT_EXIST = 1106 - , CAT_ERRORS_ENCOUNTERED_IN_PARSING_PHASE = 1107 + // unused = 1101 + // unused = 1102 + // unused = 1103 + // unused = 1104 + // unused = 1105 + // unused = 1106 + // unused = 1107 , CAT_NUM_OF_VIEW_COLS_NOT_MATCHED = 1108 , CAT_WITH_CK_OPT_IN_NOT_UPDATABLE_VIEW = 1109 , CAT_KLUDGE_TO_PRINT_TRACE_MESSAGE = 1110 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7c3ae27b/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 d7e4ffd..c681194 100644 --- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc +++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc @@ -1086,55 +1086,21 @@ which <column-number> was unnamed. unnamed column and resubmit. <<< -[[SQL-1104]] -== SQL 1104 +[[SQL-1100]] +== SQL 1100 ``` -Default value string is too long for column <column-name>. +LOB column <column-name> cannot be specified in an alter operation. ``` -Where <column-name> is the name of a character-type column for which a -default value is specified. - -*Cause:* The specified default value for <column-name> is longer than -the maximum of 239 characters. - -*Effect:* The operation fails. - -*Recovery:* Correct the error and resubmit. - -[[SQL-1105]] -== SQL 1105 - -``` -CREATE TABLE LIKE statement cannot contain both HORIZONTAL PARTITIONS and STORE BY clauses. -``` +Where <column-name> is the specified column. -*Cause:* A CREATE TABLE . . . LIKE statement specifies both the WITH -PARTITIONS and STORE BY clause, which is not allowed. +*Cause:* You attempted to perform an ALTER TABLE ALTER COLUMN statement +on a LOB column. This is not permitted. *Effect:* The operation fails. -*Recovery:* Correct the error and resubmit. - -<<< -[[SQL-1106]] -== SQL 1106 - -``` -The specified partition <partition-location> of object <table-name> does not exist. -``` - -Where <partition-location> is the location of the specified partition. - -Where <table-name> is the name of the table. - -*Cause:* The location name <partition-location> specified in the -partition operation does not exist. - -*Effect:* The partition operation fails. - -*Recovery:* Specify a valid partition location name and resubmit. +*Recovery:* If the column name is in error, correct and resubmit. [[SQL-1108]] == SQL 1108
