Repository: incubator-trafodion Updated Branches: refs/heads/master d878a12ea -> 9b3c71ee4 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/regress/executor/TEST130 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130 index cb7557f..32ccb51 100755 --- a/core/sql/regress/executor/TEST130 +++ b/core/sql/regress/executor/TEST130 @@ -44,6 +44,9 @@ drop table t130lob3 cascade; drop table t130lob4 cascade; drop table t130lob5 cascade; drop table tlob130ext cascade; +drop table t130char cascade; +drop table t130var cascade; +drop external table if exists date_dim for hive.hive.date_dim; ?section setup log LOG130 clear; @@ -58,6 +61,11 @@ create table t130lob3 (c1 int not null, c2 blob, c3 blob, primary key (c1)); create table t130lob4 (c1 int not null, c2 char(10), c3 clob, primary key (c1)); +create table t130char(c1 int not null, c2 char (20), primary key (c1)); +create table t130var(c1 int not null, c2 varchar(100), primary key (c1)); +create external table date_dim + (d_date_sk int, d_date_id varchar(100 bytes) character set utf8, d_date date) + for hive.hive.date_dim; ?section dml_insert insert into t130lob1 values(NULL); @@ -74,6 +82,29 @@ select lobtostring(c2,10) from t130lob2; select lobtostring(c2,2) from t130lob2; select c1,lobtostring(c2,100) from t130lob2; +delete from t130lob2; +--test insert with param (assumes that caller will pass in string format.) +prepare s from insert into t130lob2 values (1, ?); +execute s using 'fgfgfhfhfhfhhfhfhfhjfkkfkffllflflfll'; +select lobtostring(c2,50) from t130lob2; + +--test insert select from a source char column to lob +delete from t130lob2; +insert into t130char values (1,'fixed char 1'),(2,'fixed char 2'),(3,'fixed char 3'); +insert into t130lob2(c1,c2) select c1,c2 from t130char; +select lobtostring(c2,50) from t130lob2; + +--test insert select from a source varchar column to lob +delete from t130lob2; +insert into t130var values (1,'var char 1'),(2,'var char 22222222222222222222222'),(3,'var char 33333333333333333333333333333333333333333333333333333'); +insert into t130lob2(c1,c2) select c1,c2 from t130var; +select lobtostring(c2,100) from t130lob2; + +--test insert select from a source hive varchar column to lob +delete from t130lob2; +insert into t130lob2 select [first 10] d_date_sk,d_date_id from hive.hive.date_dim; +select lobtostring(c2,40) from t130lob2; + --test values clause values((select * from t130lob1)); @@ -609,6 +640,7 @@ sh rm TEST130_argfile*; drop table tlob130gc; drop table tlob130gt; drop table tlob130t5; +drop external table if exists date_dim for hive.hive.date_dim; drop schema trafodion.lob130 cascade;
Merge remote branch 'origin/master' into 2.2_work Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/22ef1e28 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/22ef1e28 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/22ef1e28 Branch: refs/heads/master Commit: 22ef1e28ef2a264bbe9d937efb783c65e64ec408 Parents: d3d707a 0c6089d Author: Sandhya Sundaresan <sa...@apache.org> Authored: Thu Mar 23 22:33:43 2017 +0000 Committer: Sandhya Sundaresan <sa...@apache.org> Committed: Thu Mar 23 22:33:43 2017 +0000 ---------------------------------------------------------------------- core/conn/trafci/install/Installer.java-tmpl | 36 +- .../java/org/trafodion/ci/QueryWrapper.java | 6 +- core/sqf/sql/scripts/analyzeMessageGuide.py | 3 + core/sqf/sql/scripts/install_local_hadoop | 4 + core/sqf/src/seabed/src/threadl.cpp | 38 +- .../hbase/client/transactional/TmDDL.java | 33 +- .../transactional/SplitBalanceHelper.java | 11 +- .../transactional/TrxRegionObserver.java.tmpl | 2 +- .../java/org/trafodion/dtm/HBaseTxClient.java | 487 +- core/sql/bin/SqlciErrors.txt | 40 +- core/sql/cli/Cli.cpp | 2 +- core/sql/comexe/ComTdb.h | 1 + core/sql/comexe/ComTdbExeUtil.cpp | 74 + core/sql/comexe/ComTdbExeUtil.h | 49 +- core/sql/common/CharType.cpp | 41 +- core/sql/common/CharType.h | 7 +- core/sql/common/ComSecurityKey.cpp | 118 +- core/sql/common/ComSecurityKey.h | 18 +- core/sql/common/ComSmallDefs.h | 4 + core/sql/common/ComUser.cpp | 11 + core/sql/common/ComUser.h | 1 + core/sql/common/NAType.cpp | 11 + core/sql/common/NAType.h | 3 + core/sql/common/conversionLocale.cpp | 4 +- core/sql/executor/ExComTdb.cpp | 8 + core/sql/executor/ExExeUtil.h | 96 + core/sql/executor/ExExeUtilGet.cpp | 54 +- core/sql/executor/ExExeUtilMisc.cpp | 125 + core/sql/executor/ExHbaseAccess.cpp | 18 +- core/sql/executor/ExHbaseIUD.cpp | 30 +- core/sql/executor/ExUdr.cpp | 2 +- core/sql/exp/ExpHbaseDefs.h | 2 + core/sql/exp/exp_function.cpp | 10 +- core/sql/exp/exp_function.h | 20 +- core/sql/generator/GenExplain.cpp | 27 +- core/sql/generator/GenItemFunc.cpp | 14 +- core/sql/generator/GenRelExeUtil.cpp | 68 +- core/sql/generator/GenRelGrby.cpp | 10 +- core/sql/generator/GenRelMisc.cpp | 10 +- core/sql/generator/Generator.cpp | 8 + core/sql/optimizer/BindRelExpr.cpp | 78 +- core/sql/optimizer/ItemExpr.h | 1 - core/sql/optimizer/ItemFunc.h | 6 +- core/sql/optimizer/NATable.cpp | 2 + core/sql/optimizer/ObjectNames.cpp | 37 +- core/sql/optimizer/ObjectNames.h | 4 + core/sql/optimizer/RelExeUtil.cpp | 56 + core/sql/optimizer/RelExeUtil.h | 44 +- core/sql/optimizer/SynthType.cpp | 16 +- core/sql/parser/ParKeyWords.cpp | 1 + core/sql/parser/sqlparser.y | 39 +- core/sql/regress/charsets/EXPECTED004 | 6 +- core/sql/regress/charsets/EXPECTED314 | 68 + core/sql/regress/charsets/TEST314 | 12 + core/sql/regress/hive/EXPECTED005 | 132 +- core/sql/regress/hive/EXPECTED007 | 86 +- core/sql/regress/hive/EXPECTED009 | 23 +- core/sql/regress/hive/EXPECTED017 | 18 +- core/sql/regress/hive/TEST005 | 20 +- core/sql/regress/hive/TEST007 | 80 +- core/sql/regress/hive/TEST009 | 3 +- core/sql/regress/privs1/EXPECTED120 | 129 +- core/sql/regress/privs1/TEST120 | 33 +- core/sql/regress/seabase/EXPECTED002 | 185 +- core/sql/regress/seabase/EXPECTED003 | 114 +- core/sql/regress/seabase/EXPECTED010 | 378 +- core/sql/regress/seabase/EXPECTED011 | 18 +- core/sql/regress/seabase/EXPECTED020 | 4 +- core/sql/regress/seabase/EXPECTED031 | 239 +- core/sql/regress/seabase/EXPECTED033 | 21 +- core/sql/regress/seabase/TEST002 | 30 + core/sql/regress/seabase/TEST003 | 16 +- core/sql/regress/seabase/TEST011 | 2 + core/sql/regress/seabase/TEST031 | 74 + core/sql/regress/seabase/TEST033 | 13 +- core/sql/regress/tools/runregr_privs1.ksh | 49 +- core/sql/regress/tools/runregr_privs2.ksh | 49 +- core/sql/regress/udr/EXPECTED001 | 14 +- core/sql/regress/udr/EXPECTED107.SB | 10 +- core/sql/regress/udr/TEST001 | 14 +- core/sql/regress/udr/TEST107 | 10 +- core/sql/sqlci/sqlci_lex.ll | 1 + core/sql/sqlci/sqlci_yacc.y | 2 + core/sql/sqlcomp/CmpDDLCatErrorCodes.h | 30 +- core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp | 174 +- core/sql/sqlcomp/CmpSeabaseDDLschema.cpp | 6 +- core/sql/sqlcomp/CmpSeabaseDDLtable.cpp | 3 + core/sql/sqlcomp/DefaultConstants.h | 10 +- core/sql/sqlcomp/PrivMgrCommands.cpp | 8 +- core/sql/sqlcomp/PrivMgrPrivileges.cpp | 33 +- core/sql/sqlcomp/PrivMgrPrivileges.h | 1 - core/sql/sqlcomp/nadefaults.cpp | 44 +- core/sql/sqlcomp/parser.cpp | 2 +- .../java/org/trafodion/sql/HBaseClient.java | 17 + .../java/org/trafodion/sql/HBulkLoadClient.java | 2 +- core/sql/ustat/hs_cli.cpp | 2 + .../src/asciidoc/_chapters/query_execution.adoc | 71 +- .../src/asciidoc/_chapters/ddl_msgs.adoc | 111 +- .../src/asciidoc/_chapters/olap_functions.adoc | 129 +- .../sql_functions_and_expressions.adoc | 16663 ++++++++--------- .../_chapters/sql_language_elements.adoc | 6 +- .../src/asciidoc/_chapters/sql_statements.adoc | 114 +- .../TRAFODION/2.1/service_advisor.py | 3 +- install/installer/traf_hortonworks_mods | 6 + install/python-installer/configs/mod_cfgs.json | 1 + 105 files changed, 11552 insertions(+), 9527 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/22ef1e28/core/sql/optimizer/SynthType.cpp ----------------------------------------------------------------------
Merge remote branch 'origin/pr/1022/head' into merge_1022 Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/9b3c71ee Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/9b3c71ee Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/9b3c71ee Branch: refs/heads/master Commit: 9b3c71ee4c9556da0bae3f173b85f2ec82c1456f Parents: d878a12 45bbb16 Author: Sandhya Sundaresan <sa...@apache.org> Authored: Tue Mar 28 15:18:37 2017 +0000 Committer: Sandhya Sundaresan <sa...@apache.org> Committed: Tue Mar 28 15:18:37 2017 +0000 ---------------------------------------------------------------------- core/sql/exp/ExpLOB.cpp | 14 ++- core/sql/generator/GenPreCode.cpp | 2 +- core/sql/optimizer/BindItemExpr.cpp | 22 +++- core/sql/optimizer/SynthType.cpp | 14 ++- core/sql/regress/executor/EXPECTED130 | 183 ++++++++++++++++++++++------- core/sql/regress/executor/TEST130 | 32 +++++ 6 files changed, 214 insertions(+), 53 deletions(-) ----------------------------------------------------------------------
Support for insert-select from varchar/char colummns into lob columns. Supposed for insert with parameter.This work is done as part of [TRAFODION-2516]
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/d3d707ae
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/d3d707ae
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/d3d707ae
Branch: refs/heads/master
Commit: d3d707ae49c7922ef033d2a9f2428aef5a442d7b
Parents: 2aeb4d1
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Thu Mar 23 04:49:13 2017 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Thu Mar 23 04:49:13 2017 +0000
----------------------------------------------------------------------
core/sql/exp/ExpLOB.cpp | 14 ++-
core/sql/generator/GenPreCode.cpp | 2 +-
core/sql/optimizer/BindItemExpr.cpp | 36 +++++-
core/sql/optimizer/SynthType.cpp | 14 ++-
core/sql/regress/executor/EXPECTED130 | 183 ++++++++++++++++++++++-------
core/sql/regress/executor/TEST130 | 32 +++++
6 files changed, 229 insertions(+), 52 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/exp/ExpLOB.cpp
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpLOB.cpp b/core/sql/exp/ExpLOB.cpp
index 66da5fc..447ce89 100644
--- a/core/sql/exp/ExpLOB.cpp
+++ b/core/sql/exp/ExpLOB.cpp
@@ -774,7 +774,12 @@ ex_expr::exp_return_type ExpLOBiud::insertDesc(char *op_data[],
// lob desc update, then remove this.
Int64 lobLen = 0;
if(!fromEmpty())
- lobLen = getOperand(1)->getLength();
+ {
+ lobLen = getOperand(1)->getLength();
+ //If source is a varchar, find the actual length
+ if (fromString() && ((getOperand(1)->getVCIndicatorLength() >0)))
+ lobLen = getOperand(1)->getLength(op_data[1]- getOperand(1)->getVCIndicatorLength());
+ }
// until SQL_EXEC_LOBcliInterface is changed to allow for unlimited
// black box sizes, we have to prevent over-sized file names from
@@ -919,7 +924,12 @@ ex_expr::exp_return_type ExpLOBiud::insertData(Lng32 handleLen,
return ex_expr::EXPR_ERROR;
lobLen = getOperand(1)->getLength();
-
+ if(fromString())
+ {
+ //If source is a varchar, find the actual length
+ if (getOperand(1)->getVCIndicatorLength() >0)
+ lobLen = getOperand(1)->getLength(op_data[1]- getOperand(1)->getVCIndicatorLength());
+ }
char * lobData = NULL;
if (fromExternal())
{
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/generator/GenPreCode.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenPreCode.cpp b/core/sql/generator/GenPreCode.cpp
index 381f409..f82bebc 100644
--- a/core/sql/generator/GenPreCode.cpp
+++ b/core/sql/generator/GenPreCode.cpp
@@ -5534,7 +5534,7 @@ RelExpr * HbaseInsert::preCodeGen(Generator * generator,
{
li = new(generator->wHeap())
LOBinsert(child1Expr, NULL, LOBoper::LOB_);
-
+
li->insertedTableObjectUID() =
getIndexDesc()->getPrimaryTableDesc()->
getNATable()->objectUid().castToInt64();
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/optimizer/BindItemExpr.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/BindItemExpr.cpp b/core/sql/optimizer/BindItemExpr.cpp
index bd30515..e2df528 100644
--- a/core/sql/optimizer/BindItemExpr.cpp
+++ b/core/sql/optimizer/BindItemExpr.cpp
@@ -6071,7 +6071,7 @@ ItemExpr *Assign::bindNode(BindWA *bindWA)
if (bindWA->errStatus())
return this;
child(0) = boundExpr;
-
+
if (CmpCommon::getDefault(JDBC_PROCESS) == DF_ON)
{
@@ -6173,7 +6173,35 @@ ItemExpr *Assign::bindNode(BindWA *bindWA)
} // QSTUFF
} // isUserSpecified
+ NABuiltInTypeEnum sourceType = child(1)->castToItemExpr()->getValueId().getType().getTypeQualifier() ;
+ NABuiltInTypeEnum targetType = child(0)->castToItemExpr()->getValueId().getType().getTypeQualifier() ;
+ if ((sourceType == NA_CHARACTER_TYPE) && (targetType == NA_LOB_TYPE))
+ {
+ ValueId vid1 = child(1)->castToItemExpr()->getValueId();
+ // Add a stringToLob node
+ ItemExpr *newChild = new (bindWA->wHeap()) LOBinsert( vid1.getItemExpr(), NULL, LOBoper::STRING_, FALSE);
+ newChild->bindNode(bindWA);
+ if (bindWA->errStatus())
+ return boundExpr;
+ setChild(1, newChild);
+ }
+ /* if ((sourceType == NA_UNKNOWN_TYPE) && (targetType = NA_LOB_TYPE))
+ {
+ ValueId vid1 = child(1)->castToItemExpr()->getValueId();
+
+ SQLVarChar c1(CmpCommon::getDefaultNumeric(MAX_LONG_VARCHAR_DEFAULT_SIZE));
+ vid1.coerceType(c1, NA_CHARACTER_TYPE);
+
+
+ // Add a stringToLob node
+ ItemExpr *newChild = new (bindWA->wHeap()) LOBinsert( vid1.getItemExpr(), NULL, LOBoper::STRING_, FALSE);
+ newChild->bindNode(bindWA);
+ if (bindWA->errStatus())
+ return boundExpr;
+ setChild(1, newChild);
+
+ }*/
if ((NOT child(0)->getValueId().getType().
isCompatible(child(1)->getValueId().getType())) &&
(CmpCommon::getDefault(ALLOW_INCOMPATIBLE_OPERATIONS) == DF_ON) &&
@@ -6191,13 +6219,13 @@ ItemExpr *Assign::bindNode(BindWA *bindWA)
return boundExpr;
setChild(1, newChild);
}
-
+
+
// If we assign a numeric type and the source has a larger scale then
// the target we cast the source to reduce the scale (truncate).
// We also cast (truncate) if we deal with char and the source is larger
// than the target.
- NABuiltInTypeEnum targetType =
- child(0)->getValueId().getType().getTypeQualifier();
+ targetType = child(0)->castToItemExpr()->getValueId().getType().getTypeQualifier() ;
if (targetType == NA_CHARACTER_TYPE) {
Lng32 sourceLength = ((CharType&)(child(1)->getValueId().getType())).getStrCharLimit();
Lng32 targetLength = ((CharType&)(child(0)->getValueId().getType())).getStrCharLimit();
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/optimizer/SynthType.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/SynthType.cpp b/core/sql/optimizer/SynthType.cpp
index 474a537..e3766a4 100644
--- a/core/sql/optimizer/SynthType.cpp
+++ b/core/sql/optimizer/SynthType.cpp
@@ -1853,6 +1853,7 @@ const NAType *Assign::doSynthesizeType(ValueId & targetId, ValueId & sourceId)
{
NABoolean ODBC = (CmpCommon::getDefault(ODBC_PROCESS) == DF_ON);
NABoolean JDBC = (CmpCommon::getDefault(JDBC_PROCESS) == DF_ON);
+ NABoolean isSourceNullConst = FALSE;
NABoolean forceSourceParamToBeNullable =
(CmpCommon::getDefault(COMP_BOOL_173) == DF_ON);
@@ -1866,7 +1867,16 @@ const NAType *Assign::doSynthesizeType(ValueId & targetId, ValueId & sourceId)
NABoolean sourceIsUntypedParam =
(sourceId.getType().getTypeQualifier() == NA_UNKNOWN_TYPE);
-
+ if ((sourceId.getItemExpr()->getOperatorType() == ITM_CONSTANT)
+ && (((ConstValue*)sourceId.getItemExpr())->isNull()))
+ isSourceNullConst = TRUE;
+ if (sourceIsUntypedParam && (targetType.getTypeQualifier() == NA_LOB_TYPE)
+ && !isSourceNullConst)
+ {
+ ValueId vid1 = child(1)->castToItemExpr()->getValueId();
+ SQLVarChar c1(CmpCommon::getDefaultNumeric(MAX_LONG_VARCHAR_DEFAULT_SIZE));
+ vid1.coerceType(c1, NA_CHARACTER_TYPE);
+ }
// Charset inference.
const NAType& sourceType = sourceId.getType();
targetId.coerceType(sourceType);
@@ -6704,7 +6714,7 @@ const NAType *LOBinsert::synthesizeType()
if (child(0))
{
vid1 = child(0)->getValueId();
- typ1 = &vid1.getType();
+ typ1 = &vid1.getType();
}
if ((obj_ == STRING_) ||
Removing commented out code
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/45bbb16a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/45bbb16a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/45bbb16a
Branch: refs/heads/master
Commit: 45bbb16a52e7986b56afcad68f12fc02fd0b72bf
Parents: 22ef1e2
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Tue Mar 28 05:36:56 2017 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Tue Mar 28 05:36:56 2017 +0000
----------------------------------------------------------------------
core/sql/optimizer/BindItemExpr.cpp | 18 +-----------------
1 file changed, 1 insertion(+), 17 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/45bbb16a/core/sql/optimizer/BindItemExpr.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/BindItemExpr.cpp b/core/sql/optimizer/BindItemExpr.cpp
index e2df528..91e1325 100644
--- a/core/sql/optimizer/BindItemExpr.cpp
+++ b/core/sql/optimizer/BindItemExpr.cpp
@@ -6185,23 +6185,7 @@ ItemExpr *Assign::bindNode(BindWA *bindWA)
return boundExpr;
setChild(1, newChild);
}
- /* if ((sourceType == NA_UNKNOWN_TYPE) && (targetType = NA_LOB_TYPE))
- {
- ValueId vid1 = child(1)->castToItemExpr()->getValueId();
-
- SQLVarChar c1(CmpCommon::getDefaultNumeric(MAX_LONG_VARCHAR_DEFAULT_SIZE));
- vid1.coerceType(c1, NA_CHARACTER_TYPE);
-
-
-
- // Add a stringToLob node
- ItemExpr *newChild = new (bindWA->wHeap()) LOBinsert( vid1.getItemExpr(), NULL, LOBoper::STRING_, FALSE);
- newChild->bindNode(bindWA);
- if (bindWA->errStatus())
- return boundExpr;
- setChild(1, newChild);
-
- }*/
+
if ((NOT child(0)->getValueId().getType().
isCompatible(child(1)->getValueId().getType())) &&
(CmpCommon::getDefault(ALLOW_INCOMPATIBLE_OPERATIONS) == DF_ON) &&
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d3d707ae/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index 9c8fb51..ef2e9d6 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -19,6 +19,17 @@
+>c2 char(10), c3 clob, primary key (c1));
--- SQL operation complete.
+>>create table t130char(c1 int not null, c2 char (20), primary key (c1));
+
+--- SQL operation complete.
+>>create table t130var(c1 int not null, c2 varchar(100), primary key (c1));
+
+--- SQL operation complete.
+>>create external table date_dim
++> (d_date_sk int, d_date_id varchar(100 bytes) character set utf8, d_date date)
++> for hive.hive.date_dim;
+
+--- SQL operation complete.
>>
>>?section dml_insert
>>insert into t130lob1 values(NULL);
@@ -52,9 +63,9 @@ C1
C1 C2
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1 LOBH0000000200010559696826186435416219559696826195743244718212351957479965039020"TRAFODION"."LOB130"
- 2 LOBH0000000200010559696826186435416219559696826196364100518212351957487711692020"TRAFODION"."LOB130"
- 3 LOBH0000000200010559696826186435416219559696826196975611918212351957493829420020"TRAFODION"."LOB130"
+ 1 LOBH0000000200010219168903258874722819219168903288954731118212356996658039353020"TRAFODION"."LOB130"
+ 2 LOBH0000000200010219168903258874722819219168903289672426518212356996666148698020"TRAFODION"."LOB130"
+ 3 LOBH0000000200010219168903258874722819219168903290319695818212356996672743207020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -90,6 +101,92 @@ C1 (EXPR)
--- 3 row(s) selected.
>>
+>>delete from t130lob2;
+
+--- 3 row(s) deleted.
+>>--test insert with param (assumes that caller will pass in string format.)
+>>prepare s from insert into t130lob2 values (1, ?);
+
+--- SQL command prepared.
+>>execute s using 'fgfgfhfhfhfhhfhfhfhjfkkfkffllflflfll';
+
+--- 1 row(s) inserted.
+>>select lobtostring(c2,50) from t130lob2;
+
+(EXPR)
+--------------------------------------------------
+
+fgfgfhfhfhfhhfhfhfhjfkkfkffllflflfll
+
+--- 1 row(s) selected.
+>>
+>>--test insert select from a source char column to lob
+>>delete from t130lob2;
+
+--- 1 row(s) deleted.
+>>insert into t130char values (1,'fixed char 1'),(2,'fixed char 2'),(3,'fixed char 3');
+
+--- 3 row(s) inserted.
+>>insert into t130lob2(c1,c2) select c1,c2 from t130char;
+
+--- 3 row(s) inserted.
+>>select lobtostring(c2,50) from t130lob2;
+
+(EXPR)
+--------------------------------------------------
+
+fixed char 1
+fixed char 2
+fixed char 3
+
+--- 3 row(s) selected.
+>>
+>>--test insert select from a source varchar column to lob
+>>delete from t130lob2;
+
+--- 3 row(s) deleted.
+>>insert into t130var values (1,'var char 1'),(2,'var char 22222222222222222222222'),(3,'var char 33333333333333333333333333333333333333333333333333333');
+
+--- 3 row(s) inserted.
+>>insert into t130lob2(c1,c2) select c1,c2 from t130var;
+
+--- 3 row(s) inserted.
+>>select lobtostring(c2,100) from t130lob2;
+
+(EXPR)
+----------------------------------------------------------------------------------------------------
+
+var char 1
+var char 22222222222222222222222
+var char 33333333333333333333333333333333333333333333333333333
+
+--- 3 row(s) selected.
+>>
+>>--test insert select from a source hive varchar column to lob
+>>delete from t130lob2;
+
+--- 3 row(s) deleted.
+>>insert into t130lob2 select [first 10] d_date_sk,d_date_id from hive.hive.date_dim;
+
+--- 10 row(s) inserted.
+>>select lobtostring(c2,40) from t130lob2;
+
+(EXPR)
+----------------------------------------
+
+AAAAAAAAOKJNECAA
+AAAAAAAAPKJNECAA
+AAAAAAAAALJNECAA
+AAAAAAAABLJNECAA
+AAAAAAAACLJNECAA
+AAAAAAAADLJNECAA
+AAAAAAAAELJNECAA
+AAAAAAAAFLJNECAA
+AAAAAAAAGLJNECAA
+AAAAAAAAHLJNECAA
+
+--- 10 row(s) selected.
+>>
>>--test values clause
>>values((select * from t130lob1));
@@ -103,7 +200,7 @@ C1
>>--test empty_blob(), empty_clob()
>>delete from t130lob2;
---- 3 row(s) deleted.
+--- 10 row(s) deleted.
>>insert into t130lob2 values (1, empty_blob());
--- 1 row(s) inserted.
@@ -477,7 +574,7 @@ And the dish ran away with the fork !
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_txt1.txt');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186439964319559696826241512955218212351957939199849020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881619119219168903356455897718212356997334190246020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -493,7 +590,7 @@ Success. Targetfile :tlob130_txt1.txt Length : 19
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_deep.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -509,7 +606,7 @@ Success. Targetfile :tlob130_deep.jpg Length : 159018
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -631,7 +728,7 @@ And the dish ran away with the fork !
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_txt2.txt');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186441630019559696826257581553118212351958099882804020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258883232319219168903372701511018212356997496619570020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
--- SQL operation complete.
@@ -647,7 +744,7 @@ Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_deep.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186441758719559696826264825758518212351958172401525020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258883350719219168903379688308218212356997566552580020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -663,7 +760,7 @@ Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -682,7 +779,7 @@ Column Name : c2
Input a filename to extract to :
Output File Name : lobc2out.jpg
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258881727719219168903363726830218212356997406948130020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks of 1000 ...
@@ -963,7 +1060,7 @@ And the dish ran away with the spoon.
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_deep2.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200020559696826186444079619559696826279514148718212351958319078382020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200020219168903258885636519219168903393735875718212356997706941500020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -972,7 +1069,7 @@ Success. Targetfile :tlob130_deep2.jpg Length : 159018
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_anoush2.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200030559696826186444079619559696826280142532318212351958325419986020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
+>>extract lobtofile(LOB 'LOBH0000000200030219168903258885636519219168903394315005818212356997712891888020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
--- SQL operation complete.
@@ -999,7 +1096,7 @@ Hey diddle diddle,
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_anoush3.jpg',create,truncate);/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH0000000200030559696826186444611919559696826285313364218212351958377158869020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB 'LOBH0000000200030219168903258886158819219168903399547397218212356997765122427020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1100,12 +1197,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864479209_0001
+ LOB Data File: LOBP_02191689032588893965_0001
LOB EOD : 0
LOB Used Len : 0
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864479209_0002
+ LOB Data File: LOBP_02191689032588893965_0002
LOB EOD : 0
LOB Used Len : 0
ColumnName : C4
@@ -1120,8 +1217,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT2 C2
/lobs LOBP_05596968261864479209_0001 0 0
-TRAFODION LOB130 TLOB130GT2 C3
/lobs LOBP_05596968261864479209_0002 0 0
+TRAFODION LOB130 TLOB130GT2 C2
/lobs LOBP_02191689032588893965_0001 0 0
+TRAFODION LOB130 TLOB130GT2 C3
/lobs LOBP_02191689032588893965_0002 0 0
TRAFODION LOB130 TLOB130GT2 C4
External HDFS Location External HDFS File 0 0
--- 3 row(s) selected.
@@ -1142,17 +1239,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0001
+ LOB Data File: LOBP_02191689032588891420_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0002
+ LOB Data File: LOBP_02191689032588891420_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0003
+ LOB Data File: LOBP_02191689032588891420_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1162,9 +1259,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_05596968261864476749_0001 15 15
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_05596968261864476749_0002 15 15
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_05596968261864476749_0003 45 45
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_02191689032588891420_0001 15 15
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_02191689032588891420_0002 15 15
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_02191689032588891420_0003 45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1181,17 +1278,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0001
+ LOB Data File: LOBP_02191689032588891420_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0002
+ LOB Data File: LOBP_02191689032588891420_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864476749_0003
+ LOB Data File: LOBP_02191689032588891420_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1201,9 +1298,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_05596968261864476749_0001 30 25
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_05596968261864476749_0002 31 26
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_05596968261864476749_0003 71 56
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_02191689032588891420_0001 30 25
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_02191689032588891420_0002 31 26
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_02191689032588891420_0003 71 56
--- 3 row(s) selected.
>>
@@ -1365,12 +1462,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864491728_0001
+ LOB Data File: LOBP_02191689032588906132_0001
LOB EOD : 70
LOB Used Len : 42
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_05596968261864491728_0002
+ LOB Data File: LOBP_02191689032588906132_0002
LOB EOD : 125
LOB Used Len : 68
ColumnName : C4
@@ -1385,8 +1482,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130EXT C2
/lobs LOBP_05596968261864491728_0001 70 42
-TRAFODION LOB130 TLOB130EXT C3
/lobs LOBP_05596968261864491728_0002 125 68
+TRAFODION LOB130 TLOB130EXT C2
/lobs LOBP_02191689032588906132_0001 70 42
+TRAFODION LOB130 TLOB130EXT C3
/lobs LOBP_02191689032588906132_0002 125 68
TRAFODION LOB130 TLOB130EXT C4
External HDFS Location External HDFS File 0 0
--- 3 row(s) selected.
@@ -1403,7 +1500,7 @@ Column Name : c4
Input a filename to extract to :
Output File Name : lobc4ext.txt
Extracting lob handle for column c4...
-LOB handle for c4: LOBH0000000800030559696826186449172819559696826337745983818212351958901392808020"TRAFODION"."LOB130"
+LOB handle for c4: LOBH0000000800030219168903258890613219219168903450520326718212356998274785087020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :19
Extracting lob data into file in chunks of 1000 ...
@@ -1428,7 +1525,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1445,7 +1542,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1462,7 +1559,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1479,7 +1576,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2: LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000000200010219168903258893338319219168903470214248818212356998471792486020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1506,7 +1603,7 @@ zzzzzzzzzzzzzzzzzzzz
C2
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------
-LOBH0000000200010559696826186449172819559696826371325150818212351959237435210020"TRAFODION"."LOB130"
<TRUNCATED>