trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [1/2] incubator-trafodion git commit: [TRAFODION-2389] Update some messages in the range 1001-1099
Date Wed, 14 Dec 2016 00:03:01 GMT
Repository: incubator-trafodion
Updated Branches:
  refs/heads/master 8d0910083 -> e0993dc4c


[TRAFODION-2389] Update some messages in the range 1001-1099


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/9964572a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/9964572a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/9964572a

Branch: refs/heads/master
Commit: 9964572a3dd9e5195bd443ddc5c9545c207d6d90
Parents: 672b6d1
Author: Dave Birdsall <dbirdsall@apache.org>
Authored: Mon Dec 12 22:18:00 2016 +0000
Committer: Dave Birdsall <dbirdsall@apache.org>
Committed: Mon Dec 12 22:18:00 2016 +0000

----------------------------------------------------------------------
 core/sql/bin/SqlciErrors.txt                    |  64 +--
 core/sql/regress/privs2/EXPECTED140             |   4 +-
 core/sql/regress/privs2/EXPECTED144             | Bin 59408 -> 59409 bytes
 core/sql/sqlcomp/CmpDDLCatErrorCodes.h          |  72 ++--
 .../src/asciidoc/_chapters/ddl_msgs.adoc        | 401 +++----------------
 5 files changed, 127 insertions(+), 414 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/9964572a/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index 1e65033..9cfd022 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -1,6 +1,6 @@
 100  02000 99999 UUUUUUUU UUUUU UUUUUUU The "no data" completion condition (SQLCODE = +100).
 1000 42000 99999 BEGINNER INFRM LOGONLY A syntax error occurred.
-1001 ZZZZZ 99999 ADVANCED CRTCL DIALOUT An internal error occurred in module $0~String0 on
line $1~Int0.  DETAILS($2~String1).
+1001 ZZZZZ 99999 ADVANCED CRTCL DIALOUT An internal error occurred in module $0~String0 on
line $1~Int0. Details($2~String1).
 1002 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Catalog $0~CatalogName does not exist.
 1003 ZZZZZ 99999 BEGINNER MINOR DBADMIN Schema $0~SchemaName does not exist.
 1004 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~TableName does not exist or object type
is invalid for the current operation.
@@ -22,21 +22,21 @@
 1020 ZZZZZ 99999 BEGINNER MINOR DBADMIN Privilege settings on metadata tables cannot be changed.
 1021 ZZZZZ 99999 BEGINNER MINOR DBADMIN SQL is already initialized on system $0~string0.
 1022 ZZZZZ 99999 BEGINNER MINOR DBADMIN Schema $0~SchemaName already exists.
-1023 ZZZZZ 99999 BEGINNER MINOR DBADMIN Not authorized to create schema $0~SchemaName.
-1024 ZZZZZ 99999 BEGINNER MINOR DBADMIN File system error $0~NSKCode occurred on $1~String0.
$2~String1
+1023 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1024 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
 1025 ZZZZZ 99999 BEGINNER MINOR DBADMIN Request failed.  Dependent object $0~string0 exists.
-1026 ZZZZZ 99999 BEGINNER MINOR DBADMIN Only the schema owner or super ID can drop a schema.
+1026 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
 1027 ZZZZZ 99999 BEGINNER MINOR DBADMIN The view $0~TableName was created before column privileges
were supported. To grant column privileges, please recreate the view.
 1028 ZZZZZ 99999 BEGINNER MINOR DBADMIN The schema must be empty.  It contains at least one
object $0~TableName.
 1029 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~TableName could not be created.
 1030 ZZZZZ 99999 BEGINNER MINOR DBADMIN The HBase name has a length of $0~Int0 which is too
long. Maximum length supported is $1~Int1.  
 1031 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~TableName could not be dropped.
 1032 ZZZZZ 99999 BEGINNER MINOR DBADMIN The DISPLAY command completes and the query is not
executed.
-1033 ZZZZZ 99999 BEGINNER MINOR DBADMIN The table name is not specified.
+1033 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
 1034 ZZZZZ 99999 BEGINNER MAJOR DIALOUT Unable to obtain privileges.
 1035 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Catalog $0~CatalogName already exists.
 1036 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Authorization ID $0~String0 cannot grant to authorization
ID $1~String1 because it could create a circular dependency.
-1037 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Revoke failed because of a dependent grant between
authorization ID $0~string0 and authorization ID $1~string1
+1037 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Revoke failed because of a dependent grant between
authorization ID $0~string0 and authorization ID $1~string1.
 1038 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
 1039 ZZZZZ 99999 BEGINNER MAJOR DBADMIN No privileges were revoked. You lack the grant option
for the specified privilege(s).
 1040 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The use of ALTER on metadata tables is not permitted.
@@ -59,43 +59,43 @@
 1057 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
 1058 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to create histogram table $0~TableName.
 1059 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Request failed.  Dependent constraint $0~ConstraintName
