sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tuong Truong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SENTRY-328) Need to update DataNucleus version to support proper SQL generation for DB2
Date Tue, 12 Aug 2014 19:45:13 GMT

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

Tuong Truong commented on SENTRY-328:
-------------------------------------

Verify that DN's change is hitting a bug in Derby (I am using version 10.8.x.x) while DB2
works just fine...

create table test(i1 int);
create table test2(i1 int, i2 int);

select * from test t1 where exists(select * from test2 t2 where t1.i1 = t2.i1);   -- works

select * from test t1 where exists(select i1,i2  from test2 t2 where t1.i1 = t2.i1); 
 -- failed with "Subquery is only allowed to return a single column".


> Need to update DataNucleus version to support proper SQL generation for DB2
> ---------------------------------------------------------------------------
>
>                 Key: SENTRY-328
>                 URL: https://issues.apache.org/jira/browse/SENTRY-328
>             Project: Sentry
>          Issue Type: Bug
>    Affects Versions: 1.4.0
>            Reporter: Tuong Truong
>            Assignee: Tuong Truong
>              Labels: DB2
>             Fix For: 1.5.0
>
>         Attachments: SENTRY-328.patch
>
>   Original Estimate: 2h
>  Remaining Estimate: 2h
>
> DatataNucleus RDBMS jar has defect that causes it to generate improper SQL for DB2 backend
for certain type of query.  This was found in Jira Hive-6136.  The fix was integrated into
datanucleus-core 3.2.12, datanucleus-rdbms 3.2.11.   
> We'd like to Sentry to use this version to ensure proper DB2 support.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message