db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r370059 [3/4] - in /db/derby/code/trunk/java: testing/org/apache/derbyTesting/functionTests/harness/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/j9_foundation/ testing/org/apach...
Date Wed, 18 Jan 2006 05:43:44 GMT
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/LOBTest.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out?rev=370059&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out Tue Jan 17 21:43:13 2006
@@ -0,0 +1,264 @@
+Test autoGeneratedJdbc30 starting
+Test 1 - request for generated keys resultset on a brand new statement with no sql executed on it yet
+We will get a resultset with no rows because it is a non-insert sql
+<NULL>
+Test2 - request for generated keys on a statement which does select from a table ie a non-insert sql
+We will get a resultset with no rows because it is a non-insert sql
+<NULL>
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+<NULL>
+Test 3 - insert multiple rows into a table with autogenerated key and request generated keys resultset
+ We will get a row with NULL value because this insert sql inserted more than one row and 
+ there was no prior one-row insert into a table with autogenerated key
+	 1
+	 -
+	{3}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{6}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{9}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{12}
+Test 4 - request for generated keys after doing an insert into a table with no auto generated keys
+ And there has been no one-row insert into a table with auto-generated keys yet.
+We should get a resultset with one row of NULL value from getGeneratedKeys
+	 1
+	 -
+	{12}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{12}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{12}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{12}
+Test 5a - request for generated keys after doing a one-row insert(using a subquery) into a table with autogenerated key using a subquery with auto generated keys
+Even though this is a one-row insert but since insert has a sub-select, get generated keys will return one row of NULL value
+	 1
+	 -
+	{6}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{12}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{18}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Test 5b - request for generated keys after doing a one-row insert(using a subquery) into a table with autogenerated key using a subquery with auto generated keys
+Even though this is a one-row insert but since insert has a sub-select, get generated keys will return one row of NULL value
+	 1
+	 -
+	{0}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{0}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{0}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{0}
+Test 5c - request for generated keys after doing a one-row insert(using a subquery) into a table with autogenerated key using a subquery with auto generated keys
+Even though this is a one-row insert but since insert has a sub-select, get generated keys will return one row of NULL value
+	 1
+	 -
+	{25}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{26}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{27}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{28}
+Test 6 - request for generated keys after doing a one-row insert into a table with auto generated keys
+We should get a resultset with one row of non-NULL value
+	 1
+	 -
+	{29}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{30}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{31}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{32}
+Test 7 - Now try again inserting multiple rows into a table with autogenerated key and request generated keys resultset
+ This time we will get a row of non-NULL value because there has been a prior one-row insert into table with auto-generated key 
+	 1
+	 -
+	{15}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{18}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{21}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Test 8 - create a new statement and request for generated keys on it after doing an insert into 
+ a table with no auto generated keys
+We should get a resultset with one row of non-NULL value
+	 1
+	 -
+	{24}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{24}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Test 9 - request for generated keys on a statement which does a update 
+We should get a resultset with no rows from getGeneratedKeys because we executed a non-insert sql
+<NULL>
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+<NULL>
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+<NULL>
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+<NULL>
+Test 10 - request for generated keys on a statement which does a delete 
+We should get a resultset with no rows from getGeneratedKeys because we executed a non-insert sql
+<NULL>
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+<NULL>
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+<NULL>
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+<NULL>
+Test 11 - do a commit and request for generated keys on a statement which does insert into a table with 
+ no auto generated keys (previous transaction had a one-row insert on a table with auto-generated keys)
+expected to see resultset with one row of NULL value but instead get one row of non-NULL value from getGeneratedKeys
+	 1
+	 -
+	{24}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{24}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Test 12 - do a rollback and request for generated keys on a statement which does insert into a table with 
+ no auto generated keys (previous transaction had a one-row insert on a table with auto-generated keys)
+had expected to see resultset with one row of NULL value but instead get one row of non-NULL value from getGeneratedKeys
+	 1
+	 -
+	{24}
+Now try the same test again but this time with Statement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Now try the same test again but this time with PreparedStatement.execute. It should behave the same
+	 1
+	 -
+	{24}
+Now try the same test again but this time with PreparedStatement.executeUpdate. It should behave the same
+	 1
+	 -
+	{24}
+Test 13 - try savepoint rollback and see what happens to auto generated keys resultset
+Inside the savepoint unit, issue a one-row insert into a table with auto generated keys
+We should get a resultset with one row of non-NULL value
+	 1
+	 -
+	{33}
+Now rollback the savepoint unit, and make sure that autogenerated keys resultset still holds on to 
+ value that got set inside the rolled back savepoint unit
+	 1
+	 -
+	{33}
+Test 14 - Look at metadata of a getGeneratedKeys resultset
+The resultset will have one column only
+Found 1 column in the resultset
+Type of the column is DECIMAL
+Precision of the column is 31
+Scale of the column is 0
+	 1
+	 -
+	{25}
+Test 15 - Can not see the auto generated keys if insert is with NO_GENERATED_KEYS
+<NULL>
+<NULL>
+<NULL>
+<NULL>
+Test 16 - Can not see the auto generated keys if insert is done jdbc 2.0 way ie with no generated key feature
+<NULL>
+<NULL>
+<NULL>
+<NULL>
+Test 17 - non-insert with NO_GENERATED_KEYS
+<NULL>
+<NULL>
+<NULL>
+<NULL>
+Test 18 - non-insert is done jdbc 2.0 way ie with no generated key feature
+<NULL>
+<NULL>
+<NULL>
+<NULL>
+Test21 - insert select with columnIndexes[] array should fail
+Try passing array with Statement.execute
+PASS - expected exception - Feature not implemented
+Try passing array with Statement.executeUpdate
+PASS -- expected exception
+SQLSTATE(0A000): Feature not implemented: executeUpdate(String, int[]).
+Test21ps - insert select with columnIndexes[] array should fail
+Try passing array with Connection.prepareStatement
+PASS -- expected exception
+SQLSTATE(0A000): Feature not implemented: prepareStatement(String, int[]).
+Test22 - insert select with columnNames[] array should fail
+Try passing array with Statement.execute
+PASS -- expected exception
+SQLSTATE(0A000): Feature not implemented: execute(String, String[]).
+Try passing array with Statement.executeUpdate
+PASS -- expected exception
+SQLSTATE(0A000): Feature not implemented: executeUpdate(String, String[]).
+Test22ps - insert select with columnNames[] array should fail
+Try passing array with Connection.prepareStatement
+PASS -- expected exception
+SQLSTATE(0A000): Feature not implemented: prepareStatement(String, String[]).
+Test autoGeneratedJdbc30 finished

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/autoGeneratedJdbc30.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dbMetaDataJdbc30.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dbMetaDataJdbc30.out?rev=370059&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dbMetaDataJdbc30.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dbMetaDataJdbc30.out Tue Jan 17 21:43:13 2006
@@ -0,0 +1,31 @@
+Test dbMetaDataJdbc30 starting
+JDBC Driver 'Apache Derby Embedded JDBC Driver', version 10.2 (10.2.0.0 alpha)
+DatabaseMetaData.getURL not present - correct for JSR169
+supportsSavepoints() : true
+supportsNamedParameters() : false
+supportsMultipleOpenResults() : true
+supportsGetGeneratedKeys() : false
+supportsResultSetHoldability(HOLD_CURSORS_OVER_COMMIT) : true
+supportsResultSetHoldability(CLOSE_CURSORS_AT_COMMIT) : true
+getJDBCMajorVersion() : 3
+getJDBCMinorVersion() : 0
+getSQLStateType() : 2
+getResultSetHoldability() : 1
+getDatabaseMajorVersion() : 10
+getDatabaseMinorVersion() : 2
+supportsStatementPooling() : false
+getMaxColumnNameLength() = 128
+getMaxCursorNameLength() = 128
+getMaxSchemaNameLength() = 128
+getMaxProcedureNameLength() = 128
+getMaxTableNameLength() = 128
+getMaxUserNameLength() = 30
+getSuperTypes() with null :
+EXPECTED: Not Implemented Exception or empty  ResultSet
+getSuperTables() with null :
+EXPECTED: Not Implemented Exception or empty  ResultSet
+getAttributes() with null :
+EXPECTED: Not Implemented Exception or empty  ResultSet
+locatorsUpdateCopy(): 
+Expected : Feature not implemented: no details.
+Test dbMetaDataJdbc30 finished

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/dbMetaDataJdbc30.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/holdCursorJava.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/holdCursorJava.out?rev=370059&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/holdCursorJava.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/holdCursorJava.out Tue Jan 17 21:43:13 2006
@@ -0,0 +1,12 @@
+Creating table...
+done creating table and inserting data.
+Start multi table query with holdability true test
+value of t2.c22 is 1
+value of t2.c22 is 2
+Multi table query with holdability true test over
+Start isolation level change test
+Switch isolation while there are open cursors
+Should see exceptions
+ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
+PASS: Can't change isolation if they are open cursor
+Isolation level change test over

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/holdCursorJava.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out?rev=370059&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out Tue Jan 17 21:43:13 2006
@@ -0,0 +1,332 @@
+CONNECTION0*
+* = current connection
+ij> --run the import/export negative tests in locale ES 
+run resource  '/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql';
+ij> --testing error cases for import/export
+create schema iep;
+0 rows inserted/updated/deleted
+ij> create table iep.t1(a int);
+0 rows inserted/updated/deleted
+ij> insert into iep.t1 values(100) , (101) , (102) , (103) , (104) , (105) , (106);
+7 rows inserted/updated/deleted
+ij> --export error cases
+--export can not create file
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extout/nodir/t1.dat' , 
+                                 null, null, null) ;
+ERROR XIE0I: Se ha producido una excepci EnC:>243< n de E/S al grabar datos en el archivo.
+ij> --export table not found
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' , 
+                                 null, null, null) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: La tabla 'IEP.NOTABLE' no existe.' al evaluar una expresi EnC:>243< n.
+ERROR 42X05: La tabla 'IEP.NOTABLE' no existe.
+ij> ---export schema is not valid
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
+                                 null, null, null) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El esquema 'XXXX' no existe.' al evaluar una expresi EnC:>243< n.
+ERROR 42Y07: El esquema 'XXXX' no existe.
+ij> --export query is invalid (syntax error)
+call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select from t1', 
+                                    'extinout/t1.dat' , null, null, null) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: 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.
+ij> --export codeset is invalid
+call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1', 
+                                    'extinout/t1.dat' , null, null, 'NOSUCHCODESET') ;
+ERROR XIE0I: Se ha producido una excepci EnC:>243< n de E/S al grabar datos en el archivo.
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
+                                 null, null, null) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El esquema 'XXXX' no existe.' al evaluar una expresi EnC:>243< n.
+ERROR 42Y07: El esquema 'XXXX' no existe.
+ij> --export delimiter errror cases
+--period can not be used as character ot column delimiter
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, '.', null) ;
+ERROR XIE0K: El punto se ha especificado como un delimitador de serie de caracteres.
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 '.', null, null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> --same delimter can not be used as character and column delimters
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 ';', ';', null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> --space character can not be a delimiter
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 ' ', ';', null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, ' ', null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> --if emtry strinng is passed actual value delimiter should be space
+--and the that should become a invalid delimiter 
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 '', ';', null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, '', null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> --more than one character passed to the delimiters get truncated to one
+--following one should give error because eventually '\' delimiter 
+--is used a both for char and col
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 '\a', '\', null) ;
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> --DO A VALID EXPORT AND  IMPORT 
+set schema iep;
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, null, 'utf-8') ;
+0 rows inserted/updated/deleted
+ij> delete from t1 ;
+7 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, null, 'utf-8', 0) ;
+0 rows inserted/updated/deleted
+ij> select * from t1;
+A          
+-----------
+100        
+101        
+102        
+103        
+104        
+105        
+106        
+7 rows selected
+ij> --import error cases
+--import can not find input file
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extin/nodir/t1.dat' , 
+                                 null, null, null, 0) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n.
+ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.
+ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'.
+ERROR XIE04: Archivo de datos no encontrado: extin/nodir/t1.dat
+ij> --import table not found
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'NOTABLE' , 'extinout/t1.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE0M: La tabla 'IEP.NOTABLE' no existe. 
+ij> --import schema is not valid
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('XXXX', 'T1' , 'extinout/t1.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE0M: La tabla 'XXXX.T1' no existe. 
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, null, 'INCORRECTCODESET', 0) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n.
+ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.
+ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'.
+ERROR XJ001: Excepci EnC:>243< n de Java: 'java.io.UnsupportedEncodingException: INCORRECTCODESET'.
+ij> --check import with invalid delimiter usage
+--if emtry strinng is passed actual value delimiter should be space
+--and the that should become a invalid delimiter 
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 '', ';', null, 0) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n.
+ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.
+ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'.
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 null, '', null, 0) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n.
+ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.
+ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'.
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> --same delimter can not be used as character and column delimters
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , 
+                                 ';', ';', null, 1) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.' al evaluar una expresi EnC:>243< n.
+ERROR 38000: Se he generado la excepci EnC:>243< n 'java.lang.reflect.InvocationTargetException' al evaluar una expresi EnC:>243< n.
+ERROR XJ001: Excepci EnC:>243< n de Java: ': java.lang.reflect.InvocationTargetException'.
+ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m EnC:>225< s de una vez.
+ij> autocommit off;
+ij> create table v1(a int) ;
+0 rows inserted/updated/deleted
+ij> declare global temporary table session.temp1(c1 int) on commit preserve rows not logged;
+0 rows inserted/updated/deleted
+ij> insert into session.temp1 values(1) , (2) , (3) , (4) , (5) , (6);
+6 rows inserted/updated/deleted
+ij> select * from session.temp1;
+C1         
+-----------
+1          
+2          
+3          
+4          
+5          
+6          
+6 rows selected
+ij> --export to from a temporary table
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('SESSION', 'TEMP1' , 'extinout/temp1.dat' , 
+                           null, null, null) ;
+0 rows inserted/updated/deleted
+ij> -- because temporary table has on commit preserve rows, commit issued by export will not delete data from the temp table.
+select * from session.temp1;
+C1         
+-----------
+1          
+2          
+3          
+4          
+5          
+6          
+6 rows selected
+ij> --import back to a regualr table
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'V1' , 'extinout/temp1.dat' , 
+                                 null, null, null, 0) ;
+0 rows inserted/updated/deleted
+ij> select * from v1;
+A          
+-----------
+1          
+2          
+3          
+4          
+5          
+6          
+6 rows selected
+ij> commit;
+ij> --import to a temp table should fail with a table not found errror
+declare global temporary table session.temp2(c1 int) not logged;
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SESSION', 'TEMP2' , 'extinout/temp1.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE0M: La tabla 'SESSION.TEMP2' no existe. 
+ij> select * from session.temp2 ;
+ERROR 42X05: La tabla 'SESSION.TEMP2' no existe.
+ij> commit ;
+ij> drop table v1;
+0 rows inserted/updated/deleted
+ij> autocommit on;
+ij> create table t3(c1 int , c2 double , c3 decimal , c4 varchar(20) );
+0 rows inserted/updated/deleted
+ij> insert into t3 values(1 , 3.5 , 8.6 , 'test strings');
+1 row inserted/updated/deleted
+ij> insert into t3 values(2 , 3.5 , 8.6 , 'test strings');
+1 row inserted/updated/deleted
+ij> insert into t3 values(3 , 3.5 , 8.6 , 'test strings');
+1 row inserted/updated/deleted
+ij> insert into t3 values(4 , 3.5 , 8.6 , 'test strings');
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' , 
+                                 null, null, null) ;
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' , 
+                                 null, null, null, 0) ;
+0 rows inserted/updated/deleted
+ij> select * from t3;
+C1         |C2                    |C3    |C4                  
+--------------------------------------------------------------
+1          |3.5                   |8     |test strings        
+2          |3.5                   |8     |test strings        
+3          |3.5                   |8     |test strings        
+4          |3.5                   |8     |test strings        
+1          |3.5                   |8     |test strings        
+2          |3.5                   |8     |test strings        
+3          |3.5                   |8     |test strings        
+4          |3.5                   |8     |test strings        
+8 rows selected
+ij> --import data column names are incorrect
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3, X4', null,
+                                 'extinout/t3.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE08: No existe una columna denominada: X1.  
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4', 
+                                 'extinout/t3.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE08: No existe una columna denominada: X1.  
+ij> --import data insert column names count < column indexes does not match
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3', '1,2,3,4', 
+                                 'extinout/t3.dat' , 
+                                 null, null, null, 0) ;
+0 rows inserted/updated/deleted
+ij> --import data column indexes count > insert columns count
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3,C4', '1,2', 
+                                 'extinout/t3.dat' , 
+                                 null, null, null, 0) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.' al evaluar una expresi EnC:>243< n.
+ERROR 42802: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '11,22,12,24', 
+                                 'extinout/t3.dat' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  null, null, null, 0) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: La columna 'COLUMN11' no est EnC:>225<  en ninguna tabla de la lista FROM o aparece en una especificaci EnC:>243< n de uni EnC:>243< n y est EnC:>225<  fuera del  EnC:>225< mbito de la especificaci EnC:>243< n de uni EnC:>243< n o bien aparece en una cl EnC:>225< usula HAVING y no est EnC:>225<  en la lista GROUP BY. Si se trata de una sentencia CREATE o ALTER TABLE entonces 'COLUMN11' no es una columna de la tabla destino.' al evaluar una expresi EnC:>243< n.
+ERROR 42X04: La columna 'COLUMN11' no est EnC:>225<  en ninguna tabla de la lista FROM o aparece en una especificaci EnC:>243< n de uni EnC:>243< n y est EnC:>225<  fuera del  EnC:>225< mbito de la especificaci EnC:>243< n de uni EnC:>243< n o bien aparece en una cl EnC:>225< usula HAVING y no est EnC:>225<  en la lista GROUP BY. Si se trata de una sentencia CREATE o ALTER TABLE entonces 'COLUMN11' no es una columna de la tabla destino.
+ij> --repeat the above type cases with empty file and minor variation to paramters
+delete from t3 ;
+12 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' , 
+                                  ';', '^', 'utf-16') ;
+0 rows inserted/updated/deleted
+ij> --import data column names are incorrect
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3, X4', null, 
+                                 'extinout/t3.dat' , 
+                                 ';', '^', 'utf-16', 1) ;
+ERROR XIE08: No existe una columna denominada: X1.  
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4', 
+                                 'extinout/t3.dat' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<     ';', '^', 'utf-16', 1) ;
+ERROR XIE08: No existe una columna denominada: X1.  
+ij> --import data insert column names count < column indexes does not match
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'C1, C2, C3', null, 
+                                 'extinout/t3.dat' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<     ';', '^', 'utf-16', 1) ;
+0 rows inserted/updated/deleted
+ij> --import data column indexes count > insert columns count
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '1,2', 
+                                 'extinout/t3.dat' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<     ';', '^', 'utf-16', 1) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.' al evaluar una expresi EnC:>243< n.
+ERROR 42802: El n EnC:>250< mero de valores asignado no coincide con el n EnC:>250< mero de columnas especificadas o impl EnC:>237< citas.
+ij> --specify column indexes that are not there in the file that is being  imported
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , null, '11,22,12,24', 
+                                 'extinout/t3.dat' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<     ';', '^', 'utf-16', 1) ;
+0 rows inserted/updated/deleted
+ij> --import to a system table shoud fail
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SYS', 'SYSTABLES' , 'extinout/t3.dat' , 
+                                      ';', '^', 'utf-16', 1) ;
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: 'SYS.SYSTABLES' es una tabla del sistema. Los usuarios no tienen permitido modificar el contenido de esta tabla.' al evaluar una expresi EnC:>243< n.
+ERROR 42Y25: 'SYS.SYSTABLES' es una tabla del sistema. Los usuarios no tienen permitido modificar el contenido de esta tabla.
+ij> ---not supported by db2 cloudscape import/export
+create table ntype(a int , ct CLOB(1024));
+0 rows inserted/updated/deleted
+ij> create table ntype1(bt BLOB(1024) , a int);
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NTYPE' , 'extinout/ntype.dat' , 
+                                 null, null, null) ;
+ERROR XIE0B: La columna CT de la tabla de tipo CLOB, no est EnC:>225<  soportada por la funci EnC:>243< n import/export. 
+ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.ntype1',
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<    'extinout/ntype.dat' , 
+                                   null, null, null) ;
+ERROR XIE0B: La columna BT de la tabla de tipo BLOB, no est EnC:>225<  soportada por la funci EnC:>243< n import/export. 
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'NTYPE' , 'extinout/ntype.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE0B: La columna CT de la tabla de tipo CLOB, no est EnC:>225<  soportada por la funci EnC:>243< n import/export. 
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'NTYPE1' , null , null, 
+                                 'extinout/ntype.dat' , 
+                                 null, null, null, 0) ;
+ERROR XIE0B: La columna BT de la tabla de tipo BLOB, no est EnC:>225<  soportada por la funci EnC:>243< n import/export. 
+ij> --import should aquire a lock on the table
+create table parent(a int not null primary key);
+0 rows inserted/updated/deleted
+ij> insert into parent values (1) , (2) , (3) , (4) ;
+4 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from parent where a < 3' , 'extinout/parent.del' , 
+                                 null, null, null) ;
+0 rows inserted/updated/deleted
+ij> connect 'wombat' as c1;
+ij(C1)> connect 'wombat' as c2;
+ij(C2)> set connection c1;
+ij(C1)> autocommit off;
+ij(C1)> lock table iep.parent in share mode;
+0 rows inserted/updated/deleted
+ij(C1)> set connection c2;
+ij(C2)> autocommit off;
+ij(C2)> --following import should fail with lock time out
+call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.waitTimeout', '5');
+0 rows inserted/updated/deleted
+ij(C2)> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'PARENT', 'extinout/parent.del',null, null, null,1);
+ERROR 38000: Se he generado la excepci EnC:>243< n 'SQL Exception: La tabla 'IEP.PARENT' no se puede bloquear en modalidad 'EXCLUSIVE'.' al evaluar una expresi EnC:>243< n.
+ERROR X0X02: La tabla 'IEP.PARENT' no se puede bloquear en modalidad 'EXCLUSIVE'.
+ERROR 40XL1: No se ha podido obtener un bloqueo dentro del tiempo solicitado
+ij(C2)> disconnect c1;
+ij(C2)> disconnect c2;
+ij> set connection connection0;
+ij> 

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/iepnegativetests_ES.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultsetJdbc30.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultsetJdbc30.out?rev=370059&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultsetJdbc30.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultsetJdbc30.out Tue Jan 17 21:43:13 2006
@@ -0,0 +1,22 @@
+Test resultsetJdbc30 starting
+trying rs.getURL(int) :
+Expected : Feature not implemented: no details.
+trying rs.getURL(String) :
+Expected : Feature not implemented: no details.
+trying rs.updateRef(int, Ref) :
+ResultSet.updateRef not present - correct for JSR169
+trying rs.updateRef(String, Ref) :
+ResultSet.updateRef not present - correct for JSR169
+trying rs.updateBlob(int, Blob) :
+Expected : 'updateBlob' not allowed because the ResultSet is not an updatable ResultSet. 
+trying rs.updateBlob(String, Blob) :
+Expected : 'updateBlob' not allowed because the ResultSet is not an updatable ResultSet. 
+trying rs.updateClob(int, Clob) :
+Expected : 'updateClob' not allowed because the ResultSet is not an updatable ResultSet. 
+trying rs.updateClob(String, Clob) :
+Expected : 'updateClob' not allowed because the ResultSet is not an updatable ResultSet. 
+trying rs.updateArray(int, Array) :
+ResultSet.updateArray not present - correct for JSR169
+trying rs.updateArray(String, Array) :
+ResultSet.updateArray not present - correct for JSR169
+Test resultsetJdbc30 finished

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultsetJdbc30.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/users.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/users.out?rev=370059&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/users.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/users.out Tue Jan 17 21:43:13 2006
@@ -0,0 +1,152 @@
+ij> --
+connect 'wombat;create=true;user=dan;password=MakeItFaster';
+WARNING 01J01: Database 'wombat' not created, connection made to existing database instead.
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> prepare p1 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION1)> execute p1 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> execute p1 using 'values(''derby.database.fullAccessUsers'', ''francois,jeff,howardR,ames,kreg'')';
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> remove p1;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> autocommit on;
+ij(CONNECTION1)> disconnect;
+ij> connect 'wombat;shutdown=true;user=francois;password=paceesalute';
+ERROR 08006: Database 'wombat' shutdown.
+ij> connect 'myDB;create=true;user=dan;password=MakeItFaster';
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> prepare p2 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION1)> execute p2 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> execute p2 using 'values(''derby.database.fullAccessUsers'', ''jerry,kreg,dan,jamie,ames,francois'')';
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> remove p2;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> autocommit on;
+ij(CONNECTION1)> disconnect;
+ij> connect 'myDB;shutdown=true;user=dan;password=MakeItFaster';
+ERROR 08006: Database 'myDB' shutdown.
+ij> -- beetle 5468
+disconnect all;
+ij> -- Specifically test JBMS users.
+--
+-- check allowed users in wombat db.
+connect 'wombat;user=kreg;password=visualWhat?';
+ij> connect 'wombat;user=jeff;password=HomeRun61';
+ij(CONNECTION1)> connect 'wombat;user=ames;password=AnyVolunteer?';
+ij(CONNECTION2)> connect 'wombat;user=howardR;password=IamBetterAtTennis';
+ij(CONNECTION3)> connect 'wombat;user=francois;password=paceesalute';
+ij(CONNECTION4)> show connections;
+CONNECTION0
+CONNECTION1
+CONNECTION2
+CONNECTION3
+CONNECTION4*
+* = current connection
+ij(CONNECTION4)> disconnect all;
+ij> -- check allowed users in myDB db.
+-- also check USER flavors
+connect 'myDB;user=jerry;password=SacreBleu';
+ij> create table APP.t1(c1 char(30) check (UPPER(c1) <> 'JAMIE'));
+0 rows inserted/updated/deleted
+ij> insert into APP.t1 values CURRENT_USER;
+1 row inserted/updated/deleted
+ij> connect 'myDB;user=kreg;password=visualWhat?';
+ij(CONNECTION1)> insert into APP.t1 values USER;
+1 row inserted/updated/deleted
+ij(CONNECTION1)> connect 'myDB;user=ames;password=AnyVolunteer?';
+ij(CONNECTION2)> insert into APP.t1 values SESSION_USER;
+1 row inserted/updated/deleted
+ij(CONNECTION2)> connect 'myDB;user=dan;password=MakeItFaster';
+ij(CONNECTION3)> select * from APP.t1;
+C1                            
+------------------------------
+JERRY                         
+KREG                          
+AMES                          
+ij(CONNECTION3)> update APP.t1 set c1 = {fn user() };
+3 rows inserted/updated/deleted
+ij(CONNECTION3)> select * from APP.t1;
+C1                            
+------------------------------
+DAN                           
+DAN                           
+DAN                           
+ij(CONNECTION3)> connect 'myDB;user=francois;password=paceesalute';
+ij(CONNECTION4)> update APP.t1 set c1 = USER;
+3 rows inserted/updated/deleted
+ij(CONNECTION4)> connect 'myDB;user=jamie;password=MrNamePlates';
+ij(CONNECTION5)> select * from APP.t1;
+C1                            
+------------------------------
+FRANCOIS                      
+FRANCOIS                      
+FRANCOIS                      
+ij(CONNECTION5)> update APP.t1 set c1 = USER;
+ERROR 23513: The check constraint 'xxxxGENERATED-IDxxxx' was violated while performing an INSERT or UPDATE on table 'APP.T1'.
+ij(CONNECTION5)> show connections;
+CONNECTION0
+CONNECTION1
+CONNECTION2
+CONNECTION3
+CONNECTION4
+CONNECTION5*
+* = current connection
+ij(CONNECTION5)> disconnect all;
+ij> --
+-- some negative cases
+--
+-- Invalid login's
+connect 'wombat';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> connect 'wombat;user=badUser1;password=YeeHa!';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> connect 'wombat;user=badUser2;password=YeeHa!';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> connect 'myDB;user=dan;password=MakeItSlower';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> connect 'myDB;user=jamie;password=LetMeIn';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> connect 'wombat;user=francois;password=Corsica';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> -- Invalid database users
+connect 'myDB;user=howardR;password=IamBetterAtTennis';
+ERROR 04501: Database connection refused.
+ij> connect 'wombat;user=jerry;password=SacreBleu';
+ERROR 04501: Database connection refused.
+ij> connect 'wombat;user=jamie;password=MrNamePlates';
+ERROR 04501: Database connection refused.
+ij> show connections;
+No connections available.
+ij> connect 'wombat;user=francois;password=paceesalute';
+ij> connect 'myDB;user=jerry;password=SacreBleu';
+ij(CONNECTION1)> -- Database shutdown - check user - should fail
+connect 'myDB;shutdown=true';
+ERROR 08004: Connection refused : Invalid authentication.
+ij(CONNECTION1)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
+ERROR 08004: Connection refused : Invalid authentication.
+ij(CONNECTION1)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
+ERROR 04501: Database connection refused.
+ij(CONNECTION1)> show connections;
+CONNECTION0
+CONNECTION1*
+* = current connection
+ij(CONNECTION1)> -- Database shutdown - check user - should succeed
+-- beetle 5367
+connect 'wombat;user=francois;password=paceesalute;shutdown=true';
+ERROR 08006: Database 'wombat' shutdown.
+ij(CONNECTION1)> connect 'myDB;user=jerry;password=SacreBleu;shutdown=true';
+ERROR 08006: Database 'myDB' shutdown.
+ij(CONNECTION1)> show connections;
+No current connection
+ij> -- JBMS System shutdown - check user - should fail
+connect ';user=jamie;password=LetMeIn;shutdown=true';
+ERROR 08004: Connection refused : Invalid authentication.
+ij> disconnect all;
+ij> -- JBMS System shutdown - check user - should succeed
+connect ';user=francois;password=paceesalute;shutdown=true';
+ERROR XJ015: Derby system shutdown.
+ij> -- beetle 5390
+-- the server does not shut down properly in network server
+;
+ij> 

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/users.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/maxMemPerTab.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/maxMemPerTab.out?rev=370059&r1=370058&r2=370059&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/maxMemPerTab.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/maxMemPerTab.out Tue Jan 17 21:43:13 2006
@@ -1,33 +1,18 @@
-ij> autocommit off;
-ij> create table tab1 (c1 int, c2 varchar(20000));
-0 rows inserted/updated/deleted
-ij> create table tab2 (c1 int, c2 varchar(20000));
-0 rows inserted/updated/deleted
-ij> create table tab3 (c1 int, c2 varchar(2000));
-0 rows inserted/updated/deleted
-ij> create table tab4 (c1 int, c2 varchar(2000));
-0 rows inserted/updated/deleted
-ij> create procedure INSERTDATA() language java parameter style java external name 'org.apache.derbyTesting.functionTests.util.ProcedureTest.maxMemPerTabTest';
-0 rows inserted/updated/deleted
-ij> call INSERTDATA();
-0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
-0 rows inserted/updated/deleted
-ij> maximumdisplaywidth 2500;
-ij> -- should use nested loop join due to maxMemoryPerTable property setting
-select * from tab1, tab2 where tab1.c2 = tab2.c2;
+Start creating tables and inserting data ...
+... done creating tables and inserting data.
+Called SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)
+#### Executing "select * from tab1, tab2 where tab1.c2 = tab2.c2"
 C1         |C2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
 1          |aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&|1          |aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&
 3          |ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc&|2          |cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc&
-ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
+#### Executing "values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()"
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
 Statement Name: 
 	null
 Statement Text: 
-	-- should use nested loop join due to maxMemoryPerTable property setting
-select * from tab1, tab2 where tab1.c2 = tab2.c2
+	select * from tab1, tab2 where tab1.c2 = tab2.c2
 Parse Time: 0
 Bind Time: 0
 Optimize Time: 0
@@ -97,20 +82,18 @@
 Ordered nulls: false
 Unknown return value: false
 Negate comparison result: false
-ij> -- should use hash join, maxMemoryPerTable property value is big enough
-select * from tab3, tab4 where tab3.c2 = tab4.c2;
+#### Executing "select * from tab3, tab4 where tab3.c2 = tab4.c2"
 C1         |C2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
 1          |aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|1          |aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
 3          |ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 cccccccccccccccccccccccccccccccccc|2          |cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
 ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
-ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
+#### Executing "values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()"
 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
 Statement Name: 
 	null
 Statement Text: 
-	-- should use hash join, maxMemoryPerTable property value is big enough
-select * from tab3, tab4 where tab3.c2 = tab4.c2
+	select * from tab3, tab4 where tab3.c2 = tab4.c2
 Parse Time: 0
 Bind Time: 0
 Optimize Time: 0
@@ -183,5 +166,3 @@
 Ordered nulls: false
 Unknown return value: false
 Negate comparison result: false