exists.
-1060 ZZZZZ 99999 BEGINNER MINOR DBADMIN Request failed. View $0~string0 is invalid. 
-1061 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Dropping metadata catalog $0~CatalogName is not allowed.
+1060 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1061 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
 1062 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Dropping metadata or reserved schema $0~SchemaName
is not allowed.
-1063 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Dropping metadata index $0~TableName is not allowed.
-1064 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Dropping metadata view $0~TableName is not allowed.
-1065 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Creating constraint $0~ConstraintName in metadata
schema is not allowed.
-1066 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Creating index $0~TableName in metadata schema is
not allowed.
-1067 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Creating module $0~String0 in metadata schema is
not allowed.
+1063 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1064 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1065 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1066 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1067 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
 1068 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Initialize authorization completed with warnings.
 1069 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Schema $0~SchemaName could not be dropped. $0~String0
 1070 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Object $0~TableName could not be created. File error:
$1~Int0.
-1071 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Object $0~TableName could not be accessed. 
-1072 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unique constraint $0~String0 is disabled, so foreign
key constraint $1~ConstraintName could not be created.
-1073 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Schema $0~SchemaName was partially dropped, call
CLEANUP SCHEMA to remove remaining entries.
-1074 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to create synonym: $0~String0, as part of
re-compile for view $0~TableName.
-1075 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The catalog must be empty.  It contains at least
one schema $0~SchemaName.
-1076 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to grant privilege: $0~String0, as part of
re-compile for view $0~TableName.
-1077 ZZZZZ 99999 ADVANCED MAJOR DIALOUT  Metadata table $0~String0 does not contain information
for view $1~TableName.
-1078 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The format of the specified location name '$0~string0'
is not valid.
-1079 ZZZZZ 99999 BEGINNER MINOR DBADMIN SQL was not able to prepare the statement.
+1071 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1072 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1073 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Schema $0~SchemaName was partially dropped. Use CLEANUP
SCHEMA to remove remaining entries.
+1074 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1075 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1076 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1077 ZZZZZ 99999 ADVANCED MAJOR DIALOUT --- unused ---
+1078 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1079 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
 1080 ZZZZZ 99999 BEGINNER MINOR DBADMIN The DDL request has duplicate references to column
$0~ColumnName.
 1081 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Loading of index $0~TableName failed unexpectedly.
 1082 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Validation for constraint $0~ConstraintName failed
unexpectedly.
 1083 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Validation for constraint $0~ConstraintName failed;
incompatible data exists in table.
 1084 ZZZZZ 99999 BEGINNER MINOR DBADMIN An invalid default value was specified for column
$0~ColumnName.
-1085 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The calculated key length is greater than $0~Int0
bytes.
-1086 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU Lock $0~TableName does not exist.
-1087 ZZZZZ 99999 BEGINNER MAJOR DBADMIN DDL Lock cannot be granted; invalid operation has
been specified.
-1088 ZZZZZ 99999 BEGINNER MINOR DBADMIN The system generated column SYSKEY must be specified
last or not specified at all in the STORE BY column list.
+1085 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1086 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused ---
+1087 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1088 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
 1089 ZZZZZ 99999 BEGINNER MINOR DBADMIN The system generated column SYSKEY must be specified
last or not specified at all in the index column list.
 1090 0A000 99999 BEGINNER MINOR DBADMIN Self-referencing constraints are currently not supported.
-1091 0A000 99999 BEGINNER INFRM LOGONLY The constraint, index, or file option is not supported
on a vertically partitioned table.
-1092 ZZZZZ 99999 BEGINNER INFRM LOGONLY Column $0~ColumnName must be assigned to a vertical
partition.
-1093 ZZZZZ 99999 BEGINNER INFRM LOGONLY Assigning system column $0~ColumnName to a vertical
partition is not allowed.
-1094 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~TableName could not be dropped because
it is not of type $1~string0.
-1095 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The PARTITION BY column $0~ColumnName should also
be part of the clustering/storage key.
-1096 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Validation for object $0~TableName failed unexpectedly.
+1091 0A000 99999 BEGINNER INFRM LOGONLY --- unused ---
+1092 ZZZZZ 99999 BEGINNER INFRM LOGONLY --- unused ---
+1093 ZZZZZ 99999 BEGINNER INFRM LOGONLY --- unused ---
+1094 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1095 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1096 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
 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.

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/9964572a/core/sql/regress/privs2/EXPECTED140
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED140 b/core/sql/regress/privs2/EXPECTED140
index 72d899e..c08d9a6 100644
--- a/core/sql/regress/privs2/EXPECTED140
+++ b/core/sql/regress/privs2/EXPECTED140
@@ -924,7 +924,7 @@ TRAFODION.T140_USER1_PRIVATE.TEAMS
 >>-- fails because of user3->user4 and user3->user5 grants
 >>revoke grant option for select on games from sql_user3 by sql_user2;
 
