db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From banda...@apache.org
Subject svn commit: r409578 [1/2] - in /db/derby/code/trunk/java: engine/org/apache/derby/loc/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/org/apache/derbyTesting/functionTests/ma...
Date Fri, 26 May 2006 07:24:00 GMT
Author: bandaram
Date: Fri May 26 00:23:58 2006
New Revision: 409578

URL: http://svn.apache.org/viewvc?rev=409578&view=rev
Log:
DERBY-1072: Fix misleading error while droping a view.

Submitted by Mayuresh Nirhali(Mayuresh.Nirhali@Sun.COM)

Modified:
    db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/csPrepStmt.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/prepStmt.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/supersimple.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/synonym.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/csPrepStmt.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/prepStmt.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/supersimple.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testij.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/altertable.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkConstraint.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/csPrepStmt.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJava.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJavaJDBC30.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/depend.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml147.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dropTable.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevokeDDL.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/holdCursorJavaReflection.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevoke.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/prepStmt.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/renameTable.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/statementJdbc20.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testij.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/views.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevoke.java

Modified: db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties Fri May 26 00:23:58 2006
@@ -481,7 +481,7 @@
 42X02={0}.
 42X03=Column name ''{0}'' is in more than one table in the FROM list.
 42X04=Column ''{0}'' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then ''{0}'' is not a column in the target table.
-42X05=Table ''{0}'' does not exist.
+42X05=Table/View ''{0}'' does not exist.
 42X06=Too many result columns specified for table ''{0}''.
 42X07=Null is only allowed in a VALUES clause within an INSERT statement.
 42X08=The constructor for class ''{0}'' cannot be used as an external virtual table because the class does not implement ''{1}''. 
@@ -978,7 +978,7 @@
 
 X0X02.S=Table ''{0}'' cannot be locked in ''{1}'' mode.
 X0X03.S=Invalid transaction state - held cursor requires same isolation level
-X0X05.S=Table ''{0}'' does not exist.
+X0X05.S=Table/View ''{0}'' does not exist.
 X0X0E.S=The column position ''{0}'' listed in the auto-generated column selection array was not found in the insert table. 
 X0X0F.S=Column name ''{0}'' listed in auto-generated column selection array not found in the insert table.
 X0X07.S=Cannot remove jar file ''{0}'' because it is on your derby.database.classpath ''{0}''.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out Fri May 26 00:23:58 2006
@@ -780,7 +780,7 @@
 ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression. SQLSTATE: 42Y07: Schema 'GROUP' does not exist
 ij> --following export should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table 'Group.ORDER' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table/View 'Group.ORDER' does not exist.
 ij> --following export should fail because of unquoted table name that is a reserved word.
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group".Order' , 'extinout/order.dat' ,    null , null , null ) ;
 ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression. SQLSTATE: 42X01: Syntax error: Encountered "Order" at line 1, column 23.
@@ -863,7 +863,7 @@
 ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression. SQLSTATE: 42Y07: Schema 'inventory' does not exist
 ij> --following export should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table 'INVENTORY.ordertable' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table/View 'INVENTORY.ordertable' does not exist.
 ij> --following export should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
 Statement executed.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/csPrepStmt.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/csPrepStmt.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/csPrepStmt.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/csPrepStmt.out Fri May 26 00:23:58 2006
@@ -53,7 +53,7 @@
 SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 32.
 Expected Table does not exist 
 insertTab ( wrongtab,1000)
-SQLState: 42X05 message: Table 'WRONGTAB' does not exist.
+SQLState: 42X05 message: Table/View 'WRONGTAB' does not exist.
 Minimum BigDecimal Value: 1E-15
 Prepared Statement String: update Numeric_Tab set NULL_VAL=?
 Select NULL_VAL from Numeric_Tab

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/prepStmt.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/prepStmt.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/prepStmt.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/prepStmt.out Fri May 26 00:23:58 2006
@@ -53,7 +53,7 @@
 SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 29.
 Expected Table does not exist 
 insertTab ( wrongtab,1000)
-SQLState: 42X05 message: Table 'WRONGTAB' does not exist.
+SQLState: 42X05 message: Table/View 'WRONGTAB' does not exist.
 CREATE TABLE doubletab (i int, doubleVal DOUBLE)
 testBigDecimalToDoubleConversion().
  Check that values are preserved when BigDecimal 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/supersimple.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/supersimple.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/supersimple.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/supersimple.out Fri May 26 00:23:58 2006
@@ -134,7 +134,7 @@
 ij(CONNECTION1)> disconnect;
 ij> set connection connection0;
 ij> select count(*) from a;
-ERROR 42X05: Table 'A' does not exist.
+ERROR 42X05: Table/View 'A' does not exist.
 ij> -- Bug 4758 - Store error does not return properly to client
 autocommit off;
 ij> create table t (i int);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/synonym.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/synonym.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/synonym.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/synonym.out Fri May 26 00:23:58 2006
