More adjustments to lob regress test
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/96ac8ebd
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/96ac8ebd
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/96ac8ebd
Branch: refs/heads/master
Commit: 96ac8ebdb8b7df9f4da42352511a1c4411ada2bb
Parents: 2ba37e8
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Mon Dec 21 20:47:30 2015 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Mon Dec 21 20:47:30 2015 +0000
----------------------------------------------------------------------
core/sql/regress/executor/EXPECTED130 | 130 +++++++++++++++++--------
core/sql/regress/executor/TEST130 | 1 +
core/sql/regress/executor/TEST130_argfile | 2 +-
3 files changed, 94 insertions(+), 39 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/96ac8ebd/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index 670abdf..342c076 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -53,9 +53,10 @@ C1
C1 C2
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1 LOBH00000200010279963438587423229119541341101965990251118212316399994956986020"TRAFODION"."LOB130"
- 2 LOBH00000200010279963438587423229119541341101966300063218212316400003010310020"TRAFODION"."LOB130"
- 3 LOBH00000200010279963438587423229119541341101966584793118212316400005859531020"TRAFODION"."LOB130"
+ 1 LOBH00000200010520117997292580853919884121437179977294818212317485757218627020"TRAFODION"."LOB130"
+ 2 LOBH00000200010520117997292580853919884121437180341874318212317485760955694020"TRAFODION"."LOB130"
+ 3 LOBH00000200010520117997292580853919884121437180704085518212317485764542640020"TRAFODION"."LOB130"
+
--- 3 row(s) selected.
>>
>>
@@ -332,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 'LOBH00000200010264088298048327963619185106419612837158218212316881718299730017"TRAFODION"."LOB" ' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH00000200010520117997292583625519884121437206093184618212317486018305654020"TRAFODION"."LOB130" ' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -348,8 +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 'LOBH00000200010264088298048328007319185106419616794479618212316881757900747017"TRAFODION"."LOB"
' , 'tlob130_deep.jpg');
-
+>>extract lobtofile(LOB 'LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -365,8 +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 'LOBH00000200010264088298048328007319185106419616794479618212316881757900747017"TRAFODION"."LOB"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -485,9 +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 'LOBH00000200010264088298048328671219185106419621427223118212316881804234960017"TRAFODION"."LOB" ' , 'hdfs:///lobs/tlob130_txt2.txt');
-
+>>extract lobtofile(LOB 'LOBH00000200010520117997292584465719884121437216347907218212317486120465668020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_txt2.txt');
Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
--- SQL operation complete.
@@ -503,9 +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 'LOBH00000200010264088298048328721819185106419625378358018212316881843769708017"TRAFODION"."LOB"
' , 'hdfs:///lobs/tlob130_deep.jpg');
-
+>>extract lobtofile(LOB 'LOBH00000200010520117997292584531219884121437220235037418212317486159808683020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -521,28 +516,28 @@ 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 'LOBH00000200010264088298048328007319185106419616794479618212316881757900747017"TRAFODION"."LOB"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130"
' , '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
+************************************
+Extract from a lob column in a lob table
- Input lob table name :
- Table name : tlob130bin1
+Input lob table name :
+Table name : TRAFODION.LOB130.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"
+LOB handle for c2: LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
-LOB data length :159018
+LOB data length :230150
Extracting lob data into file in chunks of 1000 ...
Wrote 1000 bytes to file : lobc2out.jpg
Wrote 1000 bytes to file : lobc2out.jpg
@@ -703,7 +698,78 @@ 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
+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 150 bytes to file : lobc2out.jpg
>>
>>------------------------------------------------------------------------------
>>obey TEST130(lob_misc_cleanup);
@@ -747,11 +813,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;
-<<<<<<< HEAD
->>extract lobtofile(LOB 'LOBH00000200020264088298048330075619185106419633949770818212316881929446626017"TRAFODION"."LOB"
' , 'tlob130_deep2.jpg');
-=======
->>extract lobtofile(LOB 'LOBH00000200020279963438587427046219541341102002085013918212316400360882889020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
->>>>>>> origin/master
+>>extract lobtofile(LOB 'LOBH00000200020520117997292585982119884121437229332169918212317486250825302020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -760,11 +822,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;
-<<<<<<< HEAD
->>extract lobtofile(LOB 'LOBH00000200030264088298048330075619185106419634292903818212316881932962861017"TRAFODION"."LOB"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
-=======
->>extract lobtofile(LOB 'LOBH00000200030279963438587427046219541341102002340817618212316400363467910020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
->>>>>>> origin/master
+>>extract lobtofile(LOB 'LOBH00000200030520117997292585982119884121437229667368718212317486254205249020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
--- SQL operation complete.
@@ -791,11 +849,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;
-<<<<<<< HEAD
->>extract lobtofile(LOB 'LOBH00000200030264088298048330340419185106419636881198218212316881958805296017"TRAFODION"."LOB" ' , 'tlob130_anoush3.jpg',create,truncate);
-=======
->>extract lobtofile(LOB 'LOBH00000200030279963438587427288519541341102004608530918212316400386132885020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate);
->>>>>>> origin/master
+>>extract lobtofile(LOB 'LOBH00000200030520117997292586250119884121437232179272218212317486279303189020"TRAFODION"."LOB130" ' , '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/96ac8ebd/core/sql/regress/executor/TEST130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130
index 0941e78..87ca365 100755
--- a/core/sql/regress/executor/TEST130
+++ b/core/sql/regress/executor/TEST130
@@ -427,6 +427,7 @@ drop table tlob130txt2;
drop table tlob130bin2;
sh rm TMP130;
sh rm tlob130txt2;
+sh rm lobc2out.jpg;
sh rm TEST130_argfile;
drop schema trafodion.lob130 cascade;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/96ac8ebd/core/sql/regress/executor/TEST130_argfile
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST130_argfile b/core/sql/regress/executor/TEST130_argfile
index 2ea2426..4e8939f 100644
--- a/core/sql/regress/executor/TEST130_argfile
+++ b/core/sql/regress/executor/TEST130_argfile
@@ -1,3 +1,3 @@
-tlob130bin1
+TRAFODION.LOB130.tlob130bin1
c2
lobc2out.jpg