-*** ERROR[1037] Revoke failed because of a dependent grant between authorization ID SQL_USER3
and authorization ID SQL_USER4
+*** ERROR[1037] Revoke failed because of a dependent grant between authorization ID SQL_USER3
and authorization ID SQL_USER4.
 
 --- SQL operation failed with errors.
 >>
@@ -934,7 +934,7 @@ TRAFODION.T140_USER1_PRIVATE.TEAMS
 --- SQL operation complete.
 >>revoke grant option for select on games from sql_user3 by sql_user2;
 
-*** ERROR[1037] Revoke failed because of a dependent grant between authorization ID SQL_USER3
and authorization ID SQL_USER5
+*** ERROR[1037] Revoke failed because of a dependent grant between authorization ID SQL_USER3
and authorization ID SQL_USER5.
 
 --- SQL operation failed with errors.
 >>revoke select on games from sql_user5 by sql_user3;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/9964572a/core/sql/regress/privs2/EXPECTED144
----------------------------------------------------------------------
diff --git a/core/sql/regress/privs2/EXPECTED144 b/core/sql/regress/privs2/EXPECTED144
index 63d458b..d89bd39 100644
Binary files a/core/sql/regress/privs2/EXPECTED144 and b/core/sql/regress/privs2/EXPECTED144
differ

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/9964572a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
index 0094001..2e7b97b 100644
--- a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
+++ b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
@@ -38,7 +38,7 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
                   , CAT_SCHEMA_DOES_NOT_EXIST_ERROR               = 1003
                   , CAT_TABLE_DOES_NOT_EXIST_ERROR                = 1004
                   , CAT_CONSTRAINT_DOES_NOT_EXIST_ERROR           = 1005
-                  // , CAT_INDEX_DOES_NOT_EXIST_ERROR             = 1006 no longer used
+                  // unused                                       = 1006
                   , CAT_WGO_NOT_ALLOWED                           = 1007
                   , CAT_AUTHID_DOES_NOT_EXIST_ERROR               = 1008
                   , CAT_COLUMN_DOES_NOT_EXIST_ERROR               = 1009
@@ -46,30 +46,30 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
                   , CAT_ONLY_ONE_GRANTEE_ALLOWED                  = 1011
                   , CAT_PRIVILEGE_NOT_GRANTED                     = 1012
                   , CAT_NOT_ALL_PRIVILEGES_GRANTED                = 1013
-                  // , CAT_DEPENDENT_PRIVILEGES_EXIST             = 1014 no longer used
+                  // unused                                       = 1014
                   , CAT_NOT_ALL_PRIVILEGES_REVOKED                = 1015
                   , CAT_REDUNDANT_COLUMN_REF_PK                   = 1016
                   , CAT_NOT_AUTHORIZED                            = 1017
                   , CAT_GRANT_NOT_FOUND                           = 1018
-                  // , CAT_PARTITION_NOT_FOUND                    = 1019 no longer used
+                  // unused                                       = 1019
                   , CAT_SMD_PRIVS_CANNOT_BE_CHANGED               = 1020
                   , CAT_INITIALIZE_SQL_ALREADY_DONE               = 1021
                   , CAT_SCHEMA_ALREADY_EXISTS                     = 1022
-                  , CAT_BAD_SCHEMA_AUTHORIZATION_ID               = 1023
-                  , CAT_FS_ERROR                                  = 1024
+                  // unused                                       = 1023
+                  // unused                                       = 1024
                   , CAT_DEPENDENT_OBJECTS_EXIST                   = 1025
-                  , CAT_SCHEMA_ID_AND_USER_ID_DO_NOT_MATCH        = 1026
+                  // unused                                       = 1026
                   , CAT_COLUMN_PRIVILEGE_NOT_ALLOWED              = 1027
                   , CAT_SCHEMA_IS_NOT_EMPTY                       = 1028
                   , CAT_UNABLE_TO_CREATE_OBJECT                   = 1029
                   , CAT_HBASE_NAME_TOO_LONG                       = 1030
                   , CAT_UNABLE_TO_DROP_OBJECT                     = 1031
-                  , CAT_ANSINAME_IS_NOT_SPECIFIED                 = 1033
+                  // unused                                       = 1033
                   , CAT_UNABLE_TO_RETRIEVE_PRIVS                  = 1034
                   , CAT_CATALOG_ALREADY_EXISTS                    = 1035
                   , CAT_CIRCULAR_PRIVS                            = 1036
                   , CAT_DEPENDENT_PRIV_EXISTS                     = 1037
