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 <[email protected]> Authored: Sun Aug 19 17:26:09 2018 +0800 Committer: LiuMing <[email protected]> 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. ```
