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 2018/01/09 17:48:09 UTC
[1/2] trafodion git commit: [TRAFODION-2880] Update Messages Guide in
range 1500-1602 + some others
Repository: trafodion
Updated Branches:
refs/heads/master 25872e771 -> 3dbfa89f9
[TRAFODION-2880] Update Messages Guide in range 1500-1602 + some others
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/a808cd39
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/a808cd39
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/a808cd39
Branch: refs/heads/master
Commit: a808cd39a512d4ac32bf5cba58118b6448f8b6a5
Parents: 8e332e5
Author: Dave Birdsall <db...@apache.org>
Authored: Mon Jan 8 00:06:32 2018 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Mon Jan 8 00:06:32 2018 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 103 +++---
core/sql/regress/seabase/EXPECTED025 | 14 +-
core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 69 ++--
.../src/asciidoc/_chapters/compiler_msgs.adoc | 6 +-
.../src/asciidoc/_chapters/ddl_msgs.adoc | 318 ++++++++++++++++++-
.../src/asciidoc/_chapters/parser_msgs.adoc | 12 +-
6 files changed, 416 insertions(+), 106 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/a808cd39/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index be528cd..3555ffb 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -413,37 +413,37 @@
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 .
-1500 ZZZZZ 99999 ADVANCED CRTCL DIALOUT The CATSYS - CAT_REFERENCES system schema relationship for catalog $0~CatalogName might be corrupt.
+1500 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
1501 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused as of 5/7/12 ---
-1502 ZZZZZ 99999 ADVANCED CRTCL DIALOUT The OBJECTS - REPLICAS definition schema relationship for $0~String0 $1~TableName might be corrupt.
-1503 ZZZZZ 99999 ADVANCED CRTCL DIALOUT The OBJECTS - PARTITIONS definition schema relationship for $0~String0 $1~TableName might be corrupt.
-1504 ZZZZZ 99999 ADVANCED MAJOR DIALOUT $0~TableName has no OBJECTS entry in $1~SchemaName.
-1505 ZZZZZ 99999 ADVANCED MAJOR DIALOUT The system schema metadata for catalog $0~CatalogName is inconsistent between the local node $1~String0 and remote node $2~String1.
-1506 ZZZZZ 99999 ADVANCED MAJOR DIALOUT The system schema metadata for schema $0~SchemaName is inconsistent between nodes $1~String0 and $2~String1.
+1502 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
+1503 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
+1504 ZZZZZ 99999 ADVANCED MAJOR DIALOUT --- unused ---
+1505 ZZZZZ 99999 ADVANCED MAJOR DIALOUT --- unused ---
+1506 ZZZZZ 99999 ADVANCED MAJOR DIALOUT --- unused ---
1507 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ----- Msg not currently used -----
1508 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ----- Msg not currently used -----
1509 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ----- Msg not currently used -----
-1510 ZZZZZ 99999 BEGINNER MAJOR DBADMIN IDENTITY column $0~ColumnName can be of the following data types only: LARGEINT, unsigned INTEGER and unsigned SMALL INT.
+1510 ZZZZZ 99999 BEGINNER MAJOR DBADMIN IDENTITY column $0~ColumnName can be of the following data types only: LARGEINT, INTEGER UNSIGNED and SMALLINT UNSIGNED.
1511 ZZZZZ 99999 BEGINNER MAJOR DBADMIN There can only be one IDENTITY column for a table.
-1512 ZZZZZ 99999 BEGINNER MAJOR DBADMIN IDENTITY column must be defined as a NOT NULL NOT DROPPABLE column.
-1513 ZZZZZ 99999 BEGINNER MAJOR DBADMIN IDENTITY column support is available only for hash and hash2 partitioned tables.
+1512 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1513 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1514 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Cannot add an IDENTITY column using ALTER TABLE command.
1515 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ----- Msg not currently used -----
-1516 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU
-1517 ZZZZZ 99999 BEGINNER MINOR DBADMIN Constraint $0~ConstraintName on table $1~TableName is NOT DROPPABLE, you cannot disable NOT DROPPABLE constraints.
-1518 ZZZZZ 99999 BEGINNER MINOR DBADMIN Constraint $0~ConstraintName was not enabled because it requires index $1~TableName which is currently disabled.
-1519 ZZZZZ 99999 BEGINNER MINOR DBADMIN Constraint $0~ConstraintName on table $1~TableName cannot be disabled because it is a foreign key constraint.
-1520 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU
-1521 ZZZZZ 99999 BEGINNER MINOR DBADMIN Exception table $0~string0 must be defined in the same schema as table $1~string1.
-1522 ZZZZZ 99999 BEGINNER MINOR DBADMIN Operation $0~string0 cannot be performed because $1~String1 is not an exception table.
-1523 ZZZZZ 99999 BEGINNER MINOR DBADMIN Exception table $0~TableName does not exist.
-1524 ZZZZZ 99999 BEGINNER MINOR DBADMIN Exception tables cannot be created on metadata tables.
-1525 ZZZZZ 99999 BEGINNER MINOR DBADMIN Exception tables cannot be created on exception tables.
-1526 ZZZZZ 99999 BEGINNER MINOR DBADMIN Exception table $0~string0 not found in metadata table $1~String1
-1527 ZZZZZ 99999 BEGINNER MINOR DBADMIN Key does not exist for $0~TableName. Cannot create exception table.
-1528 ZZZZZ 99999 BEGINNER MINOR DBADMIN Exception table $0~string0 not found for table $1~String1.
-1529 ZZZZZ 99999 BEGINNER MINOR DBADMIN Sequence Generator $0~string0 not found in metadata table $1~String1.
-1530 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Failed to add the LDAP default configuration.
+1516 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused ---
+1517 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1518 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1519 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1520 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused ---
+1521 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1522 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1523 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1524 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1525 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1526 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1527 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1528 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1529 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1530 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1540 ZZZZZ 99999 BEGINNER MINOR DBADMIN The NO POPULATE clause is not allowed for index $0~String0 on volatile table $1~TableName.
1541 ZZZZZ 99999 BEGINNER MINOR DBADMIN Use of BLOB/CLOB datatype as a key of the base table or an index is not allowed.
1550 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Failed to create UDF $0~string0 with $0~int0 parameters. A scalar UDF can have a maximum of 32 parameters.
@@ -453,47 +453,46 @@
1554 ZZZZZ 99999 ADVANCED MAJOR DBADMIN ---- Reserved for UDF ----
1555 ZZZZZ 99999 ADVANCED MAJOR DBADMIN ---- Reserved for UDF ----
1556 ZZZZZ 99999 ADVANCED MAJOR DBADMIN ---- Reserved for UDF ----
-1557 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Incorrect function data sequence numbering for function identifier $0~String0 in table $1~String1.
-1558 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Did not find a matching row for function $0~String0 in table $1~String1.
-1559 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Did not find a matching row for format or model '$0~String0' in table $1~String1.
-1560 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Error parsing column definition '$0~String0' for column number $1~Int0, function identifier $2~String1, in table $3~String2.
-1561 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Invalid column direction indicator for function identifier $0~String0, column number $1~Int0, in table $2~String1.
-1562 ZZZZZ 99999 ADVANCED MAJOR DBADMIN No output parameter rows found for model '$0~String0' in table $1~String1.
-1563 ZZZZZ 99999 ADVANCED MAJOR DBADMIN No input parameter rows found for model '$0~String0' in table $1~String1.
-1564 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Expected 1 output parameter row for format '$0~String0'. Found $1~Int0 rows in table $2~String1.
-1565 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Expected 1 input parameter row for format '$0~String0'. Found $1~Int0 rows in table $2~String1.
-1566 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Incorrect column numbering for function identifier $0~String0 in table $1~String1.
-1567 ZZZZZ 99999 ADVANCED MAJOR DBADMIN An error was encountered processing metadata for function $0~String0.
-1568 ZZZZZ 99999 ADVANCED MAJOR DBADMIN An error was encountered processing metadata for format or model '$0~String0'.
-1569 ZZZZZ 99999 ADVANCED MAJOR DBADMIN Subqueries are not allowed as arguments to user-defined functions.
+1557 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1558 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1559 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1560 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1561 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1562 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1563 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1564 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1565 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1566 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1567 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1568 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
+1569 ZZZZZ 99999 ADVANCED MAJOR DBADMIN --- unused ---
1570 ZZZZZ 99999 BEGINNER MAJOR DBADMIN MAXVALUE must be greater than MINVALUE for $0~string0.
1571 ZZZZZ 99999 BEGINNER MAJOR DBADMIN $0~string0 value cannot be zero for $1~string1.
1572 ZZZZZ 99999 BEGINNER MAJOR DBADMIN $0~string0 value cannot be a negative number for $0~string1.
1573 ZZZZZ 99999 BEGINNER MAJOR DBADMIN START WITH value must be greater than or equal to MINVALUE and less than or equal to MAXVALUE for $0~string0.
-1574 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The CYCLE option is currently not supported for $0~string0.
+1574 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1575 ZZZZZ 99999 BEGINNER MAJOR DBADMIN INCREMENT BY value cannot be greater than the difference between MINVALUE and MAXVALUE for $0~string0.
1576 ZZZZZ 99999 BEGINNER MAJOR DBADMIN $0~string0 value is greater than maximum allowed for this sequence.
1577 ZZZZZ 99999 BEGINNER MAJOR DBADMIN CACHE value must be greater than 1 and less than or equal to (maxValue-startValue+1)/incrementValue for $0~string0.
-1578 ZZZZZ 99999 BEGINNER MAJOR DBADMIN START WITH option cannot be used for $0~string0.
+1578 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1579 ZZZZZ 99999 BEGINNER MAJOR DBADMIN This sequence has reached its max and cannot provide a new value.
-1580 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Catalog $0~string0 uses an unsupported collation.
-1581 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Schema $0~string0 uses an unsupported collation.
+1580 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1581 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1582 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Internal Error: Sequence information does not exist in metadata.
1583 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Sequence metadata could not be updated.
1584 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Timestamp mismatch detected on Sequence object.
1590 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Column $0~ColumnName is not an IDENTITY column.
-1591 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The MAXVALUE option for the $0~string0 must be greater than the current value of $0~string1.
+1591 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1592 ZZZZZ 99999 BEGINNER MAJOR DBADMIN $0~string0 cannot be specified for $0~string1.
-1593 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Only one $0~string0 option can be altered at a time.
-1594 ZZZZZ 99999 BEGINNER MAJOR DBADMIN An error occurred trying to access the current value of the $0~string0.
-1595 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The MAXVALUE option for the $0~string0 must be a valid numeric value. NO MAXVALUE is not allowed.
-1596 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Recalibration of the internal sequence generator failed. \
- Please see additional messages for details.
-1597 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The maximum of the IDENTITY column, $0~string0, for the table, $0~string1, could not be obtained.
-1598 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The new CURRENT_VALUE, $0~string0, for the IDENTITY column, $0~string1, for the table, $0~string2, will be greater than the maximum allowed, $0~string3.
-1599 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The recalibration value is $0~string0 value, $0~string1, of the IDENTITY column, $0~string2, for the table, $0~string3.
-1600 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to lock table, $0~string0, for the IDENTITY column, $0~string1, during recalibration.
-1601 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Recalibration of the GENERATED ALWAYS AS IDENTITY column, $0~string0, for the table, $0~string1, is not allowed with NO SELECT.
+1593 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1594 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1595 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1596 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1597 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1598 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1599 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1600 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1601 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
1700 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Object $0~string0 is not a universal user-defined function.
1701 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Encountered an error while processing a routine definition. Too many pass through inputs.
http://git-wip-us.apache.org/repos/asf/trafodion/blob/a808cd39/core/sql/regress/seabase/EXPECTED025
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED025 b/core/sql/regress/seabase/EXPECTED025
index df98a2e..677cafa 100644
--- a/core/sql/regress/seabase/EXPECTED025
+++ b/core/sql/regress/seabase/EXPECTED025
@@ -328,7 +328,7 @@ CREATE TABLE TRAFODION.S025.T025T002
+> primary key(a) )
+>;
-*** ERROR[1510] IDENTITY column can be of the following data types only: LARGEINT, unsigned INTEGER and unsigned SMALL INT.
+*** ERROR[1510] IDENTITY column can be of the following data types only: LARGEINT, INTEGER UNSIGNED and SMALLINT UNSIGNED.
--- SQL operation failed with errors.
>>
@@ -348,7 +348,7 @@ CREATE TABLE TRAFODION.S025.T025T002
+>--HASH2 PARTITION BY(a)
+> ;
-*** ERROR[1510] IDENTITY column can be of the following data types only: LARGEINT, unsigned INTEGER and unsigned SMALL INT.
+*** ERROR[1510] IDENTITY column can be of the following data types only: LARGEINT, INTEGER UNSIGNED and SMALLINT UNSIGNED.
--- SQL operation failed with errors.
>>-- (ADD LOCATION $$partition$$);
@@ -369,7 +369,7 @@ CREATE TABLE TRAFODION.S025.T025T002
+>--HASH2 PARTITION BY(a)
+> ;
-*** ERROR[1510] IDENTITY column can be of the following data types only: LARGEINT, unsigned INTEGER and unsigned SMALL INT.
+*** ERROR[1510] IDENTITY column can be of the following data types only: LARGEINT, INTEGER UNSIGNED and SMALLINT UNSIGNED.
--- SQL operation failed with errors.
>>-- (ADD LOCATION $$partition$$);
@@ -1896,7 +1896,7 @@ CREATE TABLE TRAFODION.S025.T025T004
>>insert into T025T003 values
+>(DEFAULT,-3,0,1,'dasf',2.1,'dfaf','dfa','dfa','d');
-*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_662223558_9798 on table TRAFODION.S025.T025T003.
+*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_918519353_6685 on table TRAFODION.S025.T025T003.
--- 0 row(s) inserted.
>>
@@ -1906,7 +1906,7 @@ CREATE TABLE TRAFODION.S025.T025T004
+>(DEFAULT,-2,1,1,'dasf',2.1,'dfaf','dfa','dfa','d'),
+>(DEFAULT,-1,2,1,'dasf',2.1,'dfaf','dfa','dfa','d');
-*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_662223558_9798 on table TRAFODION.S025.T025T003.
+*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_918519353_6685 on table TRAFODION.S025.T025T003.
--- 0 row(s) inserted.
>>
@@ -2628,7 +2628,7 @@ CREATE VOLATILE TABLE T025T00V2
>>invoke T025T00V2;
-- Definition of Trafodion volatile table T025T00V2
--- Definition current Wed Apr 19 21:44:27 2017
+-- Definition current Sun Jan 7 23:18:49 2018
(
SURROGATE_KEY SMALLINT UNSIGNED GENERATED BY DEFAULT AS
@@ -2816,7 +2816,7 @@ A B
>>invoke t025t010;
-- Definition of Trafodion table TRAFODION.S025.T025T010
--- Definition current Wed Apr 19 21:46:42 2017
+-- Definition current Sun Jan 7 23:20:51 2018
(
A LARGEINT GENERATED ALWAYS AS IDENTITY NOT
http://git-wip-us.apache.org/repos/asf/trafodion/blob/a808cd39/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
index dd6b241..b193048 100644
--- a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
+++ b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
@@ -378,36 +378,35 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
, CAT_UNIQUE_INDEX_COLS_NOT_IN_DIV_EXPRS = 1402
, CAT_ALTER_NOT_ALLOWED_IN_SMD = 1403
- // Detectable metadata inconsistencies
- , CAT_CATSYS_CATREF_MISMATCH = 1500
- , CAT_OBJECTS_REPLICAS_MISMATCH = 1502
- , CAT_OBJECTS_PARTITIONS_MISMATCH = 1503
- , CAT_NO_OBJECTS_ROW_FOR_SMD = 1504
- , CAT_CATSYS_MISMATCH_ON_AUTOREF_NODE = 1505
- , CAT_SCHEMA_MISMATCH_ON_AUTOREF_NODE = 1506
+ // unused = 1500
+ // unused = 1502
+ // unused = 1503
+ // unused = 1504
+ // unused = 1505
+ // unused = 1506
// IDENTITY Column (Surrogate Key) related Errors.
, CAT_IDENTITY_COLUMN_DATATYPE_MISMATCH = 1510
, CAT_IDENTITY_COLUMN_ONE_PER_TABLE = 1511
- , CAT_IDENTITY_COLUMN_NOT_NULL_NOT_DROPPABLE = 1512
- , CAT_IDENTITY_COLUMN_HASH_PARTITIONED_ONLY = 1513
+ // unused = 1512
+ // unused = 1513
, CAT_IDENTITY_COLUMN_NO_ALTER_TABLE = 1514
// unused = 1515
- , CAT_CANNOT_DISABLE_NOT_DROPPABLE_CONSTRAINT = 1517
- , CAT_CANNOT_ENABLE_CONSTRAINT = 1518
- , CAT_CANNOT_DISABLE_FK_CONSTRAINT = 1519
- , CAT_SCHEMA_MISMATCH_ON_EXCEPTION_TABLE = 1521
- , CAT_NOT_AN_EXCEPTION_TABLE = 1522
- , CAT_EXCEPTION_TABLE_DOES_NOT_EXIST = 1523
- , CAT_NO_EXCEPTIONS_ON_METADATA = 1524
- , CAT_NO_EXCEPTIONS_ON_EXCEPTIONS = 1525
- , CAT_EXCEPTION_NOT_IN_METADATA_TABLE = 1526
- , CAT_NO_KEY_ON_BASE_TABLE = 1527
- , CAT_NO_EXCEPTION_TABLE_FOR_BASE_TABLE = 1528
+ // unused = 1517
+ // unused = 1518
+ // unused = 1519
+ // unused = 1521
+ // unused = 1522
+ // unused = 1523
+ // unused = 1524
+ // unused = 1525
+ // unused = 1526
+ // unused = 1527
+ // unused = 1528
- , CAT_SG_NOT_IN_METADATA = 1529
- , CAT_LDAP_DEFAULTCONFIG_INSERT_ERROR = 1530
+ // unused = 1529
+ // unused = 1530
, CAT_NO_POPULATE_VOLATILE_INDEX = 1540
, CAT_LOB_COL_CANNOT_BE_INDEX_OR_KEY = 1541
@@ -417,27 +416,23 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
, CAT_SG_INCREMENT_BY_ZERO_ERROR = 1571
, CAT_SG_NEGATIVE_ERROR = 1572
, CAT_SG_STARTWITH_MINVALUE_MAXVALUE_ERROR = 1573
- , CAT_SG_CYCLE_NOT_SUPPORTED_ERROR = 1574
+ // unused = 1574
, CAT_SG_INCREMENT_BY_MAXVALUE_ERROR = 1575
, CAT_SG_MAXIMUM_DATATYPE_ERROR = 1576
- // Collation for Catlog & Schema
- , CAT_CATALOG_COLLATION_NOT_SUPPORTED = 1580
- , CAT_SCHEMA_COLLATION_NOT_SUPPORTED = 1581
-
// Sequence Generator alter table errors
, CAT_SG_ALTER_NOT_IDENTITY_COLUMN_ERROR = 1590
- , CAT_SG_ALTER_MAXVALUE_NOT_GT_ERROR = 1591
+ // unused = 1591
, CAT_SG_ALTER_UNSUPPORTED_OPTION_ERROR = 1592
- , CAT_SG_ALTER_TOO_MANY_OPTIONS_ERROR = 1593
- , CAT_SG_ALTER_CURRENT_VALUE_ERROR = 1594
- , CAT_SG_ALTER_NO_MAXVALUE_ERROR = 1595
- , CAT_SG_ALTER_RECALIBRATION_ERROR = 1596
- , CAT_SG_ALTER_RECALIBRATION_MAXIMUM_ERROR = 1597
- , CAT_SG_ALTER_RECALIBRATION_CURRENT_ERROR = 1598
- , CAT_SG_ALTER_RECALIBRATION_SPECIFIED_ERROR = 1599
- , CAT_SG_ALTER_RECALIBRATION_LOCKING_ERROR = 1600
- , CAT_SG_ALTER_RECALIBRATION_NO_SELECT_ERROR = 1601
+ // unused = 1593
+ // unused = 1594
+ // unused = 1595
+ // unused = 1596
+ // unused = 1597
+ // unused = 1598
+ // unused = 1599
+ // unused = 1600
+ // unused = 1601
// UDF related errors
, CAT_NOT_UUDF_OBJECT = 1700
http://git-wip-us.apache.org/repos/asf/trafodion/blob/a808cd39/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc
----------------------------------------------------------------------
diff --git a/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc
index b062199..20c6ea9 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/compiler_msgs.adoc
@@ -32,7 +32,7 @@ This section includes process creation errors, IPC errors, static compilation er
== SQL 2004
```
-Internal error: error from MXCMP; cannot work on this query.
+Internal error: error from Compiler; cannot work on this query.
```
*Cause:* {project-name} received an internal error from the {project-name} compiler.
@@ -45,7 +45,7 @@ Internal error: error from MXCMP; cannot work on this query.
== SQL 2009
```
-The user transaction must be rolled back (or committed, if that makes sense in the application) before MXCMP can be restarted and proceed.
+The user transaction must be rolled back (or committed, if that makes sense in the application) before Compiler can be restarted and proceed.
```
*Cause:* An outstanding transaction must be resolved before the {project-name} compiler can be restarted.
@@ -59,7 +59,7 @@ The user transaction must be rolled back (or committed, if that makes sense in t
== SQL 2011
```
-Server process could not be created - error <number> while resolving program file name <name>.
+Server process could not be created - Operating system error <number> while resolving program file name <name>.
```
Where error <number> is the error number.
http://git-wip-us.apache.org/repos/asf/trafodion/blob/a808cd39/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 0a44ba2..b88fb13 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
@@ -3262,11 +3262,327 @@ Where <storage-type-2> is the storage type of the target LOB column.
Where <column-name> is the name of the target LOB column.
*Cause:* You attempted to store a LOB value into a LOB column, but the storage type of the LOB value and the target column are not
-compatible. For example, you may have attempted
+compatible.
*Effect:* The operation fails.
*Recovery:* Consult the Trafodion SQL Large Objects Guide for more information about LOB storage types. Correct the statement
and resubmit.
+<<<
+[[SQL-1510]]
+== SQL 1510
+
+```
+IDENTITY column <column-name> can be of the following data types only: LARGEINT, INTEGER UNSIGNED and SMALLINT UNSIGNED.
+```
+
+Where <column-name> is a column name you specified.
+
+*Cause:* You attempted to define an IDENTITY column but you specified a data type other than LARGEINT, INTEGER UNSIGNED or SMALLINT UNSIGNED.
+
+*Effect:* The operation fails.
+
+*Recovery:* Change the data type of the column to LARGEINT, INTEGER UNSIGNED or SMALLINT UNSIGNED and resubmit.
+
+[[SQL-1511]]
+== SQL 1511
+
+```
+There can only be one IDENTITY column for a table.
+```
+
+*Cause:* You attempted to define more than one IDENTITY column in a table.
+
+*Effect:* The operation fails.
+
+*Recovery:* Change the column definitions so that there is at most one IDENTITY column and resubmit.
+
+<<<
+[[SQL-1514]]
+== SQL 1514
+
+```
+Cannot add an IDENTITY column using ALTER TABLE command.
+```
+
+*Cause:* You attempted to add an IDENTITY column to a table using the ALTER TABLE command. {project-name} does not presently support this.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+[[SQL-1540]]
+== SQL 1540
+
+```
+The NO POPULATE clause is not allowed for index <index-name> on volatile table <table-name>.
+```
+
+*Cause:* You attempted to execute a CREATE INDEX statement to create an index on a volatile table, and you specified the NO POPULATE option. That option
+is not allowed for indexes on volatile tables.
+
+*Effect:* The operation fails.
+
+*Recovery:* Remove the NO POPULATE clause from the statement and resubmit.
+
+<<<
+[[SQL-1541]]
+== SQL 1541
+
+```
+Use of BLOB/CLOB datatype as a key of the base table or an index is not allowed.
+```
+
+*Cause:* You attempted to execute a CREATE TABLE statement with a BLOB or CLOB column in the primary key, or you attempted to execute a CREATE INDEX
+statement that referenced a CLOB or BLOB column. This is not allowed.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+[[SQL-1550]]
+== SQL 1550
+
+```
+Failed to create UDF <udf-name> with <number> parameters. A scalar UDF can have a maximum of 32 parameters.
+```
+
+Where <udf-name> is the name of a user defined function that you specified.
+
+Where <number> is the number of parameters in the function signature that you specified.
+
+*Cause:* You attempted to execute a CREATE FUNCTION statement and you specified more than 32 parameters in the function signature. {project-name}
+only supports up to 32 parameters.
+
+*Effect:* The operation fails.
+
+*Recovery:* Reduce the number of parameters in the function and resubmit.
+
+<<<
+[[SQL-1570]]
+== SQL 1570
+
+```
+MAXVALUE must be greater than MINVALUE for <purpose>.
+```
+
+Where <purpose> is either "an IDENTITY column" or "CREATE SEQUENCE".
+
+*Cause:* When creating an IDENTITY column or when executing a CREATE SEQUENCE statement, you specified a MAXVALUE that is less than or equal to the MINVALUE.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+[[SQL-1571]]
+== SQL 1571
+
+```
+<value-name> value cannot be zero for <purpose>.
+```
+
+Where <value-name> is one of "INCREMENT BY", "MINVALUE" or "MAXVALUE".
+
+Where <purpose> is one of "an IDENTITY column", "ALTER SEQUENCE" or "CREATE SEQUENCE".
+
+*Cause:* When creating an IDENTITY column or when executing an ALTER SEQUENCE or CREATE SEQUENCE statement, you specified a value of zero for INCREMENT BY,
+MINVALUE or MAXVALUE.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+<<<
+[[SQL-1572]]
+== SQL 1572
+
+```
+<value-name> value cannot be a negative number for <purpose>.
+```
+
+Where <value-name> is one of "INCREMENT BY", "MINVALUE" or "MAXVALUE".
+
+Where <purpose> is one of "an IDENTITY column", "ALTER SEQUENCE" or "CREATE SEQUENCE".
+
+*Cause:* When creating an IDENTITY column or when executing an ALTER SEQUENCE or CREATE SEQUENCE statement, you specified a negative value for INCREMENT BY,
+MINVALUE or MAXVALUE.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+[[SQL-1573]]
+== SQL 1573
+
+```
+START WITH value must be greater than or equal to MINVALUE and less than or equal to MAXVALUE for <purpose>.
+```
+
+Where <purpose> is one of "an IDENTITY column", "ALTER SEQUENCE" or "CREATE SEQUENCE".
+
+*Cause:* When creating an IDENTITY column or when executing an ALTER SEQUENCE or CREATE SEQUENCE statement, you specified a value for START WITH that is
+less than the value for MINVALUE or greater than the value for MAXVALUE.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+<<<
+[[SQL-1575]]
+== SQL 1575
+
+```
+INCREMENT BY value cannot be greater than the difference between MINVALUE and MAXVALUE for <purpose>.
+```
+
+Where <purpose> is one of "an IDENTITY column", "ALTER SEQUENCE" or "CREATE SEQUENCE".
+
+*Cause:* When creating an IDENTITY column or when executing an ALTER SEQUENCE or CREATE SEQUENCE statement, you specified a value for INCREMENT BY that is
+greater than the difference between the values for MINVALUE and MAXVALUE.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+[[SQL-1576]]
+== SQL 1576
+
+```
+<value-name> value is greater than maximum allowed for this sequence.
+```
+
+Where <value-name> is one of "INCREMENT BY", "MAXVALUE" or "START WITH".
+
+*Cause:* When creating an IDENTITY column or when executing an ALTER SEQUENCE or CREATE SEQUENCE statement, you specified a value that is larger than
+permitted for the data type of the column or sequence.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+<<<
+[[SQL-1577]]
+== SQL 1577
+
+```
+CACHE value must be greater than 1 and less than or equal to (maxValue-startValue+1)/incrementValue for <purpose>.
+```
+
+Where <purpose> is "ALTER SEQUENCE" or "CREATE SEQUENCE".
+
+*Cause:* When executing an ALTER SEQUENCE or CREATE SEQUENCE statement, you specified a value for CACHE that is less than one
+or is greater than (maxValue - startValue + 1)/incrementValue.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+[[SQL-1579]]
+== SQL 1579
+
+```
+This sequence has reached its max and cannot provide a new value.
+```
+
+*Cause:* When executing a DML statement that uses the SEQNUM to obtain a value from a sequence, or when
+inserting a row into a table having an IDENTITY column, the underlying sequence had already reached its
+maximum value.
+
+*Effect:* The operation fails.
+
+*Recovery:* If desired, use ALTER SEQUENCE to increase the maximum value for the sequence, then resubmit.
+
+<<<
+[[SQL-1582]]
+== SQL 1582
+
+```
+Internal Error: Sequence information does not exist in metadata.
+```
+
+*Cause:* When executing a DML statement that references a sequence, {project-name} could not find
+the sequence definition in the {project-name} metadata.
+
+*Effect:* The operation fails.
+
+*Recovery:* Contact the {project-name} distribution list. If the DML statement involves an IDENTITY
+column it is likely the existing data is not at risk, however it may not be possible to create new
+rows using the IDENTITY column's underlying sequence. If the DML statement involves getting new
+values from a sequence via the SEQNUM function, it may be possible to create a new sequence with
+a MINVALUE just greater to the last value taken from the sequence, and use the new sequence instead.
+
+[[SQL-1583]]
+== SQL 1583
+
+```
+Sequence metadata could not be updated.
+```
+
+*Cause:* When executing a DML statement that references a sequence, the sequence metadata could
+not be updated.
+
+*Effect:* The operation fails.
+
+*Recovery:* Contact the {project-name} distribution list.
+
+<<<
+[[SQL-1584]]
+== SQL 1584
+
+```
+Timestamp mismatch detected on Sequence object.
+```
+
+*Cause:* When executing a DML statement that references a sequence, the {project-name} run-time
+engine discovered a mismatch between the expected state of the sequence and the state found
+at run-time.
+
+*Effect:* The operation fails.
+
+*Recovery:* Contact the {project-name} distribution list. If this is a PREPAREd statement,
+re-PREPARing it may cure the error.
+
+[[SQL-1590]]
+== SQL 1590
+
+```
+Column <column-name> is not an IDENTITY column.
+```
+
+Where <column-name> is the column name you specified.
+
+*Cause:* You attempted to execute an ALTER TABLE ALTER COLUMN statement, setting an IDENTITY-column-related
+value such as INCREMENT BY. However, the column specified is not an IDENTITY column.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the table name or column name in the statement and resubmit.
+
+<<<
+[[SQL-1592]]
+== SQL 1592
+
+```
+<value-name> cannot be specified for <purpose>.
+```
+
+Where <value-name> is "MINVALUE" or "START WITH".
+
+Where <purpose> is "ALTER SEQUENCE".
+
+*Cause:* You attempted to modify the MINVALUE or START WITH values for a sequence in an ALTER SEQUENCE statement but
+this is not allowed.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the statement and resubmit.
+
+
+
+
+
+
+
+
http://git-wip-us.apache.org/repos/asf/trafodion/blob/a808cd39/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 2f2c4ee..33b29ac 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/parser_msgs.adoc
@@ -230,15 +230,15 @@ an interval qualifier.
== SQL 3014
```
-Precision of numeric, <value>, cannot exceed 18.
+Precision of numeric, <value>, cannot exceed <limit>.
```
*Cause:* You defined a numeric item, <value>, with precision greater
-than 18, which is not supported.
+than the limit, which is not supported.
*Effect:* The operation fails.
-*Recovery:* Redefine the item with a precision value of 18 or less.
+*Recovery:* Redefine the item with a lower precision value.
<<<
[[SQL-3015]]
@@ -677,7 +677,7 @@ The interval <value> is not valid.
== SQL 3045
```
-The date <value> is not valid.
+The date '<value>' is not valid.
```
*Cause:* You specified an invalid date <value>.
@@ -690,7 +690,7 @@ The date <value> is not valid.
== SQL 3046
```
-The time <value> is not valid.
+The time '<value>' is not valid.
```
*Cause:* You specified an invalid time <value>.
@@ -704,7 +704,7 @@ The time <value> is not valid.
== SQL 3047
```
-The timestamp <value> is not valid.
+The timestamp '<value>' is not valid.
```
*Cause:* You specified an invalid timestamp <value>.
[2/2] trafodion git commit: Merge [TRAFODION-2880] PR 1375 Update
Messages Guide messages 1500-1601 etc.
Posted by db...@apache.org.
Merge [TRAFODION-2880] PR 1375 Update Messages Guide messages 1500-1601 etc.
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/3dbfa89f
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/3dbfa89f
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/3dbfa89f
Branch: refs/heads/master
Commit: 3dbfa89f9bcbb43f7fbf17dfc1f0df9bbe51b6ca
Parents: 25872e7 a808cd3
Author: Dave Birdsall <db...@apache.org>
Authored: Tue Jan 9 17:46:55 2018 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Tue Jan 9 17:46:55 2018 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 103 +++---
core/sql/regress/seabase/EXPECTED025 | 14 +-
core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 69 ++--
.../src/asciidoc/_chapters/compiler_msgs.adoc | 6 +-
.../src/asciidoc/_chapters/ddl_msgs.adoc | 318 ++++++++++++++++++-
.../src/asciidoc/_chapters/parser_msgs.adoc | 12 +-
6 files changed, 416 insertions(+), 106 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/3dbfa89f/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------