db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ma...@apache.org
Subject 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/
Date Thu, 02 Oct 2014 16:44:52 GMT
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,



Mime
View raw message