http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/executor/EXPECTED130 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130 index 506dda2..6aeb277 100644 --- a/core/sql/regress/executor/EXPECTED130 +++ b/core/sql/regress/executor/EXPECTED130 @@ -63,10 +63,12 @@ C1 C1 C2 ----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- + 1 LOBH0000000200010189730973312766405019189730973325743020118212400522666936189020"TRAFODION"."LOB130" 2 LOBH0000000200010189730973312766405019189730973325822915418212400522668231546020"TRAFODION"."LOB130" 3 LOBH0000000200010189730973312766405019189730973325854670118212400522668551834020"TRAFODION"."LOB130" + --- 3 row(s) selected. >> >> @@ -668,7 +670,9 @@ 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 >>'LOBH0000000200010189730973312770821219189730973368818826218212400523097801680020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'tlob130_txt1.txt'); + Success. Targetfile :tlob130_txt1.txt Length : 19 --- SQL operation complete. @@ -684,7 +688,9 @@ 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 >>'LOBH0000000200010189730973312770991919189730973372704796118212400523136699585020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'tlob130_deep.jpg'); + Success. Targetfile :tlob130_deep.jpg Length : 159018 --- SQL operation complete. @@ -700,7 +706,9 @@ 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 >>'LOBH0000000200010189730973312770991919189730973372704796118212400523136699585020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'tlob130_anoush.jpg'); + Success. Targetfile :tlob130_anoush.jpg Length : 230150 --- SQL operation complete. @@ -821,7 +829,9 @@ And the dish ran away with the fork ! >> >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'hdfs:\/\/\/user\/trafodion\/lobs\/tlob130_txt2.txt');/g" >> >>t130_extract_command; >>obey t130_extract_command; + >>extract lobtofile(LOB >>'LOBH0000000200010189730973312772090419189730973379454400718212400523204167938020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'hdfs:///user/trafodion/lobs/tlob130_txt2.txt'); + Success. Targetfile :hdfs:///user/trafodion/lobs/tlob130_txt2.txt Length : 19 --- SQL operation complete. @@ -837,7 +847,9 @@ Success. Targetfile :hdfs:///user/trafodion/lobs/tlob130_txt2.txt Length : 19 >>sh rm t130_extract_command; >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'hdfs:\/\/\/user\/trafodion\/lobs\/tlob130_deep.jpg');/g" >> >>t130_extract_command; >>obey t130_extract_command; + >>extract lobtofile(LOB >>'LOBH0000000200010189730973312772260419189730973382656270118212400523236180902020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'hdfs:///user/trafodion/lobs/tlob130_deep.jpg'); + Success. Targetfile :hdfs:///user/trafodion/lobs/tlob130_deep.jpg Length : 159018 --- SQL operation complete. @@ -853,7 +865,9 @@ Success. Targetfile :hdfs:///user/trafodion/lobs/tlob130_deep.jpg Length : 1590 >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'hdfs:\/\/\/user\/trafodion\/lobs\/tlob130_anoush.jpg');/g" >> >>t130_extract_command; >> >>obey t130_extract_command; + >>extract lobtofile(LOB >>'LOBH0000000200010189730973312770991919189730973372704796118212400523136699585020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'hdfs:///user/trafodion/lobs/tlob130_anoush.jpg'); + Success. Targetfile :hdfs:///user/trafodion/lobs/tlob130_anoush.jpg Length : 230150 --- SQL operation complete. @@ -872,7 +886,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: LOBH0000000200010492540128525797109219492540128672143163118212384276675380782020"TRAFODION"."LOB130" +LOB handle for c2: LOBH000000020001001786226097943372181817862261042772793218212399607632028402020"TRAFODION"."LOB130" Extracting LOB data length for the above handle... LOB data length :230150 Extracting lob data into file in chunks ... @@ -946,7 +960,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 'LOBH0000000200020492540128525802271019492540128707944124018212384277034197183020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); +>>extract lobtofile(LOB 'LOBH000000020002001786226097943695171817862261069432940218212399607898537297020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); Success. Targetfile :tlob130_deep2.jpg Length : 159018 --- SQL operation complete. @@ -955,7 +969,9 @@ 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:\/\/\/user\/trafodion\/lobs\/tlob130_anoush2.jpg');/g" >> >>t130_extract_command; >>obey t130_extract_command; + >>extract lobtofile(LOB >>'LOBH0000000200030189730973312773623919189730973392250459518212400523332159942020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> ' , 'hdfs:///user/trafodion/lobs/tlob130_anoush2.jpg'); + Success. Targetfile :hdfs:///user/trafodion/lobs/tlob130_anoush2.jpg Length : 230150 --- SQL operation complete. @@ -982,7 +998,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 'LOBH0000000200030492540128525802824819492540128714305550118212384277098509118020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); +>>extract lobtofile(LOB 'LOBH000000020003001786226097943740601817862261074243267718212399607946607514020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); Success. Targetfile :tlob130_anoush3.jpg Length : 230150 --- SQL operation complete. @@ -1083,12 +1099,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2 ColumnName : C2 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258067632_0001 + LOB Data File: LOBP_00178622609794394274_0001 LOB EOD : 0 LOB Used Len : 0 ColumnName : C3 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258067632_0002 + LOB Data File: LOBP_00178622609794394274_0002 LOB EOD : 0 LOB Used Len : 0 ColumnName : C4 @@ -1103,8 +1119,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_04925401285258067632_0001 0 0 -TRAFODION LOB130 TLOB130GT2 C3 /user/trafodion/lobs LOBP_04925401285258067632_0002 0 0 +TRAFODION LOB130 TLOB130GT2 C2 /user/trafodion/lobs LOBP_00178622609794394274_0001 0 0 +TRAFODION LOB130 TLOB130GT2 C3 /user/trafodion/lobs LOBP_00178622609794394274_0002 0 0 TRAFODION LOB130 TLOB130GT2 C4 External HDFS Location External HDFS File 0 0 --- 3 row(s) selected. @@ -1125,17 +1141,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT ColumnName : C2 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258063762_0001 + LOB Data File: LOBP_00178622609794390525_0001 LOB EOD : 15 LOB Used Len : 15 ColumnName : C3 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258063762_0002 + LOB Data File: LOBP_00178622609794390525_0002 LOB EOD : 15 LOB Used Len : 15 ColumnName : C4 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258063762_0003 + LOB Data File: LOBP_00178622609794390525_0003 LOB EOD : 45 LOB Used Len : 45 @@ -1145,9 +1161,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_04925401285258063762_0001 15 15 -TRAFODION LOB130 TLOB130GT C3 /user/trafodion/lobs LOBP_04925401285258063762_0002 15 15 -TRAFODION LOB130 TLOB130GT C4 /user/trafodion/lobs LOBP_04925401285258063762_0003 45 45 +TRAFODION LOB130 TLOB130GT C2 /user/trafodion/lobs LOBP_00178622609794390525_0001 15 15 +TRAFODION LOB130 TLOB130GT C3 /user/trafodion/lobs LOBP_00178622609794390525_0002 15 15 +TRAFODION LOB130 TLOB130GT C4 /user/trafodion/lobs LOBP_00178622609794390525_0003 45 45 --- 3 row(s) selected. >>delete from tlob130gt where c1=2; @@ -1164,17 +1180,17 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT ColumnName : C2 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258063762_0001 + LOB Data File: LOBP_00178622609794390525_0001 LOB EOD : 30 LOB Used Len : 25 ColumnName : C3 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258063762_0002 + LOB Data File: LOBP_00178622609794390525_0002 LOB EOD : 31 LOB Used Len : 26 ColumnName : C4 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258063762_0003 + LOB Data File: LOBP_00178622609794390525_0003 LOB EOD : 71 LOB Used Len : 56 @@ -1184,9 +1200,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_04925401285258063762_0001 30 25 -TRAFODION LOB130 TLOB130GT C3 /user/trafodion/lobs LOBP_04925401285258063762_0002 31 26 -TRAFODION LOB130 TLOB130GT C4 /user/trafodion/lobs LOBP_04925401285258063762_0003 71 56 +TRAFODION LOB130 TLOB130GT C2 /user/trafodion/lobs LOBP_00178622609794390525_0001 30 25 +TRAFODION LOB130 TLOB130GT C3 /user/trafodion/lobs LOBP_00178622609794390525_0002 31 26 +TRAFODION LOB130 TLOB130GT C4 /user/trafodion/lobs LOBP_00178622609794390525_0003 71 56 --- 3 row(s) selected. >> @@ -1217,6 +1233,7 @@ TRAFODION >>sh rm t130_extract_command; >>sh grep "^LOBH" TMP130 | sed "s/^/extract name(LOB '/g" | sed "s/$/');/g" >> >>t130_extract_command; >>obey t130_extract_command; + >>extract name(LOB >>'LOBH0000000200020189730973312776402419189730973430096815918212400523710965517020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> '); LOB filename : /user/trafodion/lobs/LOBP_01897309733127764024_0002 @@ -1225,6 +1242,7 @@ TRAFODION >>sh grep "^LOBH" TMP130 | sed "s/^/extract offset(LOB '/g" | sed "s/$/');/g" >>>> t130_extract_command; >>obey t130_extract_command; >>extract offset(LOB >>'LOBH0000000200020189730973312776402419189730973430096815918212400523710965517020"TRAFODION"."LOB130" >> >> >> >> >> >> >> >> >> >> >> >> '); + LOB Offset : 43 --- SQL operation complete. @@ -1377,12 +1395,12 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT ColumnName : C2 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258083086_0001 + LOB Data File: LOBP_00178622609794405852_0001 LOB EOD : 70 LOB Used Len : 42 ColumnName : C3 Lob Location : /user/trafodion/lobs - LOB Data File: LOBP_04925401285258083086_0002 + LOB Data File: LOBP_00178622609794405852_0002 LOB EOD : 125 LOB Used Len : 68 ColumnName : C4 @@ -1397,8 +1415,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_04925401285258083086_0001 70 42 -TRAFODION LOB130 TLOB130EXT C3 /user/trafodion/lobs LOBP_04925401285258083086_0002 125 68 +TRAFODION LOB130 TLOB130EXT C2 /user/trafodion/lobs LOBP_00178622609794405852_0001 70 42 +TRAFODION LOB130 TLOB130EXT C3 /user/trafodion/lobs LOBP_00178622609794405852_0002 125 68 TRAFODION LOB130 TLOB130EXT C4 External HDFS Location External HDFS File 0 0 --- 3 row(s) selected. @@ -1415,7 +1433,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: LOBH0000000800030492540128525808308619492540128786993345718212384277825571287020"TRAFODION"."LOB130" +LOB handle for c4: LOBH000000080003001786226097944058521817862261119125928418212399608396514208020"TRAFODION"."LOB130" Extracting LOB data length for the above handle... LOB data length :19 Extracting lob data into file in chunks ... @@ -1481,7 +1499,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: LOBH0000000200010492540128525814570219492540128830098955718212384278256374414020"TRAFODION"."LOB130" +LOB handle for c2: LOBH000000020001001786226097944338431817862261132439379818212399608528506845020"TRAFODION"."LOB130" >>select lobtostring(c2,20) from t130lob5; (EXPR) @@ -1498,7 +1516,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: LOBH0000000200010492540128525814570219492540128830098955718212384278256374414020"TRAFODION"."LOB130" +LOB handle for c2: LOBH000000020001001786226097944338431817862261132439379818212399608528506845020"TRAFODION"."LOB130" >>select lobtostring(c2,40) from t130lob5; (EXPR) @@ -1515,7 +1533,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: LOBH0000000200010492540128525814570219492540128830098955718212384278256374414020"TRAFODION"."LOB130" +LOB handle for c2: LOBH000000020001001786226097944338431817862261132439379818212399608528506845020"TRAFODION"."LOB130" >>select lobtostring(c2,20) from t130lob5; (EXPR) @@ -1532,7 +1550,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: LOBH0000000200010492540128525814570219492540128830098955718212384278256374414020"TRAFODION"."LOB130" +LOB handle for c2: LOBH000000020001001786226097944338431817862261132439379818212399608528506845020"TRAFODION"."LOB130" >>select lobtostring(c2,40) from t130lob5; (EXPR) @@ -1559,7 +1577,7 @@ zzzzzzzzzzzzzzzzzzzz C2 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------- -LOBH0000000200010492540128525808308619492540128846057880518212384278416137106020"TRAFODION"."LOB130" +LOBH000000020001001786226097944058521817862261143587581118212399608641118580020"TRAFODION"."LOB130" --- 1 row(s) selected. >>-- following should return error since only external lobs will be allowed @@ -1602,9 +1620,9 @@ LOBH0000000200010492540128525808308619492540128846057880518212384278416137106020 Tables in Schema TRAFODION.LOBSCH ================================= -LOBDescChunks__04925401285258169438_0001 -LOBDescHandle__04925401285258169438_0001 -LOBMD__04925401285258169438 +LOBDescChunks__00178622609794451968_0001 +LOBDescHandle__00178622609794451968_0001 +LOBMD__00178622609794451968 SB_HISTOGRAMS SB_HISTOGRAM_INTERVALS SB_PERSISTENT_SAMPLES
http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/tools/rgrCleanup ---------------------------------------------------------------------- diff --git a/core/sql/regress/tools/rgrCleanup b/core/sql/regress/tools/rgrCleanup new file mode 100755 index 0000000..452a6ec --- /dev/null +++ b/core/sql/regress/tools/rgrCleanup @@ -0,0 +1,4 @@ +#temp solution to cleanup udr cached files +#can be removed when cleanup mechanism for cached files in implemented +echo "rm -rf $TRAF_HOME/udr/$MY_UDR_CACHE_LIBDIR/* 2>$NULL" +rm -rf $TRAF_HOME/udr/$MY_UDR_CACHE_LIBDIR/* 2>$NULL http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/tools/runregr ---------------------------------------------------------------------- diff --git a/core/sql/regress/tools/runregr b/core/sql/regress/tools/runregr index 820531b..4c497e9 100755 --- a/core/sql/regress/tools/runregr +++ b/core/sql/regress/tools/runregr @@ -320,6 +320,8 @@ if [ "$REGREXCLUSIVE" -ne 0 ]; then fi fi +export REGR_POSTOP="$scriptsdir/tools/rgrCleanup" +echo $REGR_POSTOP $REGR_POSTOP # you can set this envvar to any command you like # e.g. export REGR_POSTOP="$HOME/bin/rgrCleanup" echo "***** Done running regressions *****" http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/udr/EXPECTED001 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED001 b/core/sql/regress/udr/EXPECTED001 index adcf75e..99607f0 100644 --- a/core/sql/regress/udr/EXPECTED001 +++ b/core/sql/regress/udr/EXPECTED001 @@ -43,7 +43,12 @@ --- 4 row(s) inserted. >> >>-- for now use VARCHARs for LOBs ->>--cqd TRAF_BLOB_AS_VARCHAR 'OFF'; +>>cqd TRAF_BLOB_AS_VARCHAR 'ON'; + +--- SQL operation complete. +>>cqd TRAF_CLOB_AS_VARCHAR 'ON'; + +--- SQL operation complete. >> >>create table t001_Datatypes ( +>c_char char(15), @@ -183,7 +188,6 @@ +>library TEST001_Java; --- SQL operation complete. ->> >>-- negative test case, the entry point SESSIONIZE_ERR does not exist >>create table_mapping function sessionize_err(dummy char(10)) +>returns (session_id largeint) @@ -191,10 +195,10 @@ +>language cpp +>library TEST001; -*** ERROR[11246] An error occurred locating function or class 'SESSIONIZE_NON_EXISTENT' in library 'TEST001.dll'. +*** ERROR[11246] An error occurred locating function or class 'SESSIONIZE_NON_EXISTENT' in library 'TEST001_212404320583911835.dll'. *** ERROR[11248] A call to dlsym returned errors 0 and 0. Details: -/mnt2/ansharma/ansharma_bool/incubator-trafodion/core/sqf/rundir/udr/TEST001.dll: undefined symbol: SESSIONIZE_NON_EXISTENT. +/mnt3/sandhyasun/trafodion/core/sqf/udr/cached_libs/SCH/TEST001_212404320583911835.dll: undefined symbol: SESSIONIZE_NON_EXISTENT. --- SQL operation failed with errors. >>-- For now this will succeed, since we don't load the library during @@ -358,10 +362,10 @@ CREATE TABLE_MAPPING FUNCTION TRAFODION.SCH.SESSIONIZE_JAVA SESSION_ID SEQUENCE_NO USERID TS IPADDR -------------------- -------------------- -------------------------------- -------------------- --------------- - 1 1 super-user 212365360799500000 12.345.567.345 - 2 1 super-user 212365367999500000 12.345.567.345 - 2 2 super-services 212365367999500000 12.345.567.345 - 2 3 super-services 212365367999550000 12.345.567.345 + 1 1 super-user 212404327199500000 12.345.567.345 + 2 1 super-user 212404334399500000 12.345.567.345 + 2 2 super-services 212404334399500000 12.345.567.345 + 2 3 super-services 212404334399550000 12.345.567.345 --- 4 row(s) selected. >> @@ -427,7 +431,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD SESSION_ID SEQUENCE_NO USERID TS IPADDR -------------------- -------------------- -------------------------------- -------------------- --------------- - 1 1 super-user 212334861599500000 12.345.567.345 + 1 1 super-user 212404327199500000 12.345.567.345 --- 1 row(s) selected. >> @@ -525,7 +529,7 @@ IPADDR SESSION_ID SEQUENCE_NO SESSION_ID SEQUENCE_NO USERID TS IPADDR -------------------- -------------------- -------------------------------- -------------------- --------------- - 1 1 super-user 212373741599500000 12.345.567.345 + 1 1 super-user 212404327199500000 12.345.567.345 --- 1 row(s) selected. >> http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/udr/EXPECTED103 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED103 b/core/sql/regress/udr/EXPECTED103 index 0d471f6..5941b79 100644 --- a/core/sql/regress/udr/EXPECTED103 +++ b/core/sql/regress/udr/EXPECTED103 @@ -166,7 +166,7 @@ --- SQL operation complete. >>showddl library functionsForTest103; -CREATE LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 FILE '/mnt2/ansharma/ansharma_trafr21/incubator-trafodion/core/sqf/rundir/udr/TEST103_functions.dll' +CREATE LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 FILE 'TEST103_functions.dll' ; -- GRANT UPDATE, USAGE ON LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 TO DB__ROOT WITH GRANT OPTION; @@ -296,18 +296,18 @@ A R1 R2 R3 >>-- try to drop libraries - should fail >>drop library functionsForTest103; -*** ERROR[1366] Request failed. One or more dependent procedures exist. +*** ERROR[1366] Request failed. One or more dependent procedures exist. --- SQL operation failed with errors. >>drop library procsForTest103; -*** ERROR[1366] Request failed. One or more dependent procedures exist. +*** ERROR[1366] Request failed. One or more dependent procedures exist. --- SQL operation failed with errors. >> >>-- make sure query invalidation works when dropping routines and libraries >>showddl library functionsForTest103; -CREATE LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 FILE '/mnt2/ansharma/ansharma_trafr21/incubator-trafodion/core/sqf/rundir/udr/TEST103_functions.dll' +CREATE LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 FILE 'TEST103_functions.dll' ; -- GRANT UPDATE, USAGE ON LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 TO DB__ROOT WITH GRANT OPTION; @@ -418,7 +418,7 @@ CREATE PROCEDURE TRAFODION.UDR103SCH.UPDATESUBSCRIPTIONS --- SQL operation complete. >>showddl library functionsForTest103; -CREATE LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 FILE '/mnt2/ansharma/ansharma_trafr21/incubator-trafodion/core/sqf/rundir/udr/TEST103_functions.dll' +CREATE LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 FILE 'TEST103_functions.dll' ; -- GRANT UPDATE, USAGE ON LIBRARY TRAFODION.UDR103SCH.FUNCTIONSFORTEST103 TO DB__ROOT WITH GRANT OPTION; http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/udr/EXPECTED108 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED108 b/core/sql/regress/udr/EXPECTED108 index 5263730..091ae56 100644 --- a/core/sql/regress/udr/EXPECTED108 +++ b/core/sql/regress/udr/EXPECTED108 @@ -46,10 +46,10 @@ +>external name 'SESSIONIZE' +>library TEST108; -*** ERROR[11246] An error occurred locating function or class 'SESSIONIZE' in library 'TEST002.dll'. +*** ERROR[11246] An error occurred locating function or class 'SESSIONIZE' in library 'TEST002_212404327644014105.dll'. *** ERROR[11248] A call to dlsym returned errors 0 and 0. Details: -/home/centos/ansharma_trafr21/incubator-trafodion/core/sqf/rundir/udr/TEST002.dll: undefined symbol: SESSIONIZE. +/mnt3/sandhyasun/trafodion/core/sqf/udr/cached_libs/SCH/TEST002_212404327644014105.dll: undefined symbol: SESSIONIZE. --- SQL operation failed with errors. >> http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/udr/FILTER001 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/FILTER001 b/core/sql/regress/udr/FILTER001 index 283c153..4598093 100755 --- a/core/sql/regress/udr/FILTER001 +++ b/core/sql/regress/udr/FILTER001 @@ -21,6 +21,6 @@ # @@@ END COPYRIGHT @@@ sed " -s#[^ ]*/TEST001.dll#dir/TEST001.dll#g +s/^\/\([[:graph:]]*\/\)*/#udr_cached_lib_dir#\//g s/212[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]/#JULIANTIMESTAMP#/g " "$1" http://git-wip-us.apache.org/repos/asf/trafodion/blob/9528f8c0/core/sql/regress/udr/FILTER108 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/FILTER108 b/core/sql/regress/udr/FILTER108 index c42af27..4598093 100755 --- a/core/sql/regress/udr/FILTER108 +++ b/core/sql/regress/udr/FILTER108 @@ -21,6 +21,6 @@ # @@@ END COPYRIGHT @@@ sed " -s#[^ ]*/TEST002.dll#dir/TEST002.dll#g +s/^\/\([[:graph:]]*\/\)*/#udr_cached_lib_dir#\//g s/212[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]/#JULIANTIMESTAMP#/g " "$1"
