Repository: incubator-trafodion
Updated Branches:
refs/heads/master dcfc8e6aa -> b3d353156
Fixes for values() clause on lob columns and functions
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/3b31f503
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/3b31f503
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/3b31f503
Branch: refs/heads/master
Commit: 3b31f5032d35302ad361a0fcb0aed4e76d83715e
Parents: 14ea380
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Tue May 10 04:31:07 2016 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Tue May 10 04:31:07 2016 +0000
----------------------------------------------------------------------
core/sql/exp/ExpLOB.cpp | 10 ++++++++++
core/sql/generator/GenPreCode.cpp | 14 ++++++++------
core/sql/regress/executor/TEST130 | 7 ++++++-
3 files changed, 24 insertions(+), 7 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b31f503/core/sql/exp/ExpLOB.cpp
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpLOB.cpp b/core/sql/exp/ExpLOB.cpp
index f1442b6..1a51628 100644
--- a/core/sql/exp/ExpLOB.cpp
+++ b/core/sql/exp/ExpLOB.cpp
@@ -711,6 +711,15 @@ ex_expr::exp_return_type ExpLOBiud::insertDesc(char *op_data[],
char * result = op_data[0];
// get the lob name where data need to be inserted
+ if (lobNum() == -1)
+ {
+ Int32 intparam = LOB_PTR_ERROR;
+ ExRaiseSqlError(h, diagsArea,
+ (ExeErrorCode)(8442), NULL, &intparam,
+ NULL, NULL, (char*)"ExpLOB",
+ (char*)"ExpLOB",getLobErrStr(intparam));
+ return ex_expr::EXPR_ERROR;
+ }
char tgtLobNameBuf[100];
char * tgtLobName = ExpGetLOBname(objectUID_, lobNum(), tgtLobNameBuf, 100);
@@ -1020,6 +1029,7 @@ ex_expr::exp_return_type ExpLOBinsert::eval(char *op_data[],
err = insertDesc(op_data, h, diagsArea);
if (err == ex_expr::EXPR_ERROR)
return err;
+
if (fromExternal())
return err;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b31f503/core/sql/generator/GenPreCode.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenPreCode.cpp b/core/sql/generator/GenPreCode.cpp
index 0ba9383..4d79c3c 100644
--- a/core/sql/generator/GenPreCode.cpp
+++ b/core/sql/generator/GenPreCode.cpp
@@ -2222,9 +2222,9 @@ RelExpr * RelRoot::preCodeGen(Generator * generator,
{
ValueId val_id = compExpr()[i];
ItemExpr * expr = val_id.getItemExpr();
- if ((val_id.getType().isLob()) &&
+ if ((val_id.getType().isLob()))/* &&
((expr->getOperatorType() == ITM_BASECOLUMN) ||
- (expr->getOperatorType() == ITM_INDEXCOLUMN)))
+ (expr->getOperatorType() == ITM_INDEXCOLUMN)))*/
{
LOBconvertHandle * lc = new(generator->wHeap())
LOBconvertHandle(val_id.getItemExpr(), LOBoper::STRING_);
@@ -2238,10 +2238,12 @@ RelExpr * RelRoot::preCodeGen(Generator * generator,
ColumnDesc *cd = (*cdl)[i];
NAColumn * col = cd->getValueId().getNAColumn(TRUE);
- lc->lobNum() = col->lobNum();
- lc->lobStorageType() = col->lobStorageType();
- lc->lobStorageLocation() = col->lobStorageLocation();
-
+ if (col)
+ {
+ lc->lobNum() = col->lobNum();
+ lc->lobStorageType() = col->lobStorageType();
+ lc->lobStorageLocation() = col->lobStorageLocation();
+ }
cd->setValueId(lc->getValueId());
rd->changeNATypeForUserColumnList(i, &lc->getValueId().getType());
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b31f503/core/sql/regress/executor/TEST130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130
index f05be1d..f6b4384 100755
--- a/core/sql/regress/executor/TEST130
+++ b/core/sql/regress/executor/TEST130
@@ -83,6 +83,9 @@ select lobtostring(c2,10) from t130lob2;
select lobtostring(c2,2) from t130lob2;
select c1,lobtostring(c2,100) from t130lob2;
+--test values clause
+values((select * from tlob130lob2));
+
obey TEST130(dml_join);
@@ -99,7 +102,9 @@ select c1, lobtostring(c2,25), lobtostring(c3,25) from t130lob3;
select lobtostring(t130lob2.c2,30) from t130lob2, t130lob3 where t130lob2.c1 = t130lob3.c1;
-
+values(lobtostring(t130lob2.c2));
+values (filetolob('./myfile.txt'));
+values( stringtolob('xxxxxx'));
obey TEST130(dml_update);
Merge remote branch 'origin/pr/473/head' into merge_473 Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/b3d35315 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/b3d35315 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/b3d35315 Branch: refs/heads/master Commit: b3d35315672b256f3de5153d98a928c23f49324d Parents: dcfc8e6 5d5aa1f Author: Sandhya Sundaresan <sa...@apache.org> Authored: Fri May 13 07:37:10 2016 +0000 Committer: Sandhya Sundaresan <sa...@apache.org> Committed: Fri May 13 07:37:10 2016 +0000 ---------------------------------------------------------------------- core/sql/bin/SqlciErrors.txt | 1 + core/sql/exp/ExpLOB.cpp | 10 ++++ core/sql/generator/GenPreCode.cpp | 14 +++--- core/sql/regress/executor/EXPECTED130 | 77 +++++++++++++++++++----------- core/sql/regress/executor/TEST130 | 6 ++- 5 files changed, 72 insertions(+), 36 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b3d35315/core/sql/generator/GenPreCode.cpp ----------------------------------------------------------------------
Merge remote branch 'origin/master' into traf2.1_misc
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/eb407a96
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/eb407a96
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/eb407a96
Branch: refs/heads/master
Commit: eb407a9697be15bd194ce45e3526c9b125652d1d
Parents: 3b31f50 bc1b2e1
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Tue May 10 04:32:04 2016 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Tue May 10 04:32:04 2016 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 2 +
core/sql/executor/ExHdfsScan.h | 1 +
core/sql/exp/ExpPCodeClauseGen.cpp | 1 +
core/sql/exp/exp_clause.cpp | 6 +-
core/sql/exp/exp_clause_derived.h | 9 +-
core/sql/exp/exp_conv.cpp | 13 +-
core/sql/generator/GenItemFunc.cpp | 16 +-
core/sql/generator/GenRelExeUtil.cpp | 2 +-
core/sql/generator/GenRelScan.cpp | 14 +-
core/sql/optimizer/ItemExpr.cpp | 2 +
core/sql/optimizer/ItemFunc.h | 8 +
core/sql/regress/executor/EXPECTED130 | 117 +-
core/sql/regress/executor/TEST130 | 51 +-
core/sql/regress/hive/EXPECTED005 | 97 +
core/sql/regress/hive/EXPECTED015 | 101 +-
core/sql/regress/hive/TEST005 | 40 +
core/sql/regress/hive/TEST005_a.hive.sql | 16 +
core/sql/regress/hive/TEST015 | 14 +-
core/sql/regress/hive/tbl_bad.data | 8 +
core/sql/ustat/hs_const.h | 1 +
core/sql/ustat/hs_globals.cpp | 1 +
core/sql/ustat/hs_la.cpp | 13 +
core/sql/ustat/hs_parser.cpp | 5 +-
docs/client_install/pom.xml | 10 +
.../src/asciidoc/_chapters/SQuirrel.adoc | 16 +-
.../src/asciidoc/_chapters/about.adoc | 16 +-
.../src/asciidoc/_chapters/dbviz.adoc | 12 +-
.../src/asciidoc/_chapters/introduction.adoc | 104 +-
.../src/asciidoc/_chapters/jdbct4.adoc | 32 +-
.../src/asciidoc/_chapters/odb.adoc | 8 +-
.../src/asciidoc/_chapters/odbc_linux.adoc | 18 +-
.../src/asciidoc/_chapters/odbc_windows.adoc | 54 +-
.../src/asciidoc/_chapters/trafci.adoc | 10 +-
docs/client_install/src/asciidoc/index.adoc | 28 +-
docs/command_interface/pom.xml | 8 +
.../src/asciidoc/_chapters/about.adoc | 22 +-
.../src/asciidoc/_chapters/commands.adoc | 40 +-
.../src/asciidoc/_chapters/install.adoc | 4 +-
.../src/asciidoc/_chapters/interactive.adoc | 14 +-
.../src/asciidoc/_chapters/introduction.adoc | 6 +-
.../src/asciidoc/_chapters/launch.adoc | 16 +-
.../src/asciidoc/_chapters/perlpython.adoc | 6 +-
.../src/asciidoc/_chapters/scripts.adoc | 4 +-
docs/command_interface/src/asciidoc/index.adoc | 29 +-
docs/cqd_reference/pom.xml | 8 +
.../src/asciidoc/_chapters/about.adoc | 23 +-
.../src/asciidoc/_chapters/debugging.adoc | 14 +-
.../src/asciidoc/_chapters/histograms.adoc | 16 +-
.../src/asciidoc/_chapters/introduction.adoc | 8 +-
.../_chapters/operational_controls.adoc | 26 +-
.../src/asciidoc/_chapters/query_execution.adoc | 46 +-
.../src/asciidoc/_chapters/query_plans.adoc | 78 +-
.../asciidoc/_chapters/runtime_controls.adoc | 6 +-
.../src/asciidoc/_chapters/schema_controls.adoc | 8 +-
.../asciidoc/_chapters/table_definition.adoc | 28 +-
.../src/asciidoc/_chapters/transactions.adoc | 6 +-
.../src/asciidoc/_chapters/update_stats.adoc | 14 +-
docs/cqd_reference/src/asciidoc/index.adoc | 21 +-
docs/jdbct4ref_guide/pom.xml | 297 +++
.../src/asciidoc/_chapters/about.adoc | 174 ++
.../src/asciidoc/_chapters/accessing.adoc | 906 ++++++++
.../asciidoc/_chapters/avoiding_mismatch.adoc | 97 +
.../src/asciidoc/_chapters/code_examples.adoc | 56 +
.../src/asciidoc/_chapters/compliance.adoc | 367 ++++
.../src/asciidoc/_chapters/introduction.adoc | 53 +
.../src/asciidoc/_chapters/lob_data.adoc | 553 +++++
.../src/asciidoc/_chapters/lob_management.adoc | 288 +++
.../src/asciidoc/_chapters/messages.adoc | 1943 ++++++++++++++++++
.../asciidoc/_chapters/properties_detail.adoc | 959 +++++++++
.../asciidoc/_chapters/properties_overview.adoc | 244 +++
.../src/asciidoc/_chapters/tracing_logging.adoc | 176 ++
docs/jdbct4ref_guide/src/asciidoc/index.adoc | 67 +
docs/jdbct4ref_guide/src/images/lob_tables.jpg | Bin 0 -> 16241 bytes
.../src/resources/source/blob_example.java | 202 ++
.../src/resources/source/clob_example.java | 200 ++
docs/load_transform/pom.xml | 8 +
.../src/asciidoc/_chapters/about.adoc | 31 +-
.../src/asciidoc/_chapters/bulk_load.adoc | 34 +-
.../src/asciidoc/_chapters/bulk_unload.adoc | 12 +-
.../src/asciidoc/_chapters/introduction.adoc | 24 +-
.../src/asciidoc/_chapters/monitor.adoc | 8 +-
.../src/asciidoc/_chapters/tables_indexes.adoc | 24 +-
.../src/asciidoc/_chapters/trickle_load.adoc | 54 +-
.../src/asciidoc/_chapters/troubleshoot.adoc | 20 +-
docs/load_transform/src/asciidoc/index.adoc | 22 +-
docs/messages_guide/pom.xml | 8 +
.../src/asciidoc/_chapters/about.adoc | 25 +-
.../src/asciidoc/_chapters/binder_msgs.adoc | 162 +-
.../src/asciidoc/_chapters/compiler_msgs.adoc | 164 +-
.../src/asciidoc/_chapters/ddl_msgs.adoc | 156 +-
.../src/asciidoc/_chapters/executor_msgs.adoc | 82 +-
.../asciidoc/_chapters/file_system_errors.adoc | 6 +-
.../src/asciidoc/_chapters/generator_msgs.adoc | 4 +-
.../src/asciidoc/_chapters/introduction.adoc | 34 +-
.../src/asciidoc/_chapters/optimizer_msgs.adoc | 6 +-
.../src/asciidoc/_chapters/parser_msgs.adoc | 74 +-
.../src/asciidoc/_chapters/sort_msgs.adoc | 68 +-
.../src/asciidoc/_chapters/sqlstate.adoc | 78 +-
.../_chapters/udr_language_mgr_msgs.adoc | 26 +-
docs/messages_guide/src/asciidoc/index.adoc | 21 +-
docs/odb_user/pom.xml | 8 +
.../src/asciidoc/_chapters/a_warnings.adoc | 4 +-
docs/odb_user/src/asciidoc/_chapters/about.adoc | 24 +-
.../src/asciidoc/_chapters/b_develop.adoc | 2 +-
.../src/asciidoc/_chapters/compare_tables.adoc | 2 +-
.../src/asciidoc/_chapters/concepts.adoc | 23 +-
.../src/asciidoc/_chapters/install.adoc | Bin 13598 -> 13248 bytes
.../src/asciidoc/_chapters/introduction.adoc | 36 +-
docs/odb_user/src/asciidoc/_chapters/load.adoc | 42 +-
.../src/asciidoc/_chapters/query_driver.adoc | 4 +-
.../src/asciidoc/_chapters/sql_interpreter.adoc | 4 +-
docs/odb_user/src/asciidoc/index.adoc | 21 +-
docs/provisioning_guide/pom.xml | 10 +
.../src/asciidoc/_chapters/about.adoc | 35 +-
.../src/asciidoc/_chapters/activate.adoc | 30 +-
.../src/asciidoc/_chapters/enable_security.adoc | 52 +-
.../src/asciidoc/_chapters/introduction.adoc | 184 +-
.../src/asciidoc/_chapters/prepare.adoc | 84 +-
.../src/asciidoc/_chapters/requirements.adoc | 125 +-
.../src/asciidoc/_chapters/script_install.adoc | 80 +-
.../src/asciidoc/_chapters/script_remove.adoc | 22 +-
.../src/asciidoc/_chapters/script_upgrade.adoc | 82 +-
docs/provisioning_guide/src/asciidoc/index.adoc | 22 +-
docs/shared/acknowledgements.txt | 60 +
docs/shared/revisions.txt | 32 +
.../spj_guide/src/asciidoc/_chapters/about.adoc | 2 +-
.../src/asciidoc/_chapters/create_spjs.adoc | 36 +-
.../src/asciidoc/_chapters/deploy_spjs.adoc | 34 +-
.../src/asciidoc/_chapters/develop_spjs.adoc | 36 +-
.../src/asciidoc/_chapters/execute_spjs.adoc | 34 +-
.../src/asciidoc/_chapters/get_started.adoc | 36 +-
.../asciidoc/_chapters/grant_privileges.adoc | 36 +-
.../src/asciidoc/_chapters/introduction.adoc | 36 +-
.../_chapters/performance_troubleshooting.adoc | 36 +-
.../src/asciidoc/_chapters/sample_database.adoc | 36 +-
.../src/asciidoc/_chapters/sample_spjs.adoc | 42 +-
docs/spj_guide/src/asciidoc/index.adoc | 14 +-
.../src/resources/acknowledgements.txt | 38 -
.../src/resources/source/create_demo.sql | 14 +
docs/sql_reference/pom.xml | 8 +
.../src/asciidoc/_chapters/about.adoc | 48 +-
.../src/asciidoc/_chapters/introduction.adoc | 112 +-
.../src/asciidoc/_chapters/limits.adoc | 4 +-
.../src/asciidoc/_chapters/olap_functions.adoc | 19 +-
.../src/asciidoc/_chapters/reserved_words.adoc | 13 +-
.../src/asciidoc/_chapters/runtime_stats.adoc | 13 +-
.../src/asciidoc/_chapters/sql_clauses.adoc | 26 +-
.../sql_functions_and_expressions.adoc | 304 +--
.../_chapters/sql_language_elements.adoc | 160 +-
.../src/asciidoc/_chapters/sql_statements.adoc | 374 ++--
.../src/asciidoc/_chapters/sql_utilities.adoc | 84 +-
docs/sql_reference/src/asciidoc/index.adoc | 27 +-
docs/src/site/resources/css/site.css | 2 +-
153 files changed, 9216 insertions(+), 2426 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/eb407a96/core/sql/regress/executor/TEST130
----------------------------------------------------------------------
diff --cc core/sql/regress/executor/TEST130
index f6b4384,48da1ed..74e0cbb
--- a/core/sql/regress/executor/TEST130
+++ b/core/sql/regress/executor/TEST130
@@@ -83,12 -74,7 +74,10 @@@ select lobtostring(c2,10) from t130lob2
select lobtostring(c2,2) from t130lob2;
select c1,lobtostring(c2,100) from t130lob2;
+--test values clause
+values((select * from tlob130lob2));
+
- obey TEST130(dml_join);
-
?section dml_join
insert into t130lob3 values (1,stringtolob('inserted row21a'),stringtolob('inserted row21b'));
insert into t130lob3 values (2,stringtolob('inserted row22a'),stringtolob('inserted row22b'));
@@@ -102,12 -88,8 +91,10 @@@ select c1, lobtostring(c2,25), lobtostr
select lobtostring(t130lob2.c2,30) from t130lob2, t130lob3 where t130lob2.c1 = t130lob3.c1;
-
+values(lobtostring(t130lob2.c2));
+values (filetolob('./myfile.txt'));
+values( stringtolob('xxxxxx'));
- obey TEST130(dml_update);
-
?section dml_update
update t130lob2 set c2=stringtolob('updated c2 in all rows');
Improve error message for lob functions called on invalid LOB types.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/5d5aa1f1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/5d5aa1f1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/5d5aa1f1
Branch: refs/heads/master
Commit: 5d5aa1f1e0baf6b09f951ddcb6d3187c44f405bb
Parents: 6c63255
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Thu May 12 18:02:28 2016 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Thu May 12 18:02:28 2016 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 1 +
core/sql/exp/ExpLOB.cpp | 5 +--
core/sql/regress/executor/EXPECTED130 | 60 +++++++++++++++---------------
3 files changed, 33 insertions(+), 33 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5d5aa1f1/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index 198a5d9..cf532fe 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -1549,6 +1549,7 @@ $1~String1 --------------------------------
8431 22026 99999 BEGINNER MINOR LOGONLY The string parameters have different length, they must be equal (IsBitwiseAndTrue function).
8432 22003 99999 BEGINNER MINOR LOGONLY A negative value cannot be converted to an unsigned numeric datatype.$0~string0
8433 22003 99999 BEGINNER MINOR LOGONLY Invalid $0~string0 character encountered in $1~string1.
+8434 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Invalid target column for LOB function. The column needs to be blob/clob type.
8440 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The size of the history buffer is too small to execute one or more of the OLAP Windowed Functions in the query.
8441 ZZZZZ 99999 BEGINNER MAJOR DBADMIN one or more of the OLAP Windowed Functions in the query may require overflow which is not supported yet.
8442 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to access $0~string0 interface. Call to $1~string1 returned error $2~string2($0~int0). Error detail $1~int1.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5d5aa1f1/core/sql/exp/ExpLOB.cpp
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpLOB.cpp b/core/sql/exp/ExpLOB.cpp
index 6b68cda..1d28e76 100644
--- a/core/sql/exp/ExpLOB.cpp
+++ b/core/sql/exp/ExpLOB.cpp
@@ -715,10 +715,9 @@ ex_expr::exp_return_type ExpLOBiud::insertDesc(char *op_data[],
{
Int32 intparam = LOB_PTR_ERROR;
Int32 detailError = 0;
+
ExRaiseSqlError(h, diagsArea,
- (ExeErrorCode)(8442), NULL, &intparam,
- &detailError, NULL, (char*)"ExpLOB",
- (char*)"ExpLOB",getLobErrStr(intparam));
+ (ExeErrorCode)(8434));
return ex_expr::EXPR_ERROR;
}
char tgtLobNameBuf[100];
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5d5aa1f1/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index 539520d..559ab3d 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -53,9 +53,9 @@ C1
C1 C2
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1 LOBH00000200010174411644515655873419174411644521336869718212329621953026085020"TRAFODION"."LOB130"
- 2 LOBH00000200010174411644515655873419174411644521959458518212329621959347628020"TRAFODION"."LOB130"
- 3 LOBH00000200010174411644515655873419174411644522523598418212329621965032495020"TRAFODION"."LOB130"
+ 1 LOBH0000020001004189324641697287771841893246425245100618212329831345920804020"TRAFODION"."LOB130"
+ 2 LOBH0000020001004189324641697287771841893246425934955118212329831352829499020"TRAFODION"."LOB130"
+ 3 LOBH0000020001004189324641697287771841893246426607595418212329831359482435020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -136,12 +136,12 @@ inserted row13
>>
>>values (filetolob('./myfile.txt'));
-*** ERROR[8442] Unable to access ExpLOB interface. Call to ExpLOB returned error LOB_PTR_ERROR(532). Error detail 0.
+*** ERROR[8434] Invalid target column for LOB function. The column needs to be blob/clob type.
--- 0 row(s) selected.
>>values( stringtolob('xxxxxx'));
-*** ERROR[8442] Unable to access ExpLOB interface. Call to ExpLOB returned error LOB_PTR_ERROR(532). Error detail 0.
+*** ERROR[8434] Invalid target column for LOB function. The column needs to be blob/clob type.
--- 0 row(s) selected.
>>
@@ -405,7 +405,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 'LOBH00000200010174411644515659844819174411644560592935118212329622345767176020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH0000020001004189324641697728661841893246469679111318212329831790039318020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -421,7 +421,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 'LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -437,7 +437,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 'LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -557,7 +557,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 'LOBH00000200010174411644515661071419174411644573078226018212329622470474042020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
+>>extract lobtofile(LOB 'LOBH0000020001004189324641697881271841893246483969435618212329831933168721020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
--- SQL operation complete.
@@ -573,7 +573,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 'LOBH00000200010174411644515661134919174411644578658056718212329622526374024020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH0000020001004189324641697887901841893246489966084418212329831993222472020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -589,7 +589,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 'LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -608,7 +608,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: LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks of 1000 ...
@@ -887,7 +887,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 'LOBH00000200020174411644515663207219174411644593292373218212329622672767293020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB 'LOBH0000020002004189324641698186921841893246513487795918212329832228396943020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -896,7 +896,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 'LOBH00000200030174411644515663207219174411644593791498318212329622677670087020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
+>>extract lobtofile(LOB 'LOBH0000020003004189324641698186921841893246514064150018212329832234149116020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
--- SQL operation complete.
@@ -923,7 +923,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 'LOBH00000200030174411644515663628119174411644597843356218212329622718269346020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB 'LOBH0000020003004189324641698240701841893246519888633218212329832292490829020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1030,17 +1030,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_01744116445156660578_0001
+ LOB Data File: LOBP_00418932464169854392_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_01744116445156660578_0002
+ LOB Data File: LOBP_00418932464169854392_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_01744116445156660578_0003
+ LOB Data File: LOBP_00418932464169854392_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1050,9 +1050,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_01744116445156660578_0001 15 15
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_01744116445156660578_0002 15 15
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_01744116445156660578_0003 45 45
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_00418932464169854392_0001 15 15
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_00418932464169854392_0002 15 15
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_00418932464169854392_0003 45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1069,17 +1069,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_01744116445156660578_0001
+ LOB Data File: LOBP_00418932464169854392_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_01744116445156660578_0002
+ LOB Data File: LOBP_00418932464169854392_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_01744116445156660578_0003
+ LOB Data File: LOBP_00418932464169854392_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1089,9 +1089,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_01744116445156660578_0001 30 25
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_01744116445156660578_0002 31 26
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_01744116445156660578_0003 71 56
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_00418932464169854392_0001 30 25
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_00418932464169854392_0002 31 26
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_00418932464169854392_0003 71 56
--- 3 row(s) selected.
>>
@@ -1120,9 +1120,9 @@ TRAFODION
Tables in Schema TRAFODION.LOBSCH
=================================
-LOBDescChunks__01744116445156670910_0001
-LOBDescHandle__01744116445156670910_0001
-LOBMD__01744116445156670910
+LOBDescChunks__00418932464169867513_0001
+LOBDescHandle__00418932464169867513_0001
+LOBMD__00418932464169867513
SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
TLOB130TS2
Better error message and test addition in regressions.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/6c632551
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/6c632551
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/6c632551
Branch: refs/heads/master
Commit: 6c632551c26e9a2719efd795f475c52f4d194580
Parents: eb407a9
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Tue May 10 16:10:09 2016 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Tue May 10 16:10:09 2016 +0000
----------------------------------------------------------------------
core/sql/exp/ExpLOB.cpp | 3 +-
core/sql/regress/executor/EXPECTED130 | 77 +++++++++++++++++++-----------
core/sql/regress/executor/TEST130 | 3 +-
3 files changed, 51 insertions(+), 32 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6c632551/core/sql/exp/ExpLOB.cpp
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpLOB.cpp b/core/sql/exp/ExpLOB.cpp
index 1a51628..6b68cda 100644
--- a/core/sql/exp/ExpLOB.cpp
+++ b/core/sql/exp/ExpLOB.cpp
@@ -714,9 +714,10 @@ ex_expr::exp_return_type ExpLOBiud::insertDesc(char *op_data[],
if (lobNum() == -1)
{
Int32 intparam = LOB_PTR_ERROR;
+ Int32 detailError = 0;
ExRaiseSqlError(h, diagsArea,
(ExeErrorCode)(8442), NULL, &intparam,
- NULL, NULL, (char*)"ExpLOB",
+ &detailError, NULL, (char*)"ExpLOB",
(char*)"ExpLOB",getLobErrStr(intparam));
return ex_expr::EXPR_ERROR;
}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6c632551/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index bf7d45f..539520d 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -53,9 +53,9 @@ C1
C1 C2
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1 LOBH00000200010669695009493408479919669695009498814985418212329581527003582020"TRAFODION"."LOB130"
- 2 LOBH00000200010669695009493408479919669695009499452607918212329581533443121020"TRAFODION"."LOB130"
- 3 LOBH00000200010669695009493408479919669695009500088291418212329581539790325020"TRAFODION"."LOB130"
+ 1 LOBH00000200010174411644515655873419174411644521336869718212329621953026085020"TRAFODION"."LOB130"
+ 2 LOBH00000200010174411644515655873419174411644521959458518212329621959347628020"TRAFODION"."LOB130"
+ 3 LOBH00000200010174411644515655873419174411644522523598418212329621965032495020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -91,6 +91,16 @@ C1 (EXPR)
--- 3 row(s) selected.
>>
+>>--test values clause
+>>values((select * from t130lob1));
+
+C1
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------
+
+?
+
+--- 1 row(s) selected.
+>>
>>
>>?section dml_join
>>insert into t130lob3 values (1,stringtolob('inserted row21a'),stringtolob('inserted row21b'));
@@ -124,7 +134,16 @@ inserted row13
--- 3 row(s) selected.
>>
->>
+>>values (filetolob('./myfile.txt'));
+
+*** ERROR[8442] Unable to access ExpLOB interface. Call to ExpLOB returned error LOB_PTR_ERROR(532). Error detail 0.
+
+--- 0 row(s) selected.
+>>values( stringtolob('xxxxxx'));
+
+*** ERROR[8442] Unable to access ExpLOB interface. Call to ExpLOB returned error LOB_PTR_ERROR(532). Error detail 0.
+
+--- 0 row(s) selected.
>>
>>?section dml_update
>>
@@ -386,7 +405,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 'LOBH00000200010669695009493412345019669695009536909968118212329581908062051020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH00000200010174411644515659844819174411644560592935118212329622345767176020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -402,7 +421,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 'LOBH00000200010669695009493412404519669695009543226997218212329581971119639020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -418,7 +437,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 'LOBH00000200010669695009493412404519669695009543226997218212329581971119639020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -538,7 +557,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 'LOBH00000200010669695009493413536419669695009549202243618212329582030992428020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
+>>extract lobtofile(LOB 'LOBH00000200010174411644515661071419174411644573078226018212329622470474042020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
--- SQL operation complete.
@@ -554,7 +573,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 'LOBH00000200010669695009493413599619669695009555279429118212329582091774912020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010174411644515661134919174411644578658056718212329622526374024020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -570,7 +589,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 'LOBH00000200010669695009493412404519669695009543226997218212329581971119639020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -589,7 +608,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: LOBH00000200010669695009493412404519669695009543226997218212329581971119639020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH00000200010174411644515659901219174411644566666650118212329622406368505020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks of 1000 ...
@@ -868,7 +887,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 'LOBH00000200020669695009493415412319669695009566298720718212329582202018367020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB 'LOBH00000200020174411644515663207219174411644593292373218212329622672767293020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -877,7 +896,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 'LOBH00000200030669695009493415412319669695009566813234018212329582207185399020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
+>>extract lobtofile(LOB 'LOBH00000200030174411644515663207219174411644593791498318212329622677670087020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
--- SQL operation complete.
@@ -904,7 +923,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 'LOBH00000200030669695009493415804519669695009570711099518212329582246227037020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB 'LOBH00000200030174411644515663628119174411644597843356218212329622718269346020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1011,17 +1030,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_06696950094934183379_0001
+ LOB Data File: LOBP_01744116445156660578_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_06696950094934183379_0002
+ LOB Data File: LOBP_01744116445156660578_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_06696950094934183379_0003
+ LOB Data File: LOBP_01744116445156660578_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1031,9 +1050,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_06696950094934183379_0001 15 15
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_06696950094934183379_0002 15 15
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_06696950094934183379_0003 45 45
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_01744116445156660578_0001 15 15
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_01744116445156660578_0002 15 15
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_01744116445156660578_0003 45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1050,17 +1069,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_06696950094934183379_0001
+ LOB Data File: LOBP_01744116445156660578_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_06696950094934183379_0002
+ LOB Data File: LOBP_01744116445156660578_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_06696950094934183379_0003
+ LOB Data File: LOBP_01744116445156660578_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1070,9 +1089,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_06696950094934183379_0001 30 25
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_06696950094934183379_0002 31 26
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_06696950094934183379_0003 71 56
+TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_01744116445156660578_0001 30 25
+TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_01744116445156660578_0002 31 26
+TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_01744116445156660578_0003 71 56
--- 3 row(s) selected.
>>
@@ -1101,9 +1120,9 @@ TRAFODION
Tables in Schema TRAFODION.LOBSCH
=================================
-LOBDescChunks__06696950094934193691_0001
-LOBDescHandle__06696950094934193691_0001
-LOBMD__06696950094934193691
+LOBDescChunks__01744116445156670910_0001
+LOBDescHandle__01744116445156670910_0001
+LOBMD__01744116445156670910
SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
TLOB130TS2
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6c632551/core/sql/regress/executor/TEST130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130
index 74e0cbb..e592526 100755
--- a/core/sql/regress/executor/TEST130
+++ b/core/sql/regress/executor/TEST130
@@ -75,7 +75,7 @@ select lobtostring(c2,2) from t130lob2;
select c1,lobtostring(c2,100) from t130lob2;
--test values clause
-values((select * from tlob130lob2));
+values((select * from t130lob1));
?section dml_join
@@ -91,7 +91,6 @@ select c1, lobtostring(c2,25), lobtostring(c3,25) from t130lob3;
select lobtostring(t130lob2.c2,30) from t130lob2, t130lob3 where t130lob2.c1 = t130lob3.c1;
-values(lobtostring(t130lob2.c2));
values (filetolob('./myfile.txt'));
values( stringtolob('xxxxxx'));