You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sa...@apache.org on 2016/01/08 20:11:30 UTC

[05/13] incubator-trafodion git commit: Regression test for testing the programmatic interface for extracting lob data into buffer like a cursor.

Regression test for testing the programmatic interface for extracting lob data  into buffer like a cursor.


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e4f391f3
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e4f391f3
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e4f391f3

Branch: refs/heads/master
Commit: e4f391f3dff713cf5b24c1e3860cfdc220a3a557
Parents: 781682a
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Thu Dec 17 05:29:49 2015 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Thu Dec 17 05:29:49 2015 +0000

----------------------------------------------------------------------
 core/sql/bin/clitest.cpp                  |  10 +-
 core/sql/regress/executor/EXPECTED130     | 204 +++++++++++++++++++++++--
 core/sql/regress/executor/TEST130         |   8 +-
 core/sql/regress/executor/TEST130_argfile |   3 +
 4 files changed, 202 insertions(+), 23 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e4f391f3/core/sql/bin/clitest.cpp
----------------------------------------------------------------------
diff --git a/core/sql/bin/clitest.cpp b/core/sql/bin/clitest.cpp
index 37baf68..261cdf6 100644
--- a/core/sql/bin/clitest.cpp
+++ b/core/sql/bin/clitest.cpp
@@ -155,13 +155,13 @@ int main(int argc, const char * argv[])
     
      case 2:
       {
-	cout <<"***********"  <<endl;
+	cout <<"*************************************"  <<endl;
 	cout << "Blob test extract to file in chunks " << endl;
-	cout <<"***********"  <<endl;
-	cout << " Extract from a lob column in a lob table" << endl << endl;
-	cout << " Input lob table name :" << endl;
+	cout <<"************************************"  <<endl;
+	cout << "Extract from a lob column in a lob table" << endl << endl;
+	cout << "Input lob table name :" << endl;
 	cin.getline(tablename,40);
-	cout << " Table name : " << tablename << endl;
+	cout << "Table name : " << tablename << endl;
 	cout << "Input lob column name to extract from :" << endl;
 	cin.getline(columnname,40); 
 	cout << "Column Name : " << columnname << endl;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e4f391f3/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index cea117a..57bdc5f 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -53,9 +53,9 @@ C1
 C1           C2
 -----------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ----------------------------------------
 
-          1  LOBH00000200010882713693210510862219414564511952143513218212313794957530571017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                         
-          2  LOBH00000200010882713693210510862219414564511952725470718212313794971638403017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                         
-          3  LOBH00000200010882713693210510862219414564511953242068818212313794976885710017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                         
+          1  LOBH00000200010264088298048325324919185106419587973186518212316881469423000017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                         
+          2  LOBH00000200010264088298048325324919185106419588373441918212316881473635505017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                         
+          3  LOBH00000200010264088298048325324919185106419588752137918212316881477480775017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                         
 
 --- 3 row(s) selected.
 >>
@@ -237,7 +237,7 @@ C1           (EXPR)                          (EXPR)
 >>sh cp $scriptsdir/executor/deep.jpg $rundir/executor/;
 >>sh cp $scriptsdir/executor/anoush.jpg $rundir/executor/;
 >>sh cp $scriptsdir/executor/lob_input_* $rundir/executor/;
->>
+>>sh cp $scriptsdir/executor/TEST130_argfile $rundir/executor/;
 >>-- inserts
 >>-- first line
 >>insert into tlob130txt1 values (1, filetolob('lob_input_a1.txt'));
@@ -333,7 +333,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 'LOBH00000200010882713693210514378719414564511984818875018212313795291895359017"TRAFODION"."LOB"     ' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH00000200010264088298048327963619185106419612837158218212316881718299730017"TRAFODION"."LOB"     ' , 'tlob130_txt1.txt');
 Success. Targetfile :tlob130_txt1.txt  Length : 19
 
 --- SQL operation complete.
@@ -349,7 +349,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 'LOBH00000200010882713693210514444119414564511990648251418212313795350940159017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010264088298048328007319185106419616794479618212316881757900747017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'tlob130_deep.jpg');
 Success. Targetfile :tlob130_deep.jpg  Length : 159018
 
 --- SQL operation complete.
@@ -365,7 +365,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 'LOBH00000200010882713693210514444119414564511990648251418212313795350940159017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010264088298048328007319185106419616794479618212316881757900747017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'tlob130_anoush.jpg');
 Success. Targetfile :tlob130_anoush.jpg  Length : 230150
 
 --- SQL operation complete.
@@ -484,7 +484,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 'LOBH00000200010882713693210515418219414564511997894836018212313795423154729017"TRAFODION"."LOB"     ' , 'hdfs:///lobs/tlob130_txt2.txt');
+>>extract lobtofile(LOB 'LOBH00000200010264088298048328671219185106419621427223118212316881804234960017"TRAFODION"."LOB"     ' , 'hdfs:///lobs/tlob130_txt2.txt');
 Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt  Length : 19
 
 --- SQL operation complete.
