You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2005/07/01 19:28:54 UTC
svn commit: r208776 [5/7] - in /incubator/derby/code/branches/10.1: ./
java/client/org/apache/derby/client/am/ java/demo/simple/
java/engine/org/apache/derby/diag/ java/engine/org/apache/derby/iapi/jdbc/
java/engine/org/apache/derby/impl/load/ java/eng...
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out Fri Jul 1 10:28:49 2005
@@ -11,16 +11,16 @@
7 rows inserted/updated/deleted
ij> --export error cases
--export can not create file
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'nodir/t1.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'nodir/t1.dat' ,
null, null, null) ;
ERROR XIE0I: Se ha obtenido 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' ,
+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' ,
+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
@@ -33,52 +33,52 @@
call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1',
'extinout/t1.dat' , null, null, 'NOSUCHCODESET') ;
ERROR XIE0I: Se ha obtenido 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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+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' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extinout/t1.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from t1;
@@ -94,21 +94,21 @@
7 rows selected
ij> --import error cases
--import can not find input file
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE('iep', 't1' , 'nodir/t1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , '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 Java: ': java.lang.reflect.InvocationTargetException'.
ERROR XIE04: Archivo de datos no encontrado: nodir/t1.dat
ij> --import table not found
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'NOTABLE' , 'extinout/t1.dat' ,
+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' ,
+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' ,
+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.
@@ -117,20 +117,20 @@
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' ,
+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 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' ,
+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 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' ,
+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.
@@ -154,7 +154,7 @@
6
6 rows selected
ij> --export to from a temporary table
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('session', 'temp1' , 'extinout/temp1.dat' ,
+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.
@@ -169,7 +169,7 @@
6
6 rows selected
ij> --import back to a regualr table
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'v1' , 'extinout/temp1.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'V1' , 'extinout/temp1.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from v1;
@@ -186,7 +186,7 @@
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' ,
+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 ;
@@ -205,10 +205,10 @@
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' ,
+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' ,
+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;
@@ -224,26 +224,26 @@
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,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3, X4', null,
'extinout/t3.dat' ,
null, null, null, 0) ;
-ERROR XIE08: No hay ninguna columna de nombre: x1
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4',
+ERROR XIE08: No hay ninguna columna de nombre: 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 hay ninguna columna de nombre: x1
+ERROR XIE08: No hay ninguna columna de nombre: 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',
+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',
+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',
+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 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.
@@ -251,31 +251,31 @@
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' ,
+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,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3, X4', null,
'extinout/t3.dat' ,
';', '^', 'utf-16', 1) ;
-ERROR XIE08: No hay ninguna columna de nombre: x1
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4',
+ERROR XIE08: No hay ninguna columna de nombre: 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 hay ninguna columna de nombre: x1
+ERROR XIE08: No hay ninguna columna de nombre: 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,
+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',
+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',
+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
@@ -289,17 +289,17 @@
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' ,
+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 recibe soporte de 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 recibe soporte de import/export.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' ,
+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 recibe soporte de import/export.
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 'ntype1' , null , null,
+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 recibe soporte de import/export.
@@ -322,7 +322,7 @@
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);
+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 puede bloquearse en modalidad 'EXCLUSIVE'.' al evaluar una expresi EnC:>243< n.
ERROR X0X02: La tabla 'IEP.PARENT' no puede bloquearse en modalidad 'EXCLUSIVE'.
ERROR 40XL1: No se ha podido obtener un bloqueo dentro del tiempo solicitado
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out Fri Jul 1 10:28:49 2005
@@ -11,11 +11,11 @@
insert into ex_emp values(99, 'smith' , 'tennis"p,l,ayer"', 190.55) ;
1 row inserted/updated/deleted
ij> -- Perform Export:
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
null, null, null) ;
0 rows inserted/updated/deleted
ij> -- Perform Import
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_EMP' , 'extinout/emp.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> insert into ex_emp values(100, 'smith' , 'tennis"player"', 190.55) ;
@@ -41,11 +41,11 @@
insert into ex_emp values(108, null , null, null) ;
1 row inserted/updated/deleted
ij> -- Perform Export:
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
null, null, null) ;
0 rows inserted/updated/deleted
ij> -- Perform Import
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_EMP' , 'extinout/emp.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from ex_emp;
@@ -89,7 +89,7 @@
call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from ex_emp where id < 105',
'extinout/emp.dat' , null, null, null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_EMP' , 'extinout/emp.dat' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> --checking query
@@ -105,7 +105,7 @@
'extinout/emp.dat' , null, null, null) ;
0 rows inserted/updated/deleted
ij> -- import them in to a with order different than in the table;
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_emp' ,'name, salary, skills, id', null,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_EMP' ,'NAME, SALARY, SKILLS, ID', null,
'extinout/emp.dat', null, null, null, 1) ;
0 rows inserted/updated/deleted
ij> --check query
@@ -117,7 +117,7 @@
-----------
6
ij> -- do import replace into the table with table order but using column indexes
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_emp' ,null, '4, 1, 3, 2',
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_EMP' ,null, '4, 1, 3, 2',
'extinout/emp.dat', null, null, null, 1) ;
0 rows inserted/updated/deleted
ij> --check query
@@ -129,7 +129,7 @@
-----------
6
ij> --replace using insert column names and column indexes
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_emp' ,'salary, id, skills, name', '2, 4, 3, 1',
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_EMP' ,'SALARY, ID, SKILLS, NAME', '2, 4, 3, 1',
'extinout/emp.dat', null, null, null, 1) ;
0 rows inserted/updated/deleted
ij> --check query
@@ -142,10 +142,10 @@
6
ij> ---testing with different delimiters
-- single quote(') as character delimiter
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
null, '''', null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_EMP' , 'extinout/emp.dat' ,
null, '''', null, 1) ;
0 rows inserted/updated/deleted
ij> select * from imp_emp ;
@@ -162,12 +162,12 @@
107 |smith" |NULL |190.55
108 |NULL |NULL |NULL
ij> -- single quote(') as column delimiter
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
'''',null, null) ;
0 rows inserted/updated/deleted
ij> delete from imp_emp ;
10 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'imp_emp' , 'extinout/emp.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'IMP_EMP' , 'extinout/emp.dat' ,
'''', null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from imp_emp;
@@ -183,10 +183,10 @@
106 |smith |""""""""""""""""""" |190.55
107 |smith" |NULL |190.55
108 |NULL |NULL |NULL
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
'*', '%', null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ex_emp' , 'extinout/emp.dat' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'EX_EMP' , 'extinout/emp.dat' ,
'*', '%', null, 1) ;
0 rows inserted/updated/deleted
ij> select * from imp_emp ;
@@ -213,11 +213,11 @@
1 row inserted/updated/deleted
ij> insert into noncast values(2.5 , 8.999) ;
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP' , 'noncast' , 'extinout/noncast.dat' , null , null , null) ;
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP' , 'NONCAST' , 'extinout/noncast.dat' , null , null , null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'noncast' , 'extinout/noncast.dat' , null , null , null , 0) ;
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NONCAST' , 'extinout/noncast.dat' , null , null , null , 0) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'noncast', 'c2 , c1' , '2, 1' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'NONCAST', 'C2 , C1' , '2, 1' ,
'extinout/noncast.dat' , null , null , null , 0) ;
0 rows inserted/updated/deleted
ij> select * from noncast ;
@@ -242,10 +242,10 @@
1 row inserted/updated/deleted
ij> insert into ttypes values(null , null , null);
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ttypes' , 'extinout/ttypes.del' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'TTYPES' , 'extinout/ttypes.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ttypes' , 'extinout/ttypes.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'TTYPES' , 'extinout/ttypes.del' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from ttypes;
@@ -269,10 +269,10 @@
1 row inserted/updated/deleted
ij> insert into t1 values(2) ;
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/t1.del' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> --above import should have committed , following rollback should be a noop.
@@ -289,7 +289,7 @@
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
ij> --file not found error should rollback
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/nofile.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
@@ -308,7 +308,7 @@
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
ij> --table not found error should issue a implicit rollback
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'notable' , 'extinout/t1.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' ,
null, null, null, 0) ;
ERROR XIE0M: Table 'NOTABLE' does not exist.
ij> commit ;
@@ -326,7 +326,7 @@
1 row inserted/updated/deleted
ij> insert into t1 values(2) ;
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
ij> --above export should have a commit.rollback below should be a noop
@@ -336,7 +336,7 @@
-----------
1
2
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/t1.del' ,
null, null, null, 1) ;
0 rows inserted/updated/deleted
ij> --above import should have committed , following rollback should be a noop.
@@ -351,7 +351,7 @@
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
ij> --file not found error should rollback
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 't1' , 'extinout/nofile.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' ,
null, null, null, 1) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
@@ -368,7 +368,7 @@
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
ij> --table not found error should issue a implicit rollback
-call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'notable' , 'extinout/t1.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' ,
null, null, null, 1) ;
ERROR XIE0M: Table 'NOTABLE' does not exist.
ij> commit ;
@@ -385,10 +385,10 @@
1 row inserted/updated/deleted
ij> insert into t1 values(2) ;
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 't1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1' , 'a' , '1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1' , 'A' , '1' , 'extinout/t1.del' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> --above import should have committed , following rollback should be a noop.
@@ -405,7 +405,7 @@
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
ij> --file not found error should rollback
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1', 'a' , '1' , 'extinout/nofile.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1' , 'extinout/nofile.del' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
@@ -424,7 +424,7 @@
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
ij> --table not found error should issue a implicit rollback
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'notable' , 'a' , '1', 'extinout/t1.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'NOTABLE' , 'A' , '1', 'extinout/t1.del' ,
null, null, null, 1) ;
ERROR XIE0M: Table 'NOTABLE' does not exist.
ij> commit ;
@@ -441,7 +441,7 @@
1 row inserted/updated/deleted
ij> insert into t1 values(4) ;
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1' , 'a' , '1' , 'extinout/t1.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1' , 'A' , '1' , 'extinout/t1.del' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from t1 ;
@@ -460,7 +460,7 @@
ij> insert into t1 values(6) ;
1 row inserted/updated/deleted
ij> --following import will back , but should not have any impact on inserts
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 't1', 'a' , '1' , 'extinout/nofile.del' ,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1' , 'extinout/nofile.del' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
ERROR 38000: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.
@@ -480,7 +480,7 @@
5
6
ij> --END IMPORT COMMIT/ROLLBACK TESTSING
----all types supported by DB2 cloudscape import/export
+---all types supported by Derby import/export
create table alltypes(chartype char(20) ,
biginttype bigint ,
datetype date ,
@@ -533,10 +533,10 @@
'xxxxxxFILTERED-TIMESTAMPxxxxx,
'"varchar" testing');
1 row inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'alltypes' , 'extinout/alltypes.del' ,
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ALLTYPES' , 'extinout/alltypes.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'alltypes' , 'extinout/alltypes.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALLTYPES' , 'extinout/alltypes.del' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select * from alltypes ;
@@ -558,7 +558,7 @@
for each row mode db2sql
insert into test1 values(newrow.chartype);
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'alltypes' , 'extinout/alltypes.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALLTYPES' , 'extinout/alltypes.del' ,
null, null, null, 0) ;
0 rows inserted/updated/deleted
ij> select count(*) from alltypes ;
@@ -573,7 +573,7 @@
"chartype" string
ij> delete from alltypes;
3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'alltypes' , 'extinout/alltypes.del' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALLTYPES' , 'extinout/alltypes.del' ,
null, null, null, 1) ;
ERROR 38000: The exception 'SQL Exception: Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).' was thrown while evaluating an expression.
ERROR 42Z08: Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).
@@ -605,7 +605,7 @@
ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select c1,c3,c4 from table2' , 'extinout/import.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL,'table1', 'c1,c3,c4' , null, 'extinout/import.del',null, null,null,0);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL,'TABLE1', 'C1,C3,C4' , null, 'extinout/import.del',null, null,null,0);
0 rows inserted/updated/deleted
ij> select * from table1;
C1 |C2 |C3 |C4
@@ -615,14 +615,14 @@
Leo |3 |23.4 |I
ij> delete from table1;
3 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE(null , 'table2' , 'extinout/import.del', null, null, null) ;
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE(null , 'TABLE2' , 'extinout/import.del', null, null, null) ;
0 rows inserted/updated/deleted
ij> --following import should fail becuase of inserting into identity column.
-CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'table1', 'extinout/import.del',null, null, null,1);
+CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'TABLE1', 'extinout/import.del',null, null, null,1);
ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.
ERROR 42Z23: Attempt to modify an identity column 'C2'.
ij> --following import should be succesful
-CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'table1', 'c1,c3,c4' , '1,3,4', 'extinout/import.del',null, null, null,1);
+CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'TABLE1', 'C1,C3,C4' , '1,3,4', 'extinout/import.del',null, null, null,1);
0 rows inserted/updated/deleted
ij> select * from table1;
C1 |C2 |C3 |C4
@@ -633,10 +633,10 @@
ij> update table2 set c2=null;
3 rows inserted/updated/deleted
ij> --check null values import to identity columns should also fail
-call SYSCS_UTIL.SYSCS_EXPORT_TABLE(null , 'table2' , 'extinout/import.del' ,
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE(null , 'TABLE2' , 'extinout/import.del' ,
null, null, null) ;
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'table1', 'extinout/import.del',null, null, null,1);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'TABLE1', 'extinout/import.del',null, null, null,1);
ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.
ERROR 42Z23: Attempt to modify an identity column 'C2'.
ij> select * from table1;
@@ -659,7 +659,7 @@
null, null, null) ;
0 rows inserted/updated/deleted
ij> --replace should fail because of dependent table
-CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'parent', 'extinout/parent.del',null, null, null,1);
+CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'PARENT', 'extinout/parent.del',null, null, null,1);
ERROR 38000: The exception 'SQL Exception: INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3). The statement has been rolled back.' was thrown while evaluating an expression.
ERROR 23503: INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3). The statement has been rolled back.
ij> select * from parent;
@@ -672,7 +672,7 @@
ij> ---test with a file which has a differen records seperators (\n, \r , \r\n)
create table nt1( a int , b char(30));
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'nt1', 'extin/mixednl.del',null, null, null,0);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'NT1', 'extin/mixednl.del',null, null, null,0);
0 rows inserted/updated/deleted
ij> select * from nt1;
A |B
@@ -705,7 +705,7 @@
web_flag varchar(1)
);
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'position_info', 'extin/position_info.del',
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'POSITION_INFO', 'extin/position_info.del',
null, null, null, 1);
0 rows inserted/updated/deleted
ij> select count(*) from position_info ;
@@ -717,12 +717,12 @@
--------------------------------------------------------------------------------------------------------------------------------
Essential Duties and Responsibilities (include but not limited to):
*Assist the director in his work activities in leading the&
-ij> CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'position_info', 'extinout/pinfo.del',
+ij> CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'POSITION_INFO', 'extinout/pinfo.del',
null, null, null);
0 rows inserted/updated/deleted
ij> delete from position_info;
680 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'position_info', 'extinout/pinfo.del',
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'POSITION_INFO', 'extinout/pinfo.del',
null, null, null, 1);
0 rows inserted/updated/deleted
ij> select count(*) from position_info ;
@@ -741,13 +741,13 @@
0 rows inserted/updated/deleted
ij> create table dest_by_default(i int generated by default as identity);
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','dest_always','extinout/autoinc.dat',null,null,null,0);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_ALWAYS','extinout/autoinc.dat',null,null,null,0);
ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.
ERROR 42Z23: Attempt to modify an identity column 'I'.
ij> select * from dest_always;
I
-----------
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','dest_by_default','extinout/autoinc.dat',null,null,null,0);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_BY_DEFAULT','extinout/autoinc.dat',null,null,null,0);
0 rows inserted/updated/deleted
ij> select * from dest_by_default;
I
@@ -763,13 +763,13 @@
0 rows inserted/updated/deleted
ij> create table dest_by_default(i int generated by default as identity);
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','dest_always','extinout/autoinc.dat',null,null,null,1);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_ALWAYS','extinout/autoinc.dat',null,null,null,1);
ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.
ERROR 42Z23: Attempt to modify an identity column 'I'.
ij> select * from dest_always;
I
-----------
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','dest_by_default','extinout/autoinc.dat',null,null,null,1);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_BY_DEFAULT','extinout/autoinc.dat',null,null,null,1);
0 rows inserted/updated/deleted
ij> select * from dest_by_default;
I
@@ -781,4 +781,147 @@
0 rows inserted/updated/deleted
ij> drop table dest_by_default;
0 rows inserted/updated/deleted
+ij> --test case for bug (DERBY-390)
+--test import/export with reserved words as table Name, column Names ..etc.
+create schema "Group";
+0 rows inserted/updated/deleted
+ij> create table "Group"."Order"("select" int, "delete" int, itemName char(20)) ;
+0 rows inserted/updated/deleted
+ij> insert into "Group"."Order" values(1, 2, 'memory') ;
+1 row inserted/updated/deleted
+ij> insert into "Group"."Order" values(3, 4, 'disk') ;
+1 row inserted/updated/deleted
+ij> insert into "Group"."Order" values(5, 6, 'mouse') ;
+1 row inserted/updated/deleted
+ij> --following export should fail because schema name is not matching the way it is defined using delimited quotes.
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('GROUP', 'Order' , 'extinout/order.dat', null, null, null) ;
+ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression.
+ERROR 42Y07: Schema 'GROUP' does not exist
+ij> --following export should fail because table name is not matching the way it is defined in the quotes.
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null) ;
+ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression.
+ERROR 42X05: Table 'Group.ORDER' does not exist.
+ij> --following export should fail because of unquoted table name that is a reserved word.
+call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group".Order' , 'extinout/order.dat' , null , null , null ) ;
+ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression.
+ERROR 42X01: Syntax error: Encountered "Order" at line 1, column 23.
+ij> --following exports should pass.
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'Order' , 'extinout/order.dat', null, null, null) ;
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group"."Order"' , 'extinout/order.dat' , null , null , null ) ;
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select "select" , "delete" , itemName from "Group"."Order"' ,
+ 'extinout/order.dat' , null , null , null ) ;
+0 rows inserted/updated/deleted
+ij> --following import should fail because schema name is not matching the way it is defined using delimited quotes.
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('GROUP', 'Order' , 'extinout/order.dat', null, null, null, 0) ;
+ERROR XIE0M: Table 'GROUP.Order' does not exist.
+ij> --following import should fail because table name is not matching the way it is defined in the quotes.
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null, 0) ;
+ERROR XIE0M: Table 'Group.ORDER' does not exist.
+ij> --following import should fail because table name is not matching the way it is defined in the quotes.
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'ORDER' , null , null , 'extinout/order.dat' , null , null , null, 1) ;
+ERROR XIE0M: Table 'Group.ORDER' does not exist.
+ij> --following import should fail because column name is not matching the way it is defined in the quotes.
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'DELETE, ITEMNAME' , '2, 3' , 'extinout/order.dat' , null , null , null, 1) ;
+ERROR XIE08: There is no column named: DELETE.
+ij> --following import should fail because undelimited column name is not in upper case.
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'delete, itemName' , '2, 3' , 'extinout/order.dat' , null , null , null, 1) ;
+ERROR XIE08: There is no column named: itemName.
+ij> --following imports should pass
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('Group', 'Order' , 'extinout/order.dat', null, null, null, 0) ;
+0 rows inserted/updated/deleted
+ij> select * from "Group"."Order";
+select |delete |ITEMNAME
+--------------------------------------------
+1 |2 |memory
+3 |4 |disk
+5 |6 |mouse
+1 |2 |memory
+3 |4 |disk
+5 |6 |mouse
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , null , null , 'extinout/order.dat' , null , null , null, 1) ;
+0 rows inserted/updated/deleted
+ij> select * from "Group"."Order";
+select |delete |ITEMNAME
+--------------------------------------------
+1 |2 |memory
+3 |4 |disk
+5 |6 |mouse
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'delete' , '2' , 'extinout/order.dat' , null , null , null, 1) ;
+0 rows inserted/updated/deleted
+ij> select * from "Group"."Order";
+select |delete |ITEMNAME
+--------------------------------------------
+NULL |2 |NULL
+NULL |4 |NULL
+NULL |6 |NULL
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'ITEMNAME, select, delete' , '3,2,1' , 'extinout/order.dat' , null , null , null, 1) ;
+0 rows inserted/updated/deleted
+ij> select * from "Group"."Order";
+select |delete |ITEMNAME
+--------------------------------------------
+2 |1 |memory
+4 |3 |disk
+6 |5 |mouse
+ij> drop table "Group"."Order";
+0 rows inserted/updated/deleted
+ij> ---test undelimited names( All unquoted SQL identfiers should be passed in upper case).
+create schema inventory;
+0 rows inserted/updated/deleted
+ij> create table inventory.orderTable(id int, amount int, itemName char(20)) ;
+0 rows inserted/updated/deleted
+ij> insert into inventory.orderTable values(101, 5, 'pizza') ;
+1 row inserted/updated/deleted
+ij> insert into inventory.orderTable values(102, 6, 'coke') ;
+1 row inserted/updated/deleted
+ij> insert into inventory.orderTable values(103, 7, 'break sticks') ;
+1 row inserted/updated/deleted
+ij> insert into inventory.orderTable values(104, 8, 'buffolo wings') ;
+1 row inserted/updated/deleted
+ij> --following export should fail because schema name is not in upper case.
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('inventory', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
+ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression.
+ERROR 42Y07: Schema 'inventory' does not exist
+ij> --following export should fail because table name is not in upper case.
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null) ;
+ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.
+ERROR 42X05: Table 'INVENTORY.ordertable' does not exist.
+ij> --following export should pass.
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
+0 rows inserted/updated/deleted
+ij> --following import should fail because schema name is not in upper case
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('inventory', 'ORDERTABLE' , 'extinout/order.dat', null, null, null, 0) ;
+ERROR XIE0M: Table 'inventory.ORDERTABLE' does not exist.
+ij> --following import should fail because table name is not in upper case.
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null, 0) ;
+ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.
+ij> --following import should fail because table name is not in upper case .
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ordertable' , null , null , 'extinout/order.dat' , null , null , null, 1) ;
+ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.
+ij> --following import should fail because column name is not in upper case.
+call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , 'amount, ITEMNAME' , '2, 3' , 'extinout/order.dat' , null , null , null, 1) ;
+ERROR XIE08: There is no column named: amount.
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , null , null , 'extinout/order.dat' , null , null , null, 1) ;
+0 rows inserted/updated/deleted
+ij> select * from inventory.orderTable;
+ID |AMOUNT |ITEMNAME
+--------------------------------------------
+101 |5 |pizza
+102 |6 |coke
+103 |7 |break sticks
+104 |8 |buffolo wings
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , 'ITEMNAME, ID, AMOUNT' , '3,2,1' , 'extinout/order.dat' , null , null , null, 1) ;
+0 rows inserted/updated/deleted
+ij> select * from inventory.orderTable;
+ID |AMOUNT |ITEMNAME
+--------------------------------------------
+5 |101 |pizza
+6 |102 |coke
+7 |103 |break sticks
+8 |104 |buffolo wings
+ij> drop table inventory.orderTable;
+0 rows inserted/updated/deleted
+ij> --end derby-390 related test cases.
+;
ij>
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out Fri Jul 1 10:28:49 2005
@@ -364,7 +364,7 @@
Payment decimal(8,2),
Balance decimal(8,2));
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'Alt1' , 'extin/Alt1.asc' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALT1' , 'extin/Alt1.asc' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: Invalid character string format for type INTEGER.' was thrown while evaluating an expression.
ERROR 22018: Invalid character string format for type INTEGER.
@@ -388,7 +388,7 @@
Payment decimal(8,2),
Balance decimal(8,2));
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'Alt3' , 'extin/Alt3.asc' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALT3' , 'extin/Alt3.asc' ,
null, null, null, 0) ;
ERROR 38000: The exception 'SQL Exception: Invalid character string format for type INTEGER.' was thrown while evaluating an expression.
ERROR 22018: Invalid character string format for type INTEGER.
@@ -428,7 +428,7 @@
email varchar(80),
web varchar(50));
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'sqlAnywhere1' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'SQLANYWHERE1' ,
null , '1,2,3,4,5,7,8,9,10,11,12,13,14',
'extin/sqlAnywhere1.txt' ,
'|', '''', 'ASCII', 0) ;
@@ -552,7 +552,7 @@
email varchar(40),
phone varchar(30));
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'sqlAnywhere2' ,
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'SQLANYWHERE2' ,
null , '3, 4, 7, 5',
'extin/sqlAnywhere2.txt' ,
'|', '''', 'ASCII', 0) ;
@@ -584,7 +584,7 @@
0 rows inserted/updated/deleted
ij> -- import it first with just LF as record seperator, we should be seeing
-- ^M's at the end of note field.
-call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'HouseHoldItem' ,
+call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'HOUSEHOLDITEM' ,
null , '2,3,4,5,6,7,8,11,14',
'extin/Access1.txt' ,
null, null, null, 0) ;
@@ -605,7 +605,7 @@
column5 varchar(200),
column6 varchar(200));
0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'imp_temp' ,null, '2, 3, 4, 5, 6',
+ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_TEMP' ,null, '2, 3, 4, 5, 6',
'extinout/t1.dump', '|', '''', 'ASCII', 0) ;
0 rows inserted/updated/deleted
ij> select * from imp_temp ;
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out Fri Jul 1 10:28:49 2005
@@ -115,7 +115,7 @@
Got expected exception ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
Negative Test15 - Can't call updateXXX methods on columns that do not correspond to a column in the table
SQL State : XJ084
-Got expected exception Column does not correspond to a column in the base table. Cant issue {0} on this column.
+Got expected exception Column does not correspond to a column in the base table. Cannot issue 'updateInt' on this column.
Negative Test16 - Call updateXXX method on out of the range column
There are only 2 columns in the select list and we are trying to send updateXXX on column position 3
SQL State : XCL14
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/scrollCursors1.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/scrollCursors1.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/scrollCursors1.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/scrollCursors1.out Fri Jul 1 10:28:49 2005
@@ -34,19 +34,18 @@
IJ ERROR: RELATIVE is not allowed on a forward only cursor.
ij> close c1;
ij> get scroll insensitive cursor c1 as 'select * from t1';
-ij> -- 0 is invalid value for absolute
-absolute 0 c1;
-IJ ERROR: 0 is an invalid value for ABSOLUTE <integer> <cursorname>
+ij> absolute 0 c1;
+No current row
ij> close c1;
ij> get scroll insensitive cursor c1 as 'select * from t1';
-ij> -- relative is invalid when not positioned on a row
-relative 0 c1;
-ERROR X0X87: ResultSet.relative(int row) cannot be called when the cursor is not positioned on a row.
+ij> relative 0 c1;
+No current row
ij> close c1;
ij> get scroll insensitive cursor c1 as 'select * from t1';
-ij> -- relative is invalid when not positioned on a row
-relative 2 c1;
-ERROR X0X87: ResultSet.relative(int row) cannot be called when the cursor is not positioned on a row.
+ij> relative 2 c1;
+C50 |I
+--------------------------------------------------------------
+c |3
ij> close c1;
ij> -- positive
-- test positioning
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out?rev=208776&r1=208775&r2=208776&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out Fri Jul 1 10:28:49 2005
@@ -76,6 +76,9 @@
ERROR XCL51: The requested function can not reference tables in SESSION schema.
ij> create synonym synForTemp for session."T1";
ERROR XCL51: The requested function can not reference tables in SESSION schema.
+ij> -- Synonyms can't be created in session schemas
+create synonym session.table1 for APP.table1;
+ERROR XCL51: The requested function can not reference tables in SESSION schema.
ij> -- Creating a table or a view when a synonym of that name is present. Error.
create synonym myTable for table1;
0 rows inserted/updated/deleted