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 bp...@apache.org on 2008/09/13 16:26:18 UTC
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/...
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