-                  // , CAT_CATALOGS_ARE_STILL_ON_THE_SYSTEM       = 1038 no longer used
+                  // unused                                       = 1038
                   , CAT_PRIVILEGE_NOT_REVOKED                     = 1039
                   , CAT_SMD_CANNOT_BE_ALTERED                     = 1040
                   , CAT_PRIMARY_KEY_ALREADY_DEFINED               = 1041
@@ -85,49 +85,49 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
                   , CAT_INSUFFICIENT_PRIV_ON_OBJECT               = 1051
                   , CAT_CONSTRAINT_DOES_NOT_BELONG_TO_TABLE       = 1052
                   , CAT_UNIQUE_INDEX_LOAD_FAILED_WITH_DUPLICATE_ROWS = 1053
-                  // , CAT_INDEX_ALREADY_EXISTS                   = 1054 no longer used
+                  // unused                                       = 1054
                   , CAT_TABLE_ALREADY_EXISTS                      = 1055
-                  // , CAT_UNABLE_TO_ALTER_VIEW                   = 1056 no longer used
-                  // , CAT_LOCATION_NO_GOOD                       = 1057 no longer used
+                  // unused                                       = 1056
+                  // unused                                       = 1057
                   , CAT_HISTOGRAM_TABLE_NOT_CREATED               = 1058
                   , CAT_DEPENDENT_CONSTRAINT_EXISTS               = 1059
-                  , CAT_VIEW_INVALID                              = 1060
-                  , CAT_USER_CANNOT_DROP_SMD_CATALOG              = 1061
+                  // unused                                       = 1060
+                  // unused                                       = 1061
                   , CAT_USER_CANNOT_DROP_SMD_SCHEMA               = 1062
-                  , CAT_USER_CANNOT_DROP_SMD_INDEX                = 1063
-                  , CAT_USER_CANNOT_DROP_SMD_VIEW                 = 1064
-                  , CAT_CREATE_CONSTRAINT_NOT_ALLOWED_IN_SMD      = 1065
-                  , CAT_CREATE_INDEX_NOT_ALLOWED_IN_SMD           = 1066
-                  , CAT_CREATE_MODULE_NOT_ALLOWED_IN_SMD          = 1067
+                  // unused                                       = 1063
+                  // unused                                       = 1064
+                  // unused                                       = 1065
+                  // unused                                       = 1066
+                  // unused                                       = 1067
                   , CAT_AUTH_COMPLETED_WITH_WARNINGS              = 1068
                   , CAT_UNABLE_TO_DROP_SCHEMA                     = 1069
                   , CAT_CREATE_OBJECT_ERROR                       = 1070
-                  , CAT_UNABLE_TO_ACCESS_OBJECT                   = 1071
-                  , CAT_REFERENCED_UNIQUE_CONSTRAINT_IS_DISABLED  = 1072
+                  // unused                                       = 1071
+                  // unused                                       = 1072
                   , CAT_ATTEMPT_CLEANUP_SCHEMA                    = 1073
-                  , CAT_UNABLE_TO_CREATE_SYNONYM                  = 1074
-                  , CAT_CATALOG_IS_NOT_EMPTY                      = 1075
-                  , CAT_UNABLE_TO_GRANT                           = 1076
-                  , CAT_VIEW_NOT_IN_METADATA_TABLE                = 1077
-                  , CAT_ILLEGAL_LOCATION_FORMAT                   = 1078
-                  , CAT_ERRORS_ENCOUNTERED_IN_BINDING_PHASE       = 1079
+                  // unused                                       = 1074
+                  // unused                                       = 1075
+                  // unused                                       = 1076
+                  // unused                                       = 1077
+                  // unused                                       = 1078
+                  // unused                                       = 1079
                   , CAT_DUPLICATE_COLUMNS                         = 1080
                   , CAT_CLI_LOAD_INDEX                            = 1081
                   , CAT_CLI_VALIDATE_CONSTRAINT                   = 1082
                   , CAT_CONSTRAINT_DATA_EXISTS                    = 1083
                   , CAT_ILLEGAL_DEFAULT_VALUE_FORMAT              = 1084
-                  , CAT_KEY_LENGTH_INCORRECT                      = 1085
-                  , CAT_LOCK_DOES_NOT_EXIST_ERROR                 = 1086
-                  , CAT_CONFLICTING_LOCK_EXISTS                   = 1087
-                  , CAT_WRONG_KEY_ORDER                           = 1088
+                  // unused                                       = 1085
+                  // unused                                       = 1086
+                  // unused                                       = 1087
+                  // unused                                       = 1088
                   , CAT_SYSKEY_NOT_LAST_COLUMN                    = 1089
                   , CAT_SELF_REFERENCING_CONSTRAINT               = 1090
