Derby
  1. Derby
  2. DERBY-1928

Update table "Support for SQL-92 Features: Basic schema manipulation" for GRANT/REVOKE

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: 10.3.1.4
    • Component/s: Documentation
    • Labels:
      None

      Description

      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.

      1. derby1928_1.diff
        35 kB
        Laura Stewart
      2. rrefsql9241891.html
        42 kB
        Laura Stewart

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        167d 46m 1 Laura Stewart 20/Mar/07 21:35
        In Progress In Progress Resolved Resolved
        1d 5h 2m 1 Laura Stewart 22/Mar/07 02:38
        Resolved Resolved Closed Closed
        5d 14h 43m 1 Laura Stewart 27/Mar/07 18:21
        Gavin made changes -
        Workflow jira [ 12386217 ] Default workflow, editable Closed status [ 12801324 ]
        Laura Stewart made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Laura Stewart made changes -
        Fix Version/s 10.3.0.0 [ 12310800 ]
        Laura Stewart made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Derby Info [Patch Available]
        Resolution Fixed [ 1 ]
        Hide
        Laura Stewart added a comment -

        Committed revision 521089.

        Show
        Laura Stewart added a comment - Committed revision 521089.
        Hide
        Andrew McIntyre added a comment -

        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

        Show
        Andrew McIntyre added a comment - 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
        Hide
        Laura Stewart added a comment -

        Yes, but I still need someone to answer the 4 questions in my earlier comment

        Show
        Laura Stewart added a comment - Yes, but I still need someone to answer the 4 questions in my earlier comment
        Hide
        Andrew McIntyre added a comment -

        Looks good. Since you are already updating this file, could you please also change ALTER TABLE DROP COLUMN to 'Yes' as well?

        Show
        Andrew McIntyre added a comment - Looks good. Since you are already updating this file, could you please also change ALTER TABLE DROP COLUMN to 'Yes' as well?
        Laura Stewart made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Laura Stewart made changes -
        Derby Info [Patch Available]
        Laura Stewart made changes -
        Attachment rrefsql9241891.html [ 12353796 ]
        Attachment derby1928_1.diff [ 12353795 ]
        Hide
        Laura Stewart added a comment -

        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?

        Show
        Laura Stewart added a comment - 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?
        Laura Stewart made changes -
        Assignee Laura Stewart [ scotsmatrix ]
        Andrew McIntyre made changes -
        Fix Version/s 10.3.0.0 [ 12310800 ]
        Fix Version/s 10.2.3.0 [ 12312215 ]
        Hide
        Andrew McIntyre added a comment -

        Unsetting Fix Version for unassigned issues.

        Show
        Andrew McIntyre added a comment - Unsetting Fix Version for unassigned issues.
        Rick Hillegas made changes -
        Field Original Value New Value
        Fix Version/s 10.2.3.0 [ 12312215 ]
        Fix Version/s 10.2.2.0 [ 12312027 ]
        Hide
        Rick Hillegas added a comment -

        Move to 10.2.3.0.

        Show
        Rick Hillegas added a comment - Move to 10.2.3.0.
        Laura Stewart created issue -

          People

          • Assignee:
            Laura Stewart
            Reporter:
            Laura Stewart
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development