svn commit: r694954 [2/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/...

[bp...@apache.org]

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out Sat Sep 13 07:26:16 2008
@@ -74,27 +74,54 @@
 -- CLASS ALIAS;
 create class alias MyMath for java.lang.Math;
 ERROR 42X01: Syntax error: Encountered "class" at line 5, column 8.
+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> drop class alias MyMath;
 ERROR 42X01: Syntax error: Encountered "class" at line 1, column 6.
+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 class alias for java.lang.Math;
 ERROR 42X01: Syntax error: Encountered "class" at line 1, column 8.
+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> drop class alias Math;
 ERROR 42X01: Syntax error: Encountered "class" at line 1, column 6.
+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> -- METHOD ALIAS;
 create method alias myabs for java.lang.Math.abs;
 ERROR 42X01: Syntax error: Encountered "method" at line 3, column 8.
+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> drop method alias myabs;
 ERROR 42X01: Syntax error: Encountered "method" at line 1, column 6.
+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> -- STORED PREPARED STATEMENTS 
 -- create statement no more supported both in db2 and cloudscpae mode. -ve test for that
 create statement s1 as values 1,2;
 ERROR 42X01: Syntax error: Encountered "statement" at line 3, column 8.
+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, drop and execute statements are still supported for existing stored prepared statements for customers
 alter statement recompile all;
 ERROR 42X01: Syntax error: Encountered "statement" at line 2, column 7.
+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> -- following will give error because there is no stored prepared statement s1 in the database
 drop statement s1;
 ERROR 42X01: Syntax error: Encountered "statement" at line 2, column 6.
+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> -- clean up
 DROP TABLE t1;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.
@@ -102,8 +129,14 @@
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T2' because it does not exist.
 ij> DROP CLASS ALIAS ExternalInsert;
 ERROR 42X01: Syntax error: Encountered "CLASS" at line 1, column 6.
+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> DROP STATEMENT insert1;
 ERROR 42X01: Syntax error: Encountered "STATEMENT" at line 1, column 6.
+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> -- Primary key constraint, DB2 requires NOT null on the columns.
 create table customer (id int primary key, name char(100));
 0 rows inserted/updated/deleted
@@ -118,6 +151,9 @@
 0 rows inserted/updated/deleted
 ij> drop schema fred;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 16.
+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> drop schema fred restrict;
 0 rows inserted/updated/deleted
 ij> -- create schema not supported for schemas that start with SYS
@@ -138,14 +174,29 @@
 ij> -- data types not supported
 create table NOTYPE(i int, b BOOLEAN);
 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> create table NOTYPE(i int, b TINYINT);
 ERROR 42X01: Syntax error: Encountered "" 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> create table NOTYPE(i int, b java.lang.String);
 ERROR 42X01: Syntax error: Encountered "" 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> create table NOTYPE(i int, b com.acme.Address);
 ERROR 42X01: Syntax error: Encountered "" 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> create table NOTYPE(i int, b org.apache.derby.vti.VTIEnvironment);
 ERROR 42X01: Syntax error: Encountered "" 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> -- VTI in the DELETE statement
 -- beetle 5234
 CREATE TABLE testCS (col1 int, col2 char(30), col3 int);
@@ -154,18 +205,33 @@
 1 row inserted/updated/deleted
 ij> DELETE FROM NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') WHERE col1 = 100 and col3 = 732;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in the INSERT statement
 -- beetle 5234
 INSERT INTO NEW org.apache.derbyTesting.functionTests.util.serializabletypes.ExternalTable('jdbc:derby:wombat', 'testCS') VALUES (100, 'asdf', 732);
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.serializabletypes.ExternalTable.
+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> -- VTI in the SELECT statement
 -- beetle 5234
 select * from testCS, new org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI(col1, 1) a;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI.
+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 new com.acme.myVTI() as T;
 ERROR 42X01: Syntax error: com.acme.myVTI.
+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 new org.apache.derbyTesting.not.myVTI() as T;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.not.myVTI.
+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 syscs_diag.lock_table;
 XID            |TYPE |MODE|TABLENAME                                                                                                                       |LOCKNAME            |STATE|TABLETYPE|LOCK&|INDEXNAME                                                                                                                       
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -175,14 +241,23 @@
 0 rows inserted/updated/deleted
 ij> CREATE TRIGGER testtrig1 AFTER DELETE ON tb1 FOR EACH ROW MODE DB2SQL INSERT INTO NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') VALUES (1000);
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in CREATE TRIGGER statement
 -- beetle 5234
 CREATE TRIGGER testtrig2 AFTER DELETE ON tb1 FOR EACH ROW MODE DB2SQL DELETE FROM NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') WHERE col1 = 100 and col3 = 732;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in CREATE TRIGGER statement
 -- beetle 5234
 CREATE TRIGGER testtrig3 AFTER DELETE ON tb1 FOR EACH ROW MODE DB2SQL SELECT * FROM testCS, NEW org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI(col1, 1) a;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI.
+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> -- clean up
 DROP TABLE tb1;
 0 rows inserted/updated/deleted
@@ -194,16 +269,28 @@
 ij> -- BTREE not supported in both Cloudscape and DB2 mode and that is why rather than getting feature not implemented, we will get syntax error in DB2 mode
 create btree index map_idx2 on maps2(country_ISO_code);
 ERROR 42X01: Syntax error: Encountered "btree" at line 2, column 8.
+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 unique btree index map_idx2 on maps2(country_ISO_code);
 ERROR 42X01: Syntax error: Encountered "btree" at line 1, column 15.
+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> drop table maps2;
 0 rows inserted/updated/deleted
 ij> -- SET LOCKING clause in DB2 mode
 -- beetle 5208
 create table maps1 (country_ISO_code char(2)) set locking = table;
 ERROR 42X01: Syntax error: Encountered "set" at line 3, column 47.
+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 maps2 (country_ISO_code char(2)) set locking = row;
 ERROR 42X01: Syntax error: Encountered "set" at line 1, column 47.
+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> drop table maps1;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'MAPS1' because it does not exist.
 ij> drop table maps2;
@@ -216,8 +303,14 @@
 0 rows inserted/updated/deleted
 ij> alter table tb1 set locking = table;
 ERROR 42X01: Syntax error: Encountered "set" 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 tb1 set locking = row;
 ERROR 42X01: Syntax error: Encountered "set" 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> -- Locking syntax 
 -- positive tests
 -- beetle 5201
@@ -240,28 +333,46 @@
 1 row inserted/updated/deleted
 ij> DELETE FROM NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') WHERE col1 = 100 and col3 = 732;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in the INSERT statement
 -- beetle 5234
 INSERT INTO NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') VALUES (100, 'asdf', 732);
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in the SELECT statement
 -- beetle 5234
 select * from testCS, new org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI(col1, 1) a;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI.
+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> -- VTI in CREATE TRIGGER statement
 -- beetle 5234
 CREATE TABLE tb1(a int);
 0 rows inserted/updated/deleted
 ij> CREATE TRIGGER testtrig1 AFTER DELETE ON tb1 FOR EACH ROW MODE DB2SQL INSERT INTO NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') VALUES (1000);
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in CREATE TRIGGER statement
 -- beetle 5234
 CREATE TRIGGER testtrig2 AFTER DELETE ON tb1 FOR EACH ROW MODE DB2SQL DELETE FROM NEW org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable('jdbc:derby:wombat', 'testCS') WHERE col1 = 100 and col3 = 732;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.ExternalTable.
+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> -- VTI in CREATE TRIGGER statement
 -- beetle 5234
 CREATE TRIGGER testtrig3 AFTER DELETE ON tb1 FOR EACH ROW MODE DB2SQL SELECT * FROM testCS, NEW org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI(col1, 1) a;
 ERROR 42X01: Syntax error: org.apache.derbyTesting.functionTests.util.VTIClasses.PositiveInteger_VTICosting_SI.
+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> -- clean up
 DROP TABLE tb1;
 0 rows inserted/updated/deleted
@@ -272,27 +383,51 @@
 -- beetle 5205
 create table table tt (a int, b int, c int);
 ERROR 42X01: Syntax error: Encountered "table" at line 4, 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> -- alter table tt drop column b; This is now supported by Derby
 alter table tt rename to ttnew;
 ERROR 42X01: Syntax error: Encountered "rename" at line 2, column 16.
+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 tt rename c to d;
 ERROR 42X01: Syntax error: Encountered "rename" at line 1, column 16.
+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 tt.c to tt.d;
 ERROR 42X01: Syntax error: Encountered "." 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> drop table tt;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TT' because it does not exist.
 ij> -- CASCADE/RESTRICT on DROP CONSTRAINT
 -- beetle 5204
 ALTER TABLE TT DROP CONSTRAINT ABC CASCADE;
 ERROR 42X01: Syntax error: Encountered "CASCADE" at line 3, column 36.
+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 TT DROP CONSTRAINT ABC2 RESTRICT;
 ERROR 42X01: Syntax error: Encountered "RESTRICT" at line 1, column 37.
+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> -- CASCADE/RESTRICT on DROP TABLE
 -- beetle 5206
 DROP TABLE TT CASCADE;
 ERROR 42X01: Syntax error: Encountered "CASCADE" at line 3, column 15.
+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> DROP TABLE TT RESTRICT;
 ERROR 42X01: Syntax error: Encountered "RESTRICT" at line 1, column 15.
+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> -- beetle 5216
 -- there should only be one autoincrement column per table 
 CREATE TABLE T1 (C1 INT GENERATED ALWAYS AS IDENTITY 
@@ -344,6 +479,9 @@
 0 rows inserted/updated/deleted
 ij> ALTER INDEX TTIDX RENAME TTIDXNEW;
 ERROR 42X01: Syntax error: Encountered "INDEX" at line 1, column 7.
+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> -- clean up
 drop table tt;
 0 rows inserted/updated/deleted
@@ -351,24 +489,48 @@
 -- beetle 5222
 CREATE AGGREGATE STDEV FOR org.apache.derbyTesting.functionTests.util.aggregates.StandardDeviation;
 ERROR 42X01: Syntax error: Encountered "AGGREGATE" at line 3, column 8.
+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> DROP AGGREGATE STDEV;
 ERROR 42X01: Syntax error: Encountered "AGGREGATE" at line 1, column 6.
+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 AGGREGATE MAXBUTONE FOR org.apache.derbyTesting.functionTests.util.aggregates.MaxButOneDef;
 ERROR 42X01: Syntax error: Encountered "AGGREGATE" at line 1, column 8.
+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> DROP AGGREGATE MAXBUTONE;
 ERROR 42X01: Syntax error: Encountered "AGGREGATE" at line 1, column 6.
+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 and DROP CLASS ALIAS
 -- beetle 5222
 create class alias for java.util.Hashtable;
 ERROR 42X01: Syntax error: Encountered "class" at line 3, column 8.
+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> drop class alias Hashtable;
 ERROR 42X01: Syntax error: Encountered "class" at line 1, column 6.
+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 and DROP METHOD ALIAS
 -- beetle 5222
 create method alias hashtable for java.lang.Math.sin;
 ERROR 42X01: Syntax error: Encountered "method" at line 3, column 8.
+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> drop method alias hashtable;
 ERROR 42X01: Syntax error: Encountered "method" at line 1, column 6.
+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
 -- beetle 5222
 create table TT(col1 int, col2 int);
@@ -388,12 +550,24 @@
 0 rows inserted/updated/deleted
 ij> SET TRIGGERS FOR tb1 ENABLED;
 ERROR 42X01: Syntax error: Encountered "TRIGGERS" at line 1, 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> SET TRIGGERS FOR tb1 DISABLED;
 ERROR 42X01: Syntax error: Encountered "TRIGGERS" at line 1, 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> SET TRIGGERS testtrig2 ENABLED;
 ERROR 42X01: Syntax error: Encountered "TRIGGERS" at line 1, 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> SET TRIGGERS testtrig2 DISABLED;
 ERROR 42X01: Syntax error: Encountered "TRIGGERS" at line 1, 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> -- clean up
 DROP TRIGGER testtrig1;
 ERROR 42X94: TRIGGER 'TESTTRIG1' does not exist.
@@ -409,41 +583,92 @@
 -- beetle 5224
 create table t1 (i int, s smallint, c10 char(10), vc30 varchar(30), b boolean);
 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> create table mm (x org.apache.derbyTesting.functionTests.util.ManyMethods);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 20.
+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 sc (x org.apache.derbyTesting.functionTests.util.SubClass);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 20.
+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 i from t1 where i instanceof java.lang.Integer;
 ERROR 42X01: Syntax error: Encountered "instanceof" at line 1, column 26.
+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 i from t1 where i instanceof java.lang.Number;
 ERROR 42X01: Syntax error: Encountered "instanceof" at line 1, column 26.
+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 i from t1 where i instanceof java.lang.Object;
 ERROR 42X01: Syntax error: Encountered "instanceof" at line 1, column 26.
+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 s from t1 where s instanceof java.lang.Integer;
 ERROR 42X01: Syntax error: Encountered "instanceof" at line 1, column 26.
+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 b from t1 where b instanceof java.lang.Boolean;
 ERROR 42X01: Syntax error: Encountered "instanceof" at line 1, column 26.
+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 c10 from t1 where c10 instanceof java.lang.String;
 ERROR 42X01: Syntax error: Encountered "instanceof" 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> select vc30 from t1 where vc30 instanceof java.lang.String;
 ERROR 42X01: Syntax error: Encountered "instanceof" 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> -- following are negative test cases because boolean values disallowed in select clause
 select x instanceof org.apache.derbyTesting.functionTests.util.ManyMethods from mm;
 ERROR 42X01: Syntax error: Encountered "org" at line 2, column 21.
+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 x instanceof org.apache.derbyTesting.functionTests.util.SubClass from mm;
 ERROR 42X01: Syntax error: Encountered "org" at line 1, column 21.
+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 x instanceof org.apache.derbyTesting.functionTests.util.SubSubClass from mm;
 ERROR 42X01: Syntax error: Encountered "org" at line 1, column 21.
+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 (i + i) instanceof java.lang.Integer from t1;
 ERROR 42X01: Syntax error: Encountered "java" at line 1, 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> select (i instanceof java.lang.Integer) = true from t1;
 ERROR 42X01: Syntax error: Encountered "instanceof" at line 1, 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> DELETE FROM t1 where i INSTANCEOF 
 org.apache.derbyTesting.functionTests.util.serializabletypes.City;
 ERROR 42X01: Syntax error: Encountered "INSTANCEOF" 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> UPDATE t1 SET s = NULL WHERE i INSTANCEOF 
 org.apache.derbyTesting.functionTests.util.serializabletypes.City;
 ERROR 42X01: Syntax error: Encountered "INSTANCEOF" 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> -- clean up
 drop table t1;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.
@@ -455,19 +680,37 @@
 -- beetle 5233
 create table testtype1(col1 bit);
 ERROR 42X01: Syntax error: Encountered "bit" at line 3, 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> create table testtype2(col1 bit varying(10));
 ERROR 42X01: Syntax error: Encountered "bit" 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> --- boolean datatype already disabled
 create table testtype3(col1 boolean);
 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> create table testtype4(col1 LONG NVARCHAR);
 ERROR 0A000: Feature not implemented: LONG NVARCHAR.
 ij> create table testtype5(col1 LONG VARBINARY);
 ERROR 42X01: Syntax error: Encountered "VARBINARY" at line 1, column 34.
+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 testtype6(col1 LONG BIT VARYING);
 ERROR 42X01: Syntax error: Encountered "BIT" at line 1, column 34.
+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 testtype7(col1 LONG BINARY);
 ERROR 42X01: Syntax error: Encountered "BINARY" at line 1, column 34.
+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 testtype8(col1 NCHAR);
 ERROR 0A000: Feature not implemented: NATIONAL CHAR.
 ij> create table testtype9(col1 NVARCHAR(10));
@@ -475,6 +718,9 @@
 ij> -- tinyint datatype already disabled
 create table testtype10(col1 TINYINT);
 ERROR 42X01: Syntax error: Encountered "" at line 2, 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> create table testtype11 (a national character large object (1000));
 ERROR 0A000: Feature not implemented: NCLOB.
 ij> -- beetle5426
@@ -485,8 +731,14 @@
 ERROR 0A000: Feature not implemented: NATIONAL CHAR.
 ij> CREATE CLASS ALIAS FOR org.apache.derbyTesting.functionTests.util.serializabletypes.Tour;
 ERROR 42X01: Syntax error: Encountered "CLASS" at line 1, column 8.
+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 testtype13 (a Tour);
 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> -- clean up
 drop table testtype1;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TESTTYPE1' because it does not exist.
@@ -516,6 +768,9 @@
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TESTTYPE12' because it does not exist.
 ij> drop class alias Tours;
 ERROR 42X01: Syntax error: Encountered "class" at line 1, column 6.
+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> drop table testtype13;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TESTTYPE13' because it does not exist.
 ij> -- limit char to 254 and varchar to 32672 columns in db2 mode
@@ -553,6 +808,9 @@
 0 rows inserted/updated/deleted
 ij> SET CONSTRAINTS fk DISABLED;
 ERROR 42X01: Syntax error: Encountered "CONSTRAINTS" at line 1, 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> SELECT STATE FROM SYS.SYSCONSTRAINTS;
 &
 -
@@ -560,6 +818,9 @@
 E
 ij> SET CONSTRAINTS fk ENABLED;
 ERROR 42X01: Syntax error: Encountered "CONSTRAINTS" at line 1, 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> SELECT STATE FROM SYS.SYSCONSTRAINTS;
 &
 -
@@ -567,6 +828,9 @@
 E
 ij> SET CONSTRAINTS ALL DISABLED;
 ERROR 42X01: Syntax error: Encountered "CONSTRAINTS" at line 1, 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> SELECT STATE FROM SYS.SYSCONSTRAINTS;
 &
 -
@@ -574,6 +838,9 @@
 E
 ij> SET CONSTRAINTS FOR testsetconst1 ENABLED;
 ERROR 42X01: Syntax error: Encountered "CONSTRAINTS" at line 1, 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> SELECT STATE FROM SYS.SYSCONSTRAINTS;
 &
 -
@@ -588,6 +855,9 @@
 -- beetle 5252
 call org.apache.derby.iapi.db.Factory::getDatabaseOfConnection().dropAllJDBCMetaDataSPSes();
 ERROR 42X01: Syntax error: org.apache.derby.iapi.db.Factory::getDatabaseOfConnection.
+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> -- Beetle 5203: DB2 restricts what can be used for default clauses, and enforces
 -- constraints on the default clause that Cloudscape does not.
 -- Following should be okay:
@@ -657,8 +927,14 @@
 -- expressions:
 create table deftest1 (vc varchar(30) default java.lang.Integer::toBinaryString(3));
 ERROR 42X01: Syntax error: Encountered "java" at line 3, column 47.
+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 deftest2 (i int default 3+4);
 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> -- floating point assignment to non-float column.
 create table deftest3 (i int default 1.234);
 ERROR 42894: DEFAULT value or IDENTITY attribute value is not valid for column 'I'.
@@ -802,12 +1078,24 @@
 1 row inserted/updated/deleted
 ij> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
 ERROR 42X01: Syntax error: Encountered "TRANSACTION" at line 1, 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> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
 ERROR 42X01: Syntax error: Encountered "TRANSACTION" at line 1, 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> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
 ERROR 42X01: Syntax error: Encountered "TRANSACTION" at line 1, 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> SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
 ERROR 42X01: Syntax error: Encountered "TRANSACTION" at line 1, 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> -- clean up
 drop table t1;
 0 rows inserted/updated/deleted
@@ -905,40 +1193,82 @@
 -- (1) CROSS JOIN should be disabled in FROM clause of SELECT statement
 SELECT * FROM t1 CROSS JOIN t2;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 3, 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> -- (2) USING should be disabled in INNER JOIN of SELECT statement
 SELECT * FROM t1 INNER JOIN t2 USING (col1);
 ERROR 42X01: Syntax error: Encountered "USING" 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> -- (3) USING should be disabled in INNER JOIN of SELECT statement
 SELECT * FROM t1 LEFT OUTER JOIN t2 USING (col1);
 ERROR 42X01: Syntax error: Encountered "USING" at line 2, column 37.
+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> -- (4) USING should be disabled in INNER JOIN of SELECT statement
 SELECT * FROM t1 RIGHT OUTER JOIN t2 USING (col1);
 ERROR 42X01: Syntax error: Encountered "USING" at line 2, column 38.
+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> -- (5) TRUE and FALSE constants should be disabled in WHERE clause of SELECT statement
 SELECT * FROM t1 INNER JOIN t2 ON t1.col1 = t2.col1 WHERE true;
 ERROR 42X01: Syntax error: true.
+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 INNER JOIN t2 ON t1.col1 = t2.col1 WHERE false;
 ERROR 42X01: Syntax error: false.
+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> -- (5) TRUE and FALSE constants should be disabled in WHERE clause of DELETE statement
 DELETE FROM t1 where true;
 ERROR 42X01: Syntax error: true.
+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> DELETE FROM t1 where false;
 ERROR 42X01: Syntax error: false.
+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> -- (5) TRUE and FALSE constants should be disabled in WHERE clause of DELETE statement
 UPDATE t2 SET col1 = NULL WHERE true;
 ERROR 42X01: Syntax error: true.
+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> UPDATE t2 SET col1 = NULL WHERE false;
 ERROR 42X01: Syntax error: false.
+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> -- (6) AT ISOLATION clause should be disabled in SELECT statement
 -- AT ISOLATION not supported in both Cloudscape and DB2 mode and that is why rather than getting feature not implemented, we will get syntax error
 SELECT * FROM t1 AT ISOLATION READ UNCOMMITTED;
 ERROR 42X01: Syntax error: Encountered "AT" at line 3, column 18.
+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 AT ISOLATION READ COMMITTED;
 ERROR 42X01: Syntax error: Encountered "AT" at line 1, column 18.
+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 AT ISOLATION SERIALIZABLE;
 ERROR 42X01: Syntax error: Encountered "AT" at line 1, column 18.
+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 AT ISOLATION REPEATABLE READ;
 ERROR 42X01: Syntax error: Encountered "AT" at line 1, column 18.
+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> -- clean up
 DROP TABLE t1;
 0 rows inserted/updated/deleted
@@ -947,12 +1277,24 @@
 ij> -- DEFAULT CAST not supported in both Cloudscape and DB2 mode and that is why rather than getting feature not implemented, we will get syntax error
 create table testuser(col1 BLOB(3K) default cast(user as blob(3k)));
 ERROR 42X01: Syntax error: Encountered "cast" at line 2, column 45.
+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 testsessionuser(col1 BLOB(3K) default cast(session_user as blob(3k)));
 ERROR 42X01: Syntax error: Encountered "cast" at line 1, column 52.
+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 testcurrentuser(col1 BLOB(3K) default cast(current_user as blob(3k)));
 ERROR 42X01: Syntax error: Encountered "cast" at line 1, column 52.
+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 testschema(col1 BLOB(3K) default cast(current schema as blob(3k)));
 ERROR 42X01: Syntax error: Encountered "cast" at line 1, column 47.
+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 syntax that should be supported in db2 compat mode
 -- beetle 5267
 create table testmodify (col1 varchar(30), col2 int generated always as identity);
@@ -973,6 +1315,9 @@
 0 rows inserted/updated/deleted
 ij> alter table testaddcol add column col2 int add col3 int;
 ERROR 42X01: Syntax error: Encountered "add" at line 1, column 44.
+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> drop table testaddcol;
 0 rows inserted/updated/deleted
 ij> -- (2) adding more than one unique, referential, or check constraint 
@@ -989,17 +1334,32 @@
 ij> -- adding more than one unique-constraint 
 alter table testaddconst3 add primary key (col1) add unique (col2);
 ERROR 42X01: Syntax error: Encountered "add" at line 2, column 50.
+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 testaddconst3 add unique (col3) add unique (col4);
 ERROR 42X01: Syntax error: Encountered "add" at line 1, column 45.
+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> -- adding more than one referential-constraint 
 alter table testaddconst3 add foreign key (col1) references testaddconst1(col1) add foreign key (col2) references testaddconst2(col2);
 ERROR 42X01: Syntax error: Encountered "add" at line 2, column 81.
+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> -- adding more than one check-constraint 
 alter table testaddconst3 add check (col5 is null) add check (col6 is null);
 ERROR 42X01: Syntax error: Encountered "add" at line 2, column 52.
+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> -- adding a primary, unique, foreign key, and  check-constraint 
 alter table testaddconst4 add primary key(col1) add unique(col2) add foreign key (col1) references testaddconst1(col1) add check (col2 is null);
 ERROR 42X01: Syntax error: Encountered "add" at line 2, column 49.
+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> -- clean up
 drop table testaddconst1;
 0 rows inserted/updated/deleted
@@ -1027,14 +1387,26 @@
 ij> -- dropping more than one unique-constraint 
 alter table testdropconst1 drop primary key drop constraint uk1;
 ERROR 42X01: Syntax error: Encountered "drop" at line 2, column 45.
+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 testdropconst2 drop primary key drop constraint uk2 drop constraint uk3;
 ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 45.
+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> -- dropping more than one foreign key constraint
 alter table testdropconst5 drop constraint fk1 drop constraint fk2;
 ERROR 42X01: Syntax error: Encountered "drop" at line 2, column 48.
+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> -- dropping more than one check constraint
 alter table testdropconst6 drop constraint ck1 drop constraint ck2;
 ERROR 42X01: Syntax error: Encountered "drop" at line 2, column 48.
+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> --clean up
 drop table testdropconst1;
 0 rows inserted/updated/deleted
@@ -1056,6 +1428,9 @@
 0 rows inserted/updated/deleted
 ij> alter table testmodify alter col1 set data type varchar(60) alter col2 set data type varchar(60);
 ERROR 42X01: Syntax error: Encountered "alter" at line 1, column 61.
+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> -- clean up
 drop table testmodify;
 0 rows inserted/updated/deleted
@@ -1155,10 +1530,19 @@
 -- db2 raises ERROR 56098, cloudscape should raise error msg?a
 values cast(B'1' as char(100));
 ERROR 42X01: Syntax error: Encountered "\'1\'" at line 4, 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> values cast(B'1' as clob(1M));
 ERROR 42X01: Syntax error: Encountered "\'1\'" at line 1, 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> values cast(B'1' as blob(1M));
 ERROR 42X01: Syntax error: Encountered "\'1\'" at line 1, 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> values cast(X'11' as char(100));
 ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
 ij> values cast(X'11' as clob(1M));
@@ -1185,16 +1569,31 @@
 -- disable Field Access
 VALUES java.lang.Integer::MAX_VALUE;
 ERROR 42X01: Syntax error: java.lang.Integer::MAX_VALUE.
+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 (1)->noSuchField;
 ERROR 42X01: Syntax error: Encountered "->" at line 1, 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> -- beetle 5299
 -- disable Method Invocations 
 VALUES (1)->toString();
 ERROR 42X01: Syntax error: java.lang.Integer.toString.
+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 1.->toString();
 ERROR 42X01: Syntax error: java.math.BigDecimal.toString.
+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 1..getClass()->toString();
 ERROR 42X01: Syntax error: Encountered "1." at line 1, column 8.
+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 m5299 (i int, s varchar(10));
 0 rows inserted/updated/deleted
 ij> insert into m5299 values(1, 'hello');
@@ -1321,28 +1720,64 @@
 ij> -- No support for Java types in CAST statements;
 values CAST (NULL AS CLASS java.lang.Integer);
 ERROR 42X01: Syntax error: Encountered "" at line 3, 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> values CAST (NULL AS CLASS com.acme.SomeClass);
 ERROR 42X01: Syntax error: Encountered "" 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> values CAST (NULL AS CLASS java.sql.Date);
 ERROR 42X01: Syntax error: Encountered "" 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> values CAST (NULL AS java.lang.Integer);
 ERROR 42X01: Syntax error: Encountered "" 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> values CAST (NULL AS com.acme.SomeClass);
 ERROR 42X01: Syntax error: Encountered "" 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> values CAST (NULL AS java.sql.Date);
 ERROR 42X01: Syntax error: Encountered "" 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> values CAST (? AS CLASS java.lang.Integer);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 19.
+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 CAST (? AS CLASS com.acme.SomeClass);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 19.
+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 CAST (? AS CLASS java.sql.Date);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 19.
+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 CAST (? AS java.lang.Integer);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 19.
+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 CAST (? AS com.acme.SomeClass);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 19.
+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 CAST (? AS java.sql.Date);
 ERROR 42X01: Syntax error: Encountered "" at line 1, column 19.
+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> -- No support for BIT_LENGTH, OCTET_LENGTH, TRIP and SUBSTRING in DB2 compatibility mode
 values BIT_LENGTH(X'55');
 ERROR 42Y03: 'BIT_LENGTH' is not recognized as a function or procedure.
@@ -1358,6 +1793,9 @@
 -- Should fail.
 create table t1 ( i int null);
 ERROR 42X01: Syntax error: Encountered "null" at line 3, 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> -- Should pass.
 create table t1 (i int);
 0 rows inserted/updated/deleted
@@ -1366,6 +1804,9 @@
 ij> -- Alter table add explict null column should also fail.
 alter table t1 add column j int null;
 ERROR 42X01: Syntax error: Encountered "null" 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> -- Should pass
 alter table t1 add column j int;
 0 rows inserted/updated/deleted
@@ -1581,6 +2022,9 @@
 ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
 ij> insert into t1(i, j) select i, j from t2 union all i from t2;
 ERROR 42X01: Syntax error: Encountered "i" at line 1, column 52.
+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> -- positive cases
 insert into t1 select * from t2;
 1 row inserted/updated/deleted
@@ -1626,14 +2070,29 @@
 0 rows inserted/updated/deleted
 ij> select * from t1 where ((1=1) IS TRUE);
 ERROR 42X01: Syntax error: Encountered "TRUE" at line 1, column 34.
+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 where ((1=1) IS NOT TRUE);
 ERROR 42X01: Syntax error: Encountered "TRUE" at line 1, column 38.
+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 where ((1=0) IS FALSE);
 ERROR 42X01: Syntax error: Encountered "FALSE" at line 1, column 34.
+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 where ((1=0) IS NOT FALSE);
 ERROR 42X01: Syntax error: Encountered "FALSE" at line 1, column 38.
+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 where (null IS UNKNOWN);
 ERROR 42X01: Syntax error: Encountered "null" 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> drop table t1;
 0 rows inserted/updated/deleted
 ij> -- Beetle 5635, 5645 and 5633: Generated column name issues
@@ -1694,8 +2153,14 @@
 0 rows inserted/updated/deleted
 ij> alter table tb1 compress;
 ERROR 42X01: Syntax error: COMPRESS.
+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 tb1 compress sequential;
 ERROR 42X01: Syntax error: COMPRESS.
+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> -- clean up
 drop table tb1;
 0 rows inserted/updated/deleted
@@ -1722,10 +2187,16 @@
 -- Once we have rewritten our functions to not use following sql, SET STATISTICS TIMING can be completely removed from the parser.
 set statistics timing on;
 ERROR 42X01: Syntax error: Encountered "statistics" at line 3, 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> -- SET RUNTIMESTATISTICS ON stmt is cloudscape specific, disabled in db2 mode
 -- Once we have rewritten our functions to not use following sql, SET RUNTIMESTATISTICS can be completely removed from the parser.
 set runtimestatistics on;
 ERROR 42X01: Syntax error: Encountered "runtimestatistics" at line 3, 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> -- following runtime statistics related sql will fail in db2 mode but will run fine in Cloudscape mode
 create table t1 (c1 int, c2 int);
 0 rows inserted/updated/deleted
@@ -1741,8 +2212,14 @@
 ij> -- following runtime statistics related sql is not supported anymore and will not run in any mode
 UPDATE STATISTICS FOR TABLE T1;
 ERROR 42X01: Syntax error: Encountered "FOR" at line 2, column 19.
+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> DROP STATISTICS FOR TABLE T1;
 ERROR 42X01: Syntax error: Encountered "STATISTICS" at line 1, column 6.
+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> drop table t1;
 0 rows inserted/updated/deleted
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/delete.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/delete.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/delete.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/delete.out Sat Sep 13 07:26:16 2008
@@ -29,6 +29,9 @@
 -- table name required for positioned delete and for searched delete
 delete;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 4, column 6.
+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> -- populate the table
 insert into t1 values (1);
 1 row inserted/updated/deleted
@@ -311,4 +314,4 @@
 0 rows inserted/updated/deleted
 ij> drop table bug171_bonuses;
 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/derived.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/derived.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/derived.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/derived.out Sat Sep 13 07:26:16 2008
@@ -95,6 +95,9 @@
 -- no correlation name
 select * from (select * from s);
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 5, column 31.
+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> -- # of columns does not match
 select aa from (select * from s) ss (aa);
 ERROR 42X32: The number of columns in the derived column list must match the number of columns in table 'SS'.
@@ -489,4 +492,4 @@
 0 rows inserted/updated/deleted
 ij> drop table t;
 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/dml112.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml112.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml112.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml112.out Sat Sep 13 07:26:16 2008
@@ -619,35 +619,53 @@
      FROM WEIRDPAD
      WHERE LTRIM (RTRIM (NAAM)) = 'KEITH';
 ERROR 42X01: Syntax error: Encountered "," at line 3, 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> -- PASS:0633 If 1 row selected with value KATE ? 
 
    SELECT LTRIM (SPONSOR, 'X') 
      FROM WEIRDPAD
      WHERE RTRIM (NAAM) = '    KEITH';
 ERROR 42X01: Syntax error: Encountered "," at line 3, 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> -- PASS:0633 If 1 row selected with value KATEXXXXXX ?
 
    SELECT LTRIM (SPONSOR, 'X') 
      FROM WEIRDPAD
      WHERE RTRIM (SPONSOR, 'X') = 'XXXXKATE';
 ERROR 42X01: Syntax error: Encountered "," at line 3, 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> -- PASS:0633 If 1 row selected with value KATEXXXXXX ?
 
    SELECT LTRIM (B.NAAM)  FROM WEIRDPAD A,
      WEIRDPAD B WHERE RTRIM (LTRIM (A.NAAM, 'B'),'B')
                     = RTRIM (LTRIM (B.SPONSOR, 'X'),'X');
 ERROR 42X01: Syntax error: Encountered "," at line 4, column 43.
+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> -- PASS:0633 If 1 row selected with value KEITH ?
 
    SELECT COUNT(*) FROM WEIRDPAD A,
      WEIRDPAD B WHERE LTRIM (A.SPONSOR, '0')
                     = RTRIM (LTRIM (B.NAAM, ' '), ' ');
 ERROR 42X01: Syntax error: Encountered "," at line 4, 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> -- PASS:0633 If count = 1?
 
    SELECT RTRIM (NAAM, 'BB')
      FROM WEIRDPAD WHERE NAAM LIKE 'KATE%';
 ERROR 42X01: Syntax error: Encountered "," at line 3, 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> -- PASS:0633 If ERROR, length of trim character must be 1 ?
 
    INSERT INTO WEIRDPAD (NAAM, SPONSOR)
@@ -656,6 +674,9 @@
      FROM HU.STAFF, HU.PROJ 
      WHERE EMPNAME = 'Alice';
 ERROR 42X01: Syntax error: Encountered "," at line 4, column 42.
+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> -- PASS:0633 If 3 rows are inserted?
 
    SELECT COUNT(*) FROM WEIRDPAD;
@@ -668,6 +689,9 @@
      SET SPONSOR = LTRIM (RTRIM (SPONSOR, 'X'), 'X'),
              NAAM = RTRIM (NAAM, 'B');
 ERROR 42X01: Syntax error: Encountered "," at line 4, 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> -- PASS:0633 If 5 rows are updated?
 
    SELECT COUNT(*) FROM WEIRDPAD
@@ -680,6 +704,9 @@
    DELETE FROM WEIRDPAD WHERE
      LTRIM('Kest', 'K') = LTRIM(SPONSOR, 'T');
 ERROR 42X01: Syntax error: Encountered "," at line 4, column 18.
+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> -- PASS:0633 If 1 row is deleted?
 
    SELECT COUNT(*) FROM WEIRDPAD;
@@ -705,11 +732,17 @@
    SELECT COUNT(*) FROM WEIRDPAD
      WHERE RTRIM (SPONSOR, PADCHAR) IS NULL;
 ERROR 42X01: Syntax error: Encountered "," at line 4, column 26.
+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> -- PASS:0633 If count = 2?
 
    SELECT COUNT(*) FROM WEIRDPAD
      WHERE LTRIM (SPONSOR, PADCHAR) = 'KEITH';
 ERROR 42X01: Syntax error: Encountered "," at line 4, column 26.
+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> -- PASS:0633 If count = 1?
 
    COMMIT WORK;
@@ -723,4 +756,4 @@
 
 -- *************************************************////END-OF-MODULE
 ;
-ij> 
\ No newline at end of file
+ij> 

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=694954&r1=694953&r2=694954&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 Sat Sep 13 07:26:16 2008
@@ -354,8 +354,14 @@
 ERROR X0Y23: Operation 'DROP VIEW' cannot be performed on object 'VT1' because VIEW 'VVT1' is dependent on that object.
 ij> drop view vt1 restrict;
 ERROR 42X01: Syntax error: Encountered "restrict" at line 1, column 15.
+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> drop view vt1 cascade;
 ERROR 42X01: Syntax error: Encountered "cascade" at line 1, column 15.
+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> -- 
 -- make sure that indexes are dropped for drop table
 --