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/12/23 04:39:47 UTC
[1/2] incubator-trafodion git commit: [TRAFODION-2852] Bring Messages
Guide up-to-date for msgs 1200-1299 + others
Repository: incubator-trafodion
Updated Branches:
refs/heads/master d54589fd0 -> 00c370858
[TRAFODION-2852] Bring Messages Guide up-to-date for msgs 1200-1299 + others
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/1304c577
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/1304c577
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/1304c577
Branch: refs/heads/master
Commit: 1304c577a0ba9e5e6a61c5552ee5e26186f2c3dd
Parents: c0583c9
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Dec 20 21:01:42 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Dec 20 21:01:42 2017 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 90 ++--
core/sql/executor/ExExeUtilExplain.cpp | 6 +-
core/sql/parser/sqlparser.y | 46 +-
core/sql/regress/seabase/EXPECTED022 | 4 +-
core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 65 +--
core/sql/sqlcomp/CmpSeabaseDDLtable.cpp | 4 +-
.../src/asciidoc/_chapters/binder_msgs.adoc | 37 +-
.../src/asciidoc/_chapters/ddl_msgs.adoc | 513 ++++++++++---------
.../src/asciidoc/_chapters/parser_msgs.adoc | 31 +-
9 files changed, 362 insertions(+), 434 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index cfe49e7..ffc6043 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -206,7 +206,7 @@
1204 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU Unsupported Hive datatype $0~string0.
1205 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused ---
1206 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU SALT AND SPLIT BY clauses are not allowed together.
-1207 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU Text to be inserted into the TEXT metadata table contains too many quotes.
+1207 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused ---
1208 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU The SPLIT BY clause is not supported for indexes.
1209 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU The SPLIT BY clause has more columns than the table has key columns ($0~Int0).
1210 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU Column $0~String0 is not allowed at position $1~Int0 in the SPLIT BY clause, because SPLIT BY must specify a prefix of the clustering key columns and the next clustering key column is $2~String1.
@@ -219,35 +219,35 @@
1221 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Only system components may contain system operations.
1222 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Command not supported when authorization is not enabled.
1223 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Grant to self or DB__ROOT is not allowed.
-1224 ZZZZZ 99999 BEGINNER MAJOR DBADMIN An invalid data type was specified for routine parameter $0~String0.
-1225 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Mixing EXECUTE privilege with other privileges is not allowed.
-1226 ZZZZZ 99999 BEGINNER MAJOR DBADMIN No valid combination of privileges was specified.
+1224 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1225 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1226 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1227 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Cannot unregister user. User $0~String0 has been granted privileges on $1~String1.
1228 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Cannot drop role. Role $0~String0 has been granted privileges on $1~String1.
1229 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The $0~string0 option is not supported.
1230 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Object owner must be the schema owner in private schemas.
1231 ZZZZZ 99999 BEGINNER MAJOR DBADMIN User-defined routine $0~String0 could not be created.
-1232 ZZZZZ 99999 BEGINNER MINOR DBADMIN A file error ($0~int0) occurred when saving dropped table DDL for table $1~TableName to $2~String0.
-1233 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Creating schema in SQL system catalog $0~String0 is prohibited.
-1234 ZZZZZ 99999 BEGINNER MAJOR DIALOUT Authorization need to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
+1232 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1233 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1234 ZZZZZ 99999 BEGINNER MAJOR DIALOUT Authorization needs to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
1235 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
-1236 3F000 99999 BEGINNER MAJOR DBADMIN The schema name specified for SQL object $0~String0 is not valid. The schema name must be the same as the schema being created.
+1236 3F000 99999 BEGINNER MAJOR DBADMIN --- unused ---
1237 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused as of 05/7/12 ---
-1238 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The character set used in TRIGGER text must be ISO88591.
-1239 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The character set for string literals in VIEW must be ISO88591.
+1238 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1239 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1240 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The character set for a PARTITION KEY column must be ISO88591.
-1241 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The character set for HEADING must be ISO88591.
-1242 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The character set for string literals in CONSTRAINT must be ISO88591.
+1241 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1242 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1243 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The hexadecimal form of string literals is not allowed in this context.
-1244 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Authorization initialization failed.
-1245 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The supplied partition key value ($0~String0) for column $1~ColumnName of object $2~TableName is not valid.
+1244 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1245 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1246 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1247 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- Msg text will be merged in. ------
-1248 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Partition name $0~string0 has already been used. Each partition in an object should have a unique name.
+1248 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1249 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1250 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1251 01000 99999 BEGINNER MINOR DBADMIN The extra insignificant digits of default value $0~String0 are truncated to match the scale of the data type of column $1~ColumnName.
-1252 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The existing index $0~TableName to be used by a unique or primary constraint has not been populated. Please populate the index and then try to add the constraint again.
+1252 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1253 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- Msg text will be merged in. ------
1254 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Duplicate unique constraints are not allowed with same set of columns.
1255 ZZZZZ 99999 BEGINNER MINOR DBADMIN Constraint $0~String0 is the clustering key constraint for table $1~String1 and cannot be dropped.
@@ -256,43 +256,43 @@
1258 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- Msg text will be merged in ------
1259 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- Msg text will be merged in ------
1260 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU Debugging of UDRs is only allowed for the DB__ROOT user. Connect as DB__ROOT, preferably using the sqlci tool, and try again.
-1261 ZZZZZ 99999 BEGINNER MAJOR DIALOUT ADVANCED MAJOR DIALOUT Error $0~int0 was returned by the SQL CLI while processing the UDR_JAVA_OPTIONS setting '$1~string0'.
-1262 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The command cannot be executed because $0~string0 is in progress for $1~string1.
-1263 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object names that start with $0~String0 are reserved for SQL metadata.
+1261 ZZZZZ 99999 BEGINNER MAJOR DIALOUT --- unused ---
+1262 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1263 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
1264 ZZZZZ 99999 BEGINNER MINOR DBADMIN Duplicate privileges are not allowed in a GRANT or REVOKE statement.
-1265 ZZZZZ 99999 BEGINNER MINOR DBADMIN Duplicate grantees are not allowed in a GRANT or REVOKE statement.
+1265 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
1266 ZZZZZ 99999 BEGINNER MINOR DBADMIN Only EXECUTE privilege is supported for a procedure or routine.
1267 ZZZZZ 99999 BEGINNER MINOR DBADMIN $0~string0 privilege is incompatible with this object type.
1268 ZZZZZ 99999 BEGINNER MINOR DBADMIN Duplicate columns are not allowed in a GRANT or REVOKE statement.
1269 ZZZZZ 99999 BEGINNER MINOR DBADMIN Column name $0~String0 is reserved for internal system usage. It cannot be specified as a user column.
-1270 ZZZZZ 99999 BEGINNER MAJOR DBADMIN ALLOCATE or DEALLOCATE failed for object $0~TableName due to file error $1~Int0 on $2~String0.
-1271 ZZZZZ 99999 BEGINNER MAJOR DBADMIN ALLOCATE failed for object $0~TableName because the number of extents to be allocated ($1~Int0) is greater than the MAXEXTENTS for a partition of the object.
-1272 ZZZZZ 99999 BEGINNER CRTCL DIALOUT The system is not licensed for use of SQL format tables.
-1273 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The specified MAXEXTENTS value must be greater than the number of extents allocated.
-1274 01000 99999 BEGINNER MAJOR DBADMIN The specified or default MAXEXTENTS value is not sufficient. The MAXEXTENTS value has been automatically set to the new value of $1~Int0 for the file $0~String0.
-1275 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Constraint $0~String0 cannot be dropped because it is needed by unique constraint $1~String1.
+1270 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1271 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1272 ZZZZZ 99999 BEGINNER CRTCL DIALOUT --- unused ---
+1273 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1274 01000 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1275 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1276 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to select partition $0~String0 from table $1~TableName.
-1277 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Unrecognized partitioning scheme for object $0~String0.
-1278 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The command cannot be executed because $0~String0 is in progress for all schemas in catalog $1~CatalogName.
+1277 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1278 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1279 42000 99999 BEGINNER MAJOR DBADMIN A volatile DDL statement cannot be used on regular objects.
1280 42000 99999 BEGINNER MAJOR DBADMIN A regular DDL statement cannot be used on volatile objects.
-1281 ZZZZZ 99999 BEGINNER INFRM LOGONLY
-1282 ZZZZZ 99999 BEGINNER INFRM LOGONLY A LOB column cannot be specified in a volatile table
+1281 ZZZZZ 99999 BEGINNER INFRM LOGONLY --- unused ---
+1282 ZZZZZ 99999 BEGINNER INFRM LOGONLY A LOB column cannot be specified in a volatile table.
1283 0A000 99999 BEGINNER INFRM LOGONLY The specified constraint or file option is not supported on a volatile table.
-1284 ZZZZZ 99999 BEGINNER MINOR DBADMIN Table $0~TableName cannot be dropped because it was specified to be NOT DROPPABLE.
-1285 ZZZZZ 99999 BEGINNER MINOR DBADMIN Schema $0~SchemaName cannot be dropped because it contains NOT DROPPABLE table $1~TableName.
+1284 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1285 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
1286 ZZZZZ 99999 BEGINNER MINOR DBADMIN The NOT DROPPABLE clause is not allowed for volatile tables.
-1287 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Only super ID can execute INITIALIZE SECURITY.
-1288 ZZZZZ 99999 BEGINNER MAJOR DIALOUT Security was not able to initialize.
+1287 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1288 ZZZZZ 99999 BEGINNER MAJOR DIALOUT --- unused ---
1289 ZZZZZ 99999 BEGINNER MINOR DBADMIN The use of ALTER on reserved schemas and metadata schemas is not permitted.
-1290 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Select from table $0~TableName failed during UPGRADE operation.
-1291 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Select from table $0~TableName failed during DOWNGRADE operation.
-1292 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Delete from $0~string0 log table failed.
-1293 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Schema version of the object $0~string0 must be 2300.
-1294 ZZZZZ 99999 BEGINNER MAJOR DBADMIN ISO_MAPPING must be SJIS for this operation.
-1295 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Target column $0~ColumnName has mismatching default type.
-1296 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Character data type of target column and literal are different.
-1297 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The $0~string0 command cannot be executed because volatile schema $1~string1 exists.
+1290 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1291 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1292 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1293 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1294 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1295 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1296 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1297 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1298 ZZZZZ 99999 BEGINNER MINOR DBADMIN Schema $0~SchemaName could not be altered. $0~String0
1299 ZZZZZ 99999 BEGINNER MAJOR DBADMIN You cannot specify some columns with just the name and others with name & data attributes.
1300 ZZZZZ 99999 ADVANCED MAJOR DIALOUT Catman generated unknown Exception for procedure $0~TableName.
@@ -406,10 +406,10 @@
1423 ZZZZZ 99999 BEGINNER MINOR DBADMIN Insert into metadata table $0~string0 failed.
1424 ZZZZZ 99999 BEGINNER MINOR DBADMIN Column $0~ColumnName cannot be dropped as that would leave the table with no user defined or user updatable columns.
1425 ZZZZZ 99999 BEGINNER MINOR DBADMIN This operation could not be performed on $0~TableName. $0~String0
-1426 ZZZZZ 99999 BEGINNER MINOR DBADMIN An invalid HBase column name $0~String0 was specified. A valid name must be of the format: <ColumnFamily>:<ColumnName>
+1426 ZZZZZ 99999 BEGINNER MINOR DBADMIN An invalid HBase column name $0~String0 was specified. A valid name must be of the format: <ColumnFamily>:<ColumnName>
1427 ZZZZZ 99999 BEGINNER MINOR DBADMIN Table cannot be renamed. $0~String0
1428 ZZZZZ 99999 BEGINNER MINOR DBADMIN Metadata definitions could not be created and preloaded in global MDdescInfo struct. Make sure that metadata table definition syntax is correct.
-1429 ZZZZZ 99999 BEGINNER MINOR DBADMIN Inserts into _ROW_ format external hbase tables can only use the VALUES clause and must use the column_create function to create values.
+1429 ZZZZZ 99999 BEGINNER MINOR DBADMIN Inserts into _ROW_ format external HBase tables can only use the VALUES clause and must use the column_create function to create values.
1430 3F000 99999 BEGINNER MAJOR DBADMIN A schema name that starts and ends with an "_"(underscore) is reserved for internal usage. It cannot be used to create a user schema.
1431 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~String0 exists in HBase. This could be due to a concurrent transactional ddl operation in progress on this table.
1432 ZZZZZ 99999 BEGINNER MINOR DBADMIN Input LOB type $0~Int0 does not match column's storage type: $1~Int1 Column name: $0~String0 .
@@ -1197,7 +1197,7 @@ $1~String1 --------------------------------
4125 42000 99999 BEGINNER MAJOR DBADMIN The select list of a subquery in a row value constructor must be scalar (degree of one) if the subquery is one of several expressions rather than the only expression in the constructor.
4126 42000 99999 BEGINNER MAJOR DBADMIN The row value constructors in a VALUES clause must be of equal degree.
4127 42000 99999 BEGINNER MAJOR DBADMIN Type $0~String0 cannot be assigned to type $1~String1.
-4128 42000 99999 BEGINNER MAJOR DBADMIN Default volume and subvolume information could not be retrieved from =_DEFAULTS define - DEFINEINFO error $0~int0.
+4128 42000 99999 BEGINNER MAJOR DBADMIN --- unused ---
4129 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The character-typed result of the function $0~String0 is longer than the maximum supported size.
4130 ZZZZZ 99999 BEGINNER MAJOR DBADMIN $0~string0 is a read-only DEFAULTS attribute and cannot be updated.
4131 42000 99999 BEGINNER MAJOR DBADMIN Current_time, current_date, or current_timestamp is not allowed in a check constraint.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/core/sql/executor/ExExeUtilExplain.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilExplain.cpp b/core/sql/executor/ExExeUtilExplain.cpp
index 43f284b..cb7241f 100644
--- a/core/sql/executor/ExExeUtilExplain.cpp
+++ b/core/sql/executor/ExExeUtilExplain.cpp
@@ -3923,10 +3923,8 @@ short ExExeUtilDisplayExplainComplexTcb::work()
// description field.
// All other errors are reported.
cliInterface()->retrieveSQLDiagnostics(getDiagsArea());
- if (((getDiagsArea()->contains(-1292)) ||
- (getDiagsArea()->contains(-1293))) ||
- (exeUtilTdb().loadIfExists() &&
- getDiagsArea()->contains(-1055)))
+ if (exeUtilTdb().loadIfExists() &&
+ getDiagsArea()->contains(-1055))
{
SQL_EXEC_ClearDiagnostics(NULL);
}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/core/sql/parser/sqlparser.y
----------------------------------------------------------------------
diff --git a/core/sql/parser/sqlparser.y b/core/sql/parser/sqlparser.y
index b839b87..2c805da 100755
--- a/core/sql/parser/sqlparser.y
+++ b/core/sql/parser/sqlparser.y
@@ -25789,11 +25789,6 @@ column_constraint_definition : constraint_name_definition
column_constraint
optional_constraint_attributes
{
-// Commented out to allow non iso88591 constraint text
-// if (NonISO88591LiteralEncountered) {
-// *SqlParser_Diags << DgSqlCode(-1242);
-// YYABORT;
-// }
$$ = $2 /*column_constraint*/;
if ($2)
{
@@ -25807,11 +25802,6 @@ column_constraint_definition : constraint_name_definition
}
| column_constraint optional_constraint_attributes
{
-// Commented out to allow non iso88591 constraint text
-// if (NonISO88591LiteralEncountered) {
-// *SqlParser_Diags << DgSqlCode(-1242);
-// YYABORT;
-// }
$$ = $1 /*column_constraint*/;
if ($1)
$1->setConstraintAttributes(
@@ -26257,11 +26247,6 @@ compress_clause : TOK_COMPRESS
table_constraint_definition : { NonISO88591LiteralEncountered = FALSE; } constraint_name_definition table_constraint
optional_constraint_attributes
{
-// Commented out to allow non iso88591 constraint text
-// if (NonISO88591LiteralEncountered) {
-// *SqlParser_Diags << DgSqlCode(-1242);
-// YYABORT;
-// }
$3->setConstraintName(
*$2 /*constraint_name_definition*/);
$3->setConstraintKind(ElemDDLConstraint::
@@ -26274,11 +26259,6 @@ table_constraint_definition : { NonISO88591LiteralEncountered = FALSE; } constra
| { NonISO88591LiteralEncountered = FALSE; } table_constraint optional_constraint_attributes
{
-// Commented out to allow non iso88591 constraint text
-// if (NonISO88591LiteralEncountered) {
-// *SqlParser_Diags << DgSqlCode(-1242);
-// YYABORT;
-// }
$2->setConstraintKind(ElemDDLConstraint::
TABLE_CONSTRAINT_DEF);
$2->setConstraintAttributes(
@@ -27710,11 +27690,6 @@ view_definition : create_view_keywords ddl_qualified_name
order_by_clause
optional_with_check_option
{
- // if (NonISO88591LiteralEncountered) {
- // *SqlParser_Diags << DgSqlCode(-1239);
- // YYABORT;
- // }
-
RelRoot *top = finalize($8);
if (($9) &&
(CmpCommon::getDefault(ALLOW_ORDER_BY_IN_CREATE_VIEW) == DF_OFF))
@@ -29215,11 +29190,6 @@ trigger_definition: before_trigger_definition
before_trigger_definition: before_trigger_prefix triggerred_when_clause
triggered_before_action
{
- // if (NonISO88591LiteralEncountered) {
- // *SqlParser_Diags << DgSqlCode(-1238);
- // YYABORT;
- // }
-
$$ = $1; // the CreateTriggerStmt object to return
StmtDDLCreateTrigger *triggerObject = $1;
@@ -29256,12 +29226,7 @@ before_trigger_definition: before_trigger_prefix triggerred_when_clause
// returns pStmtDDL
after_trigger_definition: after_trigger_prefix triggerred_when_clause
triggered_after_action
- {
- // if (NonISO88591LiteralEncountered) {
- // *SqlParser_Diags << DgSqlCode(-1238);
- // YYABORT;
- // }
-
+ {
$$ = $1; // the CreateTriggerStmt object to return
StmtDDLCreateTrigger *triggerObject = $1;
@@ -29325,10 +29290,6 @@ before_trigger_prefix: create_trigger_keywords ddl_qualified_name
InsideTriggerDefinition = TRUE;
- // if (NonISO88591LiteralEncountered) {
- // *SqlParser_Diags << DgSqlCode(-1238);
- // YYABORT;
- // }
//
// Initialize names for REFERENCING
//
@@ -29401,11 +29362,6 @@ after_trigger_prefix: create_trigger_keywords ddl_qualified_name
InsideTriggerDefinition = TRUE;
- // if (NonISO88591LiteralEncountered) {
- // *SqlParser_Diags << DgSqlCode(-1238);
- // YYABORT;
- // }
-
//
// Initialize names for REFERENCING
//
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/core/sql/regress/seabase/EXPECTED022
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022
index 879a079..2a0251d 100644
--- a/core/sql/regress/seabase/EXPECTED022
+++ b/core/sql/regress/seabase/EXPECTED022
@@ -411,13 +411,13 @@ ROW_ID (EXPR)
--- 0 row(s) inserted.
>>insert into hbase."_ROW_".t022hbt1 values ('2', '100');
-*** ERROR[1429] Inserts into _ROW_ format external hbase tables can only use the VALUES clause and must use the column_create function to create values.
+*** ERROR[1429] Inserts into _ROW_ format external HBase tables can only use the VALUES clause and must use the column_create function to create values.
*** ERROR[8822] The statement was not prepared.
>>insert into hbase."_ROW_".t022hbt1 select * from hbase."_ROW_".t022hbt2;
-*** ERROR[1429] Inserts into _ROW_ format external hbase tables can only use the VALUES clause and must use the column_create function to create values.
+*** ERROR[1429] Inserts into _ROW_ format external HBase tables can only use the VALUES clause and must use the column_create function to create values.
*** ERROR[8822] The statement was not prepared.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
index f208652..a8e9033 100644
--- a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
+++ b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
@@ -229,58 +229,59 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
, CAT_COMPONENT_NOT_SYSTEM = 1221
, CAT_AUTHORIZATION_NOT_ENABLED = 1222
, CAT_CANT_GRANT_TO_SELF_OR_ROOT = 1223
- , CAT_INVALID_TYPE_FOR_PARAM = 1224
- , CAT_MIXED_PRIVILEGES = 1225
- , CAT_NO_PRIVILEGES_SPECIFIED = 1226
+ // unused = 1224
+ // unused = 1225
+ // unused = 1226
, CAT_NO_UNREG_USER_HAS_PRIVS = 1227
, CAT_ROLE_HAS_PRIVS_NO_DROP = 1228
, CAT_OPTION_NOT_SUPPORTED = 1229
, CAT_BY_CLAUSE_IN_PRIVATE_SCHEMA = 1230
, CAT_UNABLE_TO_CREATE_ROUTINE = 1231
- , CAT_UNABLE_TO_SAVE_DDL = 1232
- , CAT_CREATE_SCHEMA_IN_SYSCAT_IS_PROHIBITED = 1233
+ // unused = 1232
+ // unused = 1233
// unused = 1235
- , CAT_IMPROPER_SCHEMA_NAME = 1236
+ // unused = 1236
, CAT_NON_ISO88591_RANGE_PARTITION_COLUMN = 1240
- , CAT_INIT_AUTHORIZATION_FAILED = 1244
- , CAT_FIRST_KEY_VALUE_INVALID = 1245
+ // unused = 1244
+ // unused = 1245
// unused = 1246
- , CAT_PARTITION_NAME_ALREADY_EXISTS = 1248
+ // unused = 1248
// unused = 1249
// unused = 1250
, CAT_SCALE_OF_DEFAULT_VALUE_ADJUSTED = 1251
- , CAT_INVALID_INDEX_DATA = 1252
+ // unused = 1252
, CAT_DUPLICATE_UNIQUE_CONSTRAINT_ON_SAME_COL = 1254
- , CAT_UNABLE_TO_SET_UDR_OPTIONS = 1261
- , CAT_SCHEMA_IN_TRANSITION = 1262
- , CAT_RESERVED_UMD_PREFIX = 1263
+ // unused = 1261
+ // unused = 1262
+ // unused = 1263
, CAT_DUPLICATE_PRIVILEGES = 1264
- , CAT_DUPLICATE_GRANTEES = 1265
+ // unused = 1265
, CAT_ONLY_EXECUTE_PRIVILEGE_IS_ALLOWED_FOR_ROUTINE = 1266
, CAT_PRIVILEGE_NOT_ALLOWED_FOR_THIS_OBJECT_TYPE = 1267
, CAT_DUPLICATE_COLUMN_NAMES = 1268
- , CAT_LABEL_ALLOCATE_FAILED_DUE_TO_FS_ERROR = 1270
- , CAT_LABEL_ALLOCATE_FAILED_GREATER_THAN_MAXEXTENTS = 1271
- , CAT_NOT_LICENSED_FOR_SQLMX_DDL = 1272
- , CAT_MAXEXT_LESS_THAN_ALLOCATED_EXTENTS = 1273
- , CAT_WARNING_MAXEXT_RESET = 1274
- , CAT_CANNOT_DROP_DUE_TO_UNIQUE_CONSTRAINT = 1275
- , CAT_UNRECOGNIZED_PARTITIONING_SCHEME = 1277
- , CAT_ALL_SCHEMAS_OP_IN_PROGRESS = 1278
+ , CAT_RESERVED_COLUMN_NAME = 1269
+ // unused = 1270
+ // unused = 1271
+ // unused = 1272
+ // unused = 1273
+ // unused = 1274
+ // unused = 1275
+ // unused = 1277
+ // unused = 1278
, CAT_VOLATILE_OPERATION_ON_REGULAR_OBJECT = 1279
, CAT_REGULAR_OPERATION_ON_VOLATILE_OBJECT = 1280
, CAT_LOB_COLUMN_IN_VOLATILE_TABLE = 1282
- , CAT_NOT_DROPPABLE_TABLE = 1284
- , CAT_NOT_DROPPABLE_SCHEMA = 1285
- , CAT_ONLY_SUPER_ID_CAN_INITIALIZE_SECURITY = 1287
- , CAT_UNABLE_TO_INITIALIZE_SECURITY = 1288
+ // unused = 1284
+ // unused = 1285
+ // unused = 1287
+ // unused = 1288
, CAT_CANNOT_ALTER_DEFINITION_METADATA_SCHEMA = 1289
- , CAT_DELETE_FROM_TRANSLATION_TABLE_FAILED = 1292
- , CAT_WRONG_SCHEMA_VERSION = 1293
- , CAT_WRONG_ISO_MAPPING = 1294
- , CAT_COLUMN_WRONG_DEFAULT_TYPE = 1295
- , CAT_COLUMN_MISMATCHED_DEFAULT_TYPES = 1296
- , CAT_VOLATILE_SCHEMA_PRESENT = 1297
+ // unused = 1292
+ // unused = 1293
+ // unused = 1294
+ // unused = 1295
+ // unused = 1296
+ // unused = 1297
, CAT_UNABLE_TO_ALTER_SCHEMA = 1298
// Restrict and No Action referential action Messages.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp b/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
index d56a0da..de6f778 100644
--- a/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
+++ b/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
@@ -2011,7 +2011,7 @@ short CmpSeabaseDDL::createSeabaseTable2(
if ((CmpCommon::getDefault(TRAF_ALLOW_RESERVED_COLNAMES) == DF_OFF) &&
(ComTrafReservedColName(colArray[i]->getColumnName())))
{
- *CmpCommon::diags() << DgSqlCode(-1269)
+ *CmpCommon::diags() << DgSqlCode(-CAT_RESERVED_COLUMN_NAME)
<< DgString0(colArray[i]->getColumnName());
deallocEHI(ehi);
@@ -5491,7 +5491,7 @@ void CmpSeabaseDDL::alterSeabaseTableAddColumn(
if ((CmpCommon::getDefault(TRAF_ALLOW_RESERVED_COLNAMES) == DF_OFF) &&
(ComTrafReservedColName(colName)))
{
- *CmpCommon::diags() << DgSqlCode(-1269)
+ *CmpCommon::diags() << DgSqlCode(-CAT_RESERVED_COLUMN_NAME)
<< DgString0(colName);
deallocEHI(ehi);
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
----------------------------------------------------------------------
diff --git a/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
index be303f7..22327ee 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
@@ -1402,7 +1402,7 @@ other than an outermost SELECT statement.
```
If a character literal was intended, you must use the single quote
-delimiter: <literal>. The use of double quotes causes {project-name} to
+delimiter: <literal>. The use of double quotes causes SQL to
interpret <column-name> as a delimited identifier column name.
```
@@ -1864,50 +1864,35 @@ incompatible data types.
*Recovery:* Correct the syntax and resubmit.
-[[SQL-4128]]
-== SQL 4128
-
-```
-Default volume and subvolume information could not be retrieved from=_DEFAULTS define - DEFINEINFO error <number>.
-```
-
-Where <number> is the error message.
-
-*Cause:* {project-name} was not able to retrieve
-default volume and subvolume information using the =_DEFAULTS define.
-
-*Effect:* The operation fails.
-
-*Recovery:* Check the =_DEFAULTS define and resubmit.
-
[[SQL-4129]]
== SQL 4129
```
-An IF statement should have the same set of output host variables on
-both sides of IF THEN statement list and the ELSE statement list.
+The character-typed result of the function <function-name> is longer than the maximum supported size.
```
-*Cause:* You specified an IF statement that does not have the same set
-of output host variables on both sides of its IF THEN statement list and
-its ELSE statement list.
+Where <function-name> is the name of a function you specified.
+
+*Cause:* You specified arguments to the given function that cause the result of the function
+to have a data type longer than the maximum supported character data type length.
*Effect:* The operation fails.
-*Recovery:* Correct the syntax and resubmit.
+*Recovery:* Change the arguments to the function and resubmit.
[[SQL-4130]]
== SQL 4130
```
-SIGNAL parameter 3 must be of type string
+<attribute-name> is a read-only DEFAULTS attribute and cannot be updated.
```
-*Cause:* You specified a SIGNAL parameter of an incorrect type.
+*Cause:* You attempted to perform a CONTROL QUERY DEFAULT but {project-name} does not
+allow this particular attribute to be changed.
*Effect:* The operation fails.
-*Recovery:* Correct the syntax and resubmit.
+*Recovery:* If a different attribute was intended, correct the syntax and resubmit.
[[SQL-4133]]
== SQL 4133
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/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 b04bb21..03ee310 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
@@ -1479,7 +1479,7 @@ calculations. Change the column definitions and reissue the statement.
== SQL 1143
```
-Validation for constraint <constraint-name> failed; incompatible data exists in referencing base table <referencing-table-name> and referenced base table <referenced-table-name>. To display the data that violates the constraint, please use the following DML statement: <statement-text>.
+Validation for constraint <constraint-name> failed; incompatible data exists in referencing base table <referencing-table-name> and referenced base table <referenced-table-name>. To display the data that violates the constraint, please use the following DML statement: <statement-text>
```
Where <constraint-name> is the name of a column constraint or table
@@ -1781,7 +1781,7 @@ support columns of the given data type with the SERIALIZED attribute.
== SQL 1192
```
-Failed to retrieve data from Hive metastore. Call to <function> returned error <optional-symbol>(<error-number>). Cause: <diagnostics>.
+Failed to retrieve data from Hive metastore. Call to <function> returned error <optional-symbol>(<error-number>). Cause: <diagnostics>.
```
Where <function> is a {project-name} internal method call.
@@ -1853,7 +1853,6 @@ Where <upper-bound> is the largest allowable number of salt partitions supported
*Recovery:* Correct the SALT clause then resubmit.
-<<<
[[SQL-1197]]
== SQL 1197
@@ -1886,257 +1885,270 @@ The PARTITION BY clause is not allowed for a Trafodion table.
*Recovery:* Remove the PARTITION BY clause from the DDL statement and resubmit.
-<<<
-[[SQL-1224]]
-== SQL 1224
+[[SQL-1200]]
+== SQL 1200
```
-An invalid data type was specified for routine parameter <parameter-name>.
+An error occurred while reading HDFS file statistics for Hive table <table-name>. Cause: <diagnostics>.
```
-Where <parameter-name> is the name of the parameter.
+Where <table-name> is the name of a Hive table.
-*Cause:* You specified a data type for this routine parameter that is
-not supported.
+Where <diagnostics> give diagnostics as to the cause of the error.
-*Effect:* {project-name} is unable to complete the operation.
+*Cause:* The {project-name} engine attempted to read file statistics from HDFS for a particular Hive table.
+A failure occurred at the HDFS or Hive level. The diagnostics contain more information about the failure.
-*Recovery:* Specify a different data type.
+*Effect:* The operation fails.
+
+*Recovery:* Address the indicated issue at the HDFS or Hive level, then resubmit.
<<<
-[[SQL-1225]]
-== SQL 1225
+[[SQL-1201]]
+== SQL 1201
```
-Mixing EXECUTE with other privileges is not allowed.
+Salted index <index-name> cannot be unique.
```
-*Cause:* EXECUTE and another privilege were specified in the same GRANT
-or REVOKE statement, which is not allowed.
+Where <index-name> is the name of a {project-name} index that you are trying to create.
+
+*Cause:* You attempted a CREATE UNIQUE INDEX statement that included the SALT LIKE TABLE clause.
+SALT LIKE TABLE is not allowed for unique indexes.
*Effect:* The operation fails.
-*Recovery:* Use separate GRANT or REVOKE statements for EXECUTE and other privileges.
+*Recovery:* Remove either the UNIQUE keyword or the SALT LIKE TABLE clause and resubmit.
-[[SQL-1226]]
-== SQL 1226
+[[SQL-1202]]
+== SQL 1202
```
-No valid combination of privileges was specified.
+Index <index-name> cannot be salted like a table since table <table-name> is not salted.
```
-*Cause:* The GRANT or REVOKE statement did not specify a valid
-combination of privileges.
+Where <index-name> is the name of a {project-name} index that you are trying to create.
+
+Where <table-name> is a {project-name} table.
+
+*Cause:* You attempted a CREATE INDEX statement that included the SALT LIKE TABLE clause on
+a table that is not salted.
*Effect:* The operation fails.
-*Recovery:* Specify a valid combination of privileges in the GRANT or REVOKE statement.
+*Recovery:* Remove the SALT LIKE TABLE clause and resubmit.
<<<
-[[SQL-1231]]
-== SQL 1231
+[[SQL-1203]]
+== SQL 1203
```
-User-defined routine <procedure-name> could not be created.
+HBASE_OPTIONS clause in CREATE statement is longer than 6000 characters. Object <object-name> was not created.
```
-Where <procedure-name> is the stored procedure's ANSI name.
+Where <object-name> is the name of a {project-name} object that you are trying to create.
-*Cause:* The stored procedure could not be created.
+*Cause:* The HBASE_OPTIONS clause specified in the CREATE statement contained more than 6000
+characters of HBase options, exceeding the length limit that {project-name} supports.
-*Effect:* The CREATE PROCEDURE statement fails.
+*Effect:* The operation fails.
-*Recovery:* Fix the error conditions identified in messages preceding
-this message and reissue the CREATE PROCEDURE statement.
+*Recovery:* Shorten the set of options specified in HBASE_OPTIONS and resubmit.
-[[SQL-1232]]
-== SQL 1232
+[[SQL-1204]]
+== SQL 1204
```
-A file error occurred when saving dropped table DDL for table <table-name> to <path-name>.
+Unsupported Hive datatype <Hive-datatype>.
```
-Where <table-name> is the table being dropped whose DDL was to be saved.
-
-Where <path-name> is the pathname of the file to which the DDL was to
-be saved.
-
-*Cause:* A file system error occurred when you attempted to save a table
-DDL. Possible reasons are:
+Where <Hive-datatype> is a Hive data type.
-* The directory `/usr/tandem/sqlmx/ddl` did not exist or could not be
-created.
-* The system did not have write access to `/usr/tandem/sqlmx/ddl`.
-* Insufficient file space was available.
+*Cause:* You attempted to reference a Hive table that has a column with a data type
+that {project-name} does not support.
-*Effect:* The table is not dropped.
+*Effect:* The operation fails.
-*Recovery:* Either correct the file system problem and drop the table or
-perform a SHOWDDL on the existing table, capture the output, set.
-SAVE_DROPPED_TABLE_DDL to "OFF," and drop the table. For information
-about file system errors, see <<file_system_errors,File-System Errors>>.
+*Recovery:* If the wrong Hive table was referenced, correct the reference and resubmit.
<<<
-[[SQL-1233]]
-== SQL 1233
+[[SQL-1214]]
+== SQL 1214
```
-Creating schema in {project-name} system catalog <catalog-name> is prohibited.
+Error <Hive-exception-info> encountered when executing HiveQL statement <Hive-statement>.
```
-Where <catalog-name> is the name of the {project-name} database catalog.
+Where <Hive-exception-info> is error diagnostic information from Hive.
-*Cause:* You attempted to create a schema in the system catalog.
+Where <Hive-statement> is the Hive SQL statement you specified.
+
+*Cause:* You attempted to execute a Hive SQL statement via the PROCESS HIVE STATEMENT command,
+and Hive detected errors in that statement.
*Effect:* The operation fails.
-*Recovery:* Choose a different catalog name and reissue the CREATE
-statement.
+*Recovery:* Determine the proper recovery action from the <Hive-exception-info> then resubmit.
-<<<
-[[SQL-1236]]
-== SQL 1236
+[[SQL-1215]]
+== SQL 1215
```
-The schema name specified for SQL object <object-name> is not valid. The schema name must be the same as the schema being created.
+An error occurred while determining host, port, or file name for HDFS URI <HDFS-URI>. Cause: <diagnostics>.
```
-Where <object-name> is the name of the SQL object.
+Where <HDFS-URI> is a Uniform Resource Identifier for a Hive table partition.
+
+Where <diagnostics> are diagnostics from HDFS.
-*Cause:* You specified a schema name for an object that is different
-from the name of the schema being created.
+*Cause:* You attempted to access a Hive table but {project-name} could not obtain location information
+about that object.
*Effect:* The operation fails.
-*Recovery:* Specify a schema name for the object that matches the name
-of the schema being created.
+*Recovery:* Determine the proper recovery action from the <diagnostics> then resubmit.
-[[SQL-1238]]
-== SQL 1238
+<<<
+[[SQL-1222]]
+== SQL 1222
```
-The character set for TRIGGER text must be ISO88591.
+Command not supported when authorization is not enabled.
```
-*Cause:* You specified a literal with a character set other than
-ISO88591 in the text of a create trigger statement.
+*Cause:* You attempted to perform a privilege-related command (e.g. GRANT), but authorization
+is not enabled on this {project-name} instance.
*Effect:* The operation fails.
-*Recovery:* Specify only ISO88591 literals in the command.
+*Recovery:* Enable authorization on the instance (e.g. INITIALIZE AUTHORIZATION), register users and resubmit.
-<<<
-[[SQL-1239]]
-== SQL 1239
+[[SQL-1223]]
+== SQL 1223
```
-The character set for string literals in VIEW text must be ISO88591.
+Grant to self or DB__ROOT is not allowed.
```
-*Cause:* You specified a literal with a character set other than
-ISO88591 in the text of a create view statement.
+*Cause:* You attempted to grant a privilege to yourself or to DB__ROOT.
*Effect:* The operation fails.
-*Recovery:* Specify only ISO88591 literals in the command.
+*Recovery:* None.
-[[SQL-1240]]
-== SQL 1240
+<<<
+[[SQL-1227]]
+== SQL 1227
```
-The character set for a PARTITION KEY column must be ISO88591.
+Cannot unregister user. User <user-name> has been granted privileges on <object-name>.
```
-*Cause:* You specified a literal with a character set other than
-ISO88591 as a partition key.
+Where <user-name> is the name of a user that you are trying to unregister.
+
+Where <object-name> is the name of a {project-name} object.
+
+*Cause:* You attempted to unregister a user, but the user has privileges on a {project-name} object.
*Effect:* The operation fails.
-*Recovery:* Specify only ISO88591 literals as partition keys.
+*Recovery:* Use REVOKE to remove any privileges granted to the user, then resubmit.
-<<<
-[[SQL-1241]]
-== SQL 1241
+[[SQL-1228]]
+== SQL 1228
```
-The character set for HEADING must be ISO88591.
+Cannot drop role. Role <role-name> has been granted privileges on <object-name>.
```
-*Cause:* You specified a literal with a character set other than
-ISO88591 in a HEADING clause.
+Where <role-name> is the name of a role that you are trying to drop.
+
+Where <object-name> is the name of a {project-name} object.
+
+*Cause:* You attempted to drop a role that has privileges. All privileges granted to a role
+must be dropped before the role can be dropped.
*Effect:* The operation fails.
-*Recovery:* Specify only ISO88591 literals in HEADING clauses.
+*Recovery:* Use SHOWDDL on the <object-name> to see what privileges are granted to the role.
+Then REVOKE those privileges, and resubmit the DROP ROLE statement.
-[[SQL-1242]]
-== SQL 1242
+<<<
+[[SQL-1230]]
+== SQL 1230
```
-The character set for string literals in CONSTRAINT must be ISO88591.
+Object owner must be the schema owner in private schemas.
```
-*Cause:* You specified a literal with a character set other than
-
-ISO88591 in the text of a constraint.
+*Cause:* You attempted to create an object on behalf of another user but you attempted
+to place the object in a private schema owned by a different user.
*Effect:* The operation fails.
-*Recovery:* Specify only ISO88591 literals in constraints.
+*Recovery:* Correct the schema name of the new object or correct the user name in the BY clause
+to match the owner of the schema.
<<<
-[[SQL-1243]]
-== SQL 1243
+[[SQL-1231]]
+== SQL 1231
```
-The hexadecimal form of string literals is not allowed in this context.
+User-defined routine <procedure-name> could not be created.
```
-*Cause:* You specified a hexadecimal literal in the text of the
-statement, which is not allowed.
+Where <procedure-name> is the stored procedure's ANSI name.
-*Effect:* The operation fails.
+*Cause:* The stored procedure could not be created.
-*Recovery:* Do not specify hexadecimals in this type of command.
+*Effect:* The CREATE PROCEDURE statement fails.
-[[SQL-1245]]
-== SQL 1245
+*Recovery:* Fix the error conditions identified in messages preceding
+this message and reissue the CREATE PROCEDURE statement.
+
+[[SQL-1234]]
+== SQL 1234
```
-The supplied partition key value (<key-value>) for column <column-name> of object <object-name> is not valid.
+Authorization needs to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.
```
-Where <key-value> is the specified first key value.
+*Cause:* Privilege metadata has become corrupted.
-Where <column-name> is the column of <object-name> that corresponds to
-the invalid key value.
+*Effect:* Some or all authorization operations on the {project-name} instance will fail.
-Where <object-name> is the name of the affected object.
+*Recovery:* Reinitialize authorization by performing INITIALIZE AUTHORIZATION, DROP followed by INITIALIZE AUTHORIZATION.
-*Cause:* A utility command specified an invalid key value.
+<<<
+[[SQL-1240]]
+== SQL 1240
+
+```
+The character set for a PARTITION KEY column must be ISO88591.
+```
+
+*Cause:* You specified a literal with a character set other than
+ISO88591 as a partition key.
*Effect:* The operation fails.
-*Recovery:* Specify valid key values and resubmit.
+*Recovery:* Specify only ISO88591 literals as partition keys.
-<<<
-[[SQL-1248]]
-== SQL 1248
+[[SQL-1243]]
+== SQL 1243
```
-Partition name <partition-name> has already been used. Each partition in an object should have a unique name.
+The hexadecimal form of string literals is not allowed in this context.
```
-Where <partition-name> is the name specified for a partition.
-
-*Cause:* Partition names are required to be unique within the set of
-partitions of an object.
+*Cause:* You specified a hexadecimal literal in the text of the
+statement, which is not allowed.
-*Effect:* The CREATE statement fails.
+*Effect:* The operation fails.
-*Recovery:* Choose a name that is not the same as any other partition
-name in this object and reissue the CREATE statement.
+*Recovery:* Do not specify hexadecimals in this type of command.
+<<<
[[SQL-1251]]
== SQL 1251
@@ -2157,22 +2169,6 @@ extra digits to the right are discarded.
*Recovery:* None. This is a warning message only.
<<<
-[[SQL-1252]]
-== SQL 1252
-
-```
-The existing index <index-name> to be used by a unique or primary constraint has not been populated. Please populate the index and then try to add the constraint again.
-```
-
-Where <index-name> is the name of an existing unpopulated index.
-
-*Cause:* An existing index that is not populated has been chosen for a
-unique or primary constraint, which is not allowed.
-
-*Effect:* The operation fails.
-
-*Recovery:* Populate the index and resubmit.
-
[[SQL-1254]]
== SQL 1254
@@ -2191,72 +2187,71 @@ constraints or multiple unique constraints are not specified on the same
set of columns.
<<<
-[[SQL-1262]]
-== SQL 1262
+[[SQL-1255]]
+== SQL 1255
```
-The command cannot be executed because <operation> is in progress for <schema>.
+Constraint <constraint-name> is the clustering key constraint for table <table-name> and cannot be dropped.
```
-Where <operation> is a schema-level operation.
+Where <constraint-name> refers to a constraint that you are trying to drop.
-Where <schema> is the ANSI name of the affected schema.
+Where <table-name> is the name of a {project-name} table.
-*Cause:* You attempted a DDL or utility operation on a database object
-while <operation> was in progress for that object's <schema>.
+*Cause:* You attempted to drop a constraint on a {project-name} table, but the constraint is implied by
+the clustering key and therefore cannot be dropped. This can occur, for example, if the primary key
+was used as the clustering key, and you attempt to drop the primary key constraint.
-*Effect:* The DDL or utility operation fails.
+*Effect:* The operation fails.
-*Recovery:* Wait until the operation has finished, and then retry the
-DDL or utility operation.
+*Recovery:* If you genuinely wish to remove this constraint, recreate the table with a different
+clustering key.
-[[SQL-1263]]
-== SQL 1263
+[[SQL-1256]]
+== SQL 1256
```
-Table, view, and stored procedure names that start with <text> are reserved for {project-name} metadata.
+PRIMARY KEY constraint cannot be added since table <table-name> already has a user specified clustering key.
```
-Where <text> is the disallowed name that was specified.
+Where <table-name> is the name of a {project-name} table.
-*Cause:* You specified a {project-name} database reserved object name.
+*Cause:* You attempted to add a primary key constraint, but the table already has a user-specified
+clustering key. This can happen, for example, when adding a primary key to a table that already has one.
-*Effect:* The object is not created.
+*Effect:* The operation fails.
-*Recovery:* See the {docs-url}/sql_reference/index.html[_{project-name} SQL Reference Manual_] for the list of
-reserved object names. Choose a name that is not reserved and reissue
-the CREATE statement.
+*Recovery:* If you genuinely wish to add this primary key, recreate the table with the primary key as
+its clustering key.
<<<
-[[SQL-1264]]
-== SQL 1264
+[[SQL-1260]]
+== SQL 1260
```
-Duplicate privileges are not allowed in a GRANT or REVOKE statement.
+Debugging of UDRs is only allowed for the DB__ROOT user. Connect as DB__ROOT, preferably using the sqlci tool, and try again.
```
-*Cause:* You specified duplicate privileges in a GRANT or REVOKE
-statement.
+*Cause:* You attempted to debug a User Defined Routine, but you were not connected as DB__ROOT.
*Effect:* The operation fails.
-*Recovery:* Reissue the GRANT or REVOKE statement, specifying a single
-privilege or a list of distinct privileges.
+*Recovery:* Connect as DB__ROOT and resubmit.
-[[SQL-1265]]
-== SQL 1265
+[[SQL-1264]]
+== SQL 1264
```
-Duplicate grantees not allowed in a GRANT or REVOKE statement.
+Duplicate privileges are not allowed in a GRANT or REVOKE statement.
```
-*Cause:* You specified duplicate grantees in a GRANT or REVOKE
+*Cause:* You specified duplicate privileges in a GRANT or REVOKE
statement.
*Effect:* The operation fails.
-*Recovery:* Reissue the GRANT or REVOKE statement specifying a single
-grantee or a list of distinct grantees.
+*Recovery:* Reissue the GRANT or REVOKE statement, specifying a single
+privilege or a list of distinct privileges.
<<<
[[SQL-1266]]
@@ -2278,9 +2273,11 @@ for the procedure or routine.
== SQL 1267
```
-EXECUTE privilege is incompatible with this object type.
+<privilege-type> privilege is incompatible with this object type.
```
+Where <privilege-type> is a type of privilege (e.g. EXECUTE).
+
*Cause:* You specified a privilege that is not supported for the object
type in a GRANT statement.
@@ -2305,141 +2302,135 @@ references privilege in a GRANT or REVOKE statement.
*Recovery:* Correct the GRANT or REVOKE statement by specifying a single
column name or a list of distinct column names.
-[[SQL-1270]]
-== SQL 1270
+<<<
+[[SQL-1269]]
+== SQL 1269
```
-ALLOCATE or DEALLOCATE failed for object <sql-object-name> due to
-file error <file-system-error-number> on <file-name>.
+Column name <column-name> is reserved for internal system usage. It cannot be specified as a user column.
```
-Where <sql-object-name> is the ANSI name of the affected SQL database
-object.
+Where <column-name> is the column name you specified.
-Where <file-system-error-number> is a {project-name} platform file system
-error code.
-
-*Cause:* A CREATE or ALTER operation encountered a file system error
-<error-number> during processing of the ALLOCATE or DEALLOCATE attribute.
+*Cause:* You attempted to use a column name in a DDL statement that is reserved by {project-name}
+for internal use. For example,
+you attempted to create a table with a column named SYSKEY.
*Effect:* The operation fails.
-*Recovery:* For information about file system errors, see
-<file-system-errors,File-System Errors>.
+*Recovery:* Correct the DDL statement and resubmit.
-<<<
-[[SQL-1271]]
-== SQL 1271
+[[SQL-1276]]
+== SQL 1276
```
-ALLOCATE failed for object <object-name> because extents to be allocated <number> is greater than the MAXEXTENTS for a partition of the object.
+Unable to select partition <partition-number> from table <table-name>.
```
-Where <object-name> is the ANSI name of the affected database object.
+Where <partition-number> is a partition number you specified.
-Where <number> is the specified number of extents.
+Where <table-name> is the table name you specified.
-*Cause:* A CREATE or ALTER operation specified an ALLOCATE attribute
-value that was greater than the MAXEXTENTS value for the affected
-database object, which is not allowed.
+*Cause:* You attempted to select data from a subset of the partitions of a table, but the
+table in question is not salted or the table name given refers to a view.
*Effect:* The operation fails.
-*Recovery:* If possible, alter the MAXEXTENTS attribute value to be
-greater than the
-
-desired number of extents to be allocated. The current maximum value for
-MAXEXTENTS is 768.
+*Recovery:* Correct the statement and resubmit.
-[[SQL-1273]]
-== SQL 1273
+<<<
+[[SQL-1279]]
+== SQL 1279
```
-The specified MAXEXTENTS value must be greater than the number of extents allocated.
+A volatile DDL statement cannot be used on regular objects.
```
-*Cause:* The value that you specified to change MAXEXTENTS is less than
-or equal to the allocated extents.
+*Cause:* You specified VOLATILE when performing a DDL operation on a non-volatile object. For example, you
+may have specified DROP VOLATILE TABLE on a table that is not volatile.
*Effect:* The operation fails.
-*Recovery:* Use a MAXEXTENTS value greater than the allocated extents.
+*Recovery:* Correct the statement and resubmit.
-<<<
-[[SQL-1274]]
-== SQL 1274
+[[SQL-1280]]
+== SQL 1280
```
-The specified or default MAXEXTENTS value is not sufficient. The MAXEXTENTS value has been automatically set to the new value of <value> for the file <file-name>.
+A regular DDL statement cannot be used on volatile objects.
```
-*Cause:* You specified an insufficient MAXEXTENTS value while creating
-an index.
+*Cause:* You attempted an unsupported ALTER statement on a volatile object. Altering a column
+on a volatile table, for example, is not presently supported.
-*Effect:* The SQL operation completed with a warning.
+*Effect:* The operation fails.
-*Recovery:* This is a warning only.
+*Recovery:* Correct the statement and resubmit.
-[[SQL-1275]]
-== SQL 1275
+<<<
+[[SQL-1282]]
+== SQL 1282
```
-Constraint <constraint-1> cannot be dropped because it is needed by unique constraint <constraint-2>.
+A LOB column cannot be specified in a volatile table.
```
-Where <constraint-1> is the constraint you are trying to drop.
+*Cause:* You attempted to create a volatile table with a BLOB or CLOB column. {project-name} presently
+does not support this. (Note: By default, {project-name} maps BLOB and CLOB columns to VARCHAR columns,
+which are supported. This particular error message can only occur if this mapping is turned off. The
+mapping is turned off when CQD TRAF_BLOB_AS_VARCHAR and/or CQD TRAF_CLOB_AS_VARCHAR is set to 'OFF'.)
+
+*Effect:* The operation fails.
-Where <constraint-2> is the UNIQUE constraint.
+*Recovery:* Correct the statement and resubmit.
-*Cause:* You attempted to drop a constraint that is needed by a UNIQUE
-constraint, which is not allowed because it would leave a UNIQUE
-constraint on a column, but without a NOT NULL constraint for that
-column.
+[[SQL-1283]]
+== SQL 1283
+
+```
+The specified constraint or file option is not supported on a volatile table.
+```
+
+*Cause:* You attempted to create a volatile table with a feature that {project-name} does not support
+on volatile tables. For example, unique constraints are not supported on volatile table columns.
*Effect:* The operation fails.
-*Recovery:* To drop the constraint, you must remove the UNIQUE
-constraint or add an additional NOT NULL constraint to the columns that
-contain UNIQUE constraints and only one NOT NULL constraint for that
-column.
+*Recovery:* Correct the statement and resubmit.
<<<
-[[SQL-1277]]
-== SQL 1277
+[[SQL-1289]]
+== SQL 1289
```
-Unrecognized partitioning scheme for object <object-name>.
+The use of ALTER on reserved schemas and metadata schemas is not permitted.
```
-<object-name> is the name of the SQL object (table or index).
+*Cause:* You attempted to ALTER an object in a reserved or metadata schema. This is not
+permitted.
-*Cause:* The {project-name} database does not recognize the partitioning
-scheme stored in the metadata for the named object.
-
-*Effect:* The named object is considered corrupt and is inaccessible.
+*Effect:* The operation fails.
-*Recovery:* None. Contact the {project-name} User Distribution List Consider
-running the VERIFY operation on the named object to check for
-inconsistencies in the metadata with respect to the partitioning scheme.
+*Recovery:* If your intent was to alter a different object, correct the object name and resubmit.
-[[SQL-1278]]
-== SQL 1278
+[[SQL-1298]]
+== SQL 1298
```
-The command cannot be executed because <operation> is in progress for all schemas in catalog <catalog>.
+Schema <schema-name> could not be altered. <reason>
```
-<operation> is a schema level operation, currently UPGRADE or DOWNGRADE,
-that uses the ALL SCHEMAS IN CATALOG flavor. <catalog> is a catalog name
-that is affected by <operation>.
+Where <schema-name> is the name of the schema you specified.
-*Cause:* An attempt was made to execute a DDL or utility operation that
-affected <catalog>, or a schema in that catalog.
+Where <reason> gives further information about the nature of the error.
+
+*Cause:* You attempted an ALTER SCHEMA statement but one or more objects in the schema are in an
+invalid state. The <reason> gives more details concerning this invalid state.
*Effect:* The operation fails.
-*Recovery:* Wait until <operation> is finished, then retry the failed
-DDL or utility operation.
+*Recovery:* The <reason> may suggest possible recoveries. For example, you may need to
+use CLEANUP on certain objects in the schema, then resubmit the ALTER SCHEMA statement.
<<<
[[SQL-1301]]
@@ -2630,10 +2621,10 @@ be additional messages giving details of the failure.
== SQL 1424
```
-Column <column-name> cannot be dropped as that would leave the table with no user defined columns.
+Column <column-name> cannot be dropped as that would leave the table with no user defined or user updatable columns.
```
-*Cause:* You attempted to drop the only remaining user-defined column in the table.
+*Cause:* You attempted to drop the only remaining user-defined or user-updatable column in the table.
*Effect:* The operation fails.
@@ -2658,7 +2649,7 @@ be performed. <reason> gives more details.
== SQL 1426
```
-An invalid HBase column name <column-name> was specified. A valid name must be of the format: <ColumnFamily>:<ColumnName>
+An invalid HBase column name <column-name> was specified. A valid name must be of the format: <ColumnFamily>:<ColumnName>
```
*Cause:* When accessing an external HBase table (for example, using _ROW_ format), you specified
@@ -2711,4 +2702,18 @@ clause but did not use a COLUMN_CREATE function.
*Recovery:* Correct the statement and resubmit.
+[[SQL-1430]]
+== SQL 1430
+
+```
+A schema name that starts and ends with an "_"(underscore) is reserved for internal usage. It cannot be used to create a user schema.
+```
+
+*Cause:* You attempted to create a schema with a name beginning and ending with an underscore. These names are
+reserved by {project-name} for internal use.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1304c577/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc
----------------------------------------------------------------------
diff --git a/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc
index 4c18674..2f2c4ee 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc
@@ -2850,7 +2850,7 @@ specified is an unsigned numeric.
== SQL 3209
```
-Maximum length of LONGWVARCHAR is <value>.
+The maximum length of LONGWVARCHAR is <value>.
```
*Cause:* You attempted a CREATE TABLE table name (columnname
@@ -2868,7 +2868,7 @@ and resubmit.
== SQL 3210
```
-Minimum length of LONGWVARCHAR is <value>.
+The minimum length of LONGWVARCHAR is <value>.
```
*Cause:* You attempted a CREATE TABLE table name (columnname
@@ -2885,7 +2885,7 @@ and resubmit.
== SQL 3211
```
-Maximum length of LONG VARBINARY is <value>.
+The maximum length of LONG VARBINARY is <value>.
```
*Cause:* You attempted a CREATE TABLE table name (columnname long
@@ -2902,7 +2902,7 @@ and resubmit.
== SQL 3212
```
-Minimum length of LONG VARBINARY is <value>.
+The minimum length of LONG VARBINARY is <value>.
```
*Cause:* You attempted a CREATE TABLE table name (columnname long
@@ -2918,7 +2918,7 @@ and resubmit.
== SQL 3213
```
-Maximum length of LONG VARCHAR is <value>.
+The maximum length of LONG VARCHAR is <value>.
```
*Cause:* You attempted a CREATE TABLE table name (columnname long
@@ -2935,7 +2935,7 @@ and resubmit.
== SQL 3214
```
-Minimum length of LONG VARCHAR is <value>.
+The minimum length of LONG VARCHAR is <value>.
```
*Cause:* You attempted a CREATE TABLE table name (columnname long
@@ -3003,7 +3003,7 @@ functions.
== SQL 3218
```
-A table reference cannot contain DELETE or UPDATE in a CREATE VIE statement.
+A table reference cannot contain DELETE or UPDATE in a CREATE VIEW statement.
```
*Cause:* A create view statement was issued with a delete or update
@@ -3013,23 +3013,6 @@ operation as a table reference.
*Recovery:* Do not use delete or update in a CREATE view statement.
-[[SQL-3220]]
-== SQL 3220
-
-```
-SHOWDDL failed for object <object-name> because an SQL/MP display option was used on a {project-name} object.
-```
-
-Where <object-name> specifies the ANSI name of a table, view, or ALIAS.
-
-*Cause:* SHOWDDL was given the display option with a {project-name}
-table given as an argument.
-
-*Effect:* SHOWDDL does not display output.
-
-*Recovery:* Reissue the command without the display option or specify an
-object.
-
<<<
[[SQL-3225]]
== SQL 3225
[2/2] incubator-trafodion git commit: Merge [TRAFODION-2852] PR 1357
Update msgs 1200-1299 + others in Msgs Guide
Posted by db...@apache.org.
Merge [TRAFODION-2852] PR 1357 Update msgs 1200-1299 + others in Msgs Guide
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/00c37085
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/00c37085
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/00c37085
Branch: refs/heads/master
Commit: 00c37085831961f16994c42220d8df88f8c0ddb8
Parents: d54589f 1304c57
Author: Dave Birdsall <db...@apache.org>
Authored: Sat Dec 23 04:38:08 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Sat Dec 23 04:38:08 2017 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 90 ++--
core/sql/executor/ExExeUtilExplain.cpp | 6 +-
core/sql/parser/sqlparser.y | 46 +-
core/sql/regress/seabase/EXPECTED022 | 4 +-
core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 65 +--
core/sql/sqlcomp/CmpSeabaseDDLtable.cpp | 4 +-
.../src/asciidoc/_chapters/binder_msgs.adoc | 37 +-
.../src/asciidoc/_chapters/ddl_msgs.adoc | 513 ++++++++++---------
.../src/asciidoc/_chapters/parser_msgs.adoc | 31 +-
9 files changed, 362 insertions(+), 434 deletions(-)
----------------------------------------------------------------------