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

        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.
        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.
        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!
        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.
        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.

          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