[ 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)
|