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/11/15 23:43:55 UTC
[2/3] incubator-trafodion git commit: Incorporate Comments 1
Incorporate Comments 1
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/fd561079
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/fd561079
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/fd561079
Branch: refs/heads/master
Commit: fd561079b2d3077c144873ddd06671504362b6fe
Parents: 87a9937
Author: liu.yu <yu...@esgyn.cn>
Authored: Wed Nov 15 16:40:47 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Wed Nov 15 16:40:47 2017 +0800
----------------------------------------------------------------------
.../asciidoc/_chapters/sql_functions_and_expressions.adoc | 2 +-
.../sql_reference/src/asciidoc/_chapters/sql_statements.adoc | 8 ++++----
2 files changed, 5 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fd561079/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 7861cc3..6c2c530 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
@@ -2573,7 +2573,7 @@ DATE_PART('year', date'12/05/2006')
DATE_PART('day', TIMESTAMP '2006-12-31 11:59:59.999999')
```
-* This function returns the value 2011 07.
+* This function returns the value 201107.
+
```
DATE_PART('YEARMONTH', date '2011-07-25')
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fd561079/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 cce664d..a81499c 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -2822,7 +2822,7 @@ specifies a select query which is used to populate the created table. A select q
is a list of expressions that can only refer to primary key or STORE BY columns.
+
-The followings are allowed expressions in the DIVISON BY clause, they are monotonically increasing expressions:
+The following are allowed expressions in the DIVISON BY clause, they are monotonically increasing expressions:
+
** cast((exact_numeric_column[ + const1 ]) / const2 as numeric_data_type)
@@ -3343,7 +3343,7 @@ SELECT * FROM T WHERE b = 'A';
SELECT * FROM T WHERE b = 'A' (not casespecific);
```
-* This is the 1^st^ example of DIVISION BY usage.
+* This is the first example of DIVISION BY usage.
+
```
CREATE TABLE call_home_data
@@ -3355,7 +3355,7 @@ SALT USING 16 PARTITIONS ON (id)
DIVISION BY (date_trunc('day', ts));
```
-* This is the 2^nd^ example of DIVISION BY usage.
+* This is the second example of DIVISION BY usage.
+
```
CREATE TABLE sales1
@@ -3367,7 +3367,7 @@ PRIMARY KEY (store_id, item_id, sale_date))
DIVISION BY (DATEDIFF(YEAR, '2017-11-02', sale_date));
```
-* This is the 3^rd^ example of DIVISION BY usage.
+* This is the third example of DIVISION BY usage.
+
```
CREATE TABLE sales2