You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2017/12/20 21:19:03 UTC
[6/7] incubator-trafodion git commit: Incorporate Comments 2
Incorporate Comments 2
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/b59947f1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/b59947f1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/b59947f1
Branch: refs/heads/master
Commit: b59947f19468a8fb862f9ffb0c09ee9ab8861887
Parents: 2a48db2
Author: liu.yu <yu...@esgyn.cn>
Authored: Wed Dec 20 14:57:55 2017 +0800
Committer: liu.yu <yu...@esgyn.cn>
Committed: Wed Dec 20 14:57:55 2017 +0800
----------------------------------------------------------------------
.../src/asciidoc/_chapters/sql_functions_and_expressions.adoc | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b59947f1/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 733256f..1c2a7f6 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
@@ -3489,7 +3489,11 @@ EMPTY_BLOB()
** The dummy LOB handle will get the same datatype as the underlying column.
+
-For example, if the LOB column was defined as `‘EXTERNAL’` during table creation, then the LOB column gets that type. If it’s not defined, then it is considered as a regular LOB.
+For example,
++
+*** If the LOB column is defined as `'EXTERNAL'` during table creation, then the dummy LOB handle will get the type `'EXTERNAL'` and can only process external LOB data.
++
+*** If the LOB column is not defined as `'EXTERNAL'` during table creation, then the dummy LOB handle will be considered as a regular LOB dummy handle. If this handle is used to perform an insert or update operation, the LOB data will be maintained within the Trafodion space in the internal location maintained by Trafodion.
* An empty LOB is distinct from a LOB containing a string of length zero or a null LOB.