Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: neutral (hermes.apache.org: local policy)
Message-ID: <421261C4.30605@debrunners.com>
Date: Tue, 15 Feb 2005 12:55:32 -0800
From: Daniel John Debrunner <djd@debrunners.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.7.3) Gecko/20040910
MIME-Version: 1.0
To: Derby Development <derby-dev@db.apache.org>
Subject: Re: SQL identifier lengths
References: <ECEC7AB77336EE36200EB153@[10.0.1.2]>
In-Reply-To: <ECEC7AB77336EE36200EB153@[10.0.1.2]>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

thomas wrote:

> Hi,
> 
> i tried to use Derby as backend for the DaisyWiki CMS, because i'd like
> to get an solution. Currently Daisy only supports MySQL, with PostgreSQL
> being in the works. The main problem i ran into was the very constrained
> length of SQL identifiers in Derby.
> 
> I found this issue on the ToDo-List
> (<http://incubator.apache.org/derby/DerbyToDo.html>, Increased SQL
> identifier lengths) and also a discussion-thread which seemed to come to
> a consensus that support for longer SQL identifier should be added,
> since it wouldn't break backward-compatibility with DB2 but improve
> support for the SQL-standard
> <http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200409.mbox/%3c8D5A122E-09AB-11D9-8965-000A95782782@apache.org%3e>.
> 
> 
> Although this sounds quite promising to me, it seems like there hasn't
> been a vote taken  until now and nobody is working on it. Is this
> correct? Or are there any estimates possible on when a patch will be
> available? Or how much work it would be to develop that patch oneself -
> given some experience with java but none with Derby or other
> java-SQL-databases?

The patch already exists, but it doesn't pass the tests cleanly. Some
work is needed to ensure the test outputs are correct and re-issue the
patch with the changes to the tests. The orignal patch is here:

http://nagoya.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1377

and my latest comments on it.

http://mail-archives.eu.apache.org/mod_mbox/db-derby-dev/200502.mbox/%3c42026E14.8000007@debrunners.com%3e

Dan.