db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Qouted index names
Date Fri, 06 May 2005 13:25:39 GMT
>>>>>>>>>>>> Mamta Satoor wrote (2005-05-06 06:17:00):
> 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.

Thanks. I should have thought of that.  

But the second index is not created. Shouldn't the warning have been
an error (since two consecutive creations cannot be followed by two
corresponding drops)?

ij> create index x1 on tab1(i);
0 rows inserted/updated/deleted
ij> create index x2 on tab1(i);
0 rows inserted/updated/deleted
WARNING 01504: The new index is a duplicate of an existing index: X1.
ij> drop index x2;
ERROR 42X65: Index 'X2' does not exist.
ij> drop index x1;
0 rows inserted/updated/deleted

Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Norway

View raw message