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/10/04 22:49:20 UTC
[jira] Created: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
---------------------------------------------------------------------------------------
Key: DERBY-1928
URL: http://issues.apache.org/jira/browse/DERBY-1928
Project: Derby
Issue Type: Bug
Components: Documentation
Affects Versions: 10.2.1.6
Reporter: Laura Stewart
Priority: Minor
Fix For: 10.2.2.0, 10.3.0.0
In the file
http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
Table 12. Support for SQL-92 Features: Basic schema manipulation,
the column for GRANT/REVOKE row should mark as partial instead of no.
--
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] Assigned: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart reassigned DERBY-1928:
------------------------------------
Assignee: Laura Stewart
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1928?page=all ]
Rick Hillegas updated DERBY-1928:
---------------------------------
Fix Version/s: 10.2.3.0
(was: 10.2.2.0)
Move to 10.2.3.0.
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: http://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0, 10.2.3.0
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
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-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart closed DERBY-1928.
--------------------------------
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Andrew McIntyre (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482552 ]
Andrew McIntyre commented on DERBY-1928:
----------------------------------------
Looks good. Since you are already updating this file, could you please also change ALTER TABLE DROP COLUMN to 'Yes' as well?
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1928:
---------------------------------
Derby Info: [Patch Available]
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart resolved DERBY-1928.
----------------------------------
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed revision 521089.
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Andrew McIntyre (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482574 ]
Andrew McIntyre commented on DERBY-1928:
----------------------------------------
Somehow missed the earlier questions.
1 - A is correct, the feature is supported, but through JDBC method calls and not using SQL.
2 - Yes, "date and time data types" works for the second section
3 - Correct
4 - The "IBM specific syntax" should be removed. Derby has partial support for this feature, with DECLARE GLOBAL TEMPORARY TABLE
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482573 ]
Laura Stewart commented on DERBY-1928:
--------------------------------------
Yes, but I still need someone to answer the 4 questions in my earlier comment :-)
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1928:
---------------------------------
Fix Version/s: 10.3.0.0
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1928) Update table "Support for SQL-92
Features: Basic schema manipulation" for GRANT/REVOKE
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1928:
---------------------------------
Attachment: rrefsql9241891.html
derby1928_1.diff
Attaching a patch and html file for this update.
Because the tables looked terrible, I made the following additional updates:
1) Gave each table a section and a section title
2) Fixed capitalization in the "Derby" column
QUESTIONS:
1) Tables for "Cursors" and "Dynamic SQL 1" contain the text "Done through JDBC" in the Derby column
Does this mean:
A. Yes it is supported and the user should use JDBC (text should be changed to "Yes, by using JDBC")
B. Yes it is supported and JDBC does it automatically (text should be changed to "Yes, JDBC includes this support")
2) There are 2 tables labelled "Joined tables". The first one appears correct. The second one should be changed. Is the second one really "Date and time data types"?
3) Table for "User authorizations", should the entry in the Derby column be "Use SET SCHEMA" to indicate the SQL syntax?
4) Last table has a row "Temporary tables" and the Derby column says "IBM specific syntax only". Should that be changed?
> Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE
> --------------------------------------------------------------------------------------
>
> Key: DERBY-1928
> URL: https://issues.apache.org/jira/browse/DERBY-1928
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.2.1.6
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1928_1.diff, rrefsql9241891.html
>
>
> In the file
> http://db.apache.org/derby/docs/10.2/ref/rrefsql9241891.html
> Table 12. Support for SQL-92 Features: Basic schema manipulation,
> the column for GRANT/REVOKE row should mark as partial instead of no.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.