Derby
  1. Derby
  2. DERBY-4446

Clarify reference manual regarding specifying field length of LONG VARCHAR columns

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0, 10.6.1.0
    • Fix Version/s: 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None
    • Issue & fix info:
      Newcomer

      Description

      When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.

      From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
      The Derby manual I referred to said "you do not have to specify a maximum
      length when creating columns of this type". What they actually meant is "you
      cannot specify a maximum length"!

      1. DERBY-4446.diff
        1 kB
        Kim Haase
      2. rrefsqlj15147.html
        3 kB
        Kim Haase
      3. rrefsqlj30118.html
        3 kB
        Kim Haase

        Activity

        Kristian Waagan created issue -
        Kim Haase made changes -
        Field Original Value New Value
        Assignee Kim Haase [ chaase3 ]
        Hide
        Kim Haase added a comment -

        Attaching a patch that fixes the problem in these two topics, with the two output files.

        Show
        Kim Haase added a comment - Attaching a patch that fixes the problem in these two topics, with the two output files.
        Kim Haase made changes -
        Attachment rrefsqlj15147.html [ 12425495 ]
        Attachment rrefsqlj30118.html [ 12425496 ]
        Attachment DERBY-4446.diff [ 12425497 ]
        Hide
        Kim Haase added a comment -

        Reclassifying as Bug (it's really an error).

        Show
        Kim Haase added a comment - Reclassifying as Bug (it's really an error).
        Kim Haase made changes -
        Issue Type Improvement [ 4 ] Bug [ 1 ]
        Issue & fix info [Newcomer] [Newcomer, Patch Available]
        Hide
        Bryan Pendleton added a comment -

        patch and HTML pages look fine to me! +1

        Show
        Bryan Pendleton added a comment - patch and HTML pages look fine to me! +1
        Hide
        Kim Haase added a comment -

        Thanks, Bryan!

        Committed patch DERBY-4446.diff to documentation trunk at revision 882270.

        Show
        Kim Haase added a comment - Thanks, Bryan! Committed patch DERBY-4446 .diff to documentation trunk at revision 882270.
        Kim Haase made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info [Patch Available, Newcomer] [Newcomer]
        Fix Version/s 10.6.0.0 [ 12313727 ]
        Resolution Fixed [ 1 ]
        Hide
        Kristian Waagan added a comment -

        Verified in alpha manuals (built on February 8. 2010). Closing.

        Show
        Kristian Waagan added a comment - Verified in alpha manuals (built on February 8. 2010). Closing.
        Kristian Waagan made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12482264 ] Default workflow, editable Closed status [ 12799615 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        2d 10h 56m 1 Kim Haase 19/Nov/09 20:04
        Resolved Resolved Closed Closed
        81d 14h 35m 1 Kristian Waagan 09/Feb/10 10:39

          People

          • Assignee:
            Kim Haase
            Reporter:
            Kristian Waagan
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development