-                  , CAT_CONSTRAINT_OR_OPTION_NOT_PERMITTED_ON_VP_TABLE
-                  , CAT_COLUMN_MUST_BE_ASSIGNED_TO_VP             = 1092
-                  , CAT_CANNOT_ASSIGN_SYSTEM_COLUMN_TO_VP         = 1093
-                  , CAT_WRONG_OBJECT_TYPE                         = 1094
-                  , CAT_BAD_PARTITION_BY_COLUMNS                  = 1095
-                  , CAT_CLI_VALIDATE_OBJECT                       = 1096
+                  // unused                                       = 1091
+                  // unused                                       = 1092
+                  // unused                                       = 1093
+                  // unused                                       = 1094
+                  // unused                                       = 1095
+                  // unused                                       = 1096
                   , CAT_PARTITION_KEY_NOT_EXIST                   = 1097
                   , CAT_PARTITION_KEY_DUPLICATED                  = 1098
                   , CAT_VIEW_COLUMN_UNNAMED                       = 1099

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/9964572a/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 2bd872c..d7e4ffd 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
@@ -26,6 +26,25 @@
 [[data-definition-language-messages]]
 = Data Definition Language (DDL) Messages (1000 through 1999)
 
+[[SQL-1001]]
+== SQL 1001
+
+```
+An internal error occurred in module <module-name> on line <line-number>. Details(<details>).
+```
+
+Where <module-name> is the name of a {project-name} source code module.
+
+Where <line-number> is the number of a line within the source code module.
+
+Where <details> gives additional information as to the error.
+
+*Cause:* An internal error occurred in the {project-name} software.
+
+*Effect:* The operation fails.
+
+*Recovery:* None. Contact the {project-name} Developer Distribution List.
+
 [[SQL-1002]]
 == SQL 1002
 
@@ -41,6 +60,7 @@ Where <catalog> is the ANSI name of the target catalog.
 
 *Recovery:* Enter a valid catalog name and resubmit.
 
+<<<
 [[SQL-1003]]
 == SQL 1003
 
@@ -57,7 +77,6 @@ specified a schema that does not exist.
 
 *Recovery:* Check that a schema named <schema> does exist and resubmit.
 
-<<<
 [[SQL-1004]]
 == SQL 1004
 
@@ -75,6 +94,7 @@ Where <object-name> is the name of a {project-name} database object.
 did not fully qualify the name, check that the defaults generate the
 correct fully qualified name and resubmit.
 
+<<<
 [[SQL-1005]]
 == SQL 1005
 
@@ -94,7 +114,6 @@ of a constraint named <constraint-name>.
 the table specified. You can use the SHOWDDL command to find the names
 of the constraints that exist on a table.
 
-<<<
 [[SQL-1007]]
 == SQL 1007
 
@@ -109,6 +128,7 @@ the WITH GRANT OPTION. This is not allowed.
 
 *Recovery:* Remove the WITH GRANT OPTION clause and resubmit.
 
+<<<
 [[SQL-1008]]
 == SQL 1008
 
@@ -126,7 +146,6 @@ valid {project-name} platform user or role.
 
 *Recovery:* Correct the name and resubmit.
 
-<<<
 [[SQL-1009]]
 == SQL 1009
 
@@ -144,6 +163,7 @@ name.
 *Recovery:* Replace either the name of the table or the name of the
 column (whichever is incorrect) and resubmit.
 
+<<<
 [[SQL-1010]]
 == SQL 1010
 
@@ -157,7 +177,6 @@ The statement just entered is currently not supported.
 
 *Recovery:* Do not attempt to use this {project-name} database statement.
 
-<<<
 [[SQL-1011]]
 == SQL 1011
 
@@ -186,6 +205,7 @@ grant options.
 
 *Recovery:* You must have grant options for privileges to grant them.
 
+<<<
 [[SQL-1013]]
 == SQL 1013
 
@@ -203,7 +223,6 @@ that you attempted to grant.
 
 *Recovery:* You must have grant options for privileges to grant them.
 
-<<<
 [[SQL-1015]]
 == SQL 1015
 
@@ -254,6 +273,7 @@ local super ID can perform a replication operation for a catalog and for
 multiple schemas in a single catalog. Additionally, the schema owner can
 perform a replication operation for a single schema.
 
+<<<
 [[SQL-1018]]
 == SQL 1018
 
@@ -273,7 +293,6 @@ cannot.
 them and resubmit. If <user-or-role-1> is incorrect, reconnect to
 the {project-name} database via the correct user ID or role.
 
-<<<
 [[SQL-1020]]
 == SQL 1020
 
@@ -288,6 +307,7 @@ They cannot be changed.
 
 *Recovery:* None.
 
+<<<
 [[SQL-1021]]
 == SQL 1021
 
@@ -305,7 +325,6 @@ node.
 
 *Recovery:* None needed if SQL is operating normally.
 
-<<<
 [[SQL-1022]]
 == SQL 1022
 
@@ -324,47 +343,12 @@ contains a schema with that name.
 default generates the correct catalog name. Retry the request,
 specifying a schema that does not already exist.
 