-ij> rollback;
-ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultsetJdbc30.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultsetJdbc30.out?rev=370059&r1=370058&r2=370059&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultsetJdbc30.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultsetJdbc30.out Tue Jan 17 21:43:13 2006
@@ -17,6 +17,6 @@
 Expected : 'updateClob' not allowed because the ResultSet is not an updatable ResultSet. 
 trying rs.updateArray(int, Array) :
 Expected : Feature not implemented: no details.
-trying rs.updateClob(String, Array) :
+trying rs.updateArray(String, Array) :
 Expected : Feature not implemented: no details.
 Test resultsetJdbc30 finished

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerStream.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerStream.out?rev=370059&r1=370058&r2=370059&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerStream.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerStream.out Tue Jan 17 21:43:13 2006
@@ -1,90 +1,38 @@
-ij> --
--- Small trigger stream test.  Make sure we can
--- read streams ok from the context of a row or
--- statement trigger.
---
-create function getAsciiColumn( whichRS int, colNumber int, value varchar(128)) returns int
-  PARAMETER STYLE JAVA LANGUAGE JAVA NO SQL
-  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.StreamUtil.getAsciiColumn';
-0 rows inserted/updated/deleted
-ij> create procedure insertAsciiColumn( stmtText varchar( 256), colNumber int, value varchar(128), length int)
-  PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA
-  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.StreamUtil.insertAsciiColumn';
-0 rows inserted/updated/deleted
-ij> create function getBinaryColumn( whichRS int, colNumber int, value varchar(128)) returns int
-  PARAMETER STYLE JAVA LANGUAGE JAVA NO SQL
-  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.StreamUtil.getBinaryColumn';
-0 rows inserted/updated/deleted
-ij> create procedure insertBinaryColumn( stmtText varchar( 256), colNumber int, value varchar(128), length int)
-  PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA
-  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.StreamUtil.insertBinaryColumn';
-0 rows inserted/updated/deleted
-ij> drop table x;
-ERROR 42Y55: 'DROP TABLE' cannot be performed on 'X' because it does not exist.
-ij> create table x (x int, c1 long varchar, y int, slen int);
-0 rows inserted/updated/deleted
-ij> -- this getAsciiColumn() method reads in the stream
--- and verifies each byte and prints out the length
--- of the column
-create trigger t1 NO CASCADE before update of x,y on x for each statement mode db2sql
-	values getAsciiColumn( 0, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t2 after update of x,y on x for each row  mode db2sql
-	values getAsciiColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t3 after insert on x for each statement  mode db2sql
-	values getAsciiColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t4 NO CASCADE before insert on x for each row  mode db2sql
-	values getAsciiColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t5 NO CASCADE before delete on x for each statement  mode db2sql
-	values getAsciiColumn( 0, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t6 after delete on x for each row  mode db2sql
-	values getAsciiColumn( 0, 2, 'a');
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (1, ?, 1, ?)', 1, 'a', 1);
+Start creating tables and functions to be used in triggers ...
+... done creating tables and functions to be used in triggers.
+Start creating triggers for Ascii stream tests ...
+... done creating triggers for Ascii stream tests.
+Call #1 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (2, ?, 2, ?)', 1, 'a', 10);
+Call #2 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (3, ?, 3, ?)', 1, 'a', 100);
+Call #3 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (4, ?, 4, ?)', 1, 'a', 1000);
+Call #4 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (5, ?, 5, ?)', 1, 'a', 5000);
+Call #5 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (6, ?, 6, ?)', 1, 'a', 10000);
+Call #6 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (7, ?, 7, ?)', 1, 'a', 16500);
+Call #7 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (8, ?, 8, ?)', 1, 'a', 32500);
+Call #8 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (9, ?, 9, ?)', 1, 'a', 0);
+Call #9 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> call insertAsciiColumn('insert into x values (10, ?, 10, ?)', 1, 'a', 666);
+Call #10 to insertAsciiColumn
 getAsciiColumn() called
 getAsciiColumn() called
-0 rows inserted/updated/deleted
-ij> update x set x = x+1;
+#### Executing "update x1 set x = x+1"
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
@@ -96,8 +44,7 @@
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
-10 rows inserted/updated/deleted
-ij> update x set x = null;
+#### Executing "update x1 set x = null"
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
@@ -109,8 +56,7 @@
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
-10 rows inserted/updated/deleted
-ij> insert into x select * from x;
+#### Executing "insert into x1 select * from x1"
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
@@ -122,8 +68,7 @@
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
-10 rows inserted/updated/deleted
-ij> delete from x;
+#### Executing "delete from x1"
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
@@ -145,77 +90,42 @@
 getAsciiColumn() called
 getAsciiColumn() called
 getAsciiColumn() called
-20 rows inserted/updated/deleted
-ij> drop table x;
-0 rows inserted/updated/deleted
-ij> create table x (x int, c1 long varchar for bit data, y int, slen int);
-0 rows inserted/updated/deleted
-ij> -- this getBinaryColumn() method reads in the stream
--- and verifies each byte and prints out the length
--- of the column
-create trigger t1 NO CASCADE before update of x,y on x for each statement  mode db2sql
-	values getBinaryColumn( 0, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t2 after update of x,y on x for each row  mode db2sql
-	values getBinaryColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t3 after insert on x for each statement  mode db2sql
-	values getBinaryColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t4 NO CASCADE before insert on x for each row  mode db2sql
-	values getBinaryColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t5 NO CASCADE before delete on x for each statement  mode db2sql
-	values getBinaryColumn( 1, 2, 'a');
-0 rows inserted/updated/deleted
-ij> create trigger t6 after delete on x for each row  mode db2sql
-	values getBinaryColumn( 0, 2, 'a');
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (1, ?, 1, ?)', 1, 'a', 1);
+Start creating triggers for binary stream tests ...
+... done creating triggers for binary stream tests.
+Call #1 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (2, ?, 2, ?)', 1, 'a', 10);
+Call #2 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (3, ?, 3, ?)', 1, 'a', 100);
+Call #3 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (4, ?, 4, ?)', 1, 'a', 1000);
+Call #4 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (5, ?, 5, ?)', 1, 'a', 10000);
+Call #5 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (6, ?, 6, ?)', 1, 'a', 32700);
+Call #6 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (7, ?, 7, ?)', 1, 'a', 32699);
+Call #7 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (8, ?, 8, ?)', 1, 'a', 16384);
+Call #8 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (9, ?, 9, ?)', 1, 'a', 16383);
+Call #9 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (10, ?, 10, ?)', 1, 'a', 0);
+Call #10 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> call insertBinaryColumn('insert into x values (11, ?, 11, ?)', 1, 'a', 666);
+Call #11 to insertBinaryColumn
 getBinaryColumn() called
 getBinaryColumn() called
-0 rows inserted/updated/deleted
-ij> select x, length(c1) from x order by 1;
+#### Executing "select x, length(c1) from x2 order by 1"
 X          |2          
 -----------------------
 1          |1          
@@ -229,7 +139,7 @@
 9          |16383      
 10         |0          
 11         |666        
-ij> update x set x = x+1;
+#### Executing "update x2 set x = x+1"
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
@@ -242,8 +152,7 @@
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
-11 rows inserted/updated/deleted
-ij> select x, length(c1) from x order by 1;
+#### Executing "select x, length(c1) from x2 order by 1"
 X          |2          
 -----------------------
 2          |1          
@@ -257,7 +166,7 @@
 10         |16383      
 11         |0          
 12         |666        
-ij> update x set x = null;
+#### Executing "update x2 set x = null"
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
@@ -270,8 +179,7 @@
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
-11 rows inserted/updated/deleted
-ij> select x, length(c1) from x order by 2;
+#### Executing "select x, length(c1) from x2 order by 2"
 X          |2          
 -----------------------
 NULL       |0          
@@ -285,7 +193,7 @@
 NULL       |16384      
 NULL       |32699      
 NULL       |32700      
-ij> insert into x select * from x;
+#### Executing "insert into x2 select * from x2"
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
@@ -298,8 +206,7 @@
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
-11 rows inserted/updated/deleted
-ij> select x, length(c1) from x order by 2;
+#### Executing "select x, length(c1) from x2 order by 2"
 X          |2          
 -----------------------
 NULL       |0          
@@ -324,7 +231,7 @@
 NULL       |32699      
 NULL       |32700      
 NULL       |32700      
-ij> delete from x;
+#### Executing "delete from x2"
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
@@ -348,5 +255,3 @@
 getBinaryColumn() called
 getBinaryColumn() called
 getBinaryColumn() called
-22 rows inserted/updated/deleted
-ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/init.properties
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/init.properties?rev=370059&r1=370058&r2=370059&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/init.properties (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/init.properties Tue Jan 17 21:43:13 2006
@@ -1,2 +1,5 @@
 #
-database=jdbc:derby:mydb;create=true
+ij.database=jdbc:derby:mydb;create=true
+
+# DataSource properties, only used if ij.dataSource is set
+ij.dataSource.databaseName=mydb;create=true
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/run.properties
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/run.properties?rev=370059&r1=370058&r2=370059&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/run.properties (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/multi/stress/run.properties Tue Jan 17 21:43:13 2006
@@ -1,5 +1,9 @@
 #
-database=jdbc:derby:mydb;create=false
+ij.database=jdbc:derby:mydb;create=false
+
+# DataSource properties, only used if ij.dataSource is set
+ij.dataSource.databaseName=mydb
+
 derby.locks.deadlockTimeout=3
 derby.locks.waitTimeout=5
 #derby.locks.monitor=true



Mime
View raw message