[3/4] trafodion git commit: Incorporate Comments 2

[db...@apache.org]

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 <qw...@hotmail.com>
Authored: Wed Apr 25 19:40:42 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
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])