You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ma...@apache.org on 2014/10/02 18:44:52 UTC
svn commit: r1629014 - in /db/derby/code/trunk/java:
engine/org/apache/derby/impl/sql/execute/ engine/org/apache/derby/loc/
testing/org/apache/derbyTesting/functionTests/master/
Author: mamta
Date: Thu Oct 2 16:44:52 2014
New Revision: 1629014
URL: http://svn.apache.org/r1629014
Log:
DERBY-6269(Misleading warning text if you create an index duplicating a constraint.)
Improve the warning text if a user requests an index creation which duplicates a constraint.
Modified:
db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/CreateIndexConstantAction.java
db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions3.out
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/CreateIndexConstantAction.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/CreateIndexConstantAction.java?rev=1629014&r1=1629013&r2=1629014&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/CreateIndexConstantAction.java (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/CreateIndexConstantAction.java Thu Oct 2 16:44:52 2014
@@ -545,6 +545,7 @@ class CreateIndexConstantAction extends
activation.addWarning(
StandardException.newWarning(
SQLState.LANG_INDEX_DUPLICATE,
+ indexName,
cd.getConglomerateName()));
return;
Modified: db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml?rev=1629014&r1=1629013&r2=1629014&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml Thu Oct 2 16:44:52 2014
@@ -144,8 +144,9 @@ Guide.
<msg>
<name>01504</name>
- <text>The new index is a duplicate of an existing index: {0}.</text>
- <arg>indexName</arg>
+ <text>'{0}' index not created because it is a duplicate of an existing index: '{1}'.</text>
+ <arg>newIndexName</arg>
+ <arg>existingIndexName</arg>
</msg>
<msg>
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out?rev=1629014&r1=1629013&r2=1629014&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/desc_index.out Thu Oct 2 16:44:52 2014
@@ -855,20 +855,20 @@ create table tab2 (c1 int not null prima
ij> -- not unique index, shouldn't share with primary key's index
create index i21 on tab2(c1);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'I21' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> -- desc index, shouldn't share with primary key's index
create index i22 on tab2(c1 desc);
0 rows inserted/updated/deleted
ij> -- this should share with primary key's index, and give a warning
create unique index i23 on tab2(c1);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'I23' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> create index i24 on tab2(c1, c3 desc);
0 rows inserted/updated/deleted
ij> -- this should share with i24's conglomerate
create index i25 on tab2(c1, c3 desc);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: I24.
+WARNING 01504: 'I25' index not created because it is a duplicate of an existing index: 'I24'.
ij> -- no share
create index i26 on tab2(c1, c3);
0 rows inserted/updated/deleted
@@ -882,10 +882,10 @@ create index i28 on tab2 (c1, c2 desc, c
ij> -- share with i27
create index i29 on tab2 (c1, c2 desc, c3);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: I27.
+WARNING 01504: 'I29' index not created because it is a duplicate of an existing index: 'I27'.
ij> create index i20 on tab2 (c1, c2 desc, c3);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: I27.
+WARNING 01504: 'I20' index not created because it is a duplicate of an existing index: 'I27'.
ij> insert into tab2 values (56, 2, 7), (31, 5, 7), (-12, 5, 2);
3 rows inserted/updated/deleted
ij> select count(distinct conglomeratenumber) from sys.sysconglomerates
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out?rev=1629014&r1=1629013&r2=1629014&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out Thu Oct 2 16:44:52 2014
@@ -1273,7 +1273,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1372,7 +1372,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1471,7 +1471,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1524,7 +1524,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1595,7 +1595,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1677,7 +1677,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1759,7 +1759,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1813,7 +1813,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1867,7 +1867,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1921,7 +1921,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -1978,7 +1978,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2116,7 +2116,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2215,7 +2215,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2314,7 +2314,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2367,7 +2367,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2438,7 +2438,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2520,7 +2520,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2602,7 +2602,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2656,7 +2656,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2710,7 +2710,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2764,7 +2764,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -2821,7 +2821,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -7767,7 +7767,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -7873,7 +7873,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -7972,7 +7972,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8027,7 +8027,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8098,7 +8098,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8184,7 +8184,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8266,7 +8266,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8321,7 +8321,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8375,7 +8375,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8431,7 +8431,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8490,7 +8490,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8628,7 +8628,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8734,7 +8734,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8833,7 +8833,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8888,7 +8888,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -8959,7 +8959,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -9045,7 +9045,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -9127,7 +9127,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -9182,7 +9182,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -9236,7 +9236,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -9291,7 +9291,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -9350,7 +9350,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -14510,7 +14510,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -14652,7 +14652,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -14797,7 +14797,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -14856,7 +14856,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -14940,7 +14940,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15041,7 +15041,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15144,7 +15144,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15202,7 +15202,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15260,7 +15260,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15318,7 +15318,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15381,7 +15381,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15520,7 +15520,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15662,7 +15662,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15807,7 +15807,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15866,7 +15866,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -15950,7 +15950,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -16051,7 +16051,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -16154,7 +16154,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -16212,7 +16212,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -16270,7 +16270,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -16328,7 +16328,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -16391,7 +16391,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -21935,7 +21935,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22035,7 +22035,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22135,7 +22135,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22189,7 +22189,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22261,7 +22261,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22344,7 +22344,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22427,7 +22427,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22490,7 +22490,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22554,7 +22554,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22612,7 +22612,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22675,7 +22675,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22817,7 +22817,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -22917,7 +22917,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23017,7 +23017,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23071,7 +23071,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23143,7 +23143,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23226,7 +23226,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23309,7 +23309,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23372,7 +23372,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23436,7 +23436,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23497,7 +23497,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
@@ -23565,7 +23565,7 @@ ij(CONNECTION1)> -- RESOLVE: missing row
-- to force the statement to be recompiled
create index ix1 on a(a);
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: A_IDX.
+WARNING 01504: 'IX1' index not created because it is a duplicate of an existing index: 'A_IDX'.
ij(CONNECTION1)> drop index ix1;
ERROR 42X65: Index 'IX1' does not exist.
ij(CONNECTION1)> commit;
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions3.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions3.out?rev=1629014&r1=1629013&r2=1629014&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions3.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions3.out Thu Oct 2 16:44:52 2014
@@ -45,7 +45,7 @@ ij> CREATE INDEX IX20B ON APP_DESC ( GUI
0 rows inserted/updated/deleted
ij> CREATE INDEX IX20C ON APP_DESC ( PARENT_OID );
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'IX20C' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> CREATE TABLE APP_DESC_DD (
APP_DESC_OID INTEGER NOT NULL,
NAME VARCHAR(255) NOT NULL,
@@ -89,7 +89,7 @@ ij> CREATE INDEX IX40D ON PORT_DESC ( RE
0 rows inserted/updated/deleted
ij> CREATE INDEX IX40E ON PORT_DESC ( APP_DESC_OID );
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'IX40E' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> CREATE TABLE PORT_DESC_LOD (
PORT_DESC_OID INTEGER NOT NULL,
LOCALE VARCHAR(64) NOT NULL,
@@ -347,10 +347,10 @@ ij> CREATE TABLE COMP_INST (
0 rows inserted/updated/deleted
ij> CREATE INDEX IX320A ON COMP_INST ( PAGE_INST_OID );
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'IX320A' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> CREATE INDEX IX320B ON COMP_INST ( PORT_INST_OID );
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'IX320B' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> CREATE TABLE COMP_INST_LOD (
COMP_INST_OID INTEGER NOT NULL,
LOCALE VARCHAR(64) NOT NULL,
@@ -486,7 +486,7 @@ ij> CREATE INDEX IX410B ON CRED_SLOT ( R
0 rows inserted/updated/deleted
ij> CREATE INDEX IX410C ON CRED_SLOT ( SEGMENT_OID );
0 rows inserted/updated/deleted
-WARNING 01504: The new index is a duplicate of an existing index: xxxxGENERATED-IDxxxx.
+WARNING 01504: 'IX410C' index not created because it is a duplicate of an existing index: 'xxxxGENERATED-IDxxxx'.
ij> CREATE TABLE CRED_SLOT_LOD (
CRED_SLOT_OID INTEGER NOT NULL,
LOCALE VARCHAR(64) NOT NULL,