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/09 13:02:39 UTC
[1/2] trafodion git commit: [TRAFODION-3172] update documentation for
sys_guid function
Repository: trafodion
Updated Branches:
refs/heads/master affc9dbfa -> f38a1006b
[TRAFODION-3172] update documentation for sys_guid function
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/e1e35258
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/e1e35258
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/e1e35258
Branch: refs/heads/master
Commit: e1e35258af0c165a4afbbd08c8b98a999c6eb2a3
Parents: b0fe804
Author: LiuMing <ov...@sina.com>
Authored: Wed Aug 8 08:01:54 2018 +0800
Committer: LiuMing <ov...@sina.com>
Committed: Wed Aug 8 08:01:54 2018 +0800
----------------------------------------------------------------------
.../sql_functions_and_expressions.adoc | 32 ++++++++++++++++++++
1 file changed, 32 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/e1e35258/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 adba842..037b5b1 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
@@ -428,6 +428,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.
|===
See the individual entry for the function.
@@ -10601,6 +10602,37 @@ DB ROOT
```
<<<
+[[sys_guid_function]]
+== SYS_GUID Function
+SYS_GUID returns a global unique identifier. The identifier is a 16-byte value
+tranformed into HEX format.
+This function is for Oracle compatiblity.
+
+```
+SYS_GUID ()
+```
+
+[[data_type_of_the_result]]
+==== Data Type of the Result
+
+The data type of the result is always CHAR(32).
+
+[[examples_of_sys_guid]]
+=== Examples of SYS_GUID
+
+* Returns a global unique identifier
++
+```
+SELECT SYS_GUID() AS ID FROM dual;
+
+ID
+-------------------------
+ 5D35B676r5F758E6E0E40F00F0835536
+
+--- 1 row(s) selected.
+```
+
+<<<
[[variance_function]]
== VARIANCE Function
[2/2] trafodion git commit: merge [TRAFODION-3172]
Posted by li...@apache.org.
merge [TRAFODION-3172]
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/f38a1006
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/f38a1006
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/f38a1006
Branch: refs/heads/master
Commit: f38a1006ba3c99651148c08cac30c89939d5d671
Parents: affc9db e1e3525
Author: Liu Ming <ov...@sina.com>
Authored: Thu Aug 9 07:48:46 2018 +0000
Committer: Liu Ming <ov...@sina.com>
Committed: Thu Aug 9 07:48:46 2018 +0000
----------------------------------------------------------------------
.../sql_functions_and_expressions.adoc | 32 ++++++++++++++++++++
1 file changed, 32 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/f38a1006/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
----------------------------------------------------------------------