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 "Laura Stewart (JIRA)" <de...@db.apache.org> on 2006/09/11 20:36:22 UTC
[jira] Created: (DERBY-1839) Doc Review Updates - Ref Manual
Doc Review Updates - Ref Manual
-------------------------------
Key: DERBY-1839
URL: http://issues.apache.org/jira/browse/DERBY-1839
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.2.2.0
Reporter: Laura Stewart
Assigned To: Laura Stewart
This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435957 ]
Yip Ng commented on DERBY-1839:
-------------------------------
As Mamta pointed out with the CREATE VIEW doc comment, the following statement is no longer true with the work of DERBY-1686:
<snip>
The view owner automatically gains the ability to grant the SELECT privilege to other users if the view owner is granted the following privileges on all objects used by the view:
* The privilege to grant SELECT for columns used from all referenced tables and views
* The privilege to grant EXECUTE for all functions used
</snip>
Currentlly, the view owner can only grant the SELECT privilege to other users provided that the underlying objects are also owned by the view owner. (or that the view owner have been granted with grantable privileges on those objects but since Derby does not support WITH GRANT OPTION, this does not apply to the 10.2 release.)
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_functions1.diff
derby1839_functions1.zip
The following files were updated:
rrefbuiltsmallint SMALLINT
rrefsqlj93082 SUBSTR
rrefsqlj29930 UCASE or UPPER
rreftimestampfunc TIMESTAMP
rrefkeywords29722 SQL reserved words
rrefsecondfunc SECOND (partial update)
Additional updates to the function files will be addressed in Derby-908 and Derby-1927.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435984 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Yip - For CREATE VIEW, is the following statements now accurate?
Theview owner automatically gains the SELECT privilege on the view. The
SELECT privilege cannot be revoked from the view owner. The database owner
automatically gains the SELECT privilege on the view and is able to grant
this privilege to other users. The SELECT privilege cannot be revoked from
the database owner.
The view owner can only grant the SELECT privilege
to other users if the view owner also owns the underlying object. The privilege
to grant the SELECT privilege cannot be revoked. However if a subsequent REVOKE
statement revokes one of the privileges that have been granted, the ability
to grant privileges to other users is implicitly revoked.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Susan Cline (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12442733 ]
Susan Cline commented on DERBY-1839:
------------------------------------
We're good to go!
Thanks,
Susan
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_functions3.diff, derby1839_functions_html3.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435989 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Mamta -
The DIFF file should show the changes.
For GRANT, the following text was changed:
Old Text
When a table, view, function, or procedure is created, the object owner and the database owner have full privileges on the object. No other users have any privileges on the object until the object or database owner grants privileges to the users.
New Text
You can grant privileges to database objects that you are authorized to grant. See the CREATE statement for the database object that you want to grant privileges on for more information.
For CREATE SCHEMA, I changed the syntax per your recommendation and reordered the examples so that they would match the order in the syntax.
I need to look up the info for SYS and will get back to you.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435959 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
May be Yip can review the CREATE VIEW changes.
As for CREATE TRIGGER, I checked DERBY-1551 and didn't see "For schemas that start with SYS, you must have the proper SQL authorizations on the schema" going as part of DERBY-1551. Can you please point me to the right place? I may have missed it. I don't think this statement is correct for triggers.
Laura, you mentioned that the latest patch has my comments. Are those the comments for GRANT and CREATE SCHEMA pages? Can you please tell me what changed specifically between the derby1839_SQLstatements_html.zip and derby1839_SQLstatements2_html.zip. Thanks
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Andrew McIntyre updated DERBY-1839:
-----------------------------------
Derby Info: (was: [Patch Available])
Unchecking patch available, review comments indicate additional work to be done.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435992 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Mamta and Yip -
Based on Yip's comments in the Doc Review, I changed the text for CREATE TRIGGER to this:
You can create a trigger in any schema. For schemas that start with SYS, you must have the proper SQL authorizations on the schema. The trigger does not need to reside in the same schema as the table on which it is defined.
If this text is not correct, then I misunderstood Yip's comment on Derby wiki
http://wiki.apache.org/db-derby/ReferenceManualTenTwo
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435113 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
I was reviewing CREATE TRIGGER rrefsqlj43125.html and found following sentence there. It does not sound right
"For schemas that start with SYS, you must have the proper SQL authorizations on the schema. " I could be wrong, but I thought no one can create anything in SYS schema, no matter what kind of authorization they might have.
ps Laura, I hope you don't mind me sending review comments per page rather than one compiled big comment.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436913 ]
Jean T. Anderson commented on DERBY-1839:
-----------------------------------------
I looked for but couldn't spot the closing "}", can catch that in a later round as needed.
Committted patch derby1839_SQLstatement_4.diff to trunk, revision 448987. Thanks, Laura!
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Jean T. Anderson updated DERBY-1839:
------------------------------------
Fix Version/s: 10.2.1.8
10.3.0.0
Derby Info: (was: [Patch Available])
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0, 10.2.1.8, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_functions3.diff, derby1839_functions_html3.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Susan Cline (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12437013 ]
Susan Cline commented on DERBY-1839:
------------------------------------
The patch for the TAN and CEIL function topics looks good to me.
Thanks Laura.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12437122 ]
Jean T. Anderson commented on DERBY-1839:
-----------------------------------------
Merged 449098 (updates to TAN and CEIL function topics) from trunk to 10.2 branch, revision 449271.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.4, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_functions3.diff
derby1839_functions_html3.zip
Updated the TIMESTAMP file per Susan's comment.
Hope that it is correct now :-)
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_functions3.diff, derby1839_functions_html3.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Derby Info: [Patch Available]
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12442766 ]
Jean T. Anderson commented on DERBY-1839:
-----------------------------------------
Committed patch derby1839_functions3.diff to trunk, revision 464772, and merged to 10.2 branch, revision 464773. Thanks, Laura!
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0, 10.2.1.8, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_functions3.diff, derby1839_functions_html3.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Derby Info: [Patch Available]
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Susan Cline (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12440567 ]
Susan Cline commented on DERBY-1839:
------------------------------------
I had 5 comments related to this bug, shown below with the html file name and the topic I commented on. The zip file I looked in above to see the patch was derby1839_functions1.zip. If I missed another zip file which had the patch in it, could you please let me know?
These two files were fixed:
rrefbuiltsmallint SMALLINT
rrefsqlj29930 UCASE or UPPER
But these three were not:
rreftimestampfunc TIMESTAMP
rrefsecondfunc SECOND
rrefsqlj93082 SUBSTR
Here is why they were not fixed:
TIMESTAMP
----------------
The new document still shows an incorrect example, namely:
The following clause returns the value 1998-12-25-17.12.30.000000:
VALUES TIMESTAMP('1998-12-25', '17.12.30')
Here is the correct output:
VALUES TIMESTAMP('1998-12-25', '17.12.30');
1
--------------------------
1998-12-25 17:12:30.0
****************************************************
SECOND
------------
I believe that DERBY-908 partially addresses my comments, but it does not address all of them. The comment that is not addressed in either DERBY-908 or DERBY-1924 (this bug is mentioned on the ReferenceManualTenTwo wiki page, but it has nothing to do with time), is this:
If the argument can be null, the result can be null; if the argument is null, the result is
the null value.
I'm not entirely clear I understand what this means, but here is a test to show that if the
argument is null, the result is NOT null;
ij> create table timestamp_tab (id integer, col2 timestamp);
0 rows inserted/updated/deleted
ij> insert into timestamp_tab(id) values (1);
1 row inserted/updated/deleted
ij> insert into timestamp_tab values (2, null);
1 row inserted/updated/deleted
ij> select second(col2) from timestamp_tab;
1
----------------------
0.0 << these should be null according to the doc, and are 0
0.0
***************************************************************
SUBSTR
------------
SUBSTR({ CharacterExpression },
StartPosition [, LengthOfString ] )
The updated document says this:
The SUBSTR function returns NULL if the parameter lengthOfString is specified and if the parameter is less than zero.
But this is not true based on the example I gave in my comments:
ij> values substr('hello', 1,-2);
1
---------------
ERROR 22011: The second or third argument of the SUBSTR function is out of range
***************************************************************************************
Thanks,
Susan
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_SQLstatement_4.diff
derby1839_SQLstatements4_html.zip
Updated the SQL statements based on the comments from Mamta and Yip.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Affects Version/s: 10.2.1.6
(was: 10.2.2.0)
Derby Info: [Patch Available]
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_functions2.diff
derby1839_functions2_html.zip
Per further comments from Susan, updated the following files:
Filename Title
rrefsqlj93082 SUBSTR
rreftimestampfunc TIMESTAMP
rrefsecondfunc SECOND
Additionally, the other files updated were:
Filename Title
rrefbuiltsmallint SMALLINT
rrefsqlj29930 UCASE or UPPER
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Rick Hillegas updated DERBY-1839:
---------------------------------
Fix Version/s: 10.2.2.0
(was: 10.2.1.5)
(was: 10.3.0.0)
Moving to 10.2.2
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436286 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Yip - For CREATE TRIGGER, is this statement accurate?
You can create a trigger in any schema where you are the schema owner. To create a trigger on a table that you do not own,
you must be granted the TRIGGER privilege on the table. The trigger does not need to reside in the same schema as
the table on which it is defined.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436589 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
I have couple few comments on derby1839_SQLstatements3_htiml.zip
1)"CREATE VIEW statement" page has following line
"The privilege to grant the SELECT privilege cannot be revoked. However, if a subsequent REVOKE statement revokes one of the privileges that have been granted, the ability to grant privileges to other users is implicitly revoked."
This does not sound correct to me. If a subsequent REVOKE statement revokes one of the privileges that have been granted, then the view will drop automatically and hence the statement "the ability to grant privileges to other users is implicitly revoked." is incorrect. If a required privilege on one of the objects referenced by the view owner is revoked, then the view can't exist anymore and will be dropped.
2)"LOCK TABLE STATEMENT" page has following line
"To lock a table, you must either be the database owner or have authorization to the schema that the table uses."
I think it will be easier to understand if we said
"To lock a table, you must either be the database owner or the table owner."
Same comment for "RENAME TABLE statement" page
3)On the "CREATE TRIGGER statement" page, we do not say that database owner can create the trigger on any table in any schema. We have that information about the database owner on other CREATE statement pages.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Andrew McIntyre updated DERBY-1839:
-----------------------------------
Derby Info: (was: [Patch Available])
xmlfunctions_2 patch committed to trunk and 10.2. Unchecking patch available box.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: 1839_SQLstatements.diff
derby1839_SQLstatements_html.zip
Updated the SQL statements in the Reference Manual based on the
comments received from the 10.2 doc review
Note: for the GRANT, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE FUNCTION statements, there was a comment about using the term "grantable". I did not use this term, but instead worded the comment another way. Please look these statements over carefully.
I implemented the doc review comments and updated the indexes on the following files:
Filename Title
rrefdeclaretemptable DECLARE GLOBAL TEMPORARY TABLE statement
rrefsqlj31580 CREATE SCHEMA statement
rrefsqljrenametablestatement RENAME TABLE statement
rrefsqlj40506 LOCK TABLE statement
rrefsqlj43125 CREATE TRIGGER statement
rrefsqlgrant GRANT statement
rrefsqlj24513 CREATE TABLE statement
rrefcreatefunctionstatement CREATE FUNCTION statement
rrefcreateprocedurestatement CREATE PROCEDURE statement
rrefsqlj15446 CREATE VIEW statement
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "A B (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12437879 ]
A B commented on DERBY-1839:
----------------------------
I reviewed the changes and they look great to me. Only two very (very) minor suggestions that would be nice:
-- 1--
rreffuncxmlquery:
Perhaps a slight rewording here: can we replace "has" with "have" and then change the last part of the following the sentence?
The result set for this query contains a row for only the rows in x_table that has a student name of BC.
to be:
The result set for this query contains a row for only the rows in x_table that have at least one
student whose name is BC.
-- 2 --
rreffuncxmlserialize:
Very slight rewording: maybe replace "contents" with "type" in the following sentence:
There is no other way to convert the contents of a Derby XML value.
I think it's more accurate to say that we convert the type than it is to say that we convert the contents...
I did notice that "data type" is still in the title of the rrefsqljtypexml.html page even though Jean had suggested that it be removed...but I'll let Jean comment on that if she's so inclined :)
Thanks Laura.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_html1.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435916 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Mamta, the information about CREATE VIEW came from Dan, in the Doc Review comments. The info for CREATE TRIGGER was added with Derby1551.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436308 ]
Yip Ng commented on DERBY-1839:
-------------------------------
REVOKE statement:
<snip>
You can revoke privileges from an object if you are the owner of the object, the database owner, or a user that has revoke privileges on the object.
</snip>
I concur with Mamta, only the database owner and the owner of the object can revoke privilege(s) on the object from other user(s).
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Jean T. Anderson updated DERBY-1839:
------------------------------------
Fix Version/s: 10.2.1.0
10.3.0.0
Merged to 10.2 branch, revision 449063.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_TANCEILfunctions.diff
derby1839_TANCEILfunctions_html.zip
Based on the 10.2 doc review comments, updated the TAN and CEIL function topics and the indexes for those topics. The updated files are:
Filename Title
rreffunctan TAN function
rreffuncceil CEIL nad CEILING functions
The patch is called - derby1839_TANCEILfunctions.diff
The html.zip file is called - derby1839_TANCEILfunctions_html.zip
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436307 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
Laura, I just looked at the REVOKE statement page and it looks pretty good. There is one statement in there though, "You can revoke privileges from an object if you are the owner of the object, the database owner, or a user that has revoke privileges on the object.", which does not sound right to me. Other than database owner and the owner of the object, I don't think any other user can revoke privileges on a object. So this bit in the line ", or a user that has revoke privileges on the object" does not look correct to me.
Another very minor comment. At the beginning of the same page, we have this line "Delete a specific table. " We should change it to "Delete data from a specific table. "
Thanks, Laura.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Susan Cline (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12442666 ]
Susan Cline commented on DERBY-1839:
------------------------------------
Hi Laura,
Everything is correct except for the following;
TIMESTAMP:
The following clause returns the value 1998-12-25-17.12.30.000000:
VALUES TIMESTAMP('1998-12-25', '17.12.30');
1
--------------------------
1998-12-25 17:12:30.0
It should be this:
The following clause returns the value 1998-12-25-17:12:30.0:
VALUES TIMESTAMP('1998-12-25', '17.12.30');
1
--------------------------
1998-12-25 17:12:30.0
Thanks,
Susan
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436606 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
Laura, you are right about "If a required privilege on one of the objects referenced by the view is revoked, then ..."
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12434976 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
Laura, I just started looking at the patch and have following comment for GRANT statement page (rrefsqljgrant.html)
Towards the beginning of the page, there is following line
"When a table, view, function, or procedure is created, the object owner and the database owner have full privileges on the object. No other users have any privileges on the object until the object or database owner grants privileges to the users. "
As Dan point out at following page(http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/%3c44F87B93.1090607@apache.org%3e), the paragraph above is not true anymore after Yip's work on "(DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail' got checked in. Dan had some suggestions on how to tackle this at the url included above.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436601 ]
Yip Ng commented on DERBY-1839:
-------------------------------
In additional to Mamta's comments above. For:
(1) GRANT and REVOKE
Users can only issue GRANT and REVOKE statement if SQL Authorization mode is enabled. That is, database property derby.database.sqlAuthorization needs to be set to true.
In the grantee syntax for both GRANT and REVOKE, it is missing a closing "}".
(2) CREATE TRIGGER
Thanks for taking care of my comments regarding the CREATE TRIGGER syntax.
(3) General comments
I noticed that the documentation have now removed the description for legacy authorization mode behavior and describes the Derby system in regard of SQL Authorization mode. Is this intended?
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12438572 ]
Andrew McIntyre commented on DERBY-1839:
----------------------------------------
Committed to trunk with revision 451045.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_SQLstatements3_html.zip
derby1839_SQLstatements3.diff
I updated the patch and the html file for the updates to the SQL statements.
The files are:
derby1839_SQLstatements3.diff
derby1839_SQLstatements3_htiml.zip
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Susan Cline (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12437877 ]
Susan Cline commented on DERBY-1839:
------------------------------------
The xml serialize stuff I commented on looks fine now Laura. Thanks.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_html1.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436045 ]
Yip Ng commented on DERBY-1839:
-------------------------------
For CREATE VIEW:
"The view owner can only grant the SELECT privilege to other users if the view owner also owns the underlying objects."
I think this sounds fine. Similarly, you may want to also mention that in order to create a view successfully in SQL Authorization mode, the view owner needs to have the proper privileges given to him/her if the underlying objects that the view references are not own by the view owner. e.g.: if the authorization id user2 attempts to create a view called user2.v2 that references table user1.t1 and function user1.f_abs(). user2 must have SELECT privilege on user1.t1 and EXECUTE privilege on user1.f_abs().
user2:
CREATE VIEW user2.v2 as SELECT i, user1.f_abs(j) from user1.t1;
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436733 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
Laura, the doc changes look good to me. Thanks for your patience with all the comments.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436039 ]
Yip Ng commented on DERBY-1839:
-------------------------------
Hi Laura:
For CREATE TRIGGER, I think you misinterpreted my doc comment.
You cannot create trigger for schemas that start with SYS in either modes(Derby SQL authorization mode or the old mode).
I was referring to "You can create a trigger in any schema." part. In SQL authorization mode, one cannot create a trigger in a schema that the user does not own. For example, if user2 attempts to create an after insert trigger on table user1.t1, first user2 must have TRIGGER privilege granted by user1. The following create trigger statement should succeed if user2 has TRIGGER privilege on table user1.t1.
CREATE TRIGGER user2.tr1 after insert on user1.t1 for each statement mode db2sql insert into user2.t2 values 1;
This would fail since user2 is trying to create the trigger tr1 in schema user1 for which user2 does not own.
CREATE TRIGGER user1.tr1 after insert on user1.t1 for each statement mode db2sql insert into user2.t2 values 1;
Hope that clear things up.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436313 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Thank you both. I will update the patch and post a new patch very soon.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_SQLstatements2.diff
derby1839_SQLstatements2_html.zip
I updated the files based on Mamta's comments.
Attached are a patch file = derby1839_SQLstatements2.diff
and an html zip file = derby1839_SQLstatements2_html.zip
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_XML+functions_2.diff
derby1839_XML+functions_html2.zip
Updated the files per comments from Army.
New patch and html zip created.
The files are:
patch = derby1839_XML+functions_2.diff
html = derby1839_XML+functions_html2.zip
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436595 ]
Laura Stewart commented on DERBY-1839:
--------------------------------------
Mamta -
One question that I have for you is about your comment on CREATE VIEW.
You said
"If a required privilege on one of the objects referenced by the view owner is revoked, then... "
I think that you mean -
"If a required privilege on one of the objects referenced by the view is revoked, then ..."
not view owner but just view, yes?
I have incorporated your other comments, and am now waiting on Yip's comments.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12437017 ]
Jean T. Anderson commented on DERBY-1839:
-----------------------------------------
Patch derby1839_TANCEILfunctions.diff committed to trunk, revision 449098. Thanks, Laura!
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.0, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435062 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
The page for CREATE VIEW rrefsqlj15446.html has following information
"If the view owner have been granted following privileges on all objects used by the view, then the view owner automatically gains ability to grant the SELECT privilege to other users:
SELECT for columns used from all referenced tables and views
EXECUTE for all functions used
The privilege to grant the SELECT privilege cannot be revoked. However if a subsequent REVOKE statement revokes one of the privileges that have been granted, the ability to grant privileges to other users is implicitly revoked."
I think after Yip's changes for DERBY-1686, the above information is incorrect. A view owner cannot grant SELECT privileges on the view to other users if view owner does own all the underlying objects referenced by the view.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "A B (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12438566 ]
A B commented on DERBY-1839:
----------------------------
Thanks Laura, the _2.diff patch implements my suggestions and I have no other comments. +1 to commit it.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart updated DERBY-1839:
---------------------------------
Attachment: derby1839_XML+functions_1.diff
derby1839_XML+functions_html1.zip
I updated the following files based on comments from Army, Dan, and Susan.
The patch for these updates is:
derby1839_XML+functions_1.diff
derby1839_XML+functions_html1.zip
The files that were updated are:
Filename Title
rrefjdbc88908 JDBC escape syntax for fn keyword
rreffuncxmlquery XMLQUERY operator
rrefsqljtypexml XML data type
rreffuncxmlexists XMLEXISTS operator
rreffuncxmlserialize XMLSERIALIZE operator
rrefsqlj33562 CAST
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.5, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_html1.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12440542 ]
Yip Ng commented on DERBY-1839:
-------------------------------
Thanks for taking care of my comment on adding XMLQUERY in the SQL reserved keywords section in derby1839_functions1.diff. +1 to commit.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.2.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436300 ]
Yip Ng commented on DERBY-1839:
-------------------------------
Laura - I think that sounds fine.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435060 ]
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------
The page for CREATE SCHEMA rrefsqlj31580.html has following syntax
CREATE SCHEMA schemaName AUTHORIZATION user-name
This seems to say that "schemaName", "AUTHORIZATION" and "user-name" are all mandatory on the syntax. But looking at the examples on the same page, it seems one can create a schema with or without all of those mandatory keywords
1)CREATE SCHEMA EMP -- in this example, only schemaName is specified
2)CREATE SCHEMA FLIGHTS AUTHORIZATION anita -- This example adheres to the syntax above
3)CREATE SCHEMA AUTHORIZATION takumi -- in this example, no schemaName is specified
So, should the syntax look something like following? Would appreciate someone else verifying this new suggested syntax.
CREATE SCHEMA { [schemaName AUTHORIZATION user-name] | [schemaName] | [AUTHORIZATION user-name]}
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Jean T. Anderson wrote:
> Yip Ng (JIRA) wrote:
...
>>Laura, the doc changes look good to me. Just one minor problem on the grantee syntax for both GRANT and REVOKE which I mentioned on my earlier comment:
>>
>>grantees
>>
>>{ authorization ID | PUBLIC } [,{ authorization ID | PUBLIC } ] *
>>
>>
>>It is missing a "}" at the end of the syntax.
Yip, I can't seem to spot the missing "}" -- even checked all the files
in the patch with vi for matching "}".
I'll go ahead and commit after my build completes to get these changes
in, can fix more typos later.
the vi dinosaur,
-jean
>
> I'll add the missing "}" and commit asap.
>
> And if I miss Rick's mega merge, I'll merge to the 10.2 branch manually.
> :-)
>
> -jean
Re: [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Yip Ng (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436749 ]
>
> Yip Ng commented on DERBY-1839:
> -------------------------------
>
> Laura, the doc changes look good to me. Just one minor problem on the grantee syntax for both GRANT and REVOKE which I mentioned on my earlier comment:
>
> grantees
>
> { authorization ID | PUBLIC } [,{ authorization ID | PUBLIC } ] *
>
>
> It is missing a "}" at the end of the syntax.
I'll add the missing "}" and commit asap.
And if I miss Rick's mega merge, I'll merge to the 10.2 branch manually.
:-)
-jean
[jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Yip Ng (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436749 ]
Yip Ng commented on DERBY-1839:
-------------------------------
Laura, the doc changes look good to me. Just one minor problem on the grantee syntax for both GRANT and REVOKE which I mentioned on my earlier comment:
grantees
{ authorization ID | PUBLIC } [,{ authorization ID | PUBLIC } ] *
It is missing a "}" at the end of the syntax.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-1839) Doc Review Updates - Ref Manual
Posted by "Laura Stewart (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1839?page=all ]
Laura Stewart closed DERBY-1839.
--------------------------------
Resolution: Fixed
All of the doc review comments on the Ref Guide that could be fixed for 10.2.1.6 were implemented.
The remaining comments have open Jira issues.
Therefore this issue can be closed.
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Fix For: 10.2.1.8, 10.2.2.0, 10.3.0.0
>
> Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip, derby1839_functions2.diff, derby1839_functions2_html.zip, derby1839_functions3.diff, derby1839_functions_html3.zip, derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip, derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip, derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip, derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip, derby1839_XML+functions_html2.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira