http://git-wip-us.apache.org/repos/asf/trafodion/blob/f1864484/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130
b/core/sql/regress/executor/EXPECTED130
index 87a1d05..6b52203 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -63,9 +63,9 @@ C1
C1 C2
-----------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1
LOBH000000020001004521773054977751551845217730572979065218212360625565346135020"TRAFODION"."LOB130"
- 2
LOBH000000020001004521773054977751551845217730575426024718212360625592037380020"TRAFODION"."LOB130"
- 3
LOBH000000020001004521773054977751551845217730577394592318212360625613791173020"TRAFODION"."LOB130"
+ 1
LOBH0000000200010789269709250085236319789269709263410318218212370878104855192020"TRAFODION"."LOB130"
+ 2
LOBH0000000200010789269709250085236319789269709264004324418212370878112140465020"TRAFODION"."LOB130"
+ 3
LOBH0000000200010789269709250085236319789269709264603729518212370878118079347020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -654,7 +654,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
'LOBH000000020001004521773054979487561845217730741742859818212360627257261284020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB
'LOBH0000000200010789269709250093030419789269709339542449418212370878867608341020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -670,7 +670,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
'LOBH000000020001004521773054979514421845217730753331456518212360627372759041020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200010789269709250093195519789269709346199639118212370878934176767020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -686,7 +686,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
'LOBH000000020001004521773054979514421845217730753331456518212360627372759041020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200010789269709250093195519789269709346199639118212370878934176767020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -847,7 +847,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:
LOBH000000020001004521773054979514421845217730753331456518212360627372759041020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010789269709250093195519789269709346199639118212370878934176767020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks ...
@@ -921,7 +921,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
'LOBH000000020002004521773054980105951845217730796607893818212360627806139125020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200020789269709250096808819789269709373537864718212370879207561632020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -953,7 +953,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
'LOBH000000020003004521773054980180651845217730805462671518212360627894957464020"TRAFODION"."LOB130"
' ,
'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB
'LOBH0000000200030789269709250097259519789269709378642018118212370879258524867020"TRAFODION"."LOB130"
' ,
'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1054,12 +1054,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
ColumnName : C2
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498076106_0001
+ LOB Data File: LOBP_07892697092501002172_0001
LOB EOD : 0
LOB Used Len : 0
ColumnName : C3
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498076106_0002
+ LOB Data File: LOBP_07892697092501002172_0002
LOB EOD : 0
LOB Used Len : 0
ColumnName : C4
@@ -1074,8 +1074,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
COLUMN_NAME
LOB_LOCATION
LOB_DATA_FILE
LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------- -----------------------
-TRAFODION
LOB130
TLOB130GT2
C2
/user/trafodion/lobs
LOBP_00452177305498076106_0001
0 0
-TRAFODION
LOB130
TLOB130GT2
C3
/user/trafodion/lobs
LOBP_00452177305498076106_0002
0 0
+TRAFODION
LOB130
TLOB130GT2
C2
/user/trafodion/lobs
LOBP_07892697092501002172_0001
0 0
+TRAFODION
LOB130
TLOB130GT2
C3
/user/trafodion/lobs
LOBP_07892697092501002172_0002
0 0
TRAFODION
LOB130
TLOB130GT2
C4
External HDFS Location
External HDFS File
0 0
--- 3 row(s) selected.
@@ -1096,17 +1096,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498070471_0001
+ LOB Data File: LOBP_07892697092500999026_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498070471_0002
+ LOB Data File: LOBP_07892697092500999026_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498070471_0003
+ LOB Data File: LOBP_07892697092500999026_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1116,9 +1116,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
/user/trafodion/lobs
LOBP_00452177305498070471_0001
15 15
-TRAFODION
LOB130
TLOB130GT
C3
/user/trafodion/lobs
LOBP_00452177305498070471_0002
15 15
-TRAFODION
LOB130
TLOB130GT
C4
/user/trafodion/lobs
LOBP_00452177305498070471_0003
45 45
+TRAFODION
LOB130
TLOB130GT
C2
/user/trafodion/lobs
LOBP_07892697092500999026_0001
15 15
+TRAFODION
LOB130
TLOB130GT
C3
/user/trafodion/lobs
LOBP_07892697092500999026_0002
15 15
+TRAFODION
LOB130
TLOB130GT
C4
/user/trafodion/lobs
LOBP_07892697092500999026_0003
45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1135,17 +1135,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498070471_0001
+ LOB Data File: LOBP_07892697092500999026_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498070471_0002
+ LOB Data File: LOBP_07892697092500999026_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498070471_0003
+ LOB Data File: LOBP_07892697092500999026_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1155,9 +1155,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
/user/trafodion/lobs
LOBP_00452177305498070471_0001
30 25
-TRAFODION
LOB130
TLOB130GT
C3
/user/trafodion/lobs
LOBP_00452177305498070471_0002
31 26
-TRAFODION
LOB130
TLOB130GT
C4
/user/trafodion/lobs
LOBP_00452177305498070471_0003
71 56
+TRAFODION
LOB130
TLOB130GT
C2
/user/trafodion/lobs
LOBP_07892697092500999026_0001
30 25
+TRAFODION
LOB130
TLOB130GT
C3
/user/trafodion/lobs
LOBP_07892697092500999026_0002
31 26
+TRAFODION
LOB130
TLOB130GT
C4
/user/trafodion/lobs
LOBP_07892697092500999026_0003
71 56
--- 3 row(s) selected.
>>
@@ -1328,12 +1328,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
ColumnName : C2
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498099204_0001
+ LOB Data File: LOBP_07892697092501013739_0001
LOB EOD : 70
LOB Used Len : 42
ColumnName : C3
Lob Location : /user/trafodion/lobs
- LOB Data File: LOBP_00452177305498099204_0002
+ LOB Data File: LOBP_07892697092501013739_0002
LOB EOD : 125
LOB Used Len : 68
ColumnName : C4
@@ -1348,8 +1348,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
COLUMN_NAME
LOB_LOCATION
LOB_DATA_FILE
LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------- -----------------------
-TRAFODION
LOB130
TLOB130EXT
C2
/user/trafodion/lobs
LOBP_00452177305498099204_0001
70 42
-TRAFODION
LOB130
TLOB130EXT
C3
/user/trafodion/lobs
LOBP_00452177305498099204_0002
125 68
+TRAFODION
LOB130
TLOB130EXT
C2
/user/trafodion/lobs
LOBP_07892697092501013739_0001
70 42
+TRAFODION
LOB130
TLOB130EXT
C3
/user/trafodion/lobs
LOBP_07892697092501013739_0002
125 68
TRAFODION
LOB130
TLOB130EXT
C4
External HDFS Location
External HDFS File
0 0
--- 3 row(s) selected.
@@ -1366,9 +1366,9 @@ Column Name : c4
Input a filename to extract to :
Output File Name : lobc4ext.txt
Extracting lob handle for column c4...
-LOB handle for c4:
LOBH000000080003004521773054980992041845217730910800048818212360628948202356020"TRAFODION"."LOB130"
+LOB handle for c4:
LOBH0000000800030789269709250101373919789269709433659319618212370879808793595020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
-LOB data length :44
+LOB data length :19
Extracting lob data into file in chunks ...
Wrote 19 bytes to file : lobc4ext.txt
>>sh cat lobc4ext.txt |tee -a LOG130;
@@ -1432,7 +1432,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2:
LOBH000000020001004521773054981739381845217730958615332018212360629426346494020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010789269709250106581019789269709470354926518212370880175708319020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1449,7 +1449,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2:
LOBH000000020001004521773054981739381845217730958615332018212360629426346494020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010789269709250106581019789269709470354926518212370880175708319020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1466,7 +1466,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2:
LOBH000000020001004521773054981739381845217730958615332018212360629426346494020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010789269709250106581019789269709470354926518212370880175708319020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1483,7 +1483,7 @@ Table name : TRAFODION.LOB130.t130lob5
Input lob column name to get handle from :
Column Name : c2
Extracting lob handle for column c2...
-LOB handle for c2:
LOBH000000020001004521773054981739381845217730958615332018212360629426346494020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010789269709250106581019789269709470354926518212370880175708319020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1510,7 +1510,7 @@ zzzzzzzzzzzzzzzzzzzz
C2
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------
-LOBH000000020001004521773054980992041845217730978467538918212360629625048479020"TRAFODION"."LOB130"
+LOBH0000000200010789269709250101373919789269709484761570418212370880319729808020"TRAFODION"."LOB130"
--- 1 row(s) selected.
>>-- following should return error since only external lobs will be allowed
@@ -1553,9 +1553,9 @@
LOBH000000020001004521773054980992041845217730978467538918212360629625048479020"
Tables in Schema TRAFODION.LOBSCH
=================================
-LOBDescChunks__00452177305498204482_0001
-LOBDescHandle__00452177305498204482_0001
-LOBMD__00452177305498204482
+LOBDescChunks__07892697092501086222_0001
+LOBDescHandle__07892697092501086222_0001
+LOBMD__07892697092501086222
SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
