db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpendle...@apache.org
Subject svn commit: r694954 [3/4] - in /db/derby/code/trunk/java: testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/j9_13/ testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ testing/org/...
Date Sat, 13 Sep 2008 14:26:18 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Sat Sep 13 07:26:16 2008
@@ -1559,29 +1559,65 @@
 -- beetle 5806 - support REAL built-in function
 values{fn abs( REAL( 0)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" at line 4, 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> values{fn abs( REAL(-0)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL( 1)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL(-1)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL( 1000000.001)             )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL(-1000000.001)             )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL( 3.402E+38)               )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL(-3.402E+38) + 1           )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- Error
 values{fn abs( REAL( 3.402E+38 * 2)           )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs(-REAL( NaN)                     )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL( 1.40129846432481707e-45) )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn abs( REAL( 3.40282346638528860e+38) )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- Double Precision/Double
 -- Basic
 -- beetle 5803 - support DOUBLE_[PRECISION] built-in function
@@ -1637,16 +1673,34 @@
 -- beetle 5802 - support DEC[IMAL] built-in function
 values{ fn abs(DEC( 0)             )};
 ERROR 42X01: Syntax error: Encountered "DEC" at line 4, 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> values{ fn abs(DEC(-0)             )};
 ERROR 42X01: Syntax error: Encountered "DEC" 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> values{ fn abs(DEC( 1)             )};
 ERROR 42X01: Syntax error: Encountered "DEC" 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> values{ fn abs(DEC(-1)             )};
 ERROR 42X01: Syntax error: Encountered "DEC" 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> values{ fn abs(DEC( 1000000000000) )};
 ERROR 42X01: Syntax error: Encountered "DEC" 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> values{ fn abs(DEC(-1000000000000) )};
 ERROR 42X01: Syntax error: Encountered "DEC" 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> -- More generic test
 values{ fn abs( 0-1-.1 ) };
 1              
@@ -3332,17 +3386,35 @@
 0 rows inserted/updated/deleted
 ij> insert into foo values ( sqrt(FLOAT( 1)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values ( sqrt(FLOAT( 2)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 3)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 4)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (     (FLOAT(-5)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> -- this insert should fail
 insert into foo values ( sqrt(FLOAT(-3)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 2, 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> autocommit off;
 ij> prepare p1 as 'select a from foo';
 ij> prepare p2 as 'insert into foo select a*(-1) from foo';
@@ -3356,18 +3428,36 @@
 ----------------------
 ij> insert into foo values ( sqrt(FLOAT( 6)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 7)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 8)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values ( sqrt(FLOAT( 9)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (     (FLOAT(10)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> -- few negative tests
 -- insert should fail
 insert into foo values ( sqrt(FLOAT(-7)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 3, 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> prepare p3 as 'select sqrt(a) from foo';
 ij> -- executing p3 should fail
 execute p3;
@@ -3387,19 +3477,40 @@
 ij> autocommit on;
 ij> insert into foo values ( sqrt(FLOAT( 11)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 12)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 13)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (-sqrt(FLOAT( 14)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> insert into foo values (     (FLOAT( 15)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> -- these 2 inserts should fail
 insert into foo values (-sqrt(FLOAT(-12)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 2, 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> insert into foo values ( sqrt(FLOAT(-13)));
 ERROR 42X01: Syntax error: Encountered "FLOAT" at line 1, 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> -- these should pass
 autocommit off;
 ij> execute p1;
@@ -3489,29 +3600,65 @@
 -- beetle 5806 - support REAL built-in function
 values{fn sqrt( REAL( 0)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" at line 4, 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> values{fn sqrt( REAL(-0)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL( 1)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL(-1)                       )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL( 1000000.001)             )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL(-1000000.001)             )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL( 3.402E+38)               )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL(-3.402E+38) + 1           )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- Error
 values{fn sqrt( REAL( 3.402E+38 * 2)           )};
 ERROR 42X01: Syntax error: Encountered "REAL" at line 2, 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> values{fn sqrt(-REAL( NaN)                     )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL( 1.40129846432481707e-45) )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> values{fn sqrt( REAL( 3.40282346638528860e+38) )};
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- Double Precision/Double
 -- Basic
 -- beetle 5803 - support DOUBLE_[PRECISION] built-in function
@@ -3529,14 +3676,23 @@
 1.0                   
 ij> values{fn -sqrt( DOUBLE(1)                       )};
 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> values{fn  sqrt( DOUBLE( 1000000.001)            )};
 1                     
 ----------------------
 1000.0000005          
 ij> values{fn -sqrt( DOUBLE(1000000.001)             )};
 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> values{fn -sqrt( DOUBLE(1.79769E+308)            )};
 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> values{fn  sqrt( DOUBLE( 1.79769E+308) + 1       )};
 1                     
 ----------------------
@@ -3573,6 +3729,9 @@
 -- beetle 5802 - support DEC[IMAL] built-in function
 values{ fn sqrt(DEC('0'))};
 ERROR 42X01: Syntax error: Encountered "DEC" at line 4, 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> -- More generic test
 values{ fn sqrt( 0+1+.1 ) };
 1                     
@@ -3625,25 +3784,49 @@
 ij> prepare p1 as 'select a from myreal where ? <> 1';
 ij> execute p1 using 'values  sqrt(REAL( 0 ))';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> execute p1 using 'values -sqrt(REAL( 20))';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> execute p1 using 'values  sqrt(REAL( 20))';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- this should fail
 execute p1 using 'values  sqrt(REAL(-20))';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- Prepare Statements, should pass
 -- beetle 5806 - support REAL built-in function
 prepare p2 as 'select a from myreal where ? <> 1';
 ij> execute p2 using 'values {fn sqrt (REAL( 0 ))}';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> execute p2 using 'values {fn -sqrt(REAL( 20))}';
 ERROR 42X01: Syntax error: Encountered "-" at line 1, column 12.
+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> execute p2 using 'values {fn sqrt (REAL( 20))}';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> -- this should fail
 execute p2 using 'values {fn  sqrt(REAL(-20))}';
 ERROR 42X01: Syntax error: Encountered "REAL" 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> autocommit on;
 ij> -- mod function
 create table modfn(s smallint, i int, b bigint, c char(10), d decimal(6,3), r real, dbl double);
@@ -4417,4 +4600,4 @@
 1   
 ----
  as 
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql_nonSPS.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql_nonSPS.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql_nonSPS.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql_nonSPS.out Sat Sep 13 07:26:16 2008
@@ -22,43 +22,100 @@
 0 rows inserted/updated/deleted
 ij> values{ fn abs( NULL ) };
 ERROR 42X01: Syntax error: Encountered "NULL" 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> values{ fn abs( null ) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn abs( ) };
 ERROR 42X01: Syntax error: Encountered ")" 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> -- Error
 values{ fn concat( ) };
 ERROR 42X01: Syntax error: Encountered ")" at line 2, 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> values{ fn concat( 'error0' ) };
 ERROR 42X01: Syntax error: Encountered ")" 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> values  fn concat( 'syntax', ' error1' );
 ERROR 42X01: Syntax error: Encountered "concat" at line 1, column 12.
+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{ fn concat { 'syntax', ' error2' }};
 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{ fn concat( 'syntax', ' error3' });
 ERROR 42X01: Syntax error: Encountered "}" at line 1, column 40.
+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{ fn concat( fn concat( 'nested', ' not ' ), ' allowed!' ) };
 ERROR 42X01: Syntax error: Encountered "concat" 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> values{ fn concat( values{ fn concat( 'nested', ' not ' ) }, ' allowed!' ) };
 ERROR 42X01: Syntax error: Encountered "values" 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> values{ fn locate( null, null ) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn locate( null, ''   ) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn locate( '', null   ) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn locate( null, null,1) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn locate( null, ''  ,1) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn locate( '', null  ,1) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn sqrt( NULL ) };
 ERROR 42X01: Syntax error: Encountered "NULL" 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> values{ fn sqrt( null ) };
 ERROR 42X01: Syntax error: Encountered "null" 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> values{ fn sqrt( ) };
 ERROR 42X01: Syntax error: Encountered ")" 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> -- Substring tests. Valid only as escaped function
 values substring('asdf', 1);
 ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed. 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out Sat Sep 13 07:26:16 2008
@@ -1666,9 +1666,15 @@
 ij> -- these get errors for invalid precision values:
 create table t1 (d double precision, r real, f float(-10));
 ERROR 42X01: Syntax error: Encountered "-" at line 2, column 54.
+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 t2 (d double precision, r real, f float(-1));
 ERROR 42X01: Syntax error: Encountered "-" at line 2, column 54.
+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 t3 (d double precision, r real, f float(0));
 ERROR 42X48: Value '0' is not a valid precision for FLOAT.
 ij> create table t4 (d double precision, r real, f float(100));
@@ -2577,4 +2583,4 @@
 1       
 --------
 ERROR 22018: Invalid character string format for type DECIMAL.
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/functions.out Sat Sep 13 07:26:16 2008
@@ -395,6 +395,9 @@
 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.countRows'
 LANGUAGE JAVA PARAMETER STYLE JAVA;
 ERROR 42X01: Syntax error: MODIFIES SQL DATA.
+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 FUNCTION SIGNATURE_BUG_DERBY_258_D(P_VAL INT, P_RADIX INT) RETURNS VARCHAR(20)
 LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
 EXTERNAL NAME 'java.lang.Integer.toString(int, int)';
@@ -467,4 +470,4 @@
 0 rows inserted/updated/deleted
 ij> drop function SYSFUN.ACOS;
 ERROR 42X62: 'DROP FUNCTION' is not allowed in the 'SYSFUN' schema.
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out Sat Sep 13 07:26:16 2008
@@ -414,32 +414,59 @@
 -- test1
 create table "" (c1 int);
 ERROR 42X01: Syntax error: Encountered "\"" 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> -- test2
 create table t1111 ("" int);
 ERROR 42X01: Syntax error: Encountered "\"" 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> -- test3
 create schema "";
 ERROR 42X01: Syntax error: Encountered "\"" at line 2, 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> -- identifiers can not start with "_"
 -- test4
 create table _t1(_c1 int);
 ERROR 42X01: Syntax error: Encountered "_" at line 3, 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> -- test5
 create table t1(_c1 int);
 ERROR 42X01: Syntax error: Encountered "_" at line 2, 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> -- test6
 create view _v1 (c1) as select * from t1;
 ERROR 42X01: Syntax error: Encountered "_" at line 2, 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> -- test7
 create view v1 (__c1) as select * from t1;
 ERROR 42X01: Syntax error: Encountered "_" at line 2, 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> -- test8
 create index _i1 on t1(c1);
 ERROR 42X01: Syntax error: Encountered "_" 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> -- test9
 create table "_"."_"(c1 int);
 0 rows inserted/updated/deleted
 ij> -- test10
 create table "".""(c1 int);
 ERROR 42X01: Syntax error: Encountered "\"" at line 2, column 14.
-ij> 
\ No newline at end of file
+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/iepnegativetests_ES.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out Sat Sep 13 07:26:16 2008
@@ -66,6 +66,9 @@
                                     'extinout/t1.dat' , null, null, null) ;
 ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Error de sintaxis: Encountered "from" at line 1, column 8.' al evaluar una expresi EnC:>243< n.
 ERROR 42X01: Error de sintaxis: Encountered "from" 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> --export query is null 
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY(null,
                                     'extinout/t1.dat' , null, null, null) ;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ij2.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ij2.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ij2.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ij2.out Sat Sep 13 07:26:16 2008
@@ -182,4 +182,15 @@
 ij> show connections;
 CONNECTION0* - 	jdbc:derby:wombat
 * = current connection
+ij> -- DERBY-3408: Unknown command error should suggest referring to server docs:
+show schema;
+ERROR 42X01: Syntax error: Encountered "show" at line 2, column 1.
+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> xxx;
+ERROR 42X01: Syntax error: Encountered "xxx" at line 1, column 1.
+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/implicitConversions.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out Sat Sep 13 07:26:16 2008
@@ -2614,8 +2614,14 @@
 ERROR 42X61: Types 'CHAR' and 'DECIMAL' are not UNION compatible.
 ij> values true, 'a';
 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> values 'a', 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> values date('1996-09-09'), 'a';
 1         
 ----------
@@ -3899,4 +3905,4 @@
 drop table all1;
 0 rows inserted/updated/deleted
 ij> commit;
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out Sat Sep 13 07:26:16 2008
@@ -79,6 +79,9 @@
 ij> -- between null and
 select * from t where i between null and i;
 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> -- cardinality violation on a subquery
 select * from t where i between i and (select i from s);
 ERROR 21000: Scalar subquery is only allowed to return a single row.
@@ -288,9 +291,15 @@
 -- empty list
 select i from t where i in ();
 ERROR 42X01: Syntax error: Encountered ")" at line 4, 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> -- null in list
 select i from t where i in (null);
 ERROR 42X01: Syntax error: Encountered "null" at line 2, 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> -- cardinality violation from subquery
 select i from t where i in (1, 3, 5, 6, (select i from ss));
 ERROR 21000: Scalar subquery is only allowed to return a single row.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/innerjoin.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/innerjoin.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/innerjoin.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/innerjoin.out Sat Sep 13 07:26:16 2008
@@ -41,11 +41,20 @@
 -- no join clause
 select * from t1 join t2;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 4, 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> select * from t1 inner join t2;
 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> -- empty column list
 select * from t1 join t2 using ();
 ERROR 42X01: Syntax error: Encountered "using" at line 2, 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> -- non-boolean join clause
 select * from t1 join t2 on 1;
 ERROR 42Y12: The ON clause of a JOIN is a 'INTEGER' expression.  It must be a BOOLEAN expression.
@@ -234,4 +243,4 @@
 0 rows inserted/updated/deleted
 ij> drop table insert_test;
 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/isolationLevels.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/isolationLevels.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/isolationLevels.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/isolationLevels.out Sat Sep 13 07:26:16 2008
@@ -686,6 +686,9 @@
 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> -- 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/j9_13/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out Sat Sep 13 07:26:16 2008
@@ -1647,9 +1647,15 @@
 ij> -- these get errors for invalid precision values:
 create table t1 (d double precision, r real, f float(-10));
 ERROR 42X01: Syntax error: Encountered "-" at line 2, column 54.
+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 t2 (d double precision, r real, f float(-1));
 ERROR 42X01: Syntax error: Encountered "-" at line 2, column 54.
+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 t3 (d double precision, r real, f float(0));
 ERROR 42X48: Value '0' is not a valid precision for FLOAT.
 ij> create table t4 (d double precision, r real, f float(100));

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/floattypes.out Sat Sep 13 07:26:16 2008
@@ -1647,9 +1647,15 @@
 ij> -- these get errors for invalid precision values:
 create table t1 (d double precision, r real, f float(-10));
 ERROR 42X01: Syntax error: Encountered "-" at line 2, column 54.
+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 t2 (d double precision, r real, f float(-1));
 ERROR 42X01: Syntax error: Encountered "-" at line 2, column 54.
+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 t3 (d double precision, r real, f float(0));
 ERROR 42X48: Value '0' is not a valid precision for FLOAT.
 ij> create table t4 (d double precision, r real, f float(100));

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out Sat Sep 13 07:26:16 2008
@@ -66,6 +66,9 @@
                                     'extinout/t1.dat' , null, null, null) ;
 ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: Error de sintaxis: Encountered "from" at line 1, column 8.' al evaluar una expresi EnC:>243< n.
 ERROR 42X01: Error de sintaxis: Encountered "from" 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> --export query is null 
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY(null,
                                     'extinout/t1.dat' , null, null, null) ;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ij2.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ij2.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ij2.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ij2.out Sat Sep 13 07:26:16 2008
@@ -182,4 +182,15 @@
 ij> show connections;
 CONNECTION0*
 * = current connection
+ij> -- DERBY-3408: Unknown command error should suggest referring to server docs:
+show schema;
+ERROR 42X01: Syntax error: Encountered "show" at line 2, column 1.
+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> xxx;
+ERROR 42X01: Syntax error: Encountered "xxx" at line 1, column 1.
+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/logop.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/logop.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/logop.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/logop.out Sat Sep 13 07:26:16 2008
@@ -274,15 +274,27 @@
 ij> -- following NOTs in select clause won't work because it results in a transient boolean datatype
 select ( not ( (1 = 1) or (2 = 2) ) and (3 = 4) ) from s;
 ERROR 42X01: Syntax error: Encountered "not" at line 2, column 10.
+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 ( not ( ( (1 = 1) or (2 = 2) ) and (3 = 4) ) ) from s;
 ERROR 42X01: Syntax error: Encountered "not" at line 2, column 10.
+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 ( (1 = 2) and not ( (3 = 3) or (4 = 4) ) ) from s;
 ERROR 42X01: Syntax error: Encountered "=" at line 2, 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> --
 select ( not ( (1 = 2) and ( (3 = 3) or (4 = 4) ) ) ) from s;
 ERROR 42X01: Syntax error: Encountered "not" at line 2, column 10.
+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> -- Ands under ands under ands ...
 select * from s where not (	( ( ((1=1) and (1=1)) and ((1=1) and (1=1)) ) and
 						      ( ((1=1) and (1=1)) and ((1=1) and (1=1)) ) ) and
@@ -385,6 +397,9 @@
 ij> -- following nots on nots won't work because they result in transient boolean datatype in the select clause
 select not ( not ( not ((1=2) or (1=1))) or (not ((1=2) or (1=2)) ) ) from s;
 ERROR 42X01: Syntax error: Encountered "not" 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> -- negative testing
 -- non boolean where clauses
 select * from s where 1;
@@ -404,4 +419,4 @@
 0 rows inserted/updated/deleted
 ij> drop table s;
 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/messageLocale.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out Sat Sep 13 07:26:16 2008
@@ -51,6 +51,9 @@
 ij> -- expect an error
 create table t1 oops (i int primary key);
 ERROR 42X01: Syntax error: Encountered "oops" at line 2, 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> -- setup for
 create table t2 (i int);
 0 rows inserted/updated/deleted
@@ -76,6 +79,9 @@
 -- create table t1 (i longe);
 create table t1 oops (i int primary key);
 ERROR 42X01: Error of syntax: Encountered "oops" at line 3, 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> -- warning (in qq_PP messages);
 -- create table t2 (i java.lang.Object);
 create table t2 (i int);
@@ -97,6 +103,9 @@
 ij> -- create table t1 (i longe);
 create table t1 oops (i int primary key);
 ERROR 42X01: Syntax error: Encountered "oops" at line 2, 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> -- create table t2 (i java.lang.Object);
 create table t2 (i int);
 0 rows inserted/updated/deleted

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/modifyColumn.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/modifyColumn.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/modifyColumn.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/modifyColumn.out Sat Sep 13 07:26:16 2008
@@ -106,6 +106,9 @@
 ij> -- this should fail
 alter table t1 modify a null;
 ERROR 42X01: Syntax error: Encountered "modify" 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> insert into t1 values(DEFAULT);
 1 row inserted/updated/deleted
 ij> select * from t1;
@@ -220,4 +223,4 @@
 4          |NULL                                              
 ij> drop table a;
 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/orderby.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/orderby.out Sat Sep 13 07:26:16 2008
@@ -343,13 +343,25 @@
 ij> -- . order without by (error)
 select i, v from obt order i;
 ERROR 42X01: Syntax error: Encountered "i" at line 2, 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> select i, v from obt by i;
 ERROR 42X01: Syntax error: Encountered "by" 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> -- . show order, by are reserved keywords
 select order from obt;
 ERROR 42X01: Syntax error: Encountered "order" 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> select by from obt;
 ERROR 42X01: Syntax error: Encountered "by" 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> -- . order by on column not in query (error)
 select i from obt order by c;
 ERROR 42X04: Column 'C' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'C' is not a column in the target table.
@@ -733,10 +745,19 @@
 ij> -- . order by only allowed on cursor spec, not subquerys (error) 
 select v from obt where i in (select i from obt2 order by i);
 ERROR 42X01: Syntax error: Encountered "order" 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> select v from obt where i = (select i from obt2 order by i);
 ERROR 42X01: Syntax error: Encountered "order" at line 1, 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> select v from (select i,v from obt2 order by i);
 ERROR 42X01: Syntax error: Encountered "order" 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> -- rollback should release the prepared statements
 rollback ;
 ij> -- order by allowed on datatypes, 
@@ -1269,6 +1290,9 @@
 ERROR 42X04: Column 'S.D' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'S.D' is not a column in the target table.
 ij> select *, d from t order by d;
 ERROR 42X01: Syntax error: Encountered "," 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> select t.*, d from t order by d;
 ERROR 42X04: Column 'D' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'D' is not a column in the target table.
 ij> select t.*, d from t order by t.d;
@@ -2210,4 +2234,4 @@
 ERROR 42X77: Column position '2' is out of range for the query expression.
 ij> drop table d3303;
 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/outerjoin.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outerjoin.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outerjoin.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outerjoin.out Sat Sep 13 07:26:16 2008
@@ -57,11 +57,20 @@
 -- no outer join type
 select * from t1 outer join t2;
 ERROR 42X01: Syntax error: Encountered "outer" 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> -- no join clause
 select * from t1 left outer join t2;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 2, column 35.
+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 right outer join t2;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, 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> -- positive tests
 select t1.c1 from t1 left outer join t2 on t1.c1 = t2.c1;
 C1         

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/positionedDelUpd.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/positionedDelUpd.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/positionedDelUpd.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/positionedDelUpd.out Sat Sep 13 07:26:16 2008
@@ -46,6 +46,9 @@
 -- this should fail with a syntax error
 delete;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 5, 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> -- this should succeed
 get cursor c0 as 'select * from t1 for update';
 ij> next c0;
@@ -431,6 +434,9 @@
 -- this should fail with a syntax error
 update set c1 = c1;
 ERROR 42X01: Syntax error: Encountered "set" 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> -- this should succeed
 get cursor c0 as 'select * from t1 for update';
 ij> next c0;
@@ -1182,4 +1188,4 @@
 autocommit on;
 ij> drop table test1;
 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/schemas.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out Sat Sep 13 07:26:16 2008
@@ -30,16 +30,28 @@
 ERROR 42Y07: Schema 'BLAH' does not exist
 ij> insert into blah.blah.t values (3);
 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> insert into blah.blah.blah.t values (3);
 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> select "goofy name".t.c  from "goofy name".t;
 ERROR 42Y07: Schema 'goofy name' does not exist
 ij> -- catalog name not supported:
 create table mycat.myschem.s(c int);
 ERROR 42X01: Syntax error: Encountered "." 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> -- name too long:
 create table myworld.mycat.myschem.s(c int);
 ERROR 42X01: Syntax error: Encountered "." 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> create table myschem.s(c int);
 0 rows inserted/updated/deleted
 ij> insert into s values (1);
@@ -48,8 +60,14 @@
 ERROR 42Y07: Schema 'HONK' does not exist
 ij> insert into honk.blat.s values (3);
 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> insert into loud.honk.blat.s values (4);
 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> -- Catalog names in column expressions cause syntax errors.  Rather than
 -- fix this, I am checking it in this way, considering that no client we
 -- know of uses catalogs.
@@ -62,6 +80,9 @@
 ij> -- catalog name not supported:
 drop table goodness.gosh.s;
 ERROR 42X01: Syntax error: Encountered "." at line 2, 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> -- finds s, schema name ignored:
 drop table gosh.s;
 ERROR 42Y07: Schema 'GOSH' does not exist
@@ -516,8 +537,14 @@
 ij> -- try prepared statements, should fail
 prepare createSchema as 'create schema ?';
 ERROR 42X01: Syntax error: Encountered "?" 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> prepare dropSchema as 'drop schema ? RESTRICT';
 ERROR 42X01: Syntax error: Encountered "?" 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> --
 -- specific drop schema tests, all should fail
 --
@@ -540,6 +567,9 @@
 ij> -- syntax not supported yet (but is in the parser)
 drop schema x cascade;
 ERROR 42X01: Syntax error: Encountered "cascade" at line 2, 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> set schema app;
 0 rows inserted/updated/deleted
 ij> drop schema x restrict;
@@ -744,6 +774,9 @@
 from test.s
 order by a;
 ERROR 42X01: Syntax error: Encountered "exists" at line 4, 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> -- negative tests
 
 -- multiple matches at parent level
@@ -966,4 +999,4 @@
 0 rows inserted/updated/deleted
 ij> drop schema test restrict;
 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/select.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out Sat Sep 13 07:26:16 2008
@@ -66,6 +66,9 @@
 ij> -- select * and constants and columns 
 select *, 10, i from t;
 ERROR 42X01: Syntax error: Encountered "," 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> -- select correlation name dot star
 select b.* from t b;
 I          |S     
@@ -214,4 +217,4 @@
 ERROR 42X04: Column 'SYS.S1.T1.D1' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'SYS.S1.T1.D1' is not a column in the target table.
 ij> select SYS."S1.T1".d1 from "S1.T1" t1;
 ERROR 42X04: Column 'SYS.S1.T1.D1' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'SYS.S1.T1.D1' is not a column in the target table.
-ij> 
\ No newline at end of file
+ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/stringtypes.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/stringtypes.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/stringtypes.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/stringtypes.out Sat Sep 13 07:26:16 2008
@@ -419,6 +419,9 @@
 ERROR 42X44: Invalid length '0' in column specification.
 ij> create table badtab3 (x long varchar(3));
 ERROR 42X01: Syntax error: Encountered "(" 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> -- JDBC escape syntax for string functions
 create table trash(c1 char(10));
 0 rows inserted/updated/deleted
@@ -442,4 +445,4 @@
 ERROR 54002: A string constant starting with ''4749463837617201db01f70000000900001d00001500141a0a002200002&' is too long.
 ij> drop table lvc;
 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/subquery.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out Sat Sep 13 07:26:16 2008
@@ -484,10 +484,19 @@
 ij> -- select list
 select ( i in (select i from t) ) a from s order by a;
 ERROR 42X01: Syntax error: Encountered "in" at line 2, column 12.
+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 in (select i from t where 1 = 0) ) a from s order by a;
 ERROR 42X01: Syntax error: Encountered "in" at line 1, column 12.
+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 in (select i from t where 1 = 0)) is null ) a from s order by a;
 ERROR 42X01: Syntax error: Encountered "in" 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> -- subquery under an or
 select i from s where i = -1 or i in (select i from t);
 I          
@@ -714,9 +723,15 @@
 -- binary list node
 select i in (1,2) from (select i from s) as tmp(i);
 ERROR 42X01: Syntax error: Encountered "in" at line 6, column 10.
+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> -- conditional expression
 select i = 1 ? 1 : i from (select i from s) as tmp(i);
 ERROR 42X01: Syntax error: Encountered "=" at line 2, column 10.
+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> -- more tests for correlated column resolution
 select * from s where i = (values i);
 I          |S     |C                             |VC                            |B                   
@@ -791,6 +806,9 @@
 ij> update u set b = exists (select b from t)
 where vc <> (select vc from s where vc = '1');
 ERROR 42X01: Syntax error: Encountered "exists" 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 u;
 I          |S     |C                             |VC                            |B                   
 -----------------------------------------------------------------------------------------------------

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery2.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery2.out?rev=694954&r1=694953&r2=694954&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery2.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery2.out Sat Sep 13 07:26:16 2008
@@ -81,6 +81,9 @@
 ij> -- invalid operator
 select * from s where s * ANY (select c from t);
 ERROR 42X01: Syntax error: Encountered "ANY" 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> -- ? in select list of subquery
 select * from s where s = ANY (select ? from s);
 ERROR 42X34: There is a ? parameter in the select list.  This is not allowed.
@@ -990,6 +993,9 @@
 update u set b = exists (select * from t)
 where vc < ANY (select vc from s);
 ERROR 42X01: Syntax error: Encountered "exists" at line 2, 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 u;
 I          |S     |C                             |VC                            |B                   
 -----------------------------------------------------------------------------------------------------



Mime
View raw message