http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/729472c2/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130
b/core/sql/regress/executor/EXPECTED130
index d4f218f..9c8fb51 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -52,9 +52,9 @@ C1
C1 C2
-----------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1
LOBH0000000200010693284694666931821619693284694675520439318212350402808136646020"TRAFODION"."LOB130"
- 2
LOBH0000000200010693284694666931821619693284694676238320918212350402817603197020"TRAFODION"."LOB130"
- 3
LOBH0000000200010693284694666931821619693284694676863363518212350402823890682020"TRAFODION"."LOB130"
+ 1
LOBH0000000200010559696826186435416219559696826195743244718212351957479965039020"TRAFODION"."LOB130"
+ 2
LOBH0000000200010559696826186435416219559696826196364100518212351957487711692020"TRAFODION"."LOB130"
+ 3
LOBH0000000200010559696826186435416219559696826196975611918212351957493829420020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -477,7 +477,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
'LOBH0000000200010693284694666936172119693284694718802636218212350403243416736020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB
'LOBH0000000200010559696826186439964319559696826241512955218212351957939199849020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -493,7 +493,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
'LOBH0000000200010693284694666936277719693284694725950422618212350403314769123020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -509,7 +509,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
'LOBH0000000200010693284694666936277719693284694725950422618212350403314769123020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -536,6 +536,8 @@ Success. Targetfile :tlob130_anoush.jpg Length : 230150
>>sh regrhadoop.ksh fs -copyFromLocal lob_input_e1.txt /lobs/lob_input_e1.txt;
>>sh regrhadoop.ksh fs -copyFromLocal deep.jpg /lobs/deep.jpg;
>>sh regrhadoop.ksh fs -copyFromLocal anoush.jpg /lobs/anoush.jpg;
+>>-- the next one is a really long file name intended to test error message
8557
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_a1.txt
/lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt;
>>sh sleep(20);
>>
>>
@@ -629,7 +631,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
'LOBH0000000200010693284694666937699219693284694733387350918212350403389004357020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_txt2.txt');
+>>extract lobtofile(LOB
'LOBH0000000200010559696826186441630019559696826257581553118212351958099882804020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_txt2.txt');
Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
--- SQL operation complete.
@@ -645,7 +647,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
'LOBH0000000200010693284694666937807719693284694740112181518212350403456401952020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_deep.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200010559696826186441758719559696826264825758518212351958172401525020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_deep.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -661,7 +663,7 @@ Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length
: 159018
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' ,
>>'hdfs:\/\/\/lobs\/tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB
'LOBH0000000200010693284694666936277719693284694725950422618212350403314769123020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_anoush.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_anoush.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -680,7 +682,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:
LOBH0000000200010693284694666936277719693284694725950422618212350403314769123020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010559696826186440101919559696826248930896218212351958013356713020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks of 1000 ...
@@ -961,7 +963,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
'LOBH0000000200020693284694666939887019693284694753101879518212350403586346705020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200020559696826186444079619559696826279514148718212351958319078382020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
@@ -970,7 +972,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
'LOBH0000000200030693284694666939887019693284694753661757718212350403591996291020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_anoush2.jpg');
+>>extract lobtofile(LOB
'LOBH0000000200030559696826186444079619559696826280142532318212351958325419986020"TRAFODION"."LOB130"
' ,
'hdfs:///lobs/tlob130_anoush2.jpg');
Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
--- SQL operation complete.
@@ -997,7 +999,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
'LOBH0000000200030693284694666940355019693284694758323311318212350403638460438020"TRAFODION"."LOB130"
' ,
'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB
'LOBH0000000200030559696826186444611919559696826285313364218212351958377158869020"TRAFODION"."LOB130"
' ,
'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1098,12 +1100,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669434383_0001
+ LOB Data File: LOBP_05596968261864479209_0001
LOB EOD : 0
LOB Used Len : 0
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669434383_0002
+ LOB Data File: LOBP_05596968261864479209_0002
LOB EOD : 0
LOB Used Len : 0
ColumnName : C4
@@ -1118,8 +1120,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
/lobs
LOBP_06932846946669434383_0001
0 0
-TRAFODION
LOB130
TLOB130GT2
C3
/lobs
LOBP_06932846946669434383_0002
0 0
+TRAFODION
LOB130
TLOB130GT2
C2
/lobs
LOBP_05596968261864479209_0001
0 0
+TRAFODION
LOB130
TLOB130GT2
C3
/lobs
LOBP_05596968261864479209_0002
0 0
TRAFODION
LOB130
TLOB130GT2
C4
External HDFS Location
External HDFS File
0 0
--- 3 row(s) selected.
@@ -1140,17 +1142,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669431934_0001
+ LOB Data File: LOBP_05596968261864476749_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669431934_0002
+ LOB Data File: LOBP_05596968261864476749_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669431934_0003
+ LOB Data File: LOBP_05596968261864476749_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1160,9 +1162,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
COLUMN_NAME
LOB_LOCATION
LOB_DATA_FILE
LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------- -----------------------
-TRAFODION
LOB130
TLOB130GT
C2
/lobs
LOBP_06932846946669431934_0001
15 15
-TRAFODION
LOB130
TLOB130GT
C3
/lobs
LOBP_06932846946669431934_0002
15 15
-TRAFODION
LOB130
TLOB130GT
C4
/lobs
LOBP_06932846946669431934_0003
45 45
+TRAFODION
LOB130
TLOB130GT
C2
/lobs
LOBP_05596968261864476749_0001
15 15
+TRAFODION
LOB130
TLOB130GT
C3
/lobs
LOBP_05596968261864476749_0002
15 15
+TRAFODION
LOB130
TLOB130GT
C4
/lobs
LOBP_05596968261864476749_0003
45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1179,17 +1181,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669431934_0001
+ LOB Data File: LOBP_05596968261864476749_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669431934_0002
+ LOB Data File: LOBP_05596968261864476749_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669431934_0003
+ LOB Data File: LOBP_05596968261864476749_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1199,9 +1201,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME
SCHEMA_NAME
OBJECT_NAME
COLUMN_NAME
LOB_LOCATION
LOB_DATA_FILE
LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------- -----------------------
-TRAFODION
LOB130
TLOB130GT
C2
/lobs
LOBP_06932846946669431934_0001
30 25
-TRAFODION
LOB130
TLOB130GT
C3
/lobs
LOBP_06932846946669431934_0002
31 26
-TRAFODION
LOB130
TLOB130GT
C4
/lobs
LOBP_06932846946669431934_0003
71 56
+TRAFODION
LOB130
TLOB130GT
C2
/lobs
LOBP_05596968261864476749_0001
30 25
+TRAFODION
LOB130
TLOB130GT
C3
/lobs
LOBP_05596968261864476749_0002
31 26
+TRAFODION
LOB130
TLOB130GT
C4
/lobs
LOBP_05596968261864476749_0003
71 56
--- 3 row(s) selected.
>>
@@ -1270,6 +1272,13 @@ update tlob130ext set
c4=externaltolob('hdfs:///lobs/lob_input_a1.txt', append)
>>insert into tlob130ext values(1, stringtolob('first lob'),
>>filetolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt'));
--- 1 row(s) inserted.
+>>-- the next one should see error 8557
+>>insert into tlob130ext values(1, stringtolob('first lob'),
filetolob('hdfs:///lobs/lob_input_a1.txt'),
++>externaltolob('hdfs:///lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt'));
+
+*** ERROR[8557] The file name passed to externaltolob exceeds 256 bytes.
+
+--- 0 row(s) inserted.
>>
>>select lobtostring(c2,50),lobtostring(c3,50),lobtostring(c4,50) from
>>tlob130ext;
@@ -1356,13 +1365,13 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
ColumnName : C2
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669445784_0001
- LOB EOD : 61
+ LOB Data File: LOBP_05596968261864491728_0001
+ LOB EOD : 70
LOB Used Len : 42
ColumnName : C3
Lob Location : /lobs
- LOB Data File: LOBP_06932846946669445784_0002
- LOB EOD : 106
+ LOB Data File: LOBP_05596968261864491728_0002
+ LOB EOD : 125
LOB Used Len : 68
ColumnName : C4
Lob Location : External HDFS Location
@@ -1376,8 +1385,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
/lobs
LOBP_06932846946669445784_0001
61 42
-TRAFODION
LOB130
TLOB130EXT
C3
/lobs
LOBP_06932846946669445784_0002
106 68
+TRAFODION
LOB130
TLOB130EXT
C2
/lobs
LOBP_05596968261864491728_0001
70 42
+TRAFODION
LOB130
TLOB130EXT
C3
/lobs
LOBP_05596968261864491728_0002
125 68
TRAFODION
LOB130
TLOB130EXT
C4
External HDFS Location
External HDFS File
0 0
--- 3 row(s) selected.
@@ -1394,7 +1403,7 @@ Column Name : c4
Input a filename to extract to :
Output File Name : lobc4ext.txt
Extracting lob handle for column c4...
-LOB handle for c4:
LOBH0000000800030693284694666944578419693284694806495512618212350404120317726020"TRAFODION"."LOB130"
+LOB handle for c4:
LOBH0000000800030559696826186449172819559696826337745983818212351958901392808020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :19
Extracting lob data into file in chunks of 1000 ...
@@ -1419,7 +1428,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:
LOBH0000000200010693284694666947044019693284694824175608718212350404297138941020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1436,7 +1445,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:
LOBH0000000200010693284694666947044019693284694824175608718212350404297138941020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1453,7 +1462,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:
LOBH0000000200010693284694666947044019693284694824175608718212350404297138941020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
>>select lobtostring(c2,20) from t130lob5;
(EXPR)
@@ -1470,7 +1479,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:
LOBH0000000200010693284694666947044019693284694824175608718212350404297138941020"TRAFODION"."LOB130"
+LOB handle for c2:
LOBH0000000200010559696826186452001719559696826357840916318212351959102589093020"TRAFODION"."LOB130"
>>select lobtostring(c2,40) from t130lob5;
(EXPR)
@@ -1497,7 +1506,7 @@ zzzzzzzzzzzzzzzzzzzz
C2
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------
-LOBH0000000200010693284694666944578419693284694836695682418212350404422379045020"TRAFODION"."LOB130"
+LOBH0000000200010559696826186449172819559696826371325150818212351959237435210020"TRAFODION"."LOB130"
--- 1 row(s) selected.
>>-- following should return error since only external lobs will be allowed
@@ -1540,9 +1549,9 @@
LOBH0000000200010693284694666944578419693284694836695682418212350404422379045020
Tables in Schema TRAFODION.LOBSCH
=================================
-LOBDescChunks__06932846946669487886_0001
-LOBDescHandle__06932846946669487886_0001
-LOBMD__06932846946669487886
+LOBDescChunks__05596968261864538503_0001
+LOBDescHandle__05596968261864538503_0001
+LOBMD__05596968261864538503
SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