@@ -225,7 +225,7 @@
 0 rows inserted/updated/deleted
 WARNING 01522: The newly defined synonym 'SYN1' resolved to the object 'JUNKSCHEMA.TABLE2' which is currently undefined. : 
 ij> select * from junkSchema.syn1;
-ERROR 42X05: Table 'JUNKSCHEMA.TABLE2' does not exist.
+ERROR 42X05: Table/View 'JUNKSCHEMA.TABLE2' does not exist.
 ij> set schema junkSchema;
 0 rows inserted/updated/deleted
 ij> create table table2(c char(10));
@@ -346,7 +346,7 @@
 0 rows inserted/updated/deleted
 ij> -- Previously compiled cached statement should get invalidated
 select * from mySynonym;
-ERROR 42X05: Table 'MYSYNONYM' does not exist.
+ERROR 42X05: Table/View 'MYSYNONYM' does not exist.
 ij> create synonym mySyn for table1;
 0 rows inserted/updated/deleted
 ij> create view v1 as select * from mySyn;
@@ -373,7 +373,7 @@
 0 rows inserted/updated/deleted
 WARNING 01522: The newly defined synonym 'MULTISCHEMA' resolved to the object 'TESTSCHEMA.TESTTAB' which is currently undefined. : 
 ij> select * from multiSchema;
-ERROR 42X05: Table 'TESTSCHEMA.TESTTAB' does not exist.
+ERROR 42X05: Table/View 'TESTSCHEMA.TESTTAB' does not exist.
 ij> create table testSchema.testtab(i int, c char(10));
 0 rows inserted/updated/deleted
 ij> insert into testSchema.testtab values (1, 'synonym');

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out Fri May 26 00:23:58 2006
@@ -780,7 +780,7 @@
 ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression. SQLSTATE: 42Y07: Schema 'GROUP' does not exist
 ij> --following export should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table 'Group.ORDER' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table/View 'Group.ORDER' does not exist.
 ij> --following export should fail because of unquoted table name that is a reserved word.
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group".Order' , 'extinout/order.dat' ,    null , null , null ) ;
 ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression. SQLSTATE: 42X01: Syntax error: Encountered "Order" at line 1, column 23.
@@ -863,7 +863,7 @@
 ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression. SQLSTATE: 42Y07: Schema 'inventory' does not exist
 ij> --following export should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table 'INVENTORY.ordertable' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression. SQLSTATE: 42X05: Table/View 'INVENTORY.ordertable' does not exist.
 ij> --following export should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
 Statement executed.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/csPrepStmt.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/csPrepStmt.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/csPrepStmt.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/csPrepStmt.out Fri May 26 00:23:58 2006
@@ -53,7 +53,7 @@
 SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 32.
 Expected Table does not exist 
 insertTab ( wrongtab,1000)
-SQLState: 42X05 message: Table 'WRONGTAB' does not exist.
+SQLState: 42X05 message: Table/View 'WRONGTAB' does not exist.
 Minimum BigDecimal Value: 1E-15
 Prepared Statement String: update Numeric_Tab set NULL_VAL=?
 Select NULL_VAL from Numeric_Tab

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/prepStmt.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/prepStmt.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/prepStmt.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk15/prepStmt.out Fri May 26 00:23:58 2006
@@ -53,7 +53,7 @@
 SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 29.
 Expected Table does not exist 
 insertTab ( wrongtab,1000)
-SQLState: 42X05 message: Table 'WRONGTAB' does not exist.
+SQLState: 42X05 message: Table/View 'WRONGTAB' does not exist.
 CREATE TABLE doubletab (i int, doubleVal DOUBLE)
 testBigDecimalToDoubleConversion().
  Check that values are preserved when BigDecimal 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/supersimple.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/supersimple.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/supersimple.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/supersimple.out Fri May 26 00:23:58 2006
@@ -134,7 +134,7 @@
 ij(CONNECTION1)> disconnect;
 ij> set connection connection0;
 ij> select count(*) from a;
-ERROR 42X05: Table 'A' does not exist.
+ERROR 42X05: Table/View 'A' does not exist.
 ij> -- Bug 4758 - Store error does not return properly to client
 autocommit off;
 ij> create table t (i int);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out Fri May 26 00:23:58 2006
@@ -225,7 +225,7 @@
 0 rows inserted/updated/deleted
 WARNING 01522: The newly defined synonym 'SYN1' resolved to the object 'JUNKSCHEMA.TABLE2' which is currently undefined. : 
 ij> select * from junkSchema.syn1;
-ERROR 42X05: Table 'JUNKSCHEMA.TABLE2' does not exist.
+ERROR 42X05: Table/View 'JUNKSCHEMA.TABLE2' does not exist.
 ij> set schema junkSchema;
 0 rows inserted/updated/deleted
 ij> create table table2(c char(10));
@@ -346,7 +346,7 @@
 0 rows inserted/updated/deleted
 ij> -- Previously compiled cached statement should get invalidated
 select * from mySynonym;
