db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpendle...@apache.org
Subject svn commit: r694954 [1/4] - in /db/derby/code/trunk/java: testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/j9_13/ testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ testing/org/...
Date Sat, 13 Sep 2008 14:26:18 GMT
Author: bpendleton
Date: Sat Sep 13 07:26:16 2008
New Revision: 694954

URL: http://svn.apache.org/viewvc?rev=694954&view=rev
Log:
DERBY-3408: Wrong message when using SHOW in ij

This change enhances the ij tool so that, if it detects that a syntax
error has occurred, it will now emit an additional message suggesting
some useful resources that might help the user. The new message is:

    Issue the 'help' command for general information on IJ command syntax.
    Any unrecognized commands are treated as potential SQL commands and executed directly.
    Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.

The change includes updates to a number of regression test output files
which include intentional syntax errors in ij scripts.


Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DB2IsolationLevels.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/access.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.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/autoincrement.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/bit.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/columnDefaults.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/currentSchema.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/delete.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/derived.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml112.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/ejbql_nonSPS.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ij2.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/innerjoin.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/isolationLevels.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ij2.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/logop.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/modifyColumn.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outerjoin.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/positionedDelUpd.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/select.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/stringtypes.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery2.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerBeforeTrig.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerGeneral.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/valuesclause.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ij2.sql
    db/derby/code/trunk/java/tools/org/apache/derby/impl/tools/ij/utilMain.java
    db/derby/code/trunk/java/tools/org/apache/derby/loc/toolsmessages.properties

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DB2IsolationLevels.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DB2IsolationLevels.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DB2IsolationLevels.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DB2IsolationLevels.out
Sat Sep 13 07:26:16 2008
@@ -533,18 +533,39 @@
 ij> -- unknown isolation level
 select * from t1 with rw;
 ERROR 42X01: Syntax error: Encountered "rw" at line 2, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select * from t1 with DIRTY READ;
 ERROR 42X01: Syntax error: Encountered "DIRTY" at line 1, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select * from t1 with READ UNCOMMITTED;
 ERROR 42X01: Syntax error: Encountered "READ" at line 1, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select * from t1 with READ COMMITTED;
 ERROR 42X01: Syntax error: Encountered "READ" at line 1, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select * from t1 with CURSOR STABILITY;
 ERROR 42X01: Syntax error: Encountered "CURSOR" at line 1, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select * from t1 with REPEATABLE READ;
 ERROR 42X01: Syntax error: Encountered "REPEATABLE" at line 1, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select * from t1 with SERIALIZABLE;
 ERROR 42X01: Syntax error: Encountered "SERIALIZABLE" at line 1, column 23.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- check the db2 isolation levels can be used as identifiers
 create table db2iso(cs int, rr int, ur int, rs int);
 0 rows inserted/updated/deleted

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=694954&r1=694953&r2=694954&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
Sat Sep 13 07:26:16 2008
@@ -157,4 +157,7 @@
 ij> -- BIT STRING literal is not allowed in DB2
 values cast(B'1' as blob(10));
 ERROR 42X01: Syntax error: Encountered "\'1\'" at line 2, column 14.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/access.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/access.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/access.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/access.out
Sat Sep 13 07:26:16 2008
@@ -2628,6 +2628,9 @@
         '0_col10llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll012340_col10lllllllllllxxxxxx'
     where col00 = '0_';
 ERROR 42X01: Syntax error: DERBY-PROPERTIES.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> rollback;
 ij> -- prior to the fix col17 and col18 would come back null.
 select col01, col02, col03, col04, col05,  col06, col07, col08, col09, col10, col11, col12,
col13, col14, col15, col16, col17, col18 from t2778;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out
Sat Sep 13 07:26:16 2008
@@ -233,6 +233,9 @@
 ij> -- binary list operator
 select (1 in (1,2)), count(c1) from t1 group by c1;
 ERROR 42X01: Syntax error: Encountered "in" at line 2, column 11.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select count((1 in (1,2))) from t1 group by c1;
 1          
 -----------

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=694954&r1=694953&r2=694954&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
Sat Sep 13 07:26:16 2008
@@ -996,6 +996,9 @@
 ij> -- new column name is a reserved word:
 rename column renc_1.a to select;
 ERROR 42X01: Syntax error: Encountered "select" at line 2, column 27.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- attempt to rename a column in a system table. Should fali:
 rename column sys.sysconglomerates.isindex to is_an_index;
 ERROR 42X62: 'RENAME COLUMN' is not allowed in the 'SYS' schema.
@@ -1029,16 +1032,34 @@
 ERROR 42Y55: 'RENAME COLUMN' cannot be performed on 'RENC_1' because it does not exist.
 ij> rename column renc_1 rename a to b;
 ERROR 42X01: Syntax error: Encountered "rename" at line 1, column 22.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> rename column renc_1.a;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 22.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> rename column renc_1.a b;
 ERROR 42X01: Syntax error: Encountered "b" at line 1, column 24.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> rename column renc_1.a to;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 25.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> rename column renc_1.a to b, c;
 ERROR 42X01: Syntax error: Encountered "," at line 1, column 28.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> rename column renc_1.a to b and c to d;
 ERROR 42X01: Syntax error: Encountered "and" at line 1, column 29.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- Rename a column which is the primary key of the table:
 create table renc_2(c1 int not null constraint renc_2_p1 primary key);
 0 rows inserted/updated/deleted
