[jira] [Commented] (TRAFODION-1671) hive regression TEST009 FAILS

["Hans Zeller (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039177#comment-15039177 ] 

Hans Zeller commented on TRAFODION-1671:
----------------------------------------

Possible patch, but still have to test it:

diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index cea117a..81a72b0 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -1,8 +1,8 @@
 >>obey TEST130(setup);
->>create schema trafodion.lob;
+>>create schema trafodion.lob130;
 
 --- SQL operation complete.
->>set schema trafodion.lob;
+>>set schema trafodion.lob130;
 
 --- SQL operation complete.
 >>create table t130lob1 (c1 blob);
diff --git a/core/sql/regress/executor/TEST016 b/core/sql/regress/executor/TEST016
index fc1085b..0d314dd 100644
--- a/core/sql/regress/executor/TEST016
+++ b/core/sql/regress/executor/TEST016
@@ -27,6 +27,8 @@
 -- To do:
 -- Revision history:
 
+?section cleanup
+
 drop table t016t1 cascade;
 drop table t016t2 cascade;
 drop table t016t3 cascade;
@@ -41,6 +43,8 @@ drop mvgroup mvg_016;
 
 drop procedure rs016;
 
+?section tests
+
 #ifNT
 control query default ARKCMP_FAKE_HW 'ON';
 control query default DEF_NUM_SMP_CPUS '2';
@@ -315,3 +319,4 @@ drop table t016_2535_3;
 
 log;
 
+obey TEST016(cleanup);
diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130
index 6bf031e..2503121 100755
--- a/core/sql/regress/executor/TEST130
+++ b/core/sql/regress/executor/TEST130
@@ -45,6 +45,7 @@ obey TEST130(setup);
 
 
 ?section clnup
+set schema trafodion.lob130;
 drop table t130lob1 cascade;
 drop table t130lob2 cascade;
 drop table t130lob3 cascade;
@@ -52,8 +53,8 @@ drop table t130lob4 cascade;
 
 
 ?section setup
-create schema trafodion.lob;
-set schema trafodion.lob;
+create schema trafodion.lob130;
+set schema trafodion.lob130;
 create table t130lob1 (c1 blob);
 create table t130lob2 (c1 int not null, c2 blob , primary key (c1));
 create table t130lob3 (c1 int not null,
@@ -427,7 +428,7 @@ drop table tlob130bin2;
 sh rm TMP130;
 sh rm tlob130txt2;
 
-drop schema trafodion.lob;
+drop schema trafodion.lob130 cascade;
 
 exit;
 


> hive regression TEST009 FAILS
> -----------------------------
>
>                 Key: TRAFODION-1671
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1671
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: Build Infrastructure
>    Affects Versions: 1.3-incubating
>            Reporter: Eric Owhadi
>            Priority: Minor
>
> regression test hive TEST009 fails (30 lines):
> diff files:
> 28c28,34
> < --- 0 row(s) selected.
> ---
> > SCHEMA_NAME
> > ----------
> > 
> > _HBASESTATS_
> > _HB__CELL__
> > 
> > --- 2 row(s) selected.
> 446,451c452,457
> <  2 HIVE HIVE ITEM
> <  3 TRAFODION _HV_HIVE_ PROMOTION
> <  4 HIVE HIVE PROMOTION
> <  5 TRAFODION _HV_SCH_T009_ T009T2
> <  6 HIVE SCH_T009 T009T2
> <  7 HIVE HIVE CUSTOMER
> ---
> >  2 TRAFODION _HV_HIVE_ PROMOTION
> >  3 HIVE HIVE PROMOTION
> >  4 TRAFODION _HV_SCH_T009_ T009T2
> >  5 HIVE SCH_T009 T009T2
> >  6 HIVE HIVE CUSTOMER
> >  7 HIVE HIVE ITEM
> 507a514
> > _HBASESTATS_
> 511c518
> < --- 2 row(s) selected.
> ---
> > --- 3 row(s) selected.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)