Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1BDA91152C for ; Fri, 11 Jul 2014 13:47:05 +0000 (UTC) Received: (qmail 82324 invoked by uid 500); 11 Jul 2014 13:47:04 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 82297 invoked by uid 500); 11 Jul 2014 13:47:04 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 82286 invoked by uid 99); 11 Jul 2014 13:47:04 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Jul 2014 13:47:04 +0000 Date: Fri, 11 Jul 2014 13:47:04 +0000 (UTC) From: "Kim Haase (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (DERBY-6653) Data type limitations on indexes should be in Reference Manual MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase resolved DERBY-6653. ------------------------------ Resolution: Fixed Fix Version/s: 10.11.0.0 Issue & fix info: (was: Patch Available) Committed patch DERBY-6653.diff to documentation trunk at revision 1609713. Thanks for the review, Knut. > Data type limitations on indexes should be in Reference Manual > -------------------------------------------------------------- > > Key: DERBY-6653 > URL: https://issues.apache.org/jira/browse/DERBY-6653 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.11.0.0 > Reporter: Kim Haase > Assignee: Kim Haase > Priority: Minor > Fix For: 10.11.0.0 > > Attachments: DERBY-6653.diff, DERBY-6653.stat, DERBY-6653.zip > > > 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. -- This message was sent by Atlassian JIRA (v6.2#6252)