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

Data type limitations on indexes should be in Reference Manual

    XMLWordPrintableJSON

    Details

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

      Description

      The Tuning Guide topic "Create useful indexes" (http://db.apache.org/derby/docs/10.10/tuning/ctundepth1002853.html) has the following excessively vague note at the end:

      "Note: Derby does not support indexing on columns with data types like BLOB, CLOB, and XML."

      The topic also has a cross-reference to the "CREATE INDEX statement" topic in the Derby Reference Manual, but that topic says nothing about data type limitations for index columns.

      In an email exchange, Knut says that LONG VARCHAR and user-defined types should be added to make the list complete, but he also suggests moving this information from the tuning guide to the "CREATE INDEX statement" topic in the Reference Manual, since we already reference that topic and since the information needs to be there.

        Attachments

        1. DERBY-6653.zip
          7 kB
          Camilla Haase
        2. DERBY-6653.stat
          0.1 kB
          Camilla Haase
        3. DERBY-6653.diff
          2 kB
          Camilla Haase

          Activity

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              chaase3 Camilla Haase
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: