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/03/23 20:35:23 UTC
[1/2] incubator-trafodion git commit: [TRAFODION-2398] Edit some of
the messages in range 1111-1145
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 299b538b6 -> 0c6089d7a
[TRAFODION-2398] Edit some of the messages in range 1111-1145
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/91c8bae7
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/91c8bae7
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/91c8bae7
Branch: refs/heads/master
Commit: 91c8bae78f474c9a4158d3c51f7bf0d81e47c02f
Parents: 39de987
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Mar 22 20:50:49 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Mar 22 20:50:49 2017 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 38 +++----
core/sql/regress/seabase/EXPECTED020 | 4 +-
core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 30 ++---
.../src/asciidoc/_chapters/ddl_msgs.adoc | 111 ++-----------------
4 files changed, 48 insertions(+), 135 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/91c8bae7/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index 7e159cd..b03c922 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -110,41 +110,41 @@
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
-1111 25000 99999 BEGINNER CRTCL DIALOUT An error occurred while starting a transaction on object $0~TableName$1~String0$2~String1
-1112 ZZZZZ 99999 BEGINNER MINOR DBADMIN An index column list cannot contain only the system-generated column SYSKEY.
-1113 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU Alter View Compile Cascade failed for following View(s): $0~String0
+1111 25000 99999 BEGINNER CRTCL DIALOUT --- unused ---
+1112 ZZZZZ 99999 BEGINNER MINOR DBADMIN An index column list cannot consist only of the system-generated column SYSKEY.
+1113 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused ---
1114 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Metadata tables for catalog $0~CatalogName could not be created on $1~String0.
1115 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Label $0~String0 could not be created for $1~TableName (file error $2~NSKCode).
1116 ZZZZZ 99999 BEGINNER MINOR DBADMIN The current partitioning scheme requires a user-specified clustering key on object $0~TableName.
1117 ZZZZZ 99999 BEGINNER MINOR DBADMIN Dropping the only partition of an object is not allowed. At least two partitions must exist to perform the drop.
1118 ZZZZZ 99999 BEGINNER MINOR DBADMIN Creating object $0~TableName is not allowed in a reserved system schema.
1119 ZZZZZ 99999 BEGINNER MINOR DBADMIN Dropping metadata object $0~TableName is not allowed.
-1120 ZZZZZ 99999 BEGINNER MINOR DBADMIN Use of approximate numeric datatype (float, real, double precision) in a partitioning key or salt clause is not allowed.
+1120 ZZZZZ 99999 BEGINNER MINOR DBADMIN Use of an approximate numeric datatype (float, real, double precision) in a partitioning key or salt clause is not allowed.
1121 0A000 99999 BEGINNER MINOR DBADMIN Partitions cannot be added or dropped on table $0~TableName. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.
1122 ZZZZZ 99999 BEGINNER MINOR DBADMIN The number of specified partition key values ($0~String0) for object $1~TableName exceeds the number of user defined key columns, $2~Int0.
1123 42000 99999 BEGINNER MINOR DBADMIN Not all of the partition key values ($0~String0) for object $1~TableName could be processed. Please verify that the correct key value data types were specified.
-1124 ZZZZZ 99999 BEGINNER MINOR DBADMIN Metadata version is at $0~Int0. Upgrade/Downgrade to current version cannot be performed.
-1125 ZZZZZ 99999 ADVANCED CRTCL DIALOUT API request version number mismatch.
-1126 ZZZZZ 99999 BEGINNER MINOR DBADMIN $0~String0 failed.
+1124 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1125 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
+1126 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
1127 ZZZZZ 99999 BEGINNER MINOR DBADMIN The specified table $0~TableName does not exist, is inaccessible or is not a base table. Please verify that the correct table was specified.
-1128 ZZZZZ 99999 ADVANCED CRTCL DIALOUT An invalid API request was encountered. Details: $0~String0.
-1129 ZZZZZ 99999 BEGINNER MINOR DBADMIN This operation is not allowed on a vertically partitioned table.
+1128 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
+1129 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
1130 ZZZZZ 99999 BEGINNER MINOR DBADMIN The column requires a default value.
-1131 ZZZZZ 99999 BEGINNER MINOR DBADMIN There is an existing Trafodion external table, please drop it before dropping native table 0~TableName.
-1132 ZZZZZ 99999 BEGINNER MINOR DBADMIN An added column cannot have DEFAULT NULL and NOT NULL values at the same time.
-1133 ZZZZZ 99999 BEGINNER MINOR DBADMIN Only super ID can perform this operation.
-1134 ZZZZZ 99999 BEGINNER MINOR DBADMIN A concurrent utility or DDL operation is being performed on object $0~TableName, its parent, or one of its dependencies. That operation must complete before the requested operation can run.
+1131 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1132 ZZZZZ 99999 BEGINNER MINOR DBADMIN An added column cannot be declared with both DEFAULT NULL and NOT NULL.
+1133 ZZZZZ 99999 BEGINNER MINOR DBADMIN Only the super ID can perform this operation.
+1134 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
1135 ZZZZZ 99999 BEGINNER MINOR DBADMIN Clustering key column $0~ColumnName must be assigned a NOT NULL NOT DROPPABLE constraint.
1136 42000 99999 BEGINNER MINOR DBADMIN For an added column, the PRIMARY KEY clause cannot specify NOT DROPPABLE.
-1137 ZZZZZ 99999 ADVANCED CRTCL DIALOUT An internal error occurred: invalid index status. Details: $0~String0.
-1138 ZZZZZ 99999 ADVANCED CRTCL DIALOUT An internal error occurred: invalid input parameter(s). Object name and status are required.
+1137 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
+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 Label $0~String0 for $1~TableName could not be accessed. File system error: $2~NSKCode.
-1142 0A000 99999 BEGINNER MAJOR DBADMIN Because it is not audited, this table cannot have a column added that is declared NOT NULL or has a CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint.
-1143 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Validation of 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
+1141 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+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).
-1145 3D000 99999 BEGINNER MAJOR DBADMIN The catalog name $0~CatalogName is reserved for SQL metadata.
+1145 3D000 99999 BEGINNER MAJOR DBADMIN --- unused ---
1146 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~String0 could not be altered because it either does not exist or is not a table.
1147 ZZZZZ 99999 BEGINNER MINOR DBADMIN System-generated column $0~ColumnName of base table $1~TableName cannot appear in a unique or primary key constraint definition.
1148 23000 99999 BEGINNER MINOR DBADMIN System-generated column $0~ColumnName of base table $1~TableName cannot appear in a referential integrity constraint definition.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/91c8bae7/core/sql/regress/seabase/EXPECTED020
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED020 b/core/sql/regress/seabase/EXPECTED020
index 48cef66..15771ce 100644
--- a/core/sql/regress/seabase/EXPECTED020
+++ b/core/sql/regress/seabase/EXPECTED020
@@ -299,7 +299,7 @@ CREATE TABLE TRAFODION.SCH.TEST020T6
>>-- An index column list cannot consist only of the system-generated SYSKEY.
>>create index test020t6_ix1 on test020t6 (syskey);
-*** ERROR[1112] An index column list cannot contain only the system-generated column SYSKEY.
+*** ERROR[1112] An index column list cannot consist only of the system-generated column SYSKEY.
--- SQL operation failed with errors.
>>
@@ -467,7 +467,7 @@ A
>>--this alter should fail
>>alter table TEST020T31 add constraint C44B FOREIGN KEY (ssnum) references TEST020T30(ssnum);
-*** ERROR[1143] Validation of constraint TRAFODION.SCH.C44B failed; incompatible data exists in referencing base table TEST020T31 and referenced base table TEST020T30. To display the data that violates the constraint, please use the following DML statement: select count(*) from "TRAFODION"."SCH"."TEST020T31" where not (("SSNUM") in (select "SSNUM" from "TRAFODION"."SCH"."TEST020T30")) and "SSNUM" is not null ;
+*** ERROR[1143] Validation for constraint TRAFODION.SCH.C44B failed; incompatible data exists in referencing base table TEST020T31 and referenced base table TEST020T30. To display the data that violates the constraint, please use the following DML statement: select count(*) from "TRAFODION"."SCH"."TEST020T31" where not (("SSNUM") in (select "SSNUM" from "TRAFODION"."SCH"."TEST020T30")) and "SSNUM" is not null ;
--- SQL operation failed with errors.
>>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/91c8bae7/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
index 2e99e09..68d09c7 100644
--- a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
+++ b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
@@ -142,9 +142,9 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
, CAT_NUM_OF_VIEW_COLS_NOT_MATCHED = 1108
, CAT_WITH_CK_OPT_IN_NOT_UPDATABLE_VIEW = 1109
, CAT_KLUDGE_TO_PRINT_TRACE_MESSAGE = 1110
- , CAT_ERROR_IN_STARTING_TRANSACTION = 1111
+ // unused = 1111
, CAT_SYSKEY_ONLY_INDEXED_COLUMNS_LIST = 1112
- , CAT_UNABLE_TO_ALTER_VIEW_CASCADE = 1113
+ // unused = 1113
, CAT_UNABLE_TO_CREATE_METADATA = 1114
, CAT_UNABLE_TO_CREATE_LABEL = 1115
, CAT_RANGE_PARTITION_KEY_ERROR = 1116
@@ -154,28 +154,28 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
, CAT_INVALID_OPERATION = 1121
, CAT_TOO_MANY_KEY_VALUES = 1122
, CAT_INCORRECT_KEY_VALUES = 1123
- , CAT_WRONG_METADATA_VERSION = 1124
- , CAT_BAD_API_VERSION = 1125
- , CAT_UNABLE_TO_UPGRADE_DOWNGRADE = 1126
+ // unused = 1124
+ // unused = 1125
+ // unused = 1126
, CAT_NOT_A_BASE_TABLE = 1127
- , CAT_WRONG_API_REQUEST = 1128
- , CAT_OPERATION_NOT_ALLOWED_ON_VP_TABLE = 1129
+ // unused = 1128
+ // unused = 1129
, CAT_DEFAULT_REQUIRED = 1130
- , CAT_EXTERNAL_TABLE_EXISTS = 1131
+ // unused = 1131
, CAT_CANNOT_BE_DEFAULT_NULL_AND_NOT_NULL = 1132
, CAT_ONLY_SUPER_CAN_DO_THIS = 1133
- , CAT_LIST_OF_LOCKS_EXIST = 1134
- , CAT_CLUSTERING_KEY_COL_MUST_BE_NOT_NULL_NOT_DROP
+ // unused = 1134
+ , CAT_CLUSTERING_KEY_COL_MUST_BE_NOT_NULL_NOT_DROP = 1135
, CAT_ADDED_PK_CANNOT_BE_NOT_DROPPABLE = 1136
- , CAT_WRONG_INDEX_STATUS_REQUEST = 1137
- , CAT_WRONG_INPUT_PARAMETER = 1138
+ // unused = 1137
+ // unused = 1138
, CAT_SYSKEY_COL_NOT_ALLOWED_IN_CK_CNSTRNT = 1139
, CAT_REC_LEN_TOO_LARGE = 1140
- , CAT_UNABLE_TO_ACCESS_LABEL = 1141
- , CAT_NO_CONSTRAINTS_FOR_NON_AUDITED = 1142
+ // unused = 1141
+ // unused = 1142
, CAT_DATA_NOT_MEET_RI_CONSTRAINT_CRITERIA = 1143
, CAT_MISSING_QUOTE_IN_CHAR_FIRSTKEY = 1144
- , CAT_RESERVED_METADATA_CATALOG_NAME = 1145
+ // unused = 1145
, CAT_CANNOT_ALTER_WRONG_TYPE = 1146
, CAT_SYSTEM_COL_NOT_ALLOWED_IN_UNIQUE_CNSTRNT = 1147
, CAT_SYSTEM_COL_NOT_ALLOWED_IN_RI_CNSTRNT = 1148
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/91c8bae7/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 c681194..37394f8 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
@@ -1234,12 +1234,12 @@ Dropping the only partition of an object is not allowed. At least two partitions
== SQL 1118
```
-Creating object <table-name> is not allowed in metadata schema.
+Creating object <table-name> is not allowed in a reserved system schema.
```
Where <table-name> is the name of the object.
-*Cause:* You attempted to create an object in the metadata schema.
+*Cause:* You attempted to create an object in a reserved system schema.
*Effect:* The operation fails.
@@ -1268,17 +1268,16 @@ destroy the database.
== SQL 1120
```
-Use of float datatype in a partitioning key is not allowed.
+Use of an approximate numeric datatype (float, real, double precision) in a partitioning key or salt clause is not allowed.
```
-*Cause:* You attempted an operation on a partitionable table that has
-float datatype in the partitioning key.
+*Cause:* You attempted to create a table using a column having an approximate numeric datatype
+as a partitioning key or as a salt column.
*Effect:* The operation fails.
-*Recovery:* Enable the default
-ALLOW_FLOAT_DATATYPES_IN_PARTITIONING_KEY via a control query default
-statement and retry the operation.
+*Recovery:* Change the data type to an exact data type, or use different columns
+for the partitioning key or salt column.
[[SQL-1121]]
== SQL 1121
@@ -1337,35 +1336,18 @@ contains an element that is not supported.
*Recovery:* Correct the syntax and resubmit.
<<<
-[[SQL-1124]]
-== SQL 1124
-
-```
-Use of a float datatype in a partitioning key has been enabled by the default ALLOW_FLOAT_DATATYPES_IN_PARTIONING_KEY. This could give some incorrect results and the users should be aware of it.
-```
-
-*Cause:* You attempted an operation on a partitionable table that has
-float datatype in the partitioning key.
-
-*Effect:* The operation completes without errors, but the results might
-not be correct.
-The float data value might not be evaluated consistently to the same
-value each time.
-
-*Recovery:* Do not use float data types in the partitioning key of a
-partitionable table.
-
[[SQL-1127]]
== SQL 1127
```
-The specified table <table-name> is not a base table. Please verify that the correct table was specified.
+The specified table <table-name> does not exist, is inaccessible or is not a base table. Please verify that the correct table was specified.
```
Where <table-name> is the name of the table.
*Cause:* You attempted to perform an operation that can be performed
-only on a base table, and the specified object is not a base table.
+only on a base table, and the specified object does not exist,
+is inaccessible, or is not a base table.
*Effect:* The operation fails.
@@ -1390,7 +1372,7 @@ without specifying a default value.
== SQL 1132
```
-An added column cannot have both DEFAULT NULL and NOT NULL.
+An added column cannot be declared with both DEFAULT NULL and NOT NULL.
```
*Cause:* You attempted to add a column that is both DEFAULT NULL and NOT
@@ -1406,7 +1388,7 @@ NULL and resubmit.
== SQL 1133
```
-Only super ID can perform this operation.
+Only the super ID can perform this operation.
```
*Cause:* You attempted to perform an operation that can be performed
@@ -1416,24 +1398,6 @@ only by the super ID.
*Recovery:* Log on as the super ID and then resubmit.
-[[SQL-1134]]
-== SQL 1134
-
-```
-A concurrent utility or DDL is being performed on object <object-name>, its parent, or one of its dependencies. That operation must complete before the requested operation can run.
-```
-
-Where <object-name> is the name of the object.
-
-*Cause:* You attempted to execute a utility or alter the DDL of an
-object while a concurrent utility or DDL operation was being performed
-on the object, its parent, or its dependencies.
-
-*Effect:* The operation fails.
-
-*Recovery:* Wait until the concurrent operation has finished and then
-resubmit.
-
<<<
[[SQL-1135]]
== SQL 1135
@@ -1511,40 +1475,6 @@ exceeds the maximum allowed row size.
calculations. Change the column definitions and reissue the statement.
<<<
-[[SQL-1141]]
-== SQL 1141
-
-```
-Label <file-name> for object could not be accessed. File system error <error-number>.
-```
-
-Where <file-name> is the {project-name} platform file name of a partition of
-object.
-
-Where <error-number> is a {project-name} platform file system error.
-
-*Cause:* An ALTER TABLE or ALTER INDEX operation encountered a file
-system error.
-
-*Effect:* The operation fails.
-
-*Recovery:* For information about file system errors, see <<file_system_errors,File-System Errors>>.
-
-[[SQL-1142]]
-== SQL 1142
-
-```
-Because it is not audited, this table cannot have a column added that is declared NOT NULL, or has a CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint.
-```
-
-*Cause:* Internal error.
-
-*Effect:* The {project-name} database is unable to perform the requested
-operation.
-
-*Recovery:* None. Contact the {project-name} User Distribution List
-
-<<<
[[SQL-1143]]
== SQL 1143
@@ -1596,23 +1526,6 @@ specified is one of the character data types.
compatible with the type of column <column-name> and resubmit.
<<<
-[[SQL-1145]]
-== SQL 1145
-
-```
-The catalog name <catalog-name> is reserved for {project-name} metadata.
-```
-
-Where <catalog-name> is the name of a {project-name} database catalog.
-
-*Cause:* {project-name} reserves certain catalog names
-for its own use.
-
-*Effect:* The operation fails.
-
-*Recovery:* See the {docs-url}/sql_reference/index.html[_{project-name} SQL Reference Manual_] for reserved names.
-Change <catalog-name> to a name that is not reserved and resubmit.
-
[[SQL-1146]]
== SQL 1146
[2/2] incubator-trafodion git commit: Merge [TRAFODION-2398] PR 1021
Fix some messages in range 1111-1145
Posted by db...@apache.org.
Merge [TRAFODION-2398] PR 1021 Fix some messages in range 1111-1145
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/0c6089d7
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/0c6089d7
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/0c6089d7
Branch: refs/heads/master
Commit: 0c6089d7a0d75cb95917afa41847acb58bb38b3f
Parents: 299b538 91c8bae
Author: Dave Birdsall <db...@apache.org>
Authored: Thu Mar 23 20:34:57 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Thu Mar 23 20:34:57 2017 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 38 +++----
core/sql/regress/seabase/EXPECTED020 | 4 +-
core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 30 ++---
.../src/asciidoc/_chapters/ddl_msgs.adoc | 111 ++-----------------
4 files changed, 48 insertions(+), 135 deletions(-)
----------------------------------------------------------------------