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.
Mamta On 5/6/05, Bernt M. Johnsen <[EMAIL PROTECTED]> 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 >