-ERROR 42X05: Table 'MYSYNONYM' does not exist.
+ERROR 42X05: Table/View 'MYSYNONYM' does not exist.
 ij> create synonym mySyn for table1;
 0 rows inserted/updated/deleted
 ij> create view v1 as select * from mySyn;
@@ -373,7 +373,7 @@
 0 rows inserted/updated/deleted
 WARNING 01522: The newly defined synonym 'MULTISCHEMA' resolved to the object 'TESTSCHEMA.TESTTAB' which is currently undefined. : 
 ij> select * from multiSchema;
-ERROR 42X05: Table 'TESTSCHEMA.TESTTAB' does not exist.
+ERROR 42X05: Table/View 'TESTSCHEMA.TESTTAB' does not exist.
 ij> create table testSchema.testtab(i int, c char(10));
 0 rows inserted/updated/deleted
 ij> insert into testSchema.testtab values (1, 'synonym');

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testij.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testij.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testij.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/testij.out Fri May 26 00:23:58 2006
@@ -19,7 +19,7 @@
 disconnect all;
 ij> connect 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/junk;create=true' USER 'dbadmin' PASSWORD 'dbadbmin';
 ij> select * from APP.notthere;
-ERROR 42X05: Table 'APP.NOTTHERE' does not exist.
+ERROR 42X05: Table/View 'APP.NOTTHERE' does not exist.
 ij> -- examples from the docs
 connect 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat;create=true;user=judy;password=judy';
 ij(CONNECTION1)> connect 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/./wombat;user=judy;password=judy';
@@ -52,7 +52,7 @@
 ij(CONNECTION13)> connect 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/my-db-name;create=true;user=usr;password=pwd;retrieveMessageText=true';
 ij(CONNECTION14)> -- Should see message text
 select * from APP.notthere;
-ERROR 42X05: Table 'APP.NOTTHERE' does not exist.
+ERROR 42X05: Table/View 'APP.NOTTHERE' does not exist.
 ij(CONNECTION14)> -- just user security mechanism
 connect 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/my-db-name;create=true;user=usr;retrieveMessageText=true';
 ij(CONNECTION15)> connect 'jdbc:derby://xxxFILTERED_HOSTNAMExxx:1527/wombat' USER 'APP';

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out Fri May 26 00:23:58 2006
@@ -172,11 +172,11 @@
 ij> insert into c values('123456');
 ERROR 22001: A truncation error was encountered trying to shrink CLOB '123456' to length 5.
 ij> insert into n values('1234');
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> insert into n values('12345');
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> insert into n values('123456');
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> --   ok
 insert into c values(cast('1234' as clob(5)));
 1 row inserted/updated/deleted
@@ -207,7 +207,7 @@
 12345
 12345
 ij> select * from n;
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> -- concatenate
 values cast('12' as clob(2)) || cast('34' as clob(2));
 1   
@@ -235,7 +235,7 @@
 12345
 12345
 ij> select * from n where n like '12%';
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> select * from b where b like cast('0102%' as blob(10));
 ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 ij> select * from c where c like cast('12%' as clob(10));
@@ -421,40 +421,40 @@
 ij> INSERT INTO testoperatornclob VALUES (CAST(cast('50' as varchar(80)) AS NCLOB(1K)));
 ERROR 0A000: Feature not implemented: NCLOB.
 ij> select * from testoperatornclob;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> -- these select statements should raise an error but are successful in cloudscape
 select * from testoperatornclob where colone > 10;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone > 5;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone < 70;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone = 50;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone != 10;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone <= 70;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone >= 10;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone <> 10;
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone > '10';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone > '5';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone < '70';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone = '50';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone != '10';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone <= '70';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone >= '10';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> select * from testoperatornclob where colone <> '10';
-ERROR 42X05: Table 'TESTOPERATORNCLOB' does not exist.
+ERROR 42X05: Table/View 'TESTOPERATORNCLOB' does not exist.
 ij> drop table testoperatornclob;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TESTOPERATORNCLOB' because it does not exist.
 ij> ----- test method invocations on LOB objects (should disallow)

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out Fri May 26 00:23:58 2006
@@ -81,7 +81,7 @@
 2                                                                                                                               
 2                                                                                                                               
 ij> select nclob from n;
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> -- comparsion using tables
 select * from b as b1, b as b2 where b1.blob=b2.blob;
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
@@ -100,7 +100,7 @@
 ij> select c.clob from c where c.clob = '2';
 ERROR 42818: Comparisons between 'CLOB' and 'CHAR' are not supported.
 ij> select n.nclob from n where n.nclob = '3';
-ERROR 42X05: Table 'N' does not exist.
+ERROR 42X05: Table/View 'N' does not exist.
 ij> -- ORDER tests on LOB types (not allowed)
 select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1111' as blob(5));
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/altertable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/altertable.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/altertable.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/altertable.out Fri May 26 00:23:58 2006
@@ -266,7 +266,7 @@
 drop view vw1;
 0 rows inserted/updated/deleted
 ij> select * from vw1;
-ERROR 42X05: Table 'VW1' does not exist.
+ERROR 42X05: Table/View 'VW1' does not exist.
 ij> -- do the indexes still exist?
 -- the create index statements should fail
 create index i13 on tab1 (c3, c1, c4);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkConstraint.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkConstraint.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkConstraint.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkConstraint.out Fri May 26 00:23:58 2006
@@ -251,17 +251,17 @@
 create table intTab (c1 int check(INT(1) = c1));
 ERROR 42X01: Syntax error: Encountered "INT" at line 3, column 35.
 ij> insert into intTab values 1;
-ERROR 42X05: Table 'INTTAB' does not exist.
+ERROR 42X05: Table/View 'INTTAB' does not exist.
 ij> -- this insert should fail, does not satisfy check constraint
 insert into intTab values 2;
-ERROR 42X05: Table 'INTTAB' does not exist.
+ERROR 42X05: Table/View 'INTTAB' does not exist.
 ij> create table maxIntTab (c1 int check(INT(2147483647) > c1));
 ERROR 42X01: Syntax error: Encountered "INT" at line 1, column 38.
 ij> insert into maxIntTab values 1;
-ERROR 42X05: Table 'MAXINTTAB' does not exist.
+ERROR 42X05: Table/View 'MAXINTTAB' does not exist.
 ij> -- this insert should fail, does not satisfy check constraint
 insert into maxIntTab values 2147483647;
-ERROR 42X05: Table 'MAXINTTAB' does not exist.
+ERROR 42X05: Table/View 'MAXINTTAB' does not exist.
 ij> rollback;
 ij> -- verify that inserts, updates and statements with forced constraints are
 -- indeed dependent on the constraints

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/csPrepStmt.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/csPrepStmt.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/csPrepStmt.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/csPrepStmt.out Fri May 26 00:23:58 2006
@@ -53,7 +53,7 @@
 SQLState: 42X01 message: Syntax error: Encountered "<EOF>" at line 1, column 32.
 Expected Table does not exist 
 insertTab ( wrongtab,1000)
-SQLState: 42X05 message: Table 'WRONGTAB' does not exist.
+SQLState: 42X05 message: Table/View 'WRONGTAB' does not exist.
 Minimum BigDecimal Value: 0.000000000000001
 Prepared Statement String: update Numeric_Tab set NULL_VAL=?
 Select NULL_VAL from Numeric_Tab

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out Fri May 26 00:23:58 2006
@@ -4733,7 +4733,7 @@
 Creating database 'wombat_new' from ddl script 'wombat.sql'
 FAILED: to execute cmd from DDL script:
 create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as b
-Table 'BAR.T3' does not exist.
+Table/View 'BAR.T3' does not exist.
 Dumping system tables for 'wombat_new'
 ----------------=================---------------
 System Tables for: wombat_new

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJava.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJava.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJava.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJava.out Fri May 26 00:23:58 2006
@@ -204,7 +204,7 @@
 	 1
 	 -
 	{1}
-Expected message: Table 'SESSION.T2' does not exist.
+Expected message: Table/View 'SESSION.T2' does not exist.
 TEST35A PASSED
 TEST35B : Temp table in one connection should not conflict with temp table with same name in another connection
 	 C21,C22
@@ -223,7 +223,7 @@
 	 C21,C22
 	 --- ---
 	{21,1}
-Expected message: Table 'SESSION.T2' does not exist.
+Expected message: Table/View 'SESSION.T2' does not exist.
 TEST37A PASSED
 TEST37B : Prepared statement test - drop and recreate the temp table with different definition underneath
 	 C21,C22
@@ -236,7 +236,7 @@
 	 --- ---
 	{21,1}
 TEST38A : select should fail since temp table got dropped as part of rollback
-Expected message: Table 'SESSION.T2' does not exist.
+Expected message: Table/View 'SESSION.T2' does not exist.
 TEST38A PASSED
 TEST38B : Rollback behavior - declare temp table, commit, drop temp table, rollback, select should pass
 	 C21,C22
@@ -256,7 +256,7 @@
 	 --- --- ---
 	{1,1,1}
   Drop temp table t2 (with 3 columns)
-  Attempted to select from temp table t2 but it failed as expected with exception Table 'SESSION.T2' does not exist.
+  Attempted to select from temp table t2 but it failed as expected with exception Table/View 'SESSION.T2' does not exist.
   Declare temp table t2 again but this time with 2 columns
 	 C21,C22
 	 --- ---
@@ -353,7 +353,7 @@
 	{52,2}
 	{53,3}
   temp table t6 got dropped as part of rollback of this transaction since it was declared in this same transaction
