You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2017/01/26 18:33:48 UTC
[1/2] incubator-trafodion git commit: [TRAFODION-2398] Update
Messages Guide for messages 1100-1108 as needed
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 <db...@apache.org>
Authored: Thu Jan 26 00:31:04 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
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
[2/2] incubator-trafodion git commit: Merge [TRAFODION-2398] PR 930
Update Messages Guide for msgs 1100-1108
Posted by db...@apache.org.
Merge [TRAFODION-2398] PR 930 Update Messages Guide for msgs 1100-1108
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/ad6e7528
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/ad6e7528
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/ad6e7528
Branch: refs/heads/master
Commit: ad6e7528afa71a72a1737733a2f58d75dad65981
Parents: 660c80e 7c3ae27
Author: Dave Birdsall <db...@apache.org>
Authored: Thu Jan 26 18:32:52 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Thu Jan 26 18:32:52 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(-)
----------------------------------------------------------------------