You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kim Haase (JIRA)" <ji...@apache.org> on 2010/01/22 18:51:21 UTC
[jira] Created: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Document SELECT statement requirements resulting from fix to DERBY-4191
-----------------------------------------------------------------------
Key: DERBY-4522
URL: https://issues.apache.org/jira/browse/DERBY-4522
Project: Derby
Issue Type: Bug
Components: Documentation
Affects Versions: 10.5.3.0, 10.4.2.0
Reporter: Kim Haase
Assignee: Kim Haase
The SELECT statement topic needs language based on this release note:
"Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase closed DERBY-4522.
----------------------------
Closing, since fixes have appeared in latest alpha manuals.
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Fix For: 10.6.0.0
>
> Attachments: DERBY-4522-2.diff, DERBY-4522.diff, DERBY-4522.stat, DERBY-4522.zip, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4522:
-----------------------------
Issue & fix info: [Patch Available]
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522.diff, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4522:
-----------------------------
Issue & fix info: (was: [Patch Available])
Sorry, I'm an idiot. Forgot I was just waiting for the fix to show up in the alpha manuals before closing...
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Fix For: 10.6.0.0
>
> Attachments: DERBY-4522-2.diff, DERBY-4522.diff, DERBY-4522.stat, DERBY-4522.zip, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4522:
-----------------------------
Issue & fix info: [Patch Available]
Forgot to mark this Patch Available ...
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Fix For: 10.6.0.0
>
> Attachments: DERBY-4522-2.diff, DERBY-4522.diff, DERBY-4522.stat, DERBY-4522.zip, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4522) Document SELECT statement
requirements resulting from fix to DERBY-4191
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12828315#action_12828315 ]
Dag H. Wanvik commented on DERBY-4522:
--------------------------------------
Great to get this documented! Two comments:
- I think this information should also be present in the GRANT statement topic, in the paragraph that describes SELECT privilege (the one that starts with "Use the SELECT privilege type to grant permission...").
- Another thing is that in this section in the GRANT topic, the privilege requirements for SELECT is described as necessary for the *SELECT statement*. Surely, they are also necessary for the *SELECT expression* (as hinted at to by the sentence mentioning subqueries in the patch's addition to rrefsqlj41360). I think it should be possible to find the required privilege information also when looking at the *SELECT expression* topic, which is the syntax form used in an INSERT statement. If the required privilege information is also explained in the SELECT expression topic, the extra mention of subqueries would be redundant in the patch. Also, the wording should start:
"For queries that do not select a specific column from the tables involved in the SELECT statement or expression, ...."
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522.diff, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-4522) Document SELECT statement
requirements resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-4522.
------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
Issue & fix info: (was: [Patch Available])
Thanks, Dag!
Committed patch DERBY-4522-2.diff to documentation trunk at revision 906505.
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Fix For: 10.6.0.0
>
> Attachments: DERBY-4522-2.diff, DERBY-4522.diff, DERBY-4522.stat, DERBY-4522.zip, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4522) Document SELECT statement
requirements resulting from fix to DERBY-4191
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12806706#action_12806706 ]
Mamta A. Satoor commented on DERBY-4522:
----------------------------------------
The change looks good to me but I might be looking at from an implementor's point of view. It will be nice if Rick/Dag/anyone else can also review it. thanks for working on this, Kim.
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522.diff, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4522) Document SELECT statement
requirements resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12806490#action_12806490 ]
Kim Haase commented on DERBY-4522:
----------------------------------
I think either Mamta or Rick or Dag could review this patch, if one of you would be so kind. If I don't hear from anyone by Tuesday 2/2 I'll assume it's okay and commit it. Thanks!
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522.diff, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4522:
-----------------------------
Attachment: DERBY-4522.zip
DERBY-4522.stat
DERBY-4522-2.diff
Thanks for the suggestions, Dag. I hope this new patch addresses them. I added the information to the GRANT statement and SelectExpression topics, tailoring it to each, and removed the sentence about subqueries. (I also added a link to the SELECT statement topic to the GRANT information (as well as one to the SelectExpression topic).
Attaching DERBY-4522-2.diff, DERBY-4522.stat, and DERBY-4522.zip.
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522-2.diff, DERBY-4522.diff, DERBY-4522.stat, DERBY-4522.zip, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4522) Document SELECT statement
requirements resulting from fix to DERBY-4191
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12829381#action_12829381 ]
Dag H. Wanvik commented on DERBY-4522:
--------------------------------------
Thanks, Kim. The changes looks good to me . +1
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522-2.diff, DERBY-4522.diff, DERBY-4522.stat, DERBY-4522.zip, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4522) Document SELECT statement requirements
resulting from fix to DERBY-4191
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4522:
-----------------------------
Attachment: DERBY-4522.diff
rrefsqlj41360.html
Attaching DERBY-4522.diff and rrefsqlj41360.html, which add a short paragraph about required privileges based on the release note for DERBY-4191.
Should DERBY-4191 be marked as resolved, by the way? It looks as if the fix has been committed.
> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
> Key: DERBY-4522
> URL: https://issues.apache.org/jira/browse/DERBY-4522
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.4.2.0, 10.5.3.0
> Reporter: Kim Haase
> Assignee: Kim Haase
> Attachments: DERBY-4522.diff, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select privilege for queries that do not select a specific column from the tables involved in the SELECT statement. Additionally, subqueries will require that the user has necessary select privileges in order to execute it."
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.