-  Attempted to select from temp table t6 but it failed as expected with exception Table 'SESSION.T6' does not exist.
+  Attempted to select from temp table t6 but it failed as expected with exception Table/View 'SESSION.T6' does not exist.
 TEST38D PASSED
 TEST39A : Verify that there is no entry in system catalogs for temporary tables
  Declare a temp table T2 and check system catalogs. Shouldn't find anything. Then drop the temp table

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJavaJDBC30.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJavaJDBC30.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJavaJDBC30.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/declareGlobalTempTableJavaJDBC30.out Fri May 26 00:23:58 2006
@@ -70,11 +70,11 @@
 	 --- ---
 	{11,1}
   Create savepoint 2, drop temp table t1, rollback savepoint 2
-Expected message: Table 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
   select should pass, rollback savepoint 1, select should fail
 	 C11,C12
 	 --- ---
-Expected message: Table 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
 TEST3A PASSED
 TEST3B : Savepoint and Rollback behavior
  In the transaction:
@@ -87,8 +87,8 @@
 	 --- ---
   Drop temp table t2(explicit drop), rollback transaction(implicit drop of t1)
   Select from temp table t1 and t2 will fail
-Expected message: Table 'SESSION.T1' does not exist.
-Expected message: Table 'SESSION.T2' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T2' does not exist.
 TEST3B PASSED
 TEST3C : Savepoint and Rollback behavior
  In the transaction:
@@ -106,8 +106,8 @@
 	 C21,C22
 	 --- ---
   Rollback transaction and select from temp tables t1 and t2 should fail
-Expected message: Table 'SESSION.T1' does not exist.
-Expected message: Table 'SESSION.T2' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T2' does not exist.
 TEST3C PASSED
 TEST3D : Savepoint and Rollback behavior
  In the transaction:
@@ -125,7 +125,7 @@
   Create savepoint1 and declare temp table t1
   Create savepoint2 and drop temp table t1
   Rollback savepoint 1 and select from temp table t1 should fail
-Expected message: Table 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
 TEST3E PASSED
 TEST3F : Savepoint and Rollback behavior
  In the transaction:
@@ -133,7 +133,7 @@
 	 C11,C12
 	 --- ---
   rollback, select on t1 should fail
-Expected message: Table 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
 TEST3F PASSED
 TEST3G : Savepoint and Rollback behavior
  In the transaction:
@@ -152,14 +152,14 @@
 	 --- ---
  In the transaction:
   drop temp table t1 and commit, select on t1 should fail
-Expected message: Table 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
 TEST3H PASSED
 TEST3I : Savepoint and Rollback behavior
  In the transaction:
   declare temp table t1 and rollback
 	 C11,C12
 	 --- ---
-Expected message: Table 'SESSION.T1' does not exist.
+Expected message: Table/View 'SESSION.T1' does not exist.
 TEST3I PASSED
 TEST3J : Savepoint and Rollback behavior
  In the transaction:

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/depend.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/depend.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/depend.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/depend.out Fri May 26 00:23:58 2006
@@ -51,19 +51,19 @@
 0 rows inserted/updated/deleted
 ij> -- these should fail, can't find table
 execute ins;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel2;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute upd;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute del;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel_s;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute ins_sel;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> create table t(i int);
 0 rows inserted/updated/deleted
 ij> -- these should recompile and work, table now found
@@ -104,17 +104,17 @@
 ij> rollback;
 ij> -- these should fail, the table will disappear at the rollback
 execute ins;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel2;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel_s;
-ERROR 42X05: Table 'S' does not exist.
+ERROR 42X05: Table/View 'S' does not exist.
 ij> execute upd;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute del;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> -- recreate t again
 create table t(i int);
 0 rows inserted/updated/deleted
@@ -136,17 +136,17 @@
 0 rows inserted/updated/deleted
 ij> -- verify that invalidate worked this time
 execute ins;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute sel2;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute upd;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute del;
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
 ij> execute ins_sel;
-ERROR 42X05: Table 'S' does not exist.
+ERROR 42X05: Table/View 'S' does not exist.
 ij> -- cleanup, roll everything back to the beginning
 rollback;
 ij> -- verify that cascading invalidations work

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml147.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml147.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml147.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml147.out Fri May 26 00:23:58 2006
@@ -18,7 +18,7 @@
 ij> -- PASS:0840 If table is created?
    ROLLBACK WORK;
 ij> INSERT INTO NOT_THERE VALUES ('1234567890');
-ERROR 42X05: Table 'NOT_THERE' does not exist.
+ERROR 42X05: Table/View 'NOT_THERE' does not exist.
 ij> -- PASS:0840 If ERROR, syntax error/access violation, 0 rows selected?
    ROLLBACK WORK;
 ij> CREATE VIEW NOT_HERE AS
@@ -27,7 +27,7 @@
 ij> -- PASS:0840 If view is created?
    ROLLBACK WORK;
 ij> SELECT COUNT (*) FROM NOT_HERE;
