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. rrefsql9241891.html
        42 kB
        Laura Stewart
      2. derby1928_1.diff
        35 kB
        Laura Stewart

        Activity

        Hide
        Rick Hillegas added a comment -

        Move to 10.2.3.0.

        Show
        Rick Hillegas added a comment - Move to 10.2.3.0.
        Hide
        Andrew McIntyre added a comment -

        Unsetting Fix Version for unassigned issues.

        Show
        Andrew McIntyre added a comment - Unsetting Fix Version for unassigned issues.
        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?
        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?
        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 -

        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 -

        Committed revision 521089.

        Show
        Laura Stewart added a comment - Committed revision 521089.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development