@@ -500,7 +500,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 'LOBH00000200010882713693210515488319414564512003657955318212313795480776063017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'hdfs:///lobs/tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010264088298048328721819185106419625378358018212316881843769708017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'hdfs:///lobs/tlob130_deep.jpg');
 Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg  Length : 159018
 
 --- SQL operation complete.
@@ -516,13 +516,189 @@ 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 'LOBH00000200010882713693210514444119414564511990648251418212313795350940159017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010264088298048328007319185106419616794479618212316881757900747017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'hdfs:///lobs/tlob130_anoush.jpg');
 Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg  Length : 230150
 
 --- SQL operation complete.
 >>
 >>
->>
+>>sh clitestdriver 2 < TEST130_argfile 2>&1 | tee -a LOG130;
+***********
+Blob test extract to file in chunks 
+***********
+ Extract from a lob column in a lob table
+
+ Input lob table name :
+ Table name : tlob130bin1
+Input lob column name to extract from :
+Column Name : c2
+Input a filename to extract to : 
+Output File Name : lobc2out.jpg
+Extracting  lob handle for column c2...
+LOB handle for c2: LOBH00000200010476207798336764109119336145849975710857618212316460311278020021"TRAFODION"."SEABASE"
+Extracting LOB data length for the above handle...
+LOB data length :159018
+Extracting lob data into file in chunks of 1000 ...
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 1000 bytes to file : lobc2out.jpg
+Wrote 18 bytes to file : lobc2out.jpg
 >>
 >>------------------------------------------------------------------------------
 >>obey TEST130(lob_misc_cleanup);
@@ -566,7 +742,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 'LOBH00000200020882713693210517156319414564512012287022618212313795567334522017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB 'LOBH00000200020264088298048330075619185106419633949770818212316881929446626017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'tlob130_deep2.jpg');
 Success. Targetfile :tlob130_deep2.jpg  Length : 159018
 
 --- SQL operation complete.
@@ -575,7 +751,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 'LOBH00000200030882713693210517156319414564512012826755818212313795572444089017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'hdfs:///lobs/tlob130_anoush2.jpg');
+>>extract lobtofile(LOB 'LOBH00000200030264088298048330075619185106419634292903818212316881932962861017"TRAFODION"."LOB"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                     ' , 'hdfs:///lobs/tlob130_anoush2.jpg');
 Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg  Length : 230150
 
 --- SQL operation complete.
@@ -602,7 +778,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 'LOBH00000200030882713693210517507719414564512016516238718212313795609661744017"TRAFODION"."LOB"     ' , 'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB 'LOBH00000200030264088298048330340419185106419636881198218212316881958805296017"TRAFODION"."LOB"     ' , 'tlob130_anoush3.jpg',create,truncate);
 Success. Targetfile :tlob130_anoush3.jpg  Length : 230150
 
 --- SQL operation complete.

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e4f391f3/core/sql/regress/executor/TEST130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130
index 6bf031e..2c5a0a4 100755
--- a/core/sql/regress/executor/TEST130
+++ b/core/sql/regress/executor/TEST130
@@ -160,7 +160,7 @@ create table tlob130bin1 (c1 int not null, c2 blob, primary key (c1));
 sh cp $scriptsdir/executor/deep.jpg $rundir/executor/;
 sh cp $scriptsdir/executor/anoush.jpg $rundir/executor/;
 sh cp $scriptsdir/executor/lob_input_* $rundir/executor/;
-
+sh cp $scriptsdir/executor/TEST130_argfile $rundir/executor/;
 -- inserts
 -- first line
 insert into tlob130txt1 values (1, filetolob('lob_input_a1.txt'));
@@ -339,7 +339,7 @@ sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdf
 obey t130_extract_command;
 
 
-
+sh clitestdriver 2 < TEST130_argfile 2>&1 | tee -a LOG130;
 
 ------------------------------------------------------------------------------
 obey TEST130(lob_misc_cleanup);
@@ -426,8 +426,8 @@ drop table tlob130txt2;
 drop table tlob130bin2; 
 sh rm TMP130;
 sh rm tlob130txt2;
-
-drop schema trafodion.lob;
+sh rm TEST130_argfile;
+drop schema trafodion.lob cascade;
 
 exit;
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e4f391f3/core/sql/regress/executor/TEST130_argfile
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST130_argfile b/core/sql/regress/executor/TEST130_argfile
new file mode 100644
index 0000000..2ea2426
--- /dev/null
+++ b/core/sql/regress/executor/TEST130_argfile
@@ -0,0 +1,3 @@
+tlob130bin1
+c2
+lobc2out.jpg