-ERROR 42X05: Table 'NOT_HERE' does not exist.
+ERROR 42X05: Table/View 'NOT_HERE' does not exist.
 ij> -- PASS:0840 If ERROR, syntax error/access violation, 0 rows selected?
    ROLLBACK WORK;
 ij> ALTER TABLE USIG

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml149.out Fri May 26 00:23:58 2006
@@ -83,7 +83,7 @@
    INSERT INTO NO_DUCK
 --O  SELECT 22.22, CAST (C1 AS FLOAT), 0, C1 FROM HU.ECCO;
   SELECT 22.22, CAST (C1 AS FLOAT), 0, C1 FROM ECCO;
-ERROR 42X05: Table 'ECCO' does not exist.
+ERROR 42X05: Table/View 'ECCO' does not exist.
 ij> -- PASS:0846 If ERROR, invalid character value for cast, 0 rows inserted?
    INSERT INTO NO_DUCK
   SELECT 22.22, 2.222E1, CAST (C1 AS INT), 'QUACK!' FROM HU.ECCO;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dropTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dropTable.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dropTable.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dropTable.out Fri May 26 00:23:58 2006
@@ -10,21 +10,21 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 (a int);
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 (a int);
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> --
 -- test table with unique constraint - all should work
 --
@@ -34,21 +34,21 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 (a int not null unique);
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 (a int not null unique);
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> --
 -- test table with primary constraint - all should work
 --
@@ -58,21 +58,21 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 ( a int not null primary key);
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 ( a int not null primary key);
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> --
 -- test table with check constraint - all should work
 --
@@ -82,21 +82,21 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 ( a int check(a > 0));
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 ( a int check(a > 0));
 0 rows inserted/updated/deleted
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> --
 -- test table with index - all should work
 --
@@ -108,7 +108,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 (a int);
 0 rows inserted/updated/deleted
 ij> create index t1index on t1(a);
@@ -117,7 +117,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1 (a int);
 0 rows inserted/updated/deleted
 ij> create index t1index on t1(a);
@@ -126,7 +126,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> --
 -- test table with foreign key references;
 --
@@ -148,7 +148,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> -- the following should work since no referential constraint is left
 insert into t2 values(1);
 1 row inserted/updated/deleted
@@ -201,15 +201,15 @@
 0 rows inserted/updated/deleted
 ij> -- this shouldn't find the view
 select * from vt1a;
-ERROR 42X05: Table 'VT1A' does not exist.
+ERROR 42X05: Table/View 'VT1A' does not exist.
 ij> select * from vt1b;
-ERROR 42X05: Table 'VT1B' does not exist.
+ERROR 42X05: Table/View 'VT1B' does not exist.
 ij> select * from vt1t2;
-ERROR 42X05: Table 'VT1T2' does not exist.
+ERROR 42X05: Table/View 'VT1T2' does not exist.
 ij> select * from vvt1a;
-ERROR 42X05: Table 'VVT1A' does not exist.
+ERROR 42X05: Table/View 'VVT1A' does not exist.
 ij> select * from vvvt1a;
-ERROR 42X05: Table 'VVVT1A' does not exist.
+ERROR 42X05: Table/View 'VVVT1A' does not exist.
 ij> drop table t2;
 0 rows inserted/updated/deleted
 ij> --
@@ -222,7 +222,7 @@
 drop table t1;
 0 rows inserted/updated/deleted
 ij> execute t1stmt;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> remove t1stmt;
 ij> create table t1(a int);
 0 rows inserted/updated/deleted
@@ -231,7 +231,7 @@
 drop table t1;
 0 rows inserted/updated/deleted
 ij> execute t1stmt;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> remove t1stmt;
 ij> create table t1(a int);
 0 rows inserted/updated/deleted
@@ -240,7 +240,7 @@
 drop table t1;
 0 rows inserted/updated/deleted
 ij> execute t1stmt;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> remove t1stmt;
 ij> --
 -- test table with triggers
@@ -256,7 +256,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1(a int);
 0 rows inserted/updated/deleted
 ij> create trigger t1trig after insert on t1 for each row mode db2sql insert into t2 values(1);
@@ -266,7 +266,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> create table t1(a int);
 0 rows inserted/updated/deleted
 ij> create trigger t1trig after insert on t1 for each row mode db2sql insert into t2 values(1);
@@ -276,7 +276,7 @@
 0 rows inserted/updated/deleted
 ij> -- t1 shouldn't be found
 select * from t1;
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> drop table t2;
 0 rows inserted/updated/deleted
 ij> --
@@ -293,7 +293,7 @@
 0 rows inserted/updated/deleted
 ij> -- the following should get an error when trying to recompile the trigger action
 insert into t2 values(1);
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> drop table t2;
 0 rows inserted/updated/deleted
 ij> create table t1(a int);
@@ -307,7 +307,7 @@
 0 rows inserted/updated/deleted
 ij> -- the following should get an error when trying to recompile the trigger action
 insert into t2 values(1);
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> drop table t2;
 0 rows inserted/updated/deleted
 ij> create table t1(a int);
