db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: Qouted index names
Date Fri, 06 May 2005 13:17:00 GMT
Hi Brent,

The warning is not for the index name. It is because the 2nd index is
getting defined on the same column as the first index.


On 5/6/05, Bernt M. Johnsen <Bernt.Johnsen@sun.com> wrote:
> Hi!
> Is there a reason for handling quoted index names different from other
> quoted names? As I understand SQL, i1 and "i1" are different
> identifiers, also for indexes, but derby gives warning:
> ij> create index i1 on t1 (i);
> 0 rows inserted/updated/deleted
> ij> create index "i1" on t1 (i);
> 0 rows inserted/updated/deleted
> WARNING 01504: The new index is a duplicate of an existing index: I1.
> A minor detail, but if nobody objects, I'll file an issue.
> --
> Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Norway

View raw message