-[[SQL-1023]]
-== SQL 1023
-
-```
-Only services ID can name an authorization ID other than the current user name.
-```
-
-*Cause:* You attempted to create a schema with the authorization ID of
-another user. Only the services ID can do this.
-
-*Effect:* The operation fails.
-
-*Recovery:* Use the services ID to create a schema with another owner.
-
 <<<
-[[SQL-1024]]
-== SQL 1024
-
-```
-File system error <error-number> occurred on <text-string-1> <text-string-2>.
-```
-
-Where <error-number> is an error originating from the file system.
-
-Where <text-string-1> is the file name.
-
-Where <text-string-2> is (optionally) additional details about the
-error.
-
-*Cause:* Look up this error number in the file system manual to
-determine the cause.
-
-*Effect:* The operation fails.
-
-*Recovery:* For information about file system errors, see <<file_system_errors,File-System
Errors>>.
-
 [[SQL-1025]]
 == SQL 1025
 
 ```
-Request failed. One or more dependent objects exist.
+Request failed. Dependent object <object-name> exists.
 ```
 
 *Cause:* This error can occur when you drop a constraint, index, or
@@ -379,22 +363,6 @@ you can reissue the statement specifying CASCADE. For other DROP
 statements, you must first drop each of the dependent objects, then drop
 the object.
 
-<<<
-[[SQL-1026]]
-== SQL 1026
-
-```
-Only the schema owner or services ID can drop a schema.
-```
-
-*Cause:* An attempt was made to drop a schema by someone other than its
-owner or the services ID.
-
-*Effect:* No SQL objects are dropped.
-
-*Recovery:* The owner of the schema (or services ID) needs to issue the
-DROP SCHEMA statement.
-
 [[SQL-1027]]
 == SQL 1027
 
@@ -482,6 +450,7 @@ Where <object-name> is the SQL object.
 
 *Recovery:* Apply the recovery of the accompanying error message.
 
+<<<
 [[SQL-1032]]
 == SQL 1032
 
@@ -568,7 +537,6 @@ that user or role has granted that privilege to a third authorization
ID.
 that can revoke the dependent privileges, then reconnect again under the
 original authorization ID and resubmit.
 
-<<<
 [[SQL-1039]]
 == SQL 1039
 
@@ -584,6 +552,7 @@ have the ability (grant option) to perform this operation.
 *Recovery:* Reconnect to the {project-name} database using an authorization ID
 that has grant option for these privileges and resubmit.
 
+<<<
 [[SQL-1040]]
 == SQL 1040
 
@@ -598,7 +567,6 @@ of the {project-name} database metadata. Such tables cannot be altered.
 
 *Recovery:* None.
 
-<<<
 [[SQL-1041]]
 == SQL 1041
 
@@ -799,6 +767,7 @@ The constraint you specified, however, does not belong to the table you
specifie
 *Recovery:* To learn if the constraint name is incorrect, use SHOWDDL on the
 table you specified. Correct the name and resubmit.
 
+<<<
 [[SQL-1053]]
 == SQL 1053
 
@@ -853,7 +822,6 @@ Additional error messages may give insight to the cause.
 Supply the name of the table that could not be created and any accompanying
 error messages.
 
-<<<
 [[SQL-1059]]
 == SQL 1059
 
@@ -873,124 +841,59 @@ or a check constraint that refers to another table.
 then drop the table, or reissue the DROP TABLE statement, specifying the
 CASCADE option.
 
-[[SQL-1061]]
-== SQL 1061
-
-```
-Dropping metadata catalog <catalog-name> is not allowed.
-```
-
-Where <catalog-name> is the name of a {project-name} database catalog.
-
-*Cause:* You attempted to drop a catalog that is part of the {project-name}
-database metadata.
-
-*Effect:* The operation fails.
-
-*Recovery:* None.
-
 <<<
 [[SQL-1062]]
 == SQL 1062
 
 ```
-Dropping metadata schema <schema-name> is not allowed.
+Dropping metadata or reserved schema <schema-name> is not allowed.
 ```
 
-Where <schema-name> is the name of a {project-name} database metadata schema.
+Where <schema-name> is the name of a {project-name} database metadata or reserved schema.
 
 *Cause:* You attempted to drop a schema that is part of the {project-name}
-database metadata.
+database metadata or is reserved.
 
 *Effect:* The operation fails.
 
 *Recovery:* None.
 
-[[SQL-1063]]
-== SQL 1063
+[[SQL-1068]]
+== SQL 1068
 
 ```
-Dropping metadata index <index-name> is not allowed.
+Initialize authorization completed with warnings.
 ```
 
-Where <index-name> is the name of a {project-name} database index.
+*Cause:* You attempted to initialize authorization in the {project-name} database.
+This succeeded, however some warnings were reported. This message is
+accompanied by additional warning messages which report the specifics.
 
