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:08:58 UTC
[2/6] trafodion git commit: add uuid_short() documentation
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 <ov...@sina.com>
Authored: Sun Aug 19 17:26:09 2018 +0800
Committer: LiuMing <ov...@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.
```