Derby
  1. Derby
  2. DERBY-4510

Reference manual is unclear on max length for VARCHAR

    Details

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

      Description

      This is what the reference manual says about the length of a VARCHAR:
      (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)

      ,----

      length is an unsigned integer constant, and it must not be greater
      than the constraint of the integer used to specify the length, the
      value java.lang.Integer.MAX_VALUE.
      The maximum length for a VARCHAR string is 32,672 characters.
      `----

      I don't understand why it talks about Integer.MAX_VALUE here, and I
      think it would be less confusing if we replaced the above with this:

      ,----

      length is an unsigned integer constant. The maximum length for a
      VARCHAR string is 32,672 characters.
      `----
      1. rrefsqlj41207.html
        4 kB
        Bryan Pendleton
      2. docs.diff
        1 kB
        Bryan Pendleton

        Activity

        Hide
        Bryan Pendleton added a comment -

        That seems like a good simplification, and a much clearer way to describe the data type.

        Attached is a docs patch proposal, and the HTML-formatted version of the ref page.

        Show
        Bryan Pendleton added a comment - That seems like a good simplification, and a much clearer way to describe the data type. Attached is a docs patch proposal, and the HTML-formatted version of the ref page.
        Hide
        Knut Anders Hatlen added a comment -

        Thanks Bryan. The patch and the HTML look good to me. +1 to commit.

        Show
        Knut Anders Hatlen added a comment - Thanks Bryan. The patch and the HTML look good to me. +1 to commit.
        Hide
        Bryan Pendleton added a comment -

        Thanks for the timely review, Knut. Committed to the docs trunk as revision 902478.

        Show
        Bryan Pendleton added a comment - Thanks for the timely review, Knut. Committed to the docs trunk as revision 902478.
        Hide
        Knut Anders Hatlen added a comment -

        Verified the fix in the alpha manual (http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html). Closing.

        Show
        Knut Anders Hatlen added a comment - Verified the fix in the alpha manual ( http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html ). Closing.

          People

          • Assignee:
            Bryan Pendleton
            Reporter:
            Knut Anders Hatlen
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development