You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ba...@apache.org on 2006/05/26 09:24:00 UTC
svn commit: r409578 [2/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...
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/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/j9_foundation/grantRevoke.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevoke.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevoke.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevoke.out Fri May 26 00:23:58 2006
@@ -87,9 +87,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)> -- Test for external security clause
-- Expected to fail
CREATE FUNCTION F_ABS(P1 INT)
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/grantRevokeDDL.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/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/miscerrors.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out Fri May 26 00:23:58 2006
@@ -41,7 +41,7 @@
ij> VALUES FRED932432;
ERROR 42X04: Column 'FRED932432' 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 'FRED932432' is not a column in the target table.
ij> SELECT * FROM BILL932432;
-ERROR 42X05: Table 'BILL932432' does not exist.
+ERROR 42X05: Table/View 'BILL932432' does not exist.
ij> SELECT 932432;
ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 13.
ij> select SQL_TEXT from syscs_diag.statement_cache where SQL_TEXT LIKE '%932432%';
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/prepStmt.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/prepStmt.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/prepStmt.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/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/renameTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/renameTable.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/renameTable.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/renameTable.out Fri May 26 00:23:58 2006
@@ -91,7 +91,7 @@
0 rows inserted/updated/deleted
ij> -- but the execute statement will fail
execute p3 using 'values (30)';
-ERROR 42X05: Table 'T3R' does not exist.
+ERROR 42X05: Table/View 'T3R' does not exist.
ij> remove p3;
ij> autocommit on;
ij> -- creating a table with triggers defined on it
@@ -108,7 +108,7 @@
rename table t7 to t7r;
ERROR X0Y25: Operation 'RENAME' cannot be performed on object 'T7' because TRIGGER 'T7INSERT' is dependent on that object.
ij> select * from t7r;
-ERROR 42X05: Table 'T7R' does not exist.
+ERROR 42X05: Table/View 'T7R' does not exist.
ij> select * from t7;
C71
-----------
@@ -116,13 +116,13 @@
ij> rename table t6 to t6r;
0 rows inserted/updated/deleted
ij> insert into t7 values(3);
-ERROR 42X05: Table 'T6' does not exist.
+ERROR 42X05: Table/View 'T6' does not exist.
ij> select * from t6r;
C61
-----------
1
ij> select * from t7r;
-ERROR 42X05: Table 'T7R' does not exist.
+ERROR 42X05: Table/View 'T7R' does not exist.
ij> -- Rename should fail if there is a check constraint
create table tcheck (i int check(i>5));
0 rows inserted/updated/deleted
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out Fri May 26 00:23:58 2006
@@ -115,7 +115,7 @@
-- SELECT T0513.C2, BASE_VS1.C1 FROM T0513, BASE_VS1
CREATE VIEW T0513 (C1, C2) AS
SELECT T0513.C2, BASE_VS1.C1 FROM T0513, BASE_VS1;
-ERROR 42X05: Table 'T0513' does not exist.
+ERROR 42X05: Table/View 'T0513' does not exist.
ij> --0 PASS: if an error is returned that the view is circular
-- ************* End of Schema *************
disconnect;
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out Fri May 26 00:23:58 2006
@@ -8,7 +8,7 @@
create table myschem.t(c int);
0 rows inserted/updated/deleted
ij> insert into t values (1);
-ERROR 42X05: Table 'T' does not exist.
+ERROR 42X05: Table/View 'T' does not exist.
ij> insert into blah.t values (2);
ERROR 42Y07: Schema 'BLAH' does not exist
ij> insert into blah.blah.t values (3);
@@ -26,7 +26,7 @@
ij> create table myschem.s(c int);
0 rows inserted/updated/deleted
ij> insert into s values (1);
-ERROR 42X05: Table 'S' does not exist.
+ERROR 42X05: Table/View 'S' does not exist.
ij> insert into honk.s values (2);
ERROR 42Y07: Schema 'HONK' does not exist
ij> insert into honk.blat.s values (3);
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/statementJdbc20.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/statementJdbc20.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/statementJdbc20.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/statementJdbc20.out Fri May 26 00:23:58 2006
@@ -21,7 +21,7 @@
PASS -- expected exception
SQLSTATE(X0Y78): SQL Exception: Statement.executeQuery() cannot be called with a statement that returns a row count.
PASS -- expected exception
-SQLSTATE(42X05): SQL Exception: Table 'TRASH' does not exist.
+SQLSTATE(42X05): SQL Exception: Table/View 'TRASH' does not exist.
PASS -- expected exception
SQLSTATE(X0Y79): SQL Exception: Statement.executeUpdate() cannot be called with a statement that returns a ResultSet.
Test statementJdbc20 finished
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/supersimple.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/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/synonym.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out Fri May 26 00:23:58 2006
@@ -228,7 +228,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));
@@ -349,7 +349,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;
@@ -377,7 +377,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/testij.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testij.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testij.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testij.out Fri May 26 00:23:58 2006
@@ -19,7 +19,7 @@
disconnect all;
ij> connect 'jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/junk;create=true:retrieveMessagesFromServerOnGetMessage=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:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;create=true:user=judy;password=judy;retrieveMessagesFromServerOnGetMessage=true;';
ij(CONNECTION1)> connect 'jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/"./wombat":user=judy;password=judy;retrieveMessagesFromServerOnGetMessage=true;';
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/views.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/views.out?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/views.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/views.out Fri May 26 00:23:58 2006
@@ -72,7 +72,7 @@
ERROR X0Y32: Table/View 'T1' already exists in Schema 'APP'.
ij> -- drop non-existant view
drop view notexists;
-ERROR X0X05: Table 'NOTEXISTS' does not exist.
+ERROR X0X05: Table/View 'NOTEXISTS' does not exist.
ij> -- duplicate column name in view's column list
create view shouldntwork (c1, c2, c1) as select i, s, f from t1;
ERROR 42Y13: Column name 'C1' appears more than once in the CREATE VIEW statement.
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevoke.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevoke.java?rev=409578&r1=409577&r2=409578&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevoke.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/grantRevoke.java Fri May 26 00:23:58 2006
@@ -617,7 +617,7 @@
"'NOSUCHCOL' is not a column in table or VTI 'S1.T1'."},
{"grant select on nosuch.t1 to " + users[0].name, "42Y07", "Schema 'NOSUCH' does not exist"},
- {"grant select on s1.nosuch to " + users[0].name, "42X05", "Table 'S1.NOSUCH' does not exist."},
+ {"grant select on s1.nosuch to " + users[0].name, "42X05", "Table/View 'S1.NOSUCH' does not exist."},
{"grant execute on function nosuch.f0 to " + users[0].name, "42Y07", "Schema 'NOSUCH' does not exist"},
{"grant execute on function s1.nosuch to " + users[0].name, "42Y03",
"'S1.NOSUCH' is not recognized as a function or procedure."},