[
https://issues.apache.org/jira/browse/DERBY-5292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13059620#comment-13059620
]
Thomas Hill edited comment on DERBY-5292 at 7/4/11 9:42 PM:
------------------------------------------------------------
Amazed again about level of support and timely feedback I am receiving from you
and Derby community - thanks for this.
As I have never built Derby from source (and am not technical enough to start
such an undertaking) I will need to wait for binaries before I can test. I
think you advised me last time that there are periodic binary builds which are
being produced? (but unfortunately I can't remember details). In regards to
seeing the fix included in a *production* release, is 'fix version' 10.8.1.6
and 10.9.0 on this Jira indicating that this will be part of the next
maintenance release 10.8.2 tentatively scheduled for middle Sep 2011?
was (Author: thomashill):
Amazed again about level of support and timely feedback I am receiving from
you and Derby community.
As I have never built Derby from source (and am not technical enough to start
such an undertaking) I will need to wait for binaries before I can test. I
think you advised me last time that there are period binary builds which are
being produced? (but can't remember details). In regards to seeing the fix
included in a *production* release, is 'fix version' 10.8.6 on this Jira
indicating that this won't happen prior to this version?, i.e. not as part of
the next maintenance release 10.8.2 tetatively scheduled for middle Sep 2011?
> SQLAuthorisation and views
> --------------------------
>
> Key: DERBY-5292
> URL: https://issues.apache.org/jira/browse/DERBY-5292
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0,
> 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1,
> 10.7.1.1, 10.8.1.2
> Environment: windows xp
> Reporter: Thomas Hill
> Fix For: 10.8.1.6, 10.9.0.0
>
> Attachments: derby5292a.diff, derby5292b.diff, derby5292b.stat,
> derby5292c.diff, derby5292c.stat, derby5292d.diff, derby5292d.stat,
> output.txt, script.txt
>
>
> Hi,
> in some cases there seem to be issues with SQLAuthorisation in conjunction
> with database VIEWS.
> Please see attached files as repro (script.txt has only the SQL I executed,
> output is the output resulting when running the script).
> I would think identical results should be returned in all cases and
> independent on how the view has been defined, but this to my surprise not
> being the case:
> 1) Trying to select from view appl."VW_MyTasks" - which is a simple view
> defined on just one table - leads to expected results, i.e. "my" tasks are
> being returned.
> 2) Trying to select from view appl."VW_MyPriorityTasks - which is a view
> defined on two joined tables without using an inner join clause - leads to
> expected results, i.e. "my" priority tasks are being returned.
> 3) Trying to select from view appl."VW2_MyPriorityTasks - which is the same
> view but now the two tables joined using an inner join clause - leads to an
> error and no tasks returned (when the same results as in 2) above were
> expected).
> 4) Trying to select from view appl."VW3_MyPriorityTasks" - which is a view
> defined using a subselect - also unexpectedly leads to an error.
> Note: While I could rewrite each inner join clause with changing the syntax
> like in 2) above, this provides a simple work-around for such cases. May be
> there is a work-around for subselects also (not sure if every subselect could
> be rewritten to a join?). However when depending on using EXISTS constructs
> in the query there unfortunately is no way (I would know of) to get around
> this problem. Unfortuanetly a view that makes use of EXISTS is also one I
> would need to define in my data base...
> Thanks
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
