Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4446

Clarify reference manual regarding specifying field length of LONG VARCHAR columns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.5.3.0, 10.6.1.0
    • 10.6.1.0
    • Documentation
    • None
    • 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"!

      Attachments

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

        Activity

          People

            chaase3 Camilla Haase
            kristwaa Kristian Waagan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: