You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2018/08/29 01:09:01 UTC
[5/6] trafodion git commit: update the words
update the words
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/1de8531a
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/1de8531a
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/1de8531a
Branch: refs/heads/master
Commit: 1de8531a0799bb8d14890246b7c10cfb21ee06e3
Parents: d8ad0c7
Author: LiuMing <ov...@sina.com>
Authored: Fri Aug 24 10:56:21 2018 +0800
Committer: LiuMing <ov...@sina.com>
Committed: Fri Aug 24 10:56:21 2018 +0800
----------------------------------------------------------------------
.../_chapters/sql_functions_and_expressions.adoc | 12 +++++++-----
1 file changed, 7 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/1de8531a/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 7a8a4aa..44b968a 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
@@ -444,7 +444,7 @@ the expressions have NULL values, the function returns a NULL value.
| <<nvl_function,NVL Function>> | Returns the value of the first operand unless it is NULL, in which case it returns the value of the second operand.
| <<user_function,USER Function>> | Returns either the database user name of the current user who invoked the function or the database user name
associated with the specified user ID number.
-| <<sys_guid_function,SYS_GUID Function>> | Returns a globally unique identifier. (Oracle extention)
+| <<sys_guid_function,SYS_GUID Function>> | Returns a globally unique identifier, similar to Oracle's SYS_GUID function.
| <<uuid_function,UUID Function>> | Returns a globally unique identifier.
| <<uuid_short_function,UUID_SHORT Function>> | Returns a “short” universal identifier as a 64-bit unsigned integer.
| <<sleep_function,SLEEP Function>> | Sleep for a number of seconds
@@ -11303,8 +11303,9 @@ A UUID is designed as a number that is globally unique in space and time.
Two calls to UUID() are expected to generate two different values, even if
these calls are performed on two separate devices not connected to each other.
-NOTE: But UUID() can only be used in SELECT list, or very simple expressions to get a UUID.
-Do not use it in WHERE clause, the behavior is non-deterministic.
+NOTE: UUID() behavior is non-deterministic. Therefore it is best to use it
+only in SELECT lists. Using it in a WHERE clause, for example, may result in i
+non-deterministic predicate evaluation.
```
@@ -11335,8 +11336,9 @@ ID
== UUID_SHORT Function
Returns a “short” universal identifier as a 64-bit unsigned integer.
-NOTE: But UUID_SHORT() can only be used in SELECT list, or very simple expressions to get a UUID.
-Do not use it in WHERE clause, the behavior is non-deterministic.
+NOTE: UUID_SHORT() behavior is non-deterministic. Therefore it is best to use it
+only in SELECT lists. Using it in a WHERE clause, for example, may result in i
+non-deterministic predicate evaluation.
```