@@ -321,7 +321,7 @@
 0 rows inserted/updated/deleted
 ij> -- the following should get an error when trying to recompile the trigger action
 insert into t2 values(1);
-ERROR 42X05: Table 'T1' does not exist.
+ERROR 42X05: Table/View 'T1' does not exist.
 ij> drop table t2;
 0 rows inserted/updated/deleted
 ij> --

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Fri May 26 00:23:58 2006
@@ -2388,189 +2388,189 @@
 create table mynChar( a nchar(10), b nchar(20), c int );
 ERROR 0A000: Feature not implemented: NATIONAL CHAR.
 ij> insert into mynChar values( '1234567890', 'abcde1234567890fghij' );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( 'abcdefghij', 'abcdefghij1234567890' );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( 'abcdefghij', '1234567890abcdefghij' );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( 'abcdefghij', '1234567890!@#$%^&*()' );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( '1234567890', 'abcde1234567890fghij', 2 );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( 'abcdefghij', 'abcdefghij1234567890', 1  );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( 'abcdefghij', '1234567890abcdefghij', 15 );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar (c) values( 0 );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar (c) values( 1 );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar (c) values( 2 );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar (a) values( 'hello' );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar (b) values( 'hello' );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> insert into mynChar values( 'abcdefghij', '1234567890!@#$%^&*()', 21 );
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> select a, b, c from mynChar;
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> select locate(a, b) from mynChar;
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> select locate(a, b, c) from mynChar;
-ERROR 42X05: Table 'MYNCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNCHAR' does not exist.
 ij> drop table mynChar;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'MYNCHAR' because it does not exist.
 ij> create table myLongnVarChar( a long nvarchar, b long nvarchar, c int );
 ERROR 0A000: Feature not implemented: LONG NVARCHAR.
 ij> insert into myLongnVarChar values( '1234567890', 'abcde1234567890fghij' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcdefghij', 'abcdefghij1234567890' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcdefghij', '1234567890abcdefghij' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcdefghij', '1234567890!@#$%^&*()' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcde', 'abcde' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcde', 'abcd' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( '', 'abcde' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcde', null );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( null, 'abcde' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( '1234567890', 'abcde1234567890fghij', 2 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcdefghij', 'abcdefghij1234567890', 1 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcdefghij', '1234567890abcdefghij', 15 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcde', 'abcde', 1 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcde', 'abcd', 1 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( '', 'abcde', 2 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcde', null, 1  );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( null, 'abcde', 1 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar (c) values( 0 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar (c) values( 1 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar (c) values( 2 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar (a) values( 'hello' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar (b) values( 'hello' );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> insert into myLongnVarChar values( 'abcdefghij', '1234567890!@#$%^&*()', 21 );
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> select a, b, c from myLongnVarChar;
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> select locate(a, b) from myLongnVarChar;
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> select locate(a, b, c) from myLongnVarChar;
-ERROR 42X05: Table 'MYLONGNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYLONGNVARCHAR' does not exist.
 ij> drop table myLongnVarChar;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'MYLONGNVARCHAR' because it does not exist.
 ij> create table mynVarChar( a nvarchar(10), b nvarchar(20), c int );
 ERROR 0A000: Feature not implemented: NATIONAL CHAR VARYING.
 ij> insert into mynVarChar values( '1234567890', 'abcde1234567890fghij' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcdefghij', 'abcdefghij1234567890' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcdefghij', '1234567890abcdefghij' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcdefghij', '1234567890!@#$%^&*()' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcde', 'abcde' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcde', 'abcd' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( '', 'abcde' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcde', null );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( null, 'abcde' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( '1234567890', 'abcde1234567890fghij', 2 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcdefghij', 'abcdefghij1234567890', 1 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcdefghij', '1234567890abcdefghij', 15 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcde', 'abcde', 1 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcde', 'abcd', 1 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( '', 'abcde', 2 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcde', null, 1  );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( null, 'abcde', 1 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar (c) values( 0 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar (c) values( 1 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar (c) values( 2 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar (a) values( 'hello' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar (b) values( 'hello' );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into mynVarChar values( 'abcdefghij', '1234567890!@#$%^&*()', 21 );
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> select a, b, c from mynVarChar;
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> select locate(a, b) from mynVarChar;
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> select locate(a, b, c) from mynVarChar;
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> create table myMixed( a char(10), b long nvarchar, c int );
 ERROR 0A000: Feature not implemented: LONG NVARCHAR.
 ij> insert into myMixed values( '1234567890', 'abcde1234567890fghij' );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( 'abcdefghij', 'abcdefghij1234567890' );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( 'abcdefghij', '1234567890abcdefghij' );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( 'abcdefghij', '1234567890!@#$%^&*()' );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( '1234567890', 'abcde1234567890fghij', 2 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( 'abcdefghij', 'abcdefghij1234567890', 1 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( 'abcdefghij', '1234567890abcdefghij', 15 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed (c) values( 0 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed (c) values( 1 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed (c) values( 2 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed (a) values( 'hello' );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed (b) values( 'hello' );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> insert into myMixed values( 'abcdefghij', '1234567890!@#$%^&*()', 21 );
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> select a, b, c from myMixed;
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> select locate(a, b) from myMixed;
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> select locate(a, b, c) from myMixed;
-ERROR 42X05: Table 'MYMIXED' does not exist.
+ERROR 42X05: Table/View 'MYMIXED' does not exist.
 ij> drop table myMixed;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'MYMIXED' because it does not exist.
 ij> create table foo( a int );
 0 rows inserted/updated/deleted
 ij> insert into foo select locate(a, b) from mynVarChar;
-ERROR 42X05: Table 'MYNVARCHAR' does not exist.
+ERROR 42X05: Table/View 'MYNVARCHAR' does not exist.
 ij> insert into foo values( {fn locate('hello', 'hello')} );
 1 row inserted/updated/deleted
 ij> select * from foo;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevokeDDL.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevokeDDL.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevokeDDL.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevokeDDL.out Fri May 26 00:23:58 2006
@@ -91,9 +91,9 @@
 0 rows inserted/updated/deleted
 ij(SATCONNECTION)> -- Expected to fail
 grant select on mySym to bar;
-ERROR 42X05: Table 'MYSYM' does not exist.
+ERROR 42X05: Table/View 'MYSYM' does not exist.
 ij(SATCONNECTION)> grant insert on mySym to foo;
-ERROR 42X05: Table 'MYSYM' does not exist.
+ERROR 42X05: Table/View 'MYSYM' does not exist.
 ij(SATCONNECTION)> CREATE FUNCTION F_ABS(P1 INT)
 RETURNS INT NO SQL
 RETURNS NULL ON NULL INPUT

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/holdCursorJavaReflection.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/holdCursorJavaReflection.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/holdCursorJavaReflection.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/holdCursorJavaReflection.out Fri May 26 00:23:58 2006
@@ -14,7 +14,7 @@
 do next() after commit. Should be at the end of resultset
 one more next() here will give no more rows
 Holdable cursor after commit for prepared statements test over
-Expected Exception:Table 'T1NOTTHERE' does not exist.
+Expected Exception:Table/View 'T1NOTTHERE' does not exist.
 Start hold cursor for callable statements test
 do next() before commit
 look at first column's value: 1

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out Fri May 26 00:23:58 2006
@@ -13,8 +13,8 @@
 ij> --export table not found
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' , 
                                  null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'IEP.NOTABLE' does not exist.' was thrown while evaluating an expression.
-ERROR 42X05: Table 'IEP.NOTABLE' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table/View 'IEP.NOTABLE' does not exist.' was thrown while evaluating an expression.
+ERROR 42X05: Table/View 'IEP.NOTABLE' does not exist.
 ij> ---export schema is not valid
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
                                  null, null, null) ;
@@ -182,7 +182,7 @@
                                  null, null, null, 0) ;
 ERROR XIE0M: Table 'SESSION.TEMP2' does not exist.  
 ij> select * from session.temp2 ;
-ERROR 42X05: Table 'SESSION.TEMP2' does not exist.
+ERROR 42X05: Table/View 'SESSION.TEMP2' does not exist.
 ij> commit ;
 ij> drop table v1;
 0 rows inserted/updated/deleted

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out Fri May 26 00:23:58 2006
@@ -799,8 +799,8 @@
 ERROR 42Y07: Schema 'GROUP' does not exist
 ij> --following export should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression.
-ERROR 42X05: Table 'Group.ORDER' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table/View 'Group.ORDER' does not exist.' was thrown while evaluating an expression.
+ERROR 42X05: Table/View 'Group.ORDER' does not exist.
 ij> --following export should fail because of unquoted table name that is a reserved word.
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group".Order' , 'extinout/order.dat' ,    null , null , null ) ;
 ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression.
@@ -885,8 +885,8 @@
 ERROR 42Y07: Schema 'inventory' does not exist
 ij> --following export should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.
-ERROR 42X05: Table 'INVENTORY.ordertable' does not exist.
+ERROR 38000: The exception 'SQL Exception: Table/View 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.
+ERROR 42X05: Table/View 'INVENTORY.ordertable' does not exist.
 ij> --following export should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
 0 rows inserted/updated/deleted

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out Fri May 26 00:23:58 2006
@@ -87,7 +87,7 @@
 ij> rollback;
 ij> -- table should not be there
 select count(*) from T3;
-ERROR 42X05: Table 'T3' does not exist.
+ERROR 42X05: Table/View 'T3' does not exist.
 ij> create table T3 (	Lname	char(30),
 			Fname	char(30),
 			Account	int not null primary key,



Mime
View raw message