@@ -1405,19 +1426,40 @@
 ij> -- Column name is spelled incorrectly (wrong case)
 alter table atdc_2 drop column 'a';
 ERROR 42X01: Syntax error: Encountered "\'a\'" at line 2, column 32.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- Some special reserved words to cause parser errors
 alter table atdc_2 drop column column;
 ERROR 42X01: Syntax error: Encountered "column" at line 2, column 32.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> alter table atdc_2 drop column;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 30.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> alter table atdc_2 drop column constraint;
 ERROR 42X01: Syntax error: Encountered "constraint" at line 1, column 32.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> alter table atdc_2 drop column primary;
 ERROR 42X01: Syntax error: Encountered "primary" at line 1, column 32.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> alter table atdc_2 drop column foreign;
 ERROR 42X01: Syntax error: Encountered "foreign" at line 1, column 32.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> alter table atdc_2 drop column check;
 ERROR 42X01: Syntax error: Encountered "check" at line 1, column 32.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> create table atdc_3 (a integer);
 0 rows inserted/updated/deleted
 ij> create index atdc_3_idx_1 on atdc_3 (a);

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
Sat Sep 13 07:26:16 2008
@@ -881,6 +881,9 @@
 ERROR 42Z21: Invalid increment specified for identity for column 'Y'. Increment cannot be
zero.  
 ij> create table ni (x int, y int generated always as identity (increment by 0);
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 75.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> create table ni (x int, y int generated always as identity (start with 0, increment
by 0));
 ERROR 42Z21: Invalid increment specified for identity for column 'Y'. Increment cannot be
zero.  
 ij> create table ni (x int, y bigint generated always as identity (increment by 0));

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/bit.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/bit.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/bit.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/bit.out
Sat Sep 13 07:26:16 2008
@@ -54,10 +54,19 @@
 ij> -- simple negative test
 values(X'gg');
 ERROR 42X01: Syntax error: Encountered "\'gg\'" at line 2, column 9.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> values(X'z');
 ERROR 42X01: Syntax error: Encountered "\'z\'" at line 1, column 9.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> values(X'zz');
 ERROR 42X01: Syntax error: Encountered "\'zz\'" at line 1, column 9.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- fails after bug 5742 is fixed
 values(X'9');
 ERROR 42606: An invalid hexadecimal constant starting with 'X'9'' has been detected.
@@ -868,4 +877,4 @@
 0 rows inserted/updated/deleted
 ij> drop table npetest1;
 0 rows inserted/updated/deleted
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out
Sat Sep 13 07:26:16 2008
@@ -1572,8 +1572,14 @@
 12345      
 ij> values CHAR(DEC(67.21,4,2));
 ERROR 42X01: Syntax error: Encountered "DEC" at line 1, column 13.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> values CHAR(DECIMAL(67.10,4,2));
 ERROR 42X01: Syntax error: Encountered "DECIMAL" at line 1, column 13.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> values CHAR(DOUBLE(5.55));
 1                                                    
 -----------------------------------------------------
@@ -1619,6 +1625,9 @@
 -- should all fail at runtime
 select cast (aliasinfo as BOOLEAN) from sys.sysaliases;
 ERROR 42X01: Syntax error: BOOLEAN.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select cast (aliasinfo as SMALLINT) from sys.sysaliases;
 1     
 ------
@@ -1676,4 +1685,4 @@
 1                                                                                       
                                       
 --------------------------------------------------------------------------------------------------------------------------------
 INSTALL_JAR(IN URL VARCHAR(256),IN JAR VARCHAR(128),IN DEPLOY INTEGER) LANGUAGE JAVA PARAMETER
STYLE JAVA MODIFIES SQL DATA     
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/columnDefaults.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/columnDefaults.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/columnDefaults.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/columnDefaults.out
Sat Sep 13 07:26:16 2008
@@ -19,12 +19,21 @@
 -- ? in default
 create table neg(c1 int default ?);
 ERROR 42X01: Syntax error: Encountered "?" at line 22, column 33.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- column reference in default
 create table neg(c1 int, c2 int default c1);
 ERROR 42X01: Syntax error: Encountered "c1" at line 2, column 41.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- subquery in default
 create table neg(c1 int default (values 1));
 ERROR 42X01: Syntax error: Encountered "(" at line 2, column 33.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- type incompatibility at compile time
 create table neg(c1 date default 1);
 ERROR 42821: Columns of type 'DATE' cannot hold values of type 'INTEGER'. 
@@ -55,6 +64,9 @@
 0 rows inserted/updated/deleted
 ij> alter table neg modify x default null;
 ERROR 42X01: Syntax error: Encountered "modify" at line 1, column 17.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> alter table neg add column x date default 1;
 ERROR 42821: Columns of type 'DATE' cannot hold values of type 'INTEGER'. 
 ij> -- bug 5585 - should fail at alter table statement

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
Sat Sep 13 07:26:16 2008
@@ -940,6 +940,9 @@
 ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed.

 ij> insert into xena values (select (a + 4, b - 4, c, d from xena);
 ERROR 42X01: Syntax error: Encountered "," at line 1, column 39.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> select 
      cast (conglomeratename as char(10)) as name, 
      cast (numallocatedpages as char(4)) as aloc, 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/currentSchema.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/currentSchema.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/currentSchema.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/currentSchema.out
Sat Sep 13 07:26:16 2008
@@ -102,6 +102,9 @@
 ij> -- check that set sqlid doesn't work (not DB2 compatible) - should get error
 set sqlid judy;
 ERROR 42X01: Syntax error: Encountered "sqlid" at line 2, column 5.
+Issue the 'help' command for general information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed directly.
+Consult your DBMS server reference documentation for details of the SQL syntax supported
by your server.
 ij> -- change schema and make sure that the current schema is correct
 set schema sys;
 0 rows inserted/updated/deleted



Mime
View raw message