[
https://issues.apache.org/jira/browse/TRAFODION-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16296352#comment-16296352
]
ASF GitHub Bot commented on TRAFODION-2849:
-------------------------------------------
Github user sandhyasun commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1350#discussion_r157678749
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---
@@ -3526,7 +3526,7 @@ EMPTY_CLOB()
* If EMPTY_CLOB() is specified, then a dummy lob handle is created.
-** No data is associated with the empty LOBs yet, but these dummy LOB
handles can later be used to populate with new LOB data. If the LOB had data
previously associated with it, it will be erased.
+** No data is associated with the empty LOBs yet, but these dummy LOB
handles can later be used to populate the LOB with new data. If the LOB had
data previously associated with it, it will be erased.
** The dummy LOB handle will get the same datatype as the underlying
column.
+
--- End diff --
Here, maybe you can elaborate by explaining what "getting the same
datatype as column " means . If the column is declared as type LOB 'external'
in the create statement, the dummy lob handle will get the type external and
this LOB can only handle LOB's that are external.
If the column is declared without the external clause, the LOB data will be
maintained within the Trafodion space in the internal location maintained by
Trafodion.
> Add BLOB and CLOB for *Trafodion SQL Reference Manual*
> ------------------------------------------------------
>
> Key: TRAFODION-2849
> URL: https://issues.apache.org/jira/browse/TRAFODION-2849
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
