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 <[email protected]> Authored: Wed Dec 20 14:57:55 2017 +0800 Committer: liu.yu <[email protected]> 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.