-*Cause:* An attempt was made to drop an index that is part of the
-{project-name} database metadata.
+*Effect:* The operation succeeds, however there may be issues you wish to address.
 
-*Effect:* The operation fails.
-
-*Recovery:* None.
+*Recovery:* Consult the descriptions of the accompanying warning messages.
 
 <<<
-[[SQL-1064]]
-== SQL 1064
-
-```
-Dropping metadata view <table-name> is not allowed.
-```
-
-Where <table-name> is the name of a {project-name} database table.
-
-*Cause:* An attempt was made to drop a view that is a metadata object.
-Metadata views and their creation are not currently supported, so this
-error should not be encountered.
-
-*Effect:* The operation fails.
-
-*Recovery:* None.
-
-[[SQL-1065]]
-== SQL 1065
-
-```
-Creating constraint <constraint-name> in metadata schema is not allowed.
-```
-
-Where <constraint-name> is the name of the constraint.
-
-*Cause:* You attempted to create a constraint on a metadata table, which
-is not allowed.
-
-*Effect:* The operation fails.
-
-*Recovery:* None.
-
-<<<
-[[SQL-1066]]
-== SQL 1066
-
-```
-Creating index <index-name> in metadata schema is not allowed.
-```
-
-Where <index-name> is the name specified for the index.
-
-*Cause:* You attempted to create an index on a metadata table, which is
-not allowed.
-
-*Effect:* The operation fails.
-
-*Recovery:* None.
-
 [[SQL-1069]]
 == SQL 1069
 
 ```
-Schema <schema-name> could not be dropped.
+Schema <schema-name> could not be dropped. <details>
 ```
 
 Where <schema-name> is the name of a {project-name} database schema.
 
-*Cause:* See the accompanying error message for the cause of the
-problem.
+Where <details> is additional message text giving details concerning
+why the schema could not be dropped.
+
+*Cause:* The cause is given in the <details>.
 
 *Effect:* The operation fails.
 
-*Recovery:* Apply the recovery action from the accompanying error
-message.
+*Recovery:* The <details> may offer insights. Possibly there is an
+inconsistency between HBase and the {project-name} metadata. The
+CLEANUP SCHEMA command may be used to recover in these cases.
 
-<<<
 [[SQL-1070]]
 == SQL 1070
 
@@ -1009,115 +912,31 @@ system error <error-number>.
 
 *Recovery:* For information about file system errors, see <<file_system_errors,File-System
Errors>>.
 
-[[SQL-1071]]
-== SQL 1071
-
-```
-Object <ANSI-name> could not be accessed.
-```
-
-Where <ANSI-name> is the name of the {project-name} database object.
-
-*Cause:* The statement issued required access to the {project-name} platform
-file underlying object <ANSI-name>.
-
-*Effect:* The operation fails.
-
-*Recovery:* Apply the recovery action from the accompanying error
-message.
-
 <<<
-[[SQL-1072]]
-== SQL 1072
-
-```
-Unique constraint <constraint-name-1> is disabled, so foreign key constraint <constraint-name-2>
could not be created.
-```
-
-Where <constraint-name-1> is the name of the disabled constraint.
-
-Where <constraint-name-2> is the name of the foreign key constraint.
-
-*Cause:* You created a referential constraint that references a unique
-constraint that has been disabled. This is an internal error.
-
-*Effect:* The operation fails.
-
-*Recovery:* Create the referential constraint that references a unique
-constraint that has not been disabled.
-
 [[SQL-1073]]
 == SQL 1073
 
 ```
-Only services ID can execute INITIALIZE SQL.
-```
-
-*Cause:* You attempted to initialize the {project-name} database, but you are
-not the services ID. Only the services ID can perform this function.
-
-*Effect:* The operation fails.
-
-*Recovery:* Log on as the services ID before executing this command.
-
-<<<
-[[SQL-1075]]
-== SQL 1075
-
-```
-The catalog must be empty. It contains at least one schema <schema-name>.
-```
-
-Where <schema-name> is the name of a schema in the specified catalog.
-
-*Cause:* An attempt was made to drop a catalog that is not empty.
-
-*Effect:* The catalog is not dropped. None of its schemas are dropped.
-
-*Recovery:* Drop all schemas in the catalog and resubmit.
-
-*Recovery:* None. Contact the {project-name} User Distribution List
-
-[[SQL-1078]]
-== SQL 1078
-
-```
-The format of the specified location name <location-name> is not valid.
+Schema <schema-name> was partially dropped. Use CLEANUP SCHEMA to remove remaining
entries.
 ```
 
-Where <location-name> is a name specified in a LOCATION clause.
-
-*Cause:* An invalid name was supplied in a LOCATION clause.
+*Cause:* You attempted to drop the specified schema, however {project-name}
+was only able to partially drop it.
 
 *Effect:* The operation fails.
 
