http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/db3ebf5d/core/sql/regress/executor/EXPECTED130 ---------------------------------------------------------------------- diff --cc core/sql/regress/executor/EXPECTED130 index a119aed,559ab3d..875a0ed --- a/core/sql/regress/executor/EXPECTED130 +++ b/core/sql/regress/executor/EXPECTED130 @@@ -53,9 -53,9 +53,9 @@@ C C1 C2 ----------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------- - 1 LOBH0000000200010321792085830706042419321792085835428245518212331057036978909020"TRAFODION"."LOB130" - 2 LOBH0000000200010321792085830706042419321792085835962263118212331057042314939020"TRAFODION"."LOB130" - 3 LOBH0000000200010321792085830706042419321792085836459216918212331057047401716020"TRAFODION"."LOB130" - 1 LOBH0000020001004189324641697287771841893246425245100618212329831345920804020"TRAFODION"."LOB130" - 2 LOBH0000020001004189324641697287771841893246425934955118212329831352829499020"TRAFODION"."LOB130" - 3 LOBH0000020001004189324641697287771841893246426607595418212329831359482435020"TRAFODION"."LOB130" ++ 1 LOBH0000000200010746875598668540800519746875598684417084318212331087242380839020"TRAFODION"."LOB130" ++ 2 LOBH0000000200010746875598668540800519746875598684948391418212331087247955643020"TRAFODION"."LOB130" ++ 3 LOBH0000000200010746875598668540800519746875598685466216418212331087253035053020"TRAFODION"."LOB130" --- 3 row(s) selected. >> @@@ -387,7 -405,7 +406,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 'LOBH0000000200010321792085830709525319321792085869850100918212331057381219508020"TRAFODION"."LOB130" ' , 'tlob130_txt1.txt'); ->>extract lobtofile(LOB 'LOBH0000020001004189324641697728661841893246469679111318212329831790039318020"TRAFODION"."LOB130" ' , 'tlob130_txt1.txt'); ++>>extract lobtofile(LOB 'LOBH0000000200010746875598668544422419746875598720570878318212331087604055034020"TRAFODION"."LOB130" ' , 'tlob130_txt1.txt'); Success. Targetfile :tlob130_txt1.txt Length : 19 --- SQL operation complete. @@@ -403,7 -421,7 +422,7 @@@ >>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 'LOBH0000000200010321792085830709573619321792085875915579518212331057441900379020"TRAFODION"."LOB130" ' , 'tlob130_deep.jpg'); ->>extract lobtofile(LOB 'LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130" ' , 'tlob130_deep.jpg'); ++>>extract lobtofile(LOB 'LOBH0000000200010746875598668544474319746875598726644194618212331087664810761020"TRAFODION"."LOB130" ' , 'tlob130_deep.jpg'); Success. Targetfile :tlob130_deep.jpg Length : 159018 --- SQL operation complete. @@@ -419,7 -437,7 +438,7 @@@ >>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 'LOBH0000000200010321792085830709573619321792085875915579518212331057441900379020"TRAFODION"."LOB130" ' , 'tlob130_anoush.jpg'); ->>extract lobtofile(LOB 'LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130" ' , 'tlob130_anoush.jpg'); ++>>extract lobtofile(LOB 'LOBH0000000200010746875598668544474319746875598726644194618212331087664810761020"TRAFODION"."LOB130" ' , 'tlob130_anoush.jpg'); Success. Targetfile :tlob130_anoush.jpg Length : 230150 --- SQL operation complete. @@@ -539,7 -557,7 +558,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 'LOBH0000000200010321792085830710639319321792085881807198418212331057500820343020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_txt2.txt'); ->>extract lobtofile(LOB 'LOBH0000020001004189324641697881271841893246483969435618212329831933168721020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_txt2.txt'); ++>>extract lobtofile(LOB 'LOBH0000000200010746875598668545597419746875598733072936218212331087729020128020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_txt2.txt'); Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19 --- SQL operation complete. @@@ -555,7 -573,7 +574,7 @@@ >>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 'LOBH0000000200010321792085830710684919321792085887364039618212331057556357004020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_deep.jpg'); ->>extract lobtofile(LOB 'LOBH0000020001004189324641697887901841893246489966084418212329831993222472020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_deep.jpg'); ++>>extract lobtofile(LOB 'LOBH0000000200010746875598668545646319746875598738857201018212331087786975259020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_deep.jpg'); Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018 --- SQL operation complete. @@@ -571,7 -589,7 +590,7 @@@ >>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 'LOBH0000000200010321792085830709573619321792085875915579518212331057441900379020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush.jpg'); ->>extract lobtofile(LOB 'LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush.jpg'); ++>>extract lobtofile(LOB 'LOBH0000000200010746875598668544474319746875598726644194618212331087664810761020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush.jpg'); Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150 --- SQL operation complete. @@@ -590,7 -608,7 +609,7 @@@ Column Name : c Input a filename to extract to : Output File Name : lobc2out.jpg Extracting lob handle for column c2... - LOB handle for c2: LOBH0000000200010321792085830709573619321792085875915579518212331057441900379020"TRAFODION"."LOB130" -LOB handle for c2: LOBH0000020001004189324641697740091841893246476763912418212329831861079469020"TRAFODION"."LOB130" ++LOB handle for c2: LOBH0000000200010746875598668544474319746875598726644194618212331087664810761020"TRAFODION"."LOB130" Extracting LOB data length for the above handle... LOB data length :230150 Extracting lob data into file in chunks of 1000 ... @@@ -869,7 -887,7 +888,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 'LOBH0000000200020321792085830712377119321792085897256767518212331057655277665020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); ->>extract lobtofile(LOB 'LOBH0000020002004189324641698186921841893246513487795918212329832228396943020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); ++>>extract lobtofile(LOB 'LOBH0000000200020746875598668547415919746875598749193873618212331087890421128020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); Success. Targetfile :tlob130_deep2.jpg Length : 159018 --- SQL operation complete. @@@ -878,7 -896,7 +897,7 @@@ >>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 'LOBH0000000200030321792085830712377119321792085897715067718212331057660007758020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush2.jpg'); ->>extract lobtofile(LOB 'LOBH0000020003004189324641698186921841893246514064150018212329832234149116020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush2.jpg'); ++>>extract lobtofile(LOB 'LOBH0000000200030746875598668547415919746875598749664258118212331087895181496020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush2.jpg'); Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150 --- SQL operation complete. @@@ -905,7 -923,7 +924,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 'LOBH0000000200030321792085830712722219321792085901159787918212331057694392521020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); ->>extract lobtofile(LOB 'LOBH0000020003004189324641698240701841893246519888633218212329832292490829020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); ++>>extract lobtofile(LOB 'LOBH0000000200030746875598668547765619746875598753213260618212331087930470523020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); Success. Targetfile :tlob130_anoush3.jpg Length : 230150 --- SQL operation complete. @@@ -995,42 -1013,6 +1014,42 @@@ C1 (EXPR) (EXPR >>create table tlob130gt (c1 int not null, c2 blob, c3 clob, c4 blob, primary key (c1)); --- SQL operation complete. +>>create table tlob130gt2 (c1 int not null, c2 blob, c3 clob, c4 blob storage 'external', primary key (c1)); + +--- SQL operation complete. +>>get lob stats for table tlob130gt2; + + +Lob Information for table: "TRAFODION".LOB130.TLOB130GT2 +========================= + + ColumnName : C2 + Lob Location : /lobs - LOB Data File: LOBP_03217920858307150891_0001 ++ LOB Data File: LOBP_07468755986685501835_0001 + LOB EOD : 0 + LOB Used Len : 0 + ColumnName : C3 + Lob Location : /lobs - LOB Data File: LOBP_03217920858307150891_0002 ++ LOB Data File: LOBP_07468755986685501835_0002 + LOB EOD : 0 + LOB Used Len : 0 + ColumnName : C4 + Lob Location : External HDFS Location + LOB Data File: External HDFS File + LOB EOD : 0 + LOB Used Len : 0 + +--- SQL operation complete. +>>select * from table(lob stats(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_03217920858307150891_0001 0 0 - TRAFODION LOB130 TLOB130GT2 C3 /lobs LOBP_03217920858307150891_0002 0 0 ++TRAFODION LOB130 TLOB130GT2 C2 /lobs LOBP_07468755986685501835_0001 0 0 ++TRAFODION LOB130 TLOB130GT2 C3 /lobs LOBP_07468755986685501835_0002 0 0 +TRAFODION LOB130 TLOB130GT2 C4 External HDFS Location External HDFS File 0 0 + +--- 3 row(s) selected. >>insert into tlob130gt values (1, stringtolob('xxxx'), stringtolob('yyyy'), stringtolob('zzzzzzzzzzzzzz')); --- 1 row(s) inserted. @@@ -1048,17 -1030,17 +1067,17 @@@ Lob Information for table: "TRAFODION". ColumnName : C2 Lob Location : /lobs - LOB Data File: LOBP_03217920858307149714_0001 - LOB Data File: LOBP_00418932464169854392_0001 ++ LOB Data File: LOBP_07468755986685500628_0001 LOB EOD : 15 LOB Used Len : 15 ColumnName : C3 Lob Location : /lobs - LOB Data File: LOBP_03217920858307149714_0002 - LOB Data File: LOBP_00418932464169854392_0002 ++ LOB Data File: LOBP_07468755986685500628_0002 LOB EOD : 15 LOB Used Len : 15 ColumnName : C4 Lob Location : /lobs - LOB Data File: LOBP_03217920858307149714_0003 - LOB Data File: LOBP_00418932464169854392_0003 ++ LOB Data File: LOBP_07468755986685500628_0003 LOB EOD : 45 LOB Used Len : 45 @@@ -1068,9 -1050,9 +1087,9 @@@ 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_03217920858307149714_0001 15 15 - TRAFODION LOB130 TLOB130GT C3 /lobs LOBP_03217920858307149714_0002 15 15 - TRAFODION LOB130 TLOB130GT C4 /lobs LOBP_03217920858307149714_0003 45 45 -TRAFODION LOB130 TLOB130GT C2 /lobs LOBP_00418932464169854392_0001 15 15 -TRAFODION LOB130 TLOB130GT C3 /lobs LOBP_00418932464169854392_0002 15 15 -TRAFODION LOB130 TLOB130GT C4 /lobs LOBP_00418932464169854392_0003 45 45 ++TRAFODION LOB130 TLOB130GT C2 /lobs LOBP_07468755986685500628_0001 15 15 ++TRAFODION LOB130 TLOB130GT C3 /lobs LOBP_07468755986685500628_0002 15 15 ++TRAFODION LOB130 TLOB130GT C4 /lobs LOBP_07468755986685500628_0003 45 45 --- 3 row(s) selected. >>delete from tlob130gt where c1=2; @@@ -1087,17 -1069,17 +1106,17 @@@ Lob Information for table: "TRAFODION". ColumnName : C2 Lob Location : /lobs - LOB Data File: LOBP_03217920858307149714_0001 - LOB Data File: LOBP_00418932464169854392_0001 ++ LOB Data File: LOBP_07468755986685500628_0001 LOB EOD : 30 LOB Used Len : 25 ColumnName : C3 Lob Location : /lobs - LOB Data File: LOBP_03217920858307149714_0002 - LOB Data File: LOBP_00418932464169854392_0002 ++ LOB Data File: LOBP_07468755986685500628_0002 LOB EOD : 31 LOB Used Len : 26 ColumnName : C4 Lob Location : /lobs - LOB Data File: LOBP_03217920858307149714_0003 - LOB Data File: LOBP_00418932464169854392_0003 ++ LOB Data File: LOBP_07468755986685500628_0003 LOB EOD : 71 LOB Used Len : 56 @@@ -1107,209 -1089,11 +1126,209 @@@ 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_03217920858307149714_0001 30 25 - TRAFODION LOB130 TLOB130GT C3 /lobs LOBP_03217920858307149714_0002 31 26 - TRAFODION LOB130 TLOB130GT C4 /lobs LOBP_03217920858307149714_0003 71 56 -TRAFODION LOB130 TLOB130GT C2 /lobs LOBP_00418932464169854392_0001 30 25 -TRAFODION LOB130 TLOB130GT C3 /lobs LOBP_00418932464169854392_0002 31 26 -TRAFODION LOB130 TLOB130GT C4 /lobs LOBP_00418932464169854392_0003 71 56 ++TRAFODION LOB130 TLOB130GT C2 /lobs
<TRUNCATED> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/db3ebf5d/core/sql/regress/executor/TEST130 ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/db3ebf5d/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp ----------------------------------------------------------------------
