Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Tue, 10 Jun 2008 16:11:32 +0200
From: Knut Anders Hatlen <Knut.Hatlen@Sun.COM>
Subject: Re: case-insensitive searching
In-reply-to: <90540.67004.qm@web31808.mail.mud.yahoo.com>
Sender: Knut.Hatlen@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <wjo8zlpt2xd7.fsf@khepri41.norway.sun.com>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
References: <90540.67004.qm@web31808.mail.mud.yahoo.com>
User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/22.2 (usg-unix-v)

Geoff hendrey <geoff_hendrey@yahoo.com> writes:

> Hi Guys,
>
> I was wondering what is being done for case-insensitive
> comparisons. Also wanted to propose an implementation option, which
> would be to allow indexes to be created on UPPER or LOWER. As long as
> I had an index on UPPER or LOWER, I could do this efficiently:
>
> WHERE UPPER(T1.lastname) = UPPER(T2.lastname)
>
> Is that a totally crazy suggestion, to allow indexes to be created on
> UPPER and LOWER? Maybe this is easy to implement.

Hi Geoff,

It's not a crazy suggestion at all. We already have some similar feature
requests in the bug tracker. I think DERBY-455 is more or less the same
idea, but you may also take a look at some other JIRAs:

https://issues.apache.org/jira/browse/DERBY-455
https://issues.apache.org/jira/browse/DERBY-481
https://issues.apache.org/jira/browse/DERBY-1748

DERBY-481 (implement SQL generated columns) has had some activity
recently, but I don't know if anyone is planning to implement it.

-- 
Knut Anders