trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sand...@apache.org
Subject [07/13] incubator-trafodion git commit: More adjustments to lob regress test
Date Fri, 08 Jan 2016 19:11:32 GMT
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 <sandhya@apache.org>
Authored: Mon Dec 21 20:47:30 2015 +0000
Committer: Sandhya Sundaresan <sandhya@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


Mime
View raw message