[
https://issues.apache.org/jira/browse/TRAFODION-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15987646#comment-15987646
]
ASF GitHub Bot commented on TRAFODION-2598:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1072#discussion_r113799176
--- Diff: core/sql/exp/ExpLOBaccess.cpp ---
@@ -2454,7 +2560,55 @@ Ex_Lob_Error ExLobsOper (
err = lobPtr->writeDataSimple(source, sourceLen, subOperation,
retOperLen,
bufferSize , replication , blockSize);
break;
+ case Lob_InsSel:
+ {
+
+ ExLob *srcLobPtr;
+ Int16 flags;
+ Lng32 lobNum;
+ Int32 lobType;
+ Int64 uid, inDescSyskey, descPartnKey;
+ short schNameLen;
+ char schName[1024];
--- End diff --
I see several fixed-length char arrays here. Do we have guarantees that
these won't overrun?
> Insert Select to/from Trafodion tables containing LOB columns
> -------------------------------------------------------------
>
> Key: TRAFODION-2598
> URL: https://issues.apache.org/jira/browse/TRAFODION-2598
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Fix For: 2.2-incubating
>
>
> Get insert-select from LOB columns to target tables containing LOB columns to
> work. Two cases need to be considered:
> 1. LOB columns thatt contain the lob data in HDFS (regular LOB columns)
> 2. LOB columns that contain external LOB data - the data is contained in
> external LOB files - the Trafodion tables won't contain the LOB data.
> Restrictions : If a table contains an external LOB column the target table
> must also contain an external LOB column to be able to do an insert-select.
> Cannot insert a regular LOB column into an external LOB column in target
> table and vice versa.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