-*Recovery:* See the {docs-url}/sql_reference/index.html[_{project-name} SQL Reference Manual_]
for limitations on
-names allowed in the LOCATION clause. Correct the name and resubmit.
-
-<<<
-[[SQL-1079]]
-== SQL 1079
-
-```
-{project-name} was not able to prepare the statement.
-```
-
-*Cause:* See the accompanying error message for the cause.
-
-*Effect:* The operation fails.
-
-*Recovery:* Apply the recovery of the accompanying error message.
+*Recovery:* Use the CLEANUP SCHEMA <schema-name> command to drop anything remaining.
 
 [[SQL-1080]]
 == SQL 1080
 
 ```
-The create request has duplicate references to column <column-name>.
+The DDL request has duplicate references to column <column-name>.
 ```
 
 Where <column-name> is the name of a column of a table.
 
-*Cause:* You attempted to create a table that has two columns with the
+*Cause:* You attempted to create a table or view that has two columns with the
 same name. If you name a column "SYSKEY," duplication can result from
 the implicit creation by the {project-name} database software of a column
 named SYSKEY to ensure uniqueness for the clustering key.
@@ -1199,68 +1018,6 @@ for <column-name>.
 *Recovery:* Specify a valid default value for the column and resubmit.
 
 <<<
-[[SQL-1085]]
-== SQL 1085
-
-```
-The calculated key length is greater than 255 bytes.
-```
-
-*Cause:* The length of the primary key, which is calculated by the
-number of primary key columns and their data types, exceeds the maximum
-length.
-
-*Effect:* The operation fails.
-
-*Recovery:* Make sure the key length is less than 255 bytes and
-resubmit.
-
-[[SQL-1086]]
-== SQL 1086
-
-```
-Lock <lock-name> does not exist.
-```
-
-Where <lock-name> is the name of the specified lock.
-
-*Cause:* Lock <lock-name> was specified, but does not exist.
-
-*Effect:* The operation fails.
-
-*Recovery:* Create a lock <lock-name> or specify a valid lock name and
-resubmit.
-
-<<<
-[[SQL-1087]]
-== SQL 1087
-
-```
-DDL lock cannot be granted, invalid operation has been specified.
-```
-
-*Cause:* An invalid utility operation requested a DDL lock.
-
-*Effect:* The lock request fails.
-
-*Recovery:* Specify a valid utility operation, or check to see if
-invalid utilities are being run, and resubmit.
-
-[[SQL-1088]]
-== SQL 1088
-
-```
-The system generated column SYSKEY must be specified last or not specified at all in the
STORE BY column list.
-```
-
-*Cause:* If the system-generated column SKSKEY is specified in the STORE
-BY list of columns, it must be specified last.
-
-*Effect:* The operation fails.
-
-*Recovery:* Correct the STORE BY clause and resubmit.
-
-<<<
 [[SQL-1089]]
 == SQL 1089
 
@@ -1292,60 +1049,16 @@ referencing the primary key of the same table.
 *Recovery:* Remove the self-reference and resubmit.
 
 <<<
-[[SQL-1094]]
-== SQL 1094
-
-```
-Object <object-name> could not be dropped because it is not of type <object-type>.
-```
-
-Where <object-name> is the ANSI name of the object stated in the DROP
-command.
-
-Where <object-type> is the type of object that was stated in the DROP
-command.
-
-*Cause:* A DROP TABLE specified an object that is not a base table, or a
-DROP VIEW specified an object that is not a view, or a DROP PROCEDURE
-specified an object that is not a procedure.
-
-*Effect:* The operation fails.
-
-*Recovery:* Reissue the DROP statement with the correct combination of
-specified object type and actual object type.
-
-[[SQL-1095]]
-== SQL 1095
-
-```
-The PARTITION BY column <column-name> should also be part of the clustering/storage
key.
-```
-
-Where <column-name> is the name of a column of the specified table.
-
-*Cause:* This error is reported if a column specified in the
-partitioning key of the "PARTITION BY (<partitioning-columns>)" clause
-of a CREATE TABLE or CREATE INDEX statement is not also a member of the
-clustering key.
-
-*Effect:* The table or index is not created.
-
-*Recovery:* Either remove the offending column from the partitioning key
-specification (and possibly replace it with a column that is a member of
-the clustering key) or add the offending column to the clustering key by
-using the STORE BY clause or by adding it to the primary key.
-
-<<<
 [[SQL-1098]]
 == SQL 1098
 
 ```
-Duplicate partition key (<key>)specified for object <object-name>.
+Partition key (<key>) already specified for object <table-name>.
 ```
 
 Where <key> is a partition key.
 
-Where <object-name> is the name of the table being created or changed.
+Where <table-name> is the name of the table being created or changed.
 
 *Cause:* You attempted to create or change a table so that more than one
 partition has the same first key.



Mime
View raw message