This is an automated email from the ASF dual-hosted git repository.
dbirdsall pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafodion.git
The following commit(s) were added to refs/heads/master by this push:
new ea993c8 [TRAFODION-3294] Updated Messages Guide for some binder
messages
new 89db1bb Merge pull request #1826 from DaveBirdsall/Trafodion3294
ea993c8 is described below
commit ea993c8a44f2ff1eef05c349aa534b6024e7bf59
Author: Dave Birdsall <[email protected]>
AuthorDate: Fri Apr 5 20:45:57 2019 +0000
[TRAFODION-3294] Updated Messages Guide for some binder messages
---
core/sql/bin/SqlciErrors.txt | 8 ++--
.../src/asciidoc/_chapters/binder_msgs.adoc | 54 ++++++++++++++++------
2 files changed, 45 insertions(+), 17 deletions(-)
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index f828793..ebdea97 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -1123,7 +1123,7 @@ $1~String1 --------------------------------
4051 42000 99999 BEGINNER MAJOR DBADMIN The first operand of function
$0~string0 must be character.
4052 42000 99999 BEGINNER MAJOR DBADMIN The second operand of function
$0~string0 must be numeric.
4053 42000 99999 BEGINNER MAJOR DBADMIN The third operand of function
$0~string0 must be numeric.
-4054 ZZZZZ 99999 ADVANCED CRTCL DIALOUT The MAINTAIN control information table
contains an incorrect format.
+4054 ZZZZZ 99999 ADVANCED CRTCL DIALOUT --- unused ---
4055 42000 99999 BEGINNER MAJOR DBADMIN The select lists or tuples must have
comparable data types. $0~String0 and $1~String1 are not comparable.
4056 42000 99999 BEGINNER MAJOR DBADMIN Exposed name $0~TableName appears more
than once.
4057 42000 99999 BEGINNER MAJOR DBADMIN Correlation name $0~String0 conflicts
with qualified identifier of table $1~TableName.
@@ -1153,7 +1153,7 @@ $1~String1 --------------------------------
4081 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused as of 5/7/12 ---
4082 42000 99999 BEGINNER MAJOR DBADMIN Object $0~TableName does not exist or
is inaccessible.
4083 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU --- unused as of 5/7/12 ---
-4084 42000 99999 ADVANCED MAJOR DBADMIN SQL object $0~TableName is corrupt.
+4084 42000 99999 ADVANCED MAJOR DBADMIN --- unused ---
4085 0A000 99999 BEGINNER MAJOR DBADMIN File organization $0~String0 of object
$1~TableName is not supported.
4086 42000 99999 BEGINNER MAJOR DBADMIN Environment variable or define
$0~String0 does not exist.
4087 42000 99999 BEGINNER MAJOR DBADMIN Prototype value '$0~String0' is not a
valid qualified name.
@@ -1189,7 +1189,7 @@ $1~String1 --------------------------------
4117 42000 99999 BEGINNER MAJOR DBADMIN The cursor query expression might be
nonupdatable.
4118 42000 99999 BEGINNER MAJOR DBADMIN The cursor query expression is not
updatable.
4119 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The requested number of parallel
extract streams must be greater than one and cannot exceed the number of
maximally configured ESPs, $0~Int0.
-4120 42000 99999 BEGINNER MAJOR DBADMIN In a query with a GROUP BY, DISTINCT,
or aggregate function, each column in the ORDER BY clause must be one of the
columns explicitly SELECTed by the query. Column in error: $0~ColumnName.
+4120 42000 99999 BEGINNER MAJOR DBADMIN In a query with a GROUP BY, DISTINCT,
or aggregate function, each column in the ORDER BY clause must be one of the
columns explicitly SELECTed by the query. Column in error: $0~ColumnName.
4121 42000 99999 BEGINNER MAJOR DBADMIN In a query with a GROUP BY, DISTINCT,
or aggregate function, each column in the ORDER BY clause must be one of the
columns explicitly SELECTed by the query. Column in error: $0~ColumnName.
Table in scope: $1~String0.
4122 42000 99999 BEGINNER MAJOR DBADMIN NULL cannot be assigned to NOT NULL
column $0~ColumnName.
4123 42000 99999 BEGINNER MAJOR DBADMIN NULL cannot be cast to a NOT NULL data
type.
@@ -1206,7 +1206,7 @@ $1~String1 --------------------------------
4134 42000 99999 BEGINNER MAJOR DBADMIN The operation ($0~String0) is not
allowed. Try UNION ALL instead.
4135 42000 99999 BEGINNER MAJOR DBADMIN In an INSERT-SELECT, each column in
the ORDER BY clause must be one of the columns in the select list of the query.
Column in error: $0~ColumnName.
4136 ZZZZZ 99999 BEGINNER MAJOR DBADMIN An outer SELECT was used in a DELETE
[FIRST N] statement without using the [LAST 1] clause.
-4137 ZZZZZ 99999 BEGINNER MAJOR DBADMIN A DELETE [FIRST N] statement was
specified on table $0~TableName which has more than one partition, without
using the PARTITION clause.
+4137 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
4138 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Use of a subquery in the WHERE clause
of a DELETE [FIRST N] statement is not supported.
4139 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Use of a subquery in the WHERE clause
of a Long Running Update statement is not supported.
4140 42000 99999 BEGINNER MAJOR DBADMIN The second operand of function
$0~string0 must be of interger type.
diff --git a/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
b/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
index f295205..1ae1ad0 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/binder_msgs.adoc
@@ -174,13 +174,13 @@ between 1 and the <value-2> of SELECT expressions.
== SQL 4008
```
-A sub query is not allowed inside an aggregate function.
+A subquery is not allowed inside an aggregate function.
```
*Cause:* This error can occur only if support for subqueries inside
aggregate functions has been turned off (e.g., via CQD
UDF_SUBQ_IN_AGGS_AND_GBYS 'OFF').
(Note: By default, this support is presently turned on.)
-You specified a sub query within an aggregate function, which is
+You specified a subquery within an aggregate function, which is
not supported when this support has been turned off.
*Effect:* The operation fails.
@@ -322,12 +322,12 @@ Derived column name <name> was specified more than once.
== SQL 4019
```
-The select list of a sub query in a select list must be scalar (degree of one).
+The select list of a subquery in a select list must be scalar (degree of one).
```
-*Cause:* This error can only appear if support for mulit-degree subqueries has
been turned
+*Cause:* This error can only appear if support for multi-degree subqueries has
been turned
off (e.g. via CQD ALLOW_MULTIDEGREE_SUBQ_IN_SELECTLIST 'OFF'). (Note: By
default, this
-support is turned on.) You specified a sub query of degree greater than one
inside a select list,
+support is turned on.) You specified a subquery of degree greater than one
inside a select list,
and the support for this was turned off.
*Effect:* The operation fails.
@@ -1167,10 +1167,10 @@ operands must be numeric.
== SQL 4082
```
-Table, view or stored procedure <name> does not exist or is inaccessible.
+Object <name> does not exist or is inaccessible.
```
-*Cause:* You referred to table <name>, which does not exist or is
+*Cause:* You referred to the object <name>, which does not exist or is
inaccessible (for example, on a downed disk volume).
*Effect:* The operation fails.
@@ -1237,10 +1237,10 @@ in each TRANSPOSE item.
== SQL 4089
```
-Check constraint <name> contains a sub query. This is not yet supported.
+Check constraint <name> contains a subquery. This is not yet supported.
```
-*Cause:* You specified a constraint <name> that contains a sub query,
+*Cause:* You specified a constraint <name> that contains a subquery,
which is not supported.
*Effect:* The operation fails.
@@ -1748,9 +1748,9 @@ the update correctly and receives an error:
```
In a query with a GROUP BY, DISTINCT, or aggregate function, each
-```
column in the ORDER BY clause must be one of the columns explicitly
SELECTed by the query. Column in error: <name>.
+```
*Cause:* You attempted to perform a query with an aggregate function, a
GROUP BY clause, or a DISTINCT clause. A column in the ORDER BY clause,
@@ -1823,8 +1823,8 @@ one table.
== SQL 4125
```
-The select list of a sub query in a row value constructor must be
-scalar (degree of one) if the sub query is one of several expressions
+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.
```
@@ -1894,6 +1894,34 @@ allow this particular attribute to be changed.
*Recovery:* If a different attribute was intended, correct the syntax and
resubmit.
+[[SQL-4131]]
+== SQL 4131
+
+```
+Current_time, current_date, or current_timestamp is not allowed in a check
constraint.
+```
+
+*Cause:* You attempted to create a constraint referencing current_time,
current_date
+or current_timestamp.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the syntax and resubmit.
+
+[[SQL-4132]]
+== SQL 4132
+
+```
+Current_user, session_user, or system_user is not allowed in a check
constraint.
+```
+
+*Cause:* You attempted to create a constraint referencing current_user,
session_user,
+or system_user.
+
+*Effect:* The operation fails.
+
+*Recovery:* Correct the syntax and resubmit.
+
[[SQL-4133]]
== SQL 4133
@@ -1928,7 +1956,7 @@ database software does not allow.
```
In an INSERT-SELECT, each column in the ORDER BY clause must be one
-of the columns in the selected list of the query. Column in error: B.
+of the columns in the select list of the query. Column in error: B.
```
*Cause:* You tried to SQL-compile an INSERT-SELECT statement that
