Incorporate Comments 2
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/fd70c7d6 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/fd70c7d6 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/fd70c7d6 Branch: refs/heads/master Commit: fd70c7d6ec2145b1fdb2c620e1ec35009f220616 Parents: a2f740b Author: liu.yu <[email protected]> Authored: Wed Apr 25 19:40:42 2018 +0800 Committer: liu.yu <[email protected]> Committed: Wed Apr 25 19:40:42 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_functions_and_expressions.adoc | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/fd70c7d6/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 a12b983..94b5126 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 @@ -9039,7 +9039,9 @@ The RAND function generates pseudo-random numbers that are uniformly distributed in the range between 0 and 2^32^ (=4294967296), using an integer as an optional seed value. -NOTE: the RAND function does not always behaves in predictive ways. +NOTE: The RAND function does not always behaves in predictive ways. It is non-deterministic +and may cause unexpected side effect. It evaluates only once or per row depending on the optimizer. +So it can only be used in very few places, please do not use it in a predicate. ``` RAND ([numeric-expression])
