From commits-return-8540-archive-asf-public=cust-asf.ponee.io@trafodion.apache.org Fri Aug 10 06:06:11 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id CE6D5180676 for ; Fri, 10 Aug 2018 06:06:10 +0200 (CEST) Received: (qmail 38145 invoked by uid 500); 10 Aug 2018 04:06:10 -0000 Mailing-List: contact commits-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@trafodion.apache.org Delivered-To: mailing list commits@trafodion.apache.org Received: (qmail 38132 invoked by uid 99); 10 Aug 2018 04:06:09 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2018 04:06:09 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 83BEBE0181; Fri, 10 Aug 2018 04:06:09 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: liuyu@apache.org To: commits@trafodion.apache.org Date: Fri, 10 Aug 2018 04:06:10 -0000 Message-Id: In-Reply-To: <4b14c1fdd1044172a6ab8c3d93ae9931@git.apache.org> References: <4b14c1fdd1044172a6ab8c3d93ae9931@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [2/5] trafodion git commit: [TRAFODION-3178] Correct Syntax Descriptions of *CREATE PROCEDURE Statement* and Fix Typos in *Trafodion SQL Reference Manual* [TRAFODION-3178] Correct Syntax Descriptions of *CREATE PROCEDURE Statement* and Fix Typos in *Trafodion SQL Reference Manual* Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/be5cc703 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/be5cc703 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/be5cc703 Branch: refs/heads/master Commit: be5cc7037a13d67f6193f0718b8e87e780507f5a Parents: f38ade8 Author: liu.yu Authored: Tue Aug 7 19:08:23 2018 +0800 Committer: liu.yu Committed: Wed Aug 8 09:49:01 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_clauses.adoc | 3 +- .../sql_functions_and_expressions.adoc | 79 ++++++++++++-------- .../_chapters/sql_language_elements.adoc | 6 +- .../src/asciidoc/_chapters/sql_statements.adoc | 26 +++---- 4 files changed, 66 insertions(+), 48 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/be5cc703/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc index 2f2b5ad..9c44673 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc @@ -1053,8 +1053,7 @@ expressions in each item must be the same as the number of value columns in the column list. + In the example TRANSPOSE A,B,C AS V, the items are A,B, and C, and the -value column is V. This form can be thought of as a shorter way of writing TRANSPOSE -(A),(B),(C) AS (V). +value column is V. This form can be thought of as a shorter way of writing TRANSPOSE (A),(B),\(C) AS (V). * `_transpose-item-list_` + http://git-wip-us.apache.org/repos/asf/trafodion/blob/be5cc703/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc index 7a76d09..95df865 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc @@ -29,22 +29,29 @@ This section describes the syntax and semantics of specific functions and expressions that you can use in {project-name} SQL statements. The functions and expressions are categorized according to their -functionality. +functionality: -[[standard_normalization]] -== Standard Normalization +[[categories]] +== Categories -For datetime functions, the definition of standard normalization is: If -the ending day of the resulting date is invalid, the day will be rounded -DOWN to the last day of the result month. +Use these types of functions within an SQL value expression: -== Aggregate (Set) Functions +** Aggregate (Set) Functions +** Character String Functions +** Datetime Functions +** Mathematical Functions +** Sequence Functions +** Other Functions and Expressions + +For more information about SQL value expressions, see <>. + +=== Aggregate (Set) Functions An aggregate (or set) function operates on a group or groups of rows retrieved by the SELECT statement or the subquery in which the aggregate function appears. - +.Overview of Aggregate (Set) Functions [cols="25%,75%"] |=== | <> | Computes the average of a group of numbers derived from the evaluation @@ -66,10 +73,8 @@ derived from the evaluation of the expression argument of the function. The numbers can be weighted. | <> | Computes the sum of a group of numbers derived from the evaluation of the expression argument of the function. -"VARIANCE Function" -Computes the statistical variance of a group of numbers derived from the -evaluation of the expression argument of the function. The numbers can -be weighted. +| <> | Computes the statistical variance of a group of numbers derived from the +evaluation of the expression argument of the function. The numbers can be weighted. |=== @@ -89,7 +94,7 @@ list, all rows of the SELECT result table form the one and only group. See the individual entry for the function. [[character_string_functions]] -== Character String Functions +=== Character String Functions These functions manipulate character strings and use a character value expression as an argument or return a result of a character data type. @@ -97,7 +102,7 @@ Character string functions treat each single-byte or multi-byte character in an input string as one character, regardless of the byte length of the character. - +.Overview of Character String Functions [cols="25%,75%"] |=== | <> | Returns the ASCII code value of the first character of a character value @@ -108,8 +113,8 @@ CHARACTER_LENGTH. | <> | Returns an unsigned integer that is the code point of the first character in a character value expression that can be associated with one of the supported character sets. -| <> | Returns the concatenation of two character value expressions as a string -value. You can also use the concatenation operator (\|\|). +| <> | Returns the concatenation of two character value expressions as a string value. +You can also use the concatenation operator. | <> | Returns a character string where a specified number of characters within the character string have been deleted and then a second character string has been inserted at a specified start position. @@ -147,12 +152,11 @@ character set. See the individual entry for the function. [[datetime_functions]] -== Datetime Functions +=== Datetime Functions These functions use either a datetime value expression as an argument or return a result of datetime data type: -[caption="Table 7-3 "] .Overview of DATETIME Functions [cols="25%,50%,25%"] |=== @@ -258,10 +262,11 @@ corresponding week of the year. See the individual entry for the function. [[lob_functions]] -== LOB Functions +=== LOB Functions Trafodion provides following LOB functions to process LOB data. +.Overview of LOB Functions [cols="25%,75%"] |=== | <> | Creates a dummy LOB handle of type BLOB. @@ -276,10 +281,11 @@ Trafodion provides following LOB functions to process LOB data. |=== [[mathematical_functions]] -== Mathematical Functions +=== Mathematical Functions Use these mathematical functions within an SQL numeric value expression: +.Overview of Mathematical Functions [cols="25%,75%"] |=== | <> | Returns the absolute value of a numeric value expression. @@ -315,9 +321,10 @@ returns 0. If value is greater than zero, returns 1. See the individual entry for the function. [[encryption_functions]] -== Encryption Functions +=== Encryption Functions Use these functions within an SQL value expression to do data encryption or hashing: +.Overview of Encryption Functions [cols="25%,75%"] |=== | <> | Returns MD5 checksum @@ -326,7 +333,7 @@ Use these functions within an SQL value expression to do data encryption or hash |=== [[sequence_functions]] -== Sequence Functions +=== Sequence Functions Sequence functions operate on ordered rows of the intermediate result table of a SELECT statement that includes a SEQUENCE BY clause. Sequence @@ -342,8 +349,9 @@ sorted result set must be available to compute the result of the sequence function. [[difference_sequence_functions]] -=== Difference sequence functions +==== Difference sequence functions +.Overview of Difference Sequence Functions [cols="25%,75%"] |=== | <> | Calculates differences between values of a column expression in the current row and previous rows. @@ -351,8 +359,9 @@ sequence function. |=== [[moving_sequence_functions]] -=== Moving sequence functions +==== Moving sequence functions +.Overview of Moving Sequence Functions [cols="25%,75%"] |=== | <> | Returns the number of non-null values of a column expression in the current window. @@ -363,9 +372,10 @@ sequence function. | <> | Returns the variance of non-null values of a column expression in the current window. |=== -Offset sequence function -=== Offset sequence function +[[offset_sequence_function]] +==== Offset sequence function +.Overview of Offset Sequence Functions [cols="25%,75%"] |=== | <> | Retrieves columns from previous rows. @@ -373,8 +383,9 @@ Offset sequence function <<< [[running_sequence_functions]] -=== Running sequence functions +==== Running sequence functions +.Overview of Running Sequence Functions [cols="25%,75%"] |=== | <> | Returns the average of non-null values of a column expression up to and including the current row. @@ -388,8 +399,9 @@ Offset sequence function |=== [[other_sequence_functions]] -=== Other sequence functions +==== Other sequence functions +.Overview of Other Sequence Functions [cols="25%,75%"] |=== | <> | Returns the last non-null value for the specified column expression. If only null values have been returned, returns null. @@ -402,11 +414,11 @@ See <> and the individual entry for each <<< [[other_functions_and_expressions]] -== Other Functions and Expressions +=== Other Functions and Expressions Use these other functions and expressions in an SQL value expression: - +.Overview of Other Functions and Expressions [cols="25%,75%"] |=== | <> | Returns the authorization name associated with the specified authorization ID number. @@ -432,6 +444,13 @@ associated with the specified user ID number. See the individual entry for the function. +[[standard_normalization]] +=== Standard Normalization + +For datetime functions, the definition of standard normalization is: If +the ending day of the resulting date is invalid, the day will be rounded +DOWN to the last day of the result month. + <<< [[abs_function]] == ABS Function http://git-wip-us.apache.org/repos/asf/trafodion/blob/be5cc703/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc index f9e60b0..733be2c 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc @@ -386,7 +386,7 @@ depending on precision |Numeric (extended numeric precision)^7^ | NUMERIC (precision 19 to 128) | Binary integer; signed or unsigned | Stored as multiple chunks of 16-bit integers, with a minimum storage length of 8 bytes. .3+| Floating point number^7^ | FLOAT[(_precision_)] | Floating point number (64 bits); precision designates from 1 through 52 bits of precision | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes -| REAL | Floating point number (32 bits) | +/- 1.17549435e-38 through +/ 3.40282347e+38; stored in 4 bytes +| REAL | Floating point number (32 bits) | +/- 1.17549435e-38 through +/- 3.40282347e+38; stored in 4 bytes | DOUBLE PRECISION | Floating-point numbers (64 bits) with 1 through 52 bits of precision (52 bits of binary precision and 1 bits of exponent) | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes | Decimal number^6^ | DECIMAL (1,_scale_) to DECIMAL (18,_scale_) | Decimal number with optional scale; stored as ASCII characters; signed or unsigned for 1 to 9 digits; signed required for 10 or more digits | 1 to 18 digits. Byte length equals the number of digits. Sign is stored as the first bit of the leftmost byte. @@ -3217,10 +3217,10 @@ The IN predicate is true if and only if either of these is true: * The result of the `_row-value-constructor_` (a row or sequence of values) is equal to any row of column values specified by `_table-subquery_`. - ++ A table subquery is a query expression and can be specified as a form of a simple table; for example, as the VALUES keyword followed by a list of -row values. See <>. +row values. For more information, see <>. * The result of the `_row-value-constructor_` (a single value) is equal to any of the values specified by the list of expressions http://git-wip-us.apache.org/repos/asf/trafodion/blob/be5cc703/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc index 0b773b5..b768085 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc @@ -2278,19 +2278,19 @@ pic[ture] x^1^ + nchar + nchar varying + national char[acter] + -national char[acter] varying | java.lang.string -| date | java.sql.date -| time | java.sql.time -| timestamp | java.sql.timestamp +national char[acter] varying | java.lang.String +| date | java.sql.Date +| time | java.sql.Time +| timestamp | java.sql.Timestamp | dec[imal]^2^ + pic[ture] s9^3^ + -numeric (including numeric with a precision greater than eighteen)^2^ | java.math.bigdecimal +numeric (including numeric with a precision greater than eighteen)^2^ | java.math.Bigdecimal | smallint^2^ | short -| int[eger]^2^ | int or java.lang.integer^4^ -| largeint^2^ | long or java.lang.long^4^ -| float | double or java.lang.double^4^ -| real | float or java.lang.float^4^ -| double precision | double or java.lang.double^4^ +| int[eger]^2^ | int or java.lang.Integer^4^ +| largeint^2^ | long or java.lang.Long^4^ +| float | double or java.lang.Double^4^ +| real | float or java.lang.Float^4^ +| double precision | double or java.lang.Double^4^ |=== + 1. the trafodion database stores pic x as a char data type. @@ -2321,13 +2321,13 @@ specifies the signature of the SPJ method and consists of: + `([_java-datatype_[, _java-datatype_]…])` + -The Java signature is necessary only if you want to specify a Java wrapper class (for example, `java.lang.integer`) instead of a java +The Java signature is necessary only if you want to specify a Java wrapper class (for example, `java.lang.Integer`) instead of a java primitive data type (for example, `int`). An SQL data type maps to a Java primitive data type by default. + -The Java signature is case-sensitive and must be placed within parentheses, such as `(java.lang.integer, java.lang.integer`). +The Java signature is case-sensitive and must be placed within parentheses, such as `(java.lang.Integer, java.lang.Integer`). The signature must specify each of the parameter data types in the order they appear in the Java method definition within the class file. Each Java data type that corresponds to an out or inout parameter must be followed by empty square -brackets (`[ ]`), such as `java.lang.integer[]`. +brackets (`[ ]`), such as `java.lang.Integer[]`. + <<< *** `_java-datatype_`