Derby
  1. Derby
  2. DERBY-5566

CREATE SCHEMA should state that one cannot create a new schema starting with "SYS" in case normal form

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.8.2.2
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None
    1. DERBY-5566.diff
      0.8 kB
      Kim Haase
    2. rrefsqlj31580.html
      7 kB
      Kim Haase
    3. rrefsqlj31580.html
      7 kB
      Kim Haase
    4. DERBY-5566-2.diff
      0.8 kB
      Kim Haase

      Issue Links

        Activity

        Dag H. Wanvik created issue -
        Knut Anders Hatlen made changes -
        Field Original Value New Value
        Link This issue is related to DERBY-699 [ DERBY-699 ]
        Hide
        Knut Anders Hatlen added a comment -

        See also DERBY-699 which was filed to lift this limitation.

        Show
        Knut Anders Hatlen added a comment - See also DERBY-699 which was filed to lift this limitation.
        Kim Haase made changes -
        Assignee Kim Haase [ chaase3 ]
        Kathey Marsden made changes -
        Affects Version/s 10.8.2.2 [ 12317968 ]
        Hide
        Kim Haase added a comment -

        Attaching DERBY-5566.diff and rrefsqlj31580.html, adding a couple of sentences to the CREATE SCHEMA topic. I borrowed the language from the CREATE ROLE topic but left out some detail and changed the error message number.

        Please let me know if any changes are needed.

        Show
        Kim Haase added a comment - Attaching DERBY-5566 .diff and rrefsqlj31580.html, adding a couple of sentences to the CREATE SCHEMA topic. I borrowed the language from the CREATE ROLE topic but left out some detail and changed the error message number. Please let me know if any changes are needed.
        Kim Haase made changes -
        Attachment DERBY-5566.diff [ 12524475 ]
        Attachment rrefsqlj31580.html [ 12524476 ]
        Kim Haase made changes -
        Issue & fix info Patch Available [ 10102 ]
        Hide
        Dag H. Wanvik added a comment -

        Thanks! Look good to me. Do we normally specify the exact SQL error state in our docs, though?

        Show
        Dag H. Wanvik added a comment - Thanks! Look good to me. Do we normally specify the exact SQL error state in our docs, though?
        Hide
        Kim Haase added a comment -

        No, we don't usually specify the exact SQL error state. I can take it out. Thanks, Dag.

        Show
        Kim Haase added a comment - No, we don't usually specify the exact SQL error state. I can take it out. Thanks, Dag.
        Hide
        Kim Haase added a comment -

        Attaching DERBY-5566-2.diff and rrefsqlj31580.html, with the exact number of the SQLException removed. Hope this is okay now. Thanks!

        Show
        Kim Haase added a comment - Attaching DERBY-5566 -2.diff and rrefsqlj31580.html, with the exact number of the SQLException removed. Hope this is okay now. Thanks!
        Kim Haase made changes -
        Attachment rrefsqlj31580.html [ 12525909 ]
        Attachment DERBY-5566-2.diff [ 12525910 ]
        Hide
        Kim Haase added a comment -

        I'm assuming the second patch is okay, since no additional comments have come in.

        Committed patch DERBY-5566-2.diff to documentation trunk at revision 1340237.

        Show
        Kim Haase added a comment - I'm assuming the second patch is okay, since no additional comments have come in. Committed patch DERBY-5566 -2.diff to documentation trunk at revision 1340237.
        Kim Haase made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info Patch Available [ 10102 ]
        Fix Version/s 10.9.0.0 [ 12316344 ]
        Resolution Fixed [ 1 ]
        Hide
        Kim Haase added a comment -

        Changes have appeared in Latest Alpha Manuals.

        Show
        Kim Haase added a comment - Changes have appeared in Latest Alpha Manuals.
        Kim Haase made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12648008 ] Default workflow, editable Closed status [ 12796641 ]

          People

          • Assignee:
            Kim Haase
            Reporter:
            Dag H. Wanvik
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development