trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lium...@apache.org
Subject [2/6] trafodion git commit: add uuid_short() documentation
Date Wed, 29 Aug 2018 01:08:58 GMT
add uuid_short() documentation


Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/95348f43
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/95348f43
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/95348f43

Branch: refs/heads/master
Commit: 95348f435b9c7585c09283a95093c9dc47b0cf03
Parents: 694d6d4
Author: LiuMing <ovis_poly@sina.com>
Authored: Sun Aug 19 17:26:09 2018 +0800
Committer: LiuMing <ovis_poly@sina.com>
Committed: Sun Aug 19 17:26:09 2018 +0800

----------------------------------------------------------------------
 .../sql_functions_and_expressions.adoc          | 34 +++++++++++++++++++-
 1 file changed, 33 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/95348f43/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 29cb4a5..daa3d83 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,6 +444,7 @@ the expressions have NULL values, the function returns a NULL value.
 associated with the specified user ID number.
 | <<sys_guid_function,SYS_GUID Function>>                         | Returns a
globally unique identifier. (Oracle extention)
 | <<uuid_function,UUID Function>>                                 | Returns a
globally unique identifier.
+| <<uuid_short_function,UUID Function>>                           | Returns a
“short” universal identifier as a 64-bit unsigned integer.
 |===
 
 See the individual entry for the function.
@@ -11322,7 +11323,38 @@ SELECT UUID() AS ID FROM dual;
 
 ID
 -------------------------
-  6ccd780c-baba-1026-9564-5b8c656024db
+  5cdd380c-33ba-3216-1352-2c9d624042c3
+--- 1 row(s) selected.
+```
+
+<<<
+[[uuid_short_function]]
+== UUID_SHORT Function
+
+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.
+
+
+```
+UUID ()
+```
+
+[[data_type_of_the_result]]
+==== Data Type of the Result
+
+The data type of the result is always LARGEINT.
+
+[[examples_of_uuid_short]]
+=== Examples of UUID_SHORT
+
+* Returns a global unique identifier
++
+```
+SELECT UUID_SHORT() AS ID FROM dual;
+
+ID
+-------------------------
+  92395783831158784
 --- 1 row(s) selected.
 ```
 


Mime
View raw message