Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 66966 invoked from network); 1 Jul 2005 16:34:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Jul 2005 16:34:13 -0000 Received: (qmail 52435 invoked by uid 500); 1 Jul 2005 16:34:12 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 52372 invoked by uid 500); 1 Jul 2005 16:34:11 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 52292 invoked by uid 500); 1 Jul 2005 16:34:09 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 52263 invoked by uid 99); 1 Jul 2005 16:34:09 -0000 X-ASF-Spam-Status: No, hits=2.4 required=10.0 tests=NO_REAL_NAME,UPPERCASE_25_50,WEIRD_QUOTING X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 01 Jul 2005 09:34:05 -0700 Received: (qmail 66880 invoked by uid 65534); 1 Jul 2005 16:34:03 -0000 Message-ID: <20050701163403.66878.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r208770 [2/3] - in /incubator/derby/code/trunk/java: engine/org/apache/derby/impl/load/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/org/apache/derbyTesting/fun... Date: Fri, 01 Jul 2005 16:33:58 -0000 To: derby-cvs@incubator.apache.org From: mikem@apache.org X-Mailer: svnmailer-1.0.2 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests.out Fri Jul 1 09:33:55 2005 @@ -7,16 +7,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: An IOException occurred while writing data to the file. 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: The exception 'SQL Exception: Table 'IEP.NOTABLE' does not exist.' was thrown while evaluating an expression. ERROR 42X05: Table 'IEP.NOTABLE' does not exist. 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: The exception 'SQL Exception: Schema 'XXXX' does not exist' was thrown while evaluating an expression. ERROR 42Y07: Schema 'XXXX' does not exist @@ -29,52 +29,52 @@ call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1', 'extinout/t1.dat' , null, null, 'NOSUCHCODESET') ; ERROR XIE0I: An IOException occurred while writing data to the file. -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: The exception 'SQL Exception: Schema 'XXXX' does not exist' was thrown while evaluating an expression. ERROR 42Y07: Schema 'XXXX' does not exist 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: The period was specified as a character string delimiter. -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: A delimiter is not valid or is used more than once. 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: A delimiter is not valid or is used more than once. 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: A delimiter is not valid or is used more than once. -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: A delimiter is not valid or is used more than once. 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: A delimiter is not valid or is used more than once. -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: A delimiter is not valid or is used more than once. 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: A delimiter is not valid or is used more than once. 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; @@ -89,21 +89,21 @@ 106 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: 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. ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. ERROR XIE04: Data file not found: 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: Table 'IEP.NOTABLE' does not exist. 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: Table 'XXXX.T1' does not exist. -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: 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. @@ -112,20 +112,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: 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. ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. ERROR XIE0J: A delimiter is not valid or is used more than once. -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: 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. ERROR XJ001: Java exception: ': java.lang.reflect.InvocationTargetException'. ERROR XIE0J: A delimiter is not valid or is used more than once. 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: 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. @@ -148,7 +148,7 @@ 5 6 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. @@ -162,7 +162,7 @@ 5 6 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; @@ -178,7 +178,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: Table 'SESSION.TEMP2' does not exist. ij> select * from session.temp2 ; @@ -197,10 +197,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; @@ -215,26 +215,26 @@ 3 |3.5 |8 |test strings 4 |3.5 |8 |test strings 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: There is no column named: x1. -ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4', +ERROR XIE08: There is no column named: 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: There is no column named: x1. +ERROR XIE08: There is no column named: 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: The exception 'SQL Exception: The number of values assigned is not the same as the number of specified or implied columns.' was thrown while evaluating an expression. ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns. -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' , null, null, null, 0) ; ERROR 38000: The exception 'SQL Exception: Column 'COLUMN11' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'COLUMN11' is not a column in the target table.' was thrown while evaluating an expression. @@ -242,31 +242,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: There is no column named: x1. -ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4', +ERROR XIE08: There is no column named: X1. +ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4', 'extinout/t3.dat' , ';', '^', 'utf-16', 1) ; -ERROR XIE08: There is no column named: x1. +ERROR XIE08: There is no column named: 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' , ';', '^', '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' , ';', '^', 'utf-16', 1) ; ERROR 38000: The exception 'SQL Exception: The number of values assigned is not the same as the number of specified or implied columns.' was thrown while evaluating an expression. ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns. 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' , ';', '^', 'utf-16', 1) ; 0 rows inserted/updated/deleted @@ -280,17 +280,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: Column 'CT' in the table is of type CLOB, it is not supported by the import/export feature. ij> call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.ntype1', 'extinout/ntype.dat' , null, null, null) ; ERROR XIE0B: Column 'BT' in the table is of type BLOB, it is not supported by the import/export feature. -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: Column 'CT' in the table is of type CLOB, it is not supported by the import/export feature. -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: Column 'BT' in the table is of type BLOB, it is not supported by the import/export feature. @@ -313,7 +313,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: The exception 'SQL Exception: Table 'IEP.PARENT' cannot be locked in 'EXCLUSIVE' mode.' was thrown while evaluating an expression. ERROR X0X02: Table 'IEP.PARENT' cannot be locked in 'EXCLUSIVE' mode. ERROR 40XL1: A lock could not be obtained within the time requested Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out Fri Jul 1 09:33:55 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/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out Fri Jul 1 09:33:55 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/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/importExportThruIJ.out Fri Jul 1 09:33:55 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/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql Fri Jul 1 09:33:55 2005 @@ -7,7 +7,7 @@ insert into tab1 values(77.406, date('2000-10-19'), 'test row 5'); insert into tab1 values(50.395, date('2000-11-29'), 'test row 6'); -call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'TAB1' , 'extinout/tab1_fr.unl' , null, null, 'UTF8') ; -- localized display is off @@ -19,7 +19,7 @@ drop table tab1; create table tab1( c1 decimal(5,3), c2 date, c3 char(20) ); -call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'TAB1' , 'extinout/tab1_fr.unl' , null, null, 'UTF8', 0) ; Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql Fri Jul 1 09:33:55 2005 @@ -17,5 +17,5 @@ insert into jtest values(15,'15:35:35','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002'); insert into jtest values(16,'15:39:10','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79d2\u3067\u3057\u305f'); select * from jtest; -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'jtest' , 'extout/jtest.unl' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'JTEST' , 'extout/jtest.unl' , null, null,'EUC_JP') ; Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql?rev=208770&r1=208769&r2=208770&view=diff ============================================================================== --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql Fri Jul 1 09:33:55 2005 @@ -4,13 +4,13 @@ insert into iep.t1 values(100) , (101) , (102) , (103) , (104) , (105) , (106); --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) ; --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) ; ---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) ; --export query is invalid (syntax error) call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select from t1', @@ -20,77 +20,77 @@ call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.t1', 'extinout/t1.dat' , null, null, 'NOSUCHCODESET') ; -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) ; --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) ; -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , '.', null, null) ; --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) ; --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) ; -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, ' ', null) ; --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) ; -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, '', null) ; --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) ; --DO A VALID EXPORT AND IMPORT set schema iep; -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, null, 'utf-8') ; delete from t1 ; -call SYSCS_UTIL.SYSCS_IMPORT_TABLE('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'T1' , 'extinout/t1.dat' , null, null, null, 0) ; select * from t1; --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) ; --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) ; --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) ; -call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, null, 'INCORRECTCODESET', 0) ; --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) ; -call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't1' , 'extinout/t1.dat' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T1' , 'extinout/t1.dat' , null, '', null, 0) ; --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) ; @@ -100,19 +100,19 @@ insert into session.temp1 values(1) , (2) , (3) , (4) , (5) , (6); select * from session.temp1; --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) ; -- because temporary table has on commit preserve rows, commit issued by export will not delete data from the temp table. select * from session.temp1; --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) ; select * from v1; commit; --import to a temp table should fail with a table not found errror declare global temporary table session.temp2(c1 int) not logged; -call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('session', 'temp2' , 'extinout/temp1.dat' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('SESSION', 'TEMP2' , 'extinout/temp1.dat' , null, null, null, 0) ; select * from session.temp2 ; @@ -125,61 +125,61 @@ insert into t3 values(2 , 3.5 , 8.6 , 'test strings'); insert into t3 values(3 , 3.5 , 8.6 , 'test strings'); insert into t3 values(4 , 3.5 , 8.6 , 'test strings'); -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't3' , 'extinout/t3.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' , null, null, null) ; -call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 't3' , 'extinout/t3.dat' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' , null, null, null, 0) ; select * from t3; --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) ; -call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4', +call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4', 'extinout/t3.dat' , null, null, null, 0) ; --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) ; --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) ; -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' , null, null, null, 0) ; --repeat the above type cases with empty file and minor variation to paramters delete from t3 ; -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 't3' , 'extinout/t3.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'T3' , 'extinout/t3.dat' , ';', '^', 'utf-16') ; --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) ; -call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 't3' , 'x1, x2, x3', '1,2,3,4', +call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'T3' , 'X1, X2, X3', '1,2,3,4', 'extinout/t3.dat' , ';', '^', 'utf-16', 1) ; --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' , ';', '^', 'utf-16', 1) ; --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' , ';', '^', 'utf-16', 1) ; --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' , ';', '^', 'utf-16', 1) ; @@ -193,15 +193,15 @@ create table ntype(a int , ct CLOB(1024)); create table ntype1(bt BLOB(1024) , a int); -call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' , +call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('IEP', 'NTYPE' , 'extinout/ntype.dat' , null, null, null) ; call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from iep.ntype1', 'extinout/ntype.dat' , null, null, null) ; -call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('iep', 'ntype' , 'extinout/ntype.dat' , +call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('IEP', 'NTYPE' , 'extinout/ntype.dat' , null, null, null, 0) ; -call SYSCS_UTIL.SYSCS_IMPORT_DATA('iep', 'ntype1' , null , null, +call SYSCS_UTIL.SYSCS_IMPORT_DATA('IEP', 'NTYPE1' , null , null, 'extinout/ntype.dat' , null, null, null, 0) ; @@ -219,7 +219,7 @@ autocommit off; --following import should fail with lock time out call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.waitTimeout', '5'); -CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('iep', 'parent', 'extinout/parent.del',null, null, null,1); +CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('IEP', 'PARENT', 'extinout/parent.del',null, null, null,1); disconnect c1; disconnect c2;