http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/executor/EXPECTED014.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED014.SB b/core/sql/regress/executor/EXPECTED014.SB index ad663f0..2615fc5 100755 --- a/core/sql/regress/executor/EXPECTED014.SB +++ b/core/sql/regress/executor/EXPECTED014.SB @@ -12,11 +12,12 @@ >>log; >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:07 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:23 2016 ( - A INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A INT DEFAULT NULL , B INT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -39,11 +40,12 @@ A B --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:11 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:30 2016 ( - A INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A INT DEFAULT NULL , B INT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -66,11 +68,12 @@ A B --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:15 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:35 2016 ( - A LARGEINT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A LARGEINT DEFAULT NULL , B DOUBLE PRECISION NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -94,11 +97,12 @@ A B --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:18 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:42 2016 ( - C INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , C INT DEFAULT NULL , D INT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -121,11 +125,12 @@ C D --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:22 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:46 2016 ( - C INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , C INT DEFAULT NULL , D INT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -148,11 +153,12 @@ C D --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:26 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:51 2016 ( - C NUMERIC(11, 0) DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , C NUMERIC(11, 0) DEFAULT NULL , D NUMERIC(11, 0) NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -176,11 +182,12 @@ C D --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:29 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:03:55 2016 ( - C NUMERIC(11, 0) DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , C NUMERIC(11, 0) DEFAULT NULL , D NUMERIC(11, 0) NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -204,11 +211,12 @@ C D --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:33 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:04:00 2016 ( - A INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A INT DEFAULT NULL , B INT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -234,11 +242,12 @@ A B --- 2 row(s) inserted. >>invoke t014t1t; --- Definition of Seabase table CAT.SCH.T014T1T --- Definition current Thu Mar 22 15:48:36 2012 +-- Definition of Trafodion table TRAFODION.SCH.T014T1T +-- Definition current Thu Feb 25 08:04:04 2016 ( - A INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A INT DEFAULT NULL , B INT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -272,7 +281,7 @@ A B --- 2 row(s) inserted. >>showddl t014t1t; -CREATE TABLE CAT.SCH.T014T1T +CREATE TABLE TRAFODION.SCH.T014T1T ( A INT DEFAULT NULL , B INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -299,7 +308,7 @@ A B --- 2 row(s) inserted. >>showddl t014t1t; -CREATE TABLE CAT.SCH.T014T1T +CREATE TABLE TRAFODION.SCH.T014T1T ( C INT DEFAULT NULL , D INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -326,7 +335,7 @@ C D --- 2 row(s) inserted. >>showddl t014t1t; -CREATE TABLE CAT.SCH.T014T1T +CREATE TABLE TRAFODION.SCH.T014T1T ( C INT DEFAULT NULL , D INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -353,7 +362,7 @@ C D --- 2 row(s) inserted. >>showddl t014t1t; -CREATE TABLE CAT.SCH.T014T1T +CREATE TABLE TRAFODION.SCH.T014T1T ( A INT DEFAULT NULL , B INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -408,7 +417,7 @@ A B *** ERROR[15001] A syntax error occurred at or before: create schema tempsch create table t014t1 as select * from t014t1s; - ^ (67 characters from start of SQL statement) + ^ (28 characters from start of SQL statement) *** ERROR[8822] The statement was not prepared.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/executor/EXPECTED016.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED016.SB b/core/sql/regress/executor/EXPECTED016.SB index 1d60ec5..c6306f5 100644 --- a/core/sql/regress/executor/EXPECTED016.SB +++ b/core/sql/regress/executor/EXPECTED016.SB @@ -71,7 +71,8 @@ -- Definition current Wed May 14 05:01:26 2014 ( - A NUMERIC(10, 0) UNSIGNED DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A NUMERIC(10, 0) UNSIGNED DEFAULT NULL , B NUMERIC(18, 0) UNSIGNED NO DEFAULT NOT NULL NOT DROPPABLE , C NUMERIC(20, 0) DEFAULT @@ -135,6 +136,7 @@ CREATE TABLE TRAFODION.SCH.T016T1 NULL NOT DROPPABLE , C NUMERIC(21, 21) DEFAULT NULL ) + PRIMARY KEY (A ASC, B ASC) --- SQL operation complete. >>showddl t016t2; @@ -382,7 +384,8 @@ A B C -- Definition current Wed May 14 05:01:40 2014 ( - A NUMERIC(10, 0) UNSIGNED DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A NUMERIC(10, 0) UNSIGNED DEFAULT NULL , B NUMERIC(18, 0) UNSIGNED NO DEFAULT NOT NULL NOT DROPPABLE , C NUMERIC(20, 0) DEFAULT NULL @@ -416,7 +419,8 @@ A B C -- Definition current Wed May 14 05:01:42 2014 ( - JJ NUMERIC(128, 0) UNSIGNED DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , JJ NUMERIC(128, 0) UNSIGNED DEFAULT NULL , KF NUMERIC(128, 0) DEFAULT NULL ) http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/executor/EXPECTED122 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED122 b/core/sql/regress/executor/EXPECTED122 index f011381..c372676 100644 --- a/core/sql/regress/executor/EXPECTED122 +++ b/core/sql/regress/executor/EXPECTED122 @@ -65,10 +65,11 @@ A >>invoke t122t1; -- Definition of Trafodion table TRAFODION.SCH.T122T1 --- Definition current Wed Apr 22 14:46:39 2015 +-- Definition current Thu Feb 25 08:40:12 2016 ( - A INT NO DEFAULT NOT NULL NOT DROPPABLE + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A INT NO DEFAULT NOT NULL NOT DROPPABLE ) --- SQL operation complete. @@ -117,10 +118,11 @@ A >>execute s3; -- Definition of Trafodion table TRAFODION.SCH.T122T1 --- Definition current Wed Apr 22 14:46:39 2015 +-- Definition current Thu Feb 25 08:40:13 2016 ( - A INT NO DEFAULT NOT NULL NOT DROPPABLE + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A INT NO DEFAULT NOT NULL NOT DROPPABLE ) --- SQL operation complete. @@ -176,10 +178,11 @@ iv >>invoke t122t1; -- Definition of Trafodion table TRAFODION.SCH.T122T1 --- Definition current Wed Apr 22 14:46:59 2015 +-- Definition current Thu Feb 25 08:40:32 2016 ( - A CHAR(4) CHARACTER SET ISO88591 COLLATE + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A CHAR(4) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) @@ -226,10 +229,11 @@ iv -- Definition of Trafodion table TRAFODION.SCH.T122T1 --- Definition current Wed Apr 22 14:47:01 2015 +-- Definition current Thu Feb 25 08:40:34 2016 ( - A CHAR(4) CHARACTER SET ISO88591 COLLATE + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , A CHAR(4) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/executor/EXPECTED130 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130 index 342c076..741fcaa 100644 --- a/core/sql/regress/executor/EXPECTED130 +++ b/core/sql/regress/executor/EXPECTED130 @@ -53,9 +53,9 @@ C1 C1 C2 ----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- - 1 LOBH00000200010520117997292580853919884121437179977294818212317485757218627020"TRAFODION"."LOB130" - 2 LOBH00000200010520117997292580853919884121437180341874318212317485760955694020"TRAFODION"."LOB130" - 3 LOBH00000200010520117997292580853919884121437180704085518212317485764542640020"TRAFODION"."LOB130" + 1 LOBH00000200010592176192134729966219592176192139496647918212323493795172702020"TRAFODION"."LOB130" + 2 LOBH00000200010592176192134729966219592176192140030953518212323493800597686020"TRAFODION"."LOB130" + 3 LOBH00000200010592176192134729966219592176192140527060218212323493805564311020"TRAFODION"."LOB130" --- 3 row(s) selected. >> @@ -333,7 +333,7 @@ And the dish ran away with the fork ! >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'tlob130_txt1.txt');/g" >> t130_extract_command; >> >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200010520117997292583625519884121437206093184618212317486018305654020"TRAFODION"."LOB130" ' , 'tlob130_txt1.txt'); +>>extract lobtofile(LOB 'LOBH00000200010592176192134733245719592176192171050485618212323494110664949020"TRAFODION"."LOB130" ' , 'tlob130_txt1.txt'); Success. Targetfile :tlob130_txt1.txt Length : 19 --- SQL operation complete. @@ -349,7 +349,7 @@ Success. Targetfile :tlob130_txt1.txt Length : 19 >>sh rm t130_extract_command; >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'tlob130_deep.jpg');/g" >> t130_extract_command; >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130" ' , 'tlob130_deep.jpg'); +>>extract lobtofile(LOB 'LOBH00000200010592176192134733309019592176192176652813118212323494166743790020"TRAFODION"."LOB130" ' , 'tlob130_deep.jpg'); Success. Targetfile :tlob130_deep.jpg Length : 159018 --- SQL operation complete. @@ -365,7 +365,7 @@ Success. Targetfile :tlob130_deep.jpg Length : 159018 >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'tlob130_anoush.jpg');/g" >> t130_extract_command; >> >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130" ' , 'tlob130_anoush.jpg'); +>>extract lobtofile(LOB 'LOBH00000200010592176192134733309019592176192176652813118212323494166743790020"TRAFODION"."LOB130" ' , 'tlob130_anoush.jpg'); Success. Targetfile :tlob130_anoush.jpg Length : 230150 --- SQL operation complete. @@ -484,7 +484,7 @@ And the dish ran away with the fork ! >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'hdfs:\/\/\/lobs\/tlob130_txt2.txt');/g" >> t130_extract_command; >> >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200010520117997292584465719884121437216347907218212317486120465668020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_txt2.txt'); +>>extract lobtofile(LOB 'LOBH00000200010592176192134734270219592176192182731401318212323494227492370020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_txt2.txt'); Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19 --- SQL operation complete. @@ -500,7 +500,7 @@ Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19 >>sh rm t130_extract_command; >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'hdfs:\/\/\/lobs\/tlob130_deep.jpg');/g" >> t130_extract_command; >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200010520117997292584531219884121437220235037418212317486159808683020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_deep.jpg'); +>>extract lobtofile(LOB 'LOBH00000200010592176192134734319619592176192188535869918212323494285449446020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_deep.jpg'); Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018 --- SQL operation complete. @@ -516,7 +516,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 'LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush.jpg'); +>>extract lobtofile(LOB 'LOBH00000200010592176192134733309019592176192176652813118212323494166743790020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush.jpg'); Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150 --- SQL operation complete. @@ -535,7 +535,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: LOBH00000200010520117997292583681719884121437210516812518212317486062586654020"TRAFODION"."LOB130" +LOB handle for c2: LOBH00000200010592176192134733309019592176192176652813118212323494166743790020"TRAFODION"."LOB130" Extracting LOB data length for the above handle... LOB data length :230150 Extracting lob data into file in chunks of 1000 ... @@ -813,7 +813,7 @@ And the dish ran away with the spoon. >>sh rm t130_extract_command; >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'tlob130_deep2.jpg');/g" >> t130_extract_command; >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200020520117997292585982119884121437229332169918212317486250825302020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); +>>extract lobtofile(LOB 'LOBH00000200020592176192134736068419592176192198951613118212323494389654681020"TRAFODION"."LOB130" ' , 'tlob130_deep2.jpg'); Success. Targetfile :tlob130_deep2.jpg Length : 159018 --- SQL operation complete. @@ -822,7 +822,7 @@ Success. Targetfile :tlob130_deep2.jpg Length : 159018 >>sh rm t130_extract_command; >>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , >>'hdfs:\/\/\/lobs\/tlob130_anoush2.jpg');/g" >> t130_extract_command; >>obey t130_extract_command; ->>extract lobtofile(LOB 'LOBH00000200030520117997292585982119884121437229667368718212317486254205249020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush2.jpg'); +>>extract lobtofile(LOB 'LOBH00000200030592176192134736068419592176192199447013618212323494394650219020"TRAFODION"."LOB130" ' , 'hdfs:///lobs/tlob130_anoush2.jpg'); Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150 --- SQL operation complete. @@ -849,10 +849,90 @@ 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 'LOBH00000200030520117997292586250119884121437232179272218212317486279303189020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); +>>extract lobtofile(LOB 'LOBH00000200030592176192134736435719592176192203041777118212323494430688273020"TRAFODION"."LOB130" ' , 'tlob130_anoush3.jpg',create,truncate); Success. Targetfile :tlob130_anoush3.jpg Length : 230150 --- SQL operation complete. >> +>>obey TEST130(lob_gc_cleanup); +>>log; +>>create table tlob130gc (c1 int not null, c2 blob, c3 blob, primary key (c1)); + +--- SQL operation complete. +>>--insert a few rows +>>insert into tlob130gc values (1, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (2, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (3, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (4, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (5, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (6, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (7, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>insert into tlob130gc values (8, stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>--create holes in the lob data file +>>delete from tlob130gc where c1=2; + +--- 1 row(s) deleted. +>>delete from tlob130gc where c1=6; + +--- 1 row(s) deleted. +>>update tlob130gc set c2=stringtolob('xxxx')where c1=7; + +--- 1 row(s) updated. +>>--check contents of table +>>select c1,lobtostring(c2,10),lobtostring(c3,10) from tlob130gc; + +C1 (EXPR) (EXPR) +----------- ---------- ---------- + + 1 aaaa bbbbb + 3 aaaa bbbbb + 4 aaaa bbbbb + 5 aaaa bbbbb + 7 xxxx bbbbb + 8 aaaa bbbbb + +--- 6 row(s) selected. +>>cqd LOB_GC_LIMIT_SIZE '0'; + +--- SQL operation complete. +>>--this next insert should trigger a GC +>>insert into tlob130gc values(9,stringtolob('aaaa'), stringtolob('bbbbb')); + +--- 1 row(s) inserted. +>>--check contents of table. Should have one extra row compared to above select +>>select c1,lobtostring(c2,10),lobtostring(c3,10) from tlob130gc; + +C1 (EXPR) (EXPR) +----------- ---------- ---------- + + 1 aaaa bbbbb + 3 aaaa bbbbb + 4 aaaa bbbbb + 5 aaaa bbbbb + 7 xxxx bbbbb + 8 aaaa bbbbb + 9 aaaa bbbbb + +--- 7 row(s) selected. +>>cqd LOB_GC_LIMIT_SIZE reset; + +--- SQL operation complete. +>> >>obey TEST130(lob_general_cleanup); >>log; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/executor/TEST130 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130 index 87ca365..108da27 100755 --- a/core/sql/regress/executor/TEST130 +++ b/core/sql/regress/executor/TEST130 @@ -404,6 +404,37 @@ 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; +obey TEST130(lob_gc_cleanup); +?section lob_gc_cleanup +log; +drop table tlob130gc; +obey TEST130(lob_gc_test); + +?section lob_gc_test +log LOG130; +create table tlob130gc (c1 int not null, c2 blob, c3 blob, primary key (c1)); +--insert a few rows +insert into tlob130gc values (1, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (2, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (3, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (4, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (5, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (6, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (7, stringtolob('aaaa'), stringtolob('bbbbb')); +insert into tlob130gc values (8, stringtolob('aaaa'), stringtolob('bbbbb')); +--create holes in the lob data file +delete from tlob130gc where c1=2; +delete from tlob130gc where c1=6; +update tlob130gc set c2=stringtolob('xxxx')where c1=7; +--check contents of table +select c1,lobtostring(c2,10),lobtostring(c3,10) from tlob130gc; +cqd LOB_GC_LIMIT_SIZE '0'; +--this next insert should trigger a GC +insert into tlob130gc values(9,stringtolob('aaaa'), stringtolob('bbbbb')); +--check contents of table. Should have one extra row compared to above select +select c1,lobtostring(c2,10),lobtostring(c3,10) from tlob130gc; +cqd LOB_GC_LIMIT_SIZE reset; + obey TEST130(lob_general_cleanup); -- cleanup ?section lob_general_cleanup @@ -429,6 +460,7 @@ sh rm TMP130; sh rm tlob130txt2; sh rm lobc2out.jpg; sh rm TEST130_argfile; +drop table tlob130gc; drop schema trafodion.lob130 cascade; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/hive/EXPECTED009 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED009 b/core/sql/regress/hive/EXPECTED009 index 0f4be9e..df03c8e 100644 --- a/core/sql/regress/hive/EXPECTED009 +++ b/core/sql/regress/hive/EXPECTED009 @@ -82,6 +82,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HV_HIVE_".CUSTOMER , C_LAST_REVIEW_DATE VARCHAR(32000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. @@ -124,6 +125,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HV_HIVE_".ITEM , I_PRODUCT_NAME VARCHAR(32000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. @@ -164,6 +166,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HV_HIVE_".PROMOTION , P_DISCOUNT_ACTIVE VARCHAR(32000 BYTES) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. @@ -193,6 +196,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HV_SCH_T009_".T009T1 , B INT DEFAULT NULL , C INT DEFAULT NULL ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. @@ -204,6 +208,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HV_SCH_T009_".T009T2 , B INT DEFAULT NULL , C INT DEFAULT NULL ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. @@ -520,6 +525,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HB__ROW__"."baseball" , COLUMN_DETAILS VARCHAR(10000) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL NOT NULL NOT DROPPABLE ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. @@ -538,6 +544,7 @@ CREATE EXTERNAL TABLE TRAFODION."_HB__CELL__"."baseball" , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL NOT NULL NOT DROPPABLE ) + ATTRIBUTES NO AUDIT ; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/hive/EXPECTED017 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED017 b/core/sql/regress/hive/EXPECTED017 index 34ce3fd..2e746b7 100644 --- a/core/sql/regress/hive/EXPECTED017 +++ b/core/sql/regress/hive/EXPECTED017 @@ -322,6 +322,7 @@ CREATE TABLE TRAFODION.HBASE.T017TTCIDXB , A INT NO DEFAULT NOT NULL NOT DROPPABLE , PRIMARY KEY ("B@" ASC, "_SALT_" ASC, A ASC) ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -474,6 +475,7 @@ CREATE TABLE TRAFODION.HBASE.T017TTDIDXB , SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE , PRIMARY KEY ("B@" ASC, A ASC, SYSKEY ASC) ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -616,6 +618,7 @@ CREATE TABLE TRAFODION.HBASE.T017TTEIDXB , SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE , PRIMARY KEY ("B@" ASC, SYSKEY ASC) ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/privs1/EXPECTED132 ---------------------------------------------------------------------- diff --git a/core/sql/regress/privs1/EXPECTED132 b/core/sql/regress/privs1/EXPECTED132 index ea090c5..0e9828c 100644 --- a/core/sql/regress/privs1/EXPECTED132 +++ b/core/sql/regress/privs1/EXPECTED132 @@ -863,7 +863,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_games; -- Definition of Trafodion table TRAFODION.T132SCH.T132_GAMES --- Definition current Sat Feb 13 01:27:45 2016 +-- Definition current Thu Feb 25 11:15:40 2016 ( HOME_TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -874,12 +874,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , GAME_LOCATION VARCHAR(50) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (GAME_NUMBER ASC) --- SQL operation complete. >>invoke t132_teams; -- Definition of Trafodion table TRAFODION.T132SCH.T132_TEAMS --- Definition current Sat Feb 13 01:27:47 2016 +-- Definition current Thu Feb 25 11:15:42 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -890,12 +891,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , TEAM_CONTACT_NUMBER CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (TEAM_NUMBER ASC) --- SQL operation complete. >>invoke t132_giants_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_GIANTS_GAMES --- Definition current Sat Feb 13 01:27:49 2016 +-- Definition current Thu Feb 25 11:15:43 2016 ( GAME_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -909,7 +911,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_home_teams_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_HOME_TEAMS_GAMES --- Definition current Sat Feb 13 01:27:50 2016 +-- Definition current Thu Feb 25 11:15:45 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -979,7 +981,7 @@ ALTER TABLE TRAFODION.T132SCH.T132_GAMES ADD CONSTRAINT >>invoke t132_games; -- Definition of Trafodion table TRAFODION.T132SCH.T132_GAMES --- Definition current Sat Feb 13 01:28:08 2016 +-- Definition current Thu Feb 25 11:16:00 2016 ( HOME_TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -990,6 +992,7 @@ ALTER TABLE TRAFODION.T132SCH.T132_GAMES ADD CONSTRAINT , GAME_LOCATION VARCHAR(50) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (GAME_NUMBER ASC) --- SQL operation complete. >>invoke t132_teams; @@ -1173,7 +1176,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_games; -- Definition of Trafodion table TRAFODION.T132SCH.T132_GAMES --- Definition current Sat Feb 13 01:28:45 2016 +-- Definition current Thu Feb 25 11:16:33 2016 ( HOME_TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1184,12 +1187,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , GAME_LOCATION VARCHAR(50) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (GAME_NUMBER ASC) --- SQL operation complete. >>invoke t132_teams; -- Definition of Trafodion table TRAFODION.T132SCH.T132_TEAMS --- Definition current Sat Feb 13 01:28:45 2016 +-- Definition current Thu Feb 25 11:16:33 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1200,12 +1204,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , TEAM_CONTACT_NUMBER CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (TEAM_NUMBER ASC) --- SQL operation complete. >>invoke t132_giants_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_GIANTS_GAMES --- Definition current Sat Feb 13 01:28:45 2016 +-- Definition current Thu Feb 25 11:16:33 2016 ( GAME_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1219,7 +1224,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_home_teams_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_HOME_TEAMS_GAMES --- Definition current Sat Feb 13 01:28:45 2016 +-- Definition current Thu Feb 25 11:16:33 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1299,7 +1304,7 @@ ALTER TABLE TRAFODION.T132SCH.T132_TEAMS ADD CONSTRAINT >>invoke t132_teams; -- Definition of Trafodion table TRAFODION.T132SCH.T132_TEAMS --- Definition current Sat Feb 13 01:29:10 2016 +-- Definition current Thu Feb 25 11:16:51 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1310,6 +1315,7 @@ ALTER TABLE TRAFODION.T132SCH.T132_TEAMS ADD CONSTRAINT , TEAM_CONTACT_NUMBER CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (TEAM_NUMBER ASC) --- SQL operation complete. >>invoke t132_giants_games; @@ -1447,7 +1453,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_games; -- Definition of Trafodion table TRAFODION.T132SCH.T132_GAMES --- Definition current Sat Feb 13 01:29:32 2016 +-- Definition current Thu Feb 25 11:17:10 2016 ( HOME_TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1458,12 +1464,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , GAME_LOCATION VARCHAR(50) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (GAME_NUMBER ASC) --- SQL operation complete. >>invoke t132_teams; -- Definition of Trafodion table TRAFODION.T132SCH.T132_TEAMS --- Definition current Sat Feb 13 01:29:32 2016 +-- Definition current Thu Feb 25 11:17:10 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1474,12 +1481,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , TEAM_CONTACT_NUMBER CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (TEAM_NUMBER ASC) --- SQL operation complete. >>invoke t132_giants_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_GIANTS_GAMES --- Definition current Sat Feb 13 01:29:32 2016 +-- Definition current Thu Feb 25 11:17:10 2016 ( GAME_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1493,7 +1501,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_home_teams_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_HOME_TEAMS_GAMES --- Definition current Sat Feb 13 01:29:32 2016 +-- Definition current Thu Feb 25 11:17:10 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1606,7 +1614,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_games; -- Definition of Trafodion table TRAFODION.T132SCH.T132_GAMES --- Definition current Sat Feb 13 01:29:53 2016 +-- Definition current Thu Feb 25 11:17:27 2016 ( HOME_TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1617,12 +1625,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , GAME_LOCATION VARCHAR(50) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (GAME_NUMBER ASC) --- SQL operation complete. >>invoke t132_teams; -- Definition of Trafodion table TRAFODION.T132SCH.T132_TEAMS --- Definition current Sat Feb 13 01:29:53 2016 +-- Definition current Thu Feb 25 11:17:27 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1633,12 +1642,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , TEAM_CONTACT_NUMBER CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (TEAM_NUMBER ASC) --- SQL operation complete. >>invoke t132_giants_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_GIANTS_GAMES --- Definition current Sat Feb 13 01:29:53 2016 +-- Definition current Thu Feb 25 11:17:27 2016 ( GAME_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1652,7 +1662,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_home_teams_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_HOME_TEAMS_GAMES --- Definition current Sat Feb 13 01:29:53 2016 +-- Definition current Thu Feb 25 11:17:27 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1765,7 +1775,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_games; -- Definition of Trafodion table TRAFODION.T132SCH.T132_GAMES --- Definition current Sat Feb 13 01:30:13 2016 +-- Definition current Thu Feb 25 11:17:44 2016 ( HOME_TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1776,12 +1786,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , GAME_LOCATION VARCHAR(50) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (GAME_NUMBER ASC) --- SQL operation complete. >>invoke t132_teams; -- Definition of Trafodion table TRAFODION.T132SCH.T132_TEAMS --- Definition current Sat Feb 13 01:30:13 2016 +-- Definition current Thu Feb 25 11:17:44 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1792,12 +1803,13 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE , TEAM_CONTACT_NUMBER CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (TEAM_NUMBER ASC) --- SQL operation complete. >>invoke t132_giants_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_GIANTS_GAMES --- Definition current Sat Feb 13 01:30:13 2016 +-- Definition current Thu Feb 25 11:17:44 2016 ( GAME_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1811,7 +1823,7 @@ CREATE SEQUENCE TRAFODION.T132SCH.T132_TEAM_NUMBER_SEQUENCE >>invoke t132_home_teams_games; -- Definition of Trafodion view TRAFODION.T132SCH.T132_HOME_TEAMS_GAMES --- Definition current Sat Feb 13 01:30:13 2016 +-- Definition current Thu Feb 25 11:17:44 2016 ( TEAM_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1979,26 +1991,26 @@ End of MXCI Session >>showstats for table t132t1 on every column; Histogram data for Table TRAFODION.T132SCH.T132T1 -Table ID: 8532722397900169867 +Table ID: 9082725574613497403 Hist ID # Ints Rowcount UEC Colname(s) ========== ====== =========== =========== =========================== - 835649386 8 8 8 SYSKEY - 835649383 8 8 8 C1 - 835649376 8 8 8 C2 +1275314956 8 8 8 SYSKEY +1275314953 8 8 8 C1 +1275314946 8 8 8 C2 --- SQL operation complete. >>showstats for table t132t2 on every column; Histogram data for Table TRAFODION.T132SCH.T132T2 -Table ID: 8532722397900169937 +Table ID: 9082725574613497462 Hist ID # Ints Rowcount UEC Colname(s) ========== ====== =========== =========== =========================== - 839319130 8 8 8 SYSKEY - 839319125 8 8 8 C1 - 839319120 8 8 8 C2 +1278381713 8 8 8 SYSKEY +1278381708 8 8 8 C1 +1278381703 8 8 8 C2 --- SQL operation complete. @@ -2104,26 +2116,26 @@ MANAGE_STATISTICS >>showstats for table t132t1 on every column; Histogram data for Table TRAFODION.T132SCH.T132T1 -Table ID: 8532722397900169867 +Table ID: 9082725574613497403 Hist ID # Ints Rowcount UEC Colname(s) ========== ====== =========== =========== =========================== - 835649387 8 8 8 SYSKEY - 835649382 8 8 8 C1 - 835649377 8 8 8 C2 +1275314957 8 8 8 SYSKEY +1275314952 8 8 8 C1 +1275314947 8 8 8 C2 --- SQL operation complete. >>showstats for table t132t2 on every column; Histogram data for Table TRAFODION.T132SCH.T132T2 -Table ID: 8532722397900169937 +Table ID: 9082725574613497462 Hist ID # Ints Rowcount UEC Colname(s) ========== ====== =========== =========== =========================== - 839319131 8 8 8 SYSKEY - 839319124 8 8 8 C1 - 839319121 8 8 8 C2 +1278381712 8 8 8 SYSKEY +1278381709 8 8 8 C1 +1278381702 8 8 8 C2 --- SQL operation complete. @@ -2184,13 +2196,13 @@ CREATE TABLE TRAFODION.T132SCH.T132T1 >>showstats for table t132t1 on every column; Histogram data for Table TRAFODION.T132SCH.T132T1 -Table ID: 8532722397900169867 +Table ID: 9082725574613497403 Hist ID # Ints Rowcount UEC Colname(s) ========== ====== =========== =========== =========================== - 835649387 8 8 8 SYSKEY - 835649382 8 8 8 C1 - 835649377 8 8 8 C2 +1275314957 8 8 8 SYSKEY +1275314952 8 8 8 C1 +1275314947 8 8 8 C2 --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/privs2/EXPECTED135 ---------------------------------------------------------------------- diff --git a/core/sql/regress/privs2/EXPECTED135 b/core/sql/regress/privs2/EXPECTED135 index 9fbc688..8ce623f 100644 --- a/core/sql/regress/privs2/EXPECTED135 +++ b/core/sql/regress/privs2/EXPECTED135 @@ -670,6 +670,7 @@ Roles DB__HBASEROLE DB__HIVEROLE +DB__LIBMGRROLE DB__ROOTROLE PUBLIC T135_ROLE1 @@ -1087,6 +1088,7 @@ Roles DB__HBASEROLE DB__HIVEROLE +DB__LIBMGRROLE DB__ROOTROLE PUBLIC
