db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r691812 - in /db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests: master/ suites/ testData/ testData/ImportExport/ tests/tools/
Date Wed, 03 Sep 2008 22:39:47 GMT
Author: myrnavl
Date: Wed Sep  3 15:39:46 2008
New Revision: 691812

URL: http://svn.apache.org/viewvc?rev=691812&view=rev
Log:
DERBY-3863; improve importexport ij test; backport of 691769 from 10.3 (which 
  was a modified backport of the trunk change via 10.4); with modifications
  for bug test cases not fixed in this branche. 

Added:
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out
      - copied, changed from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_NullFields.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_NullFields.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_defaultformat.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_defaultformat.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_format1.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_format1.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_format2.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_format2.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_format2oops.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/AccountData_format2oops.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/NoEOR.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/NoEOR.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/TwoLineBadEOF.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/TwoLineBadEOF.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/UnsupportedFormat1.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/UnsupportedFormat1.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/UnsupportedFormat2.dat
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/testData/ImportExport/UnsupportedFormat2.dat
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql
      - copied, changed from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ_app.properties
      - copied unchanged from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ_app.properties
Modified:
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/build.xml
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport.java
    db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport_app.properties

Copied: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out
(from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out)
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out?p2=db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out&p1=db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out&r1=691757&r2=691812&rev=691812&view=diff
==============================================================================
--- db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/master/importExportIJ.out
Wed Sep  3 15:39:46 2008
@@ -49,7 +49,7 @@
 ij> -- second line of data file is not complete - should give error message re EOF
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extin/TwoLineBadEOF.dat' , 
                                     null, null, null, 0) ;
-ERROR XIE0R: Import error on line 2 of file extin/TwoLineBadEOF.dat: Read endOfFile at unexpected
place on line 2. 
+ERROR 38000: The exception 'java.sql.SQLException: Read endOfFile at unexpected place on
line 2.' was thrown while evaluating an expression.
 ERROR XIE0E: Read endOfFile at unexpected place on line 2.
 ij> -- should work, default format (i.e. field sep , column delimiter ".)
 -- (last two lines have extra white space (tabs, spaces) which should not matter).
@@ -303,7 +303,7 @@
 0 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALT1' , 'extin/UnsupportedFormat1.dat'
, 
                                       null, null, null, 0) ;
-ERROR XIE0R: Import error on line 1 of file extin/UnsupportedFormat1.dat: Invalid character
string format for type INTEGER. 
+ERROR 38000: The exception 'java.sql.SQLException: Invalid character string format for type
INTEGER.' was thrown while evaluating an expression.
 ERROR 22018: Invalid character string format for type INTEGER.
 ij> select count(*) from Alt1;
 1          
@@ -513,7 +513,7 @@
 ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALT7' ,
 			          'extin/AccountData_format2oops.dat' , 
 				  '|', '''', 'ASCII', 0) ;
-ERROR XIE0R: Import error on line 1 of file extin/AccountData_format2oops.dat: Data found
on line 1 for column 4 after the stop delimiter.   
+ERROR 38000: The exception 'java.sql.SQLException: Data found on line 1 for column 4 after
the stop delimiter.' was thrown while evaluating an expression.
 ERROR XIE03: Data found on line 1 for column 4 after the stop delimiter.  
 ij> select count(*) from Alt8;
 ERROR 42X05: Table/View 'ALT8' does not exist.
@@ -592,7 +592,7 @@
 				  null , '2,3,4,5,6,7,8,11,12,10', 
 				  'extin/Access1.txt' , 
 				  null, null, null, 0) ;
-ERROR XIE0R: Import error on line 1 of file extin/Access1.txt: Invalid character string format
for type SMALLINT. 
+ERROR 38000: The exception 'java.sql.SQLException: Invalid character string format for type
SMALLINT.' was thrown while evaluating an expression.
 ERROR 22018: Invalid character string format for type SMALLINT.
 ij> select * from HouseHoldItem;
 ERROR 42X05: Table/View 'HOUSEHOLDITEM' does not exist.
@@ -728,127 +728,5 @@
 ij> drop table users;
 0 rows inserted/updated/deleted
 ij> -- end derby-1854/derby-1641 test case. 
---
--- begin test case for derby-2193:
---
--- Field comprised of all blank space should become a null
---
-create table derby_2193_tab
-(
-    a  varchar( 50 ),
-    b  varchar( 50 )
-);
-0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE 
-( null, 'DERBY_2193_TAB', 'extin/derby-2193.txt', null, null, null, 0 );
-0 rows inserted/updated/deleted
-ij> select * from derby_2193_tab;
-A                                                 |B                                    
            
------------------------------------------------------------------------------------------------------
-who put the bop                                   |in the bopshebop                     
            
-diddywopdiddy                                     |NULL                                 
            
-boopdeedoo                                        |boopdeedoo                           
            
-ij> select b, length(b) from derby_2193_tab;
-B                                                 |2          
---------------------------------------------------------------
-in the bopshebop                                  |16         
-NULL                                              |NULL       
-boopdeedoo                                        |10         
-ij> --
--- Errors should contain identifying line numbers
---
-create table derby_2193_lineNumber
-(
-    a  int,
-    b  int
-);
-0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE 
-( null, 'DERBY_2193_LINENUMBER', 'extin/derby-2193-linenumber.txt', null, null, null, 0 );
-ERROR XIE0R: Import error on line 2 of file extin/derby-2193-linenumber.txt: Invalid character
string format for type INTEGER. 
-ERROR 22018: Invalid character string format for type INTEGER.
-ij> select * from derby_2193_lineNumber;
-ERROR 42X05: Table/View 'DERBY_2193_LINENUMBER' does not exist.
-ij> --
--- end test case for derby-2193:
---
---
--- begin test case for derby-2925:
---
--- Prevent export from overwriting existing files 
---
-create table derby_2925_tab
-(
-    a  varchar( 50 ),
-    b  varchar( 50 )
-);
-0 rows inserted/updated/deleted
-ij> --
--- Testing SYSCS_UTIL.SYSCS_EXPORT_TABLE
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
-( null, 'DERBY_2925_TAB', 'extout/derby-2925.txt', null, null, null);
-0 rows inserted/updated/deleted
-ij> --
--- Errors should should happen in the second
--- call to SYSCS_UTIL.SYSCS_EXPORT_TABLE
--- since extout/derby-2925.txt already exists. 
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
-( null, 'DERBY_2925_TAB', 'extout/derby-2925.txt', null, null, null);
-ERROR XIE0S: The export operation was not performed, because the specified output file (extout/derby-2925.txt)
already exists. Export processing will not overwrite an existing file, even if the process
has permissions to write to that file, due to security concerns, and to avoid accidental file
damage. Please either change the output file name in the export procedure arguments to specify
a file which does not exist, or delete the existing file, then retry the export operation.
-ij> --
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY
-('select * from DERBY_2925_TAB', 'extout/derby-2925-query.dat', null , null , null ) ;
-0 rows inserted/updated/deleted
-ij> --
--- Errors should should happen in the second
--- call to SYSCS_UTIL.SYSCS_EXPORT_QUERY
--- since extout/derby-2925-query.dat already exists.
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY
-('select * from DERBY_2925_TAB', 'extout/derby-2925-query.dat', null , null , null ) ;
-ERROR XIE0S: The export operation was not performed, because the specified output file (extout/derby-2925-query.dat)
already exists. Export processing will not overwrite an existing file, even if the process
has permissions to write to that file, due to security concerns, and to avoid accidental file
damage. Please either change the output file name in the export procedure arguments to specify
a file which does not exist, or delete the existing file, then retry the export operation.
-ij> --
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
---
-create table derby_2925_lob
-(
-	id 	int,
-        name 	varchar(30),
-        content clob, 
-        pic 	blob 
-);
-0 rows inserted/updated/deleted
-ij> --
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- where data file exists.
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
-('SELECT * FROM DERBY_2925_LOB','extout/derby-2925_data.dat', '\t' ,'|','UTF-16','extout/derby-2925_lobs.dat');
-0 rows inserted/updated/deleted
-ij> --
--- Errors should should happen in the second
--- call to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- since extout/derby-2925_data.dat already exists.
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
-('SELECT * FROM DERBY_2925_LOB','extout/derby-2925_data.dat', '\t' ,'|','UTF-16','extout/derby-2925_lobs.dat');
-ERROR XIE0S: The export operation was not performed, because the specified output file (extout/derby-2925_data.dat)
already exists. Export processing will not overwrite an existing file, even if the process
has permissions to write to that file, due to security concerns, and to avoid accidental file
damage. Please either change the output file name in the export procedure arguments to specify
a file which does not exist, or delete the existing file, then retry the export operation.
-ij> --
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- where lob file exists.
---
--- Errors should should happen in the 
--- call to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- since extout/derby-2925_lobs.dat already exists.
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
-('SELECT * FROM DERBY_2925_LOB','extout/derby-2925_data1.dat', '\t' ,'|','UTF-16','extout/derby-2925_lobs.dat');
-ERROR XIE0T: The export operation was not performed, because the specified large object auxiliary
file (extout/derby-2925_lobs.dat) already exists. Export processing will not overwrite an
existing file, even if the process has permissions to write to that file, due to security
concerns, and to avoid accidental file damage. Please either change the large object auxiliary
file name in the export procedure arguments to specify a file which does not exist, or delete
the existing file, then retry the export operation.
-ij> --
--- end test case for derby-2925:
 ;
 ij> 

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall?rev=691812&r1=691811&r2=691812&view=diff
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/suites/derbytools.runall
Wed Sep  3 15:39:46 2008
@@ -1,7 +1,7 @@
 tools/dblook_test.java
 tools/derbyrunjartest.java
 tools/importExport.java
-tools/importExportThruIJ.sql
+tools/importExportIJ.sql
 tools/ieptests.sql
 tools/iepnegativetests.sql
 tools/ij.sql

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/build.xml
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/build.xml?rev=691812&r1=691811&r2=691812&view=diff
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/build.xml
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/testData/build.xml
Wed Sep  3 15:39:46 2008
@@ -45,7 +45,7 @@
     </copy>
     <copy todir="${out.dir}/${derby.testing.functest.dir}/testData/ImportExport">
       <fileset dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/testData/ImportExport"
-        includes="*.asc,*.del,*.txt,*.utf"/>
+        includes="*.asc,*.del,*.txt,*.utf,*.dat"/>
     </copy>
   </target>
 

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport.java
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport.java?rev=691812&r1=691811&r2=691812&view=diff
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport.java
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport.java
Wed Sep  3 15:39:46 2008
@@ -149,7 +149,7 @@
 			//test less data case on the seconds line of input that 
 			//should throw end of file exception. 
 			try{
-				doImportFromFile("extin/EndOfFile.txt" , "T4" , null , null , null, 0);
+				doImportFromFile("extin/TwoLineBadEOF.dat" , "T4" , null , null , null, 0);
 			}catch (Exception ex) {
 				printExceptionMessage(ex);
 			}
@@ -353,10 +353,13 @@
 			verifyCount(
 						stmt.executeUpdate("CREATE TABLE T3 (C1 BLOB)"), 0);
 			verifyCount(
-						stmt.executeUpdate("create table T4 (   Account int,    Fname   char(30),"+
-                        "Lname   char(30), Company varchar(35), Address varchar(40), City
   varchar(20),"+
- 					   "State   char(5), Zip     char(10), Payment decimal(8,2), Balance decimal(8,2))"),0);
-			
+
+						stmt.executeUpdate("create table T4 (   Account int,  Name   char(30), Jobdesc char(40),
" +
+										   "Company varchar(35), Address1 varchar(40), Address2 varchar(40), " +
+										   "City    varchar(20), State   char(5), Zip char(10), Country char(10), " +
+										   "Phone1  char(20), Phone2  char(20), email   char(30), web     char(30), " +
+										   "Fname   char(30), Lname   char(30), Comment char(30), AccDate char(30), " +
+										   "Payment decimal(8,2), Balance decimal(8,2))"),0);
 		} else {
 			verifyBoolean( stmt.execute("DELETE FROM t1"), false);
 		}

Copied: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql
(from r691757, db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql)
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql?p2=db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql&p1=db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql&r1=691757&r2=691812&rev=691812&view=diff
==============================================================================
--- db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExportIJ.sql
Wed Sep  3 15:39:46 2008
@@ -443,118 +443,3 @@
 drop table users;
 -- end derby-1854/derby-1641 test case. 
 
---
--- begin test case for derby-2193:
---
--- Field comprised of all blank space should become a null
---
-
-create table derby_2193_tab
-(
-    a  varchar( 50 ),
-    b  varchar( 50 )
-);
-
-CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE 
-( null, 'DERBY_2193_TAB', 'extin/derby-2193.txt', null, null, null, 0 );
-select * from derby_2193_tab;
-select b, length(b) from derby_2193_tab;
-
---
--- Errors should contain identifying line numbers
---
-create table derby_2193_lineNumber
-(
-    a  int,
-    b  int
-);
-
-CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE 
-( null, 'DERBY_2193_LINENUMBER', 'extin/derby-2193-linenumber.txt', null, null, null, 0 );
-select * from derby_2193_lineNumber;
-
---
--- end test case for derby-2193:
---
-
---
--- begin test case for derby-2925:
---
--- Prevent export from overwriting existing files 
---
-
-create table derby_2925_tab
-(
-    a  varchar( 50 ),
-    b  varchar( 50 )
-);
-
---
--- Testing SYSCS_UTIL.SYSCS_EXPORT_TABLE
---
-
-CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
-( null, 'DERBY_2925_TAB', 'extout/derby-2925.txt', null, null, null);
---
--- Errors should should happen in the second
--- call to SYSCS_UTIL.SYSCS_EXPORT_TABLE
--- since extout/derby-2925.txt already exists. 
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
-( null, 'DERBY_2925_TAB', 'extout/derby-2925.txt', null, null, null);
-
---
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY
---
-
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY
-('select * from DERBY_2925_TAB', 'extout/derby-2925-query.dat', null , null , null ) ;
---
--- Errors should should happen in the second
--- call to SYSCS_UTIL.SYSCS_EXPORT_QUERY
--- since extout/derby-2925-query.dat already exists.
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY
-('select * from DERBY_2925_TAB', 'extout/derby-2925-query.dat', null , null , null ) ;
-
---
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
---
-
-create table derby_2925_lob
-(
-	id 	int,
-        name 	varchar(30),
-        content clob, 
-        pic 	blob 
-);
-
---
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- where data file exists.
---
-
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
-('SELECT * FROM DERBY_2925_LOB','extout/derby-2925_data.dat', '\t' ,'|','UTF-16','extout/derby-2925_lobs.dat');
---
--- Errors should should happen in the second
--- call to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- since extout/derby-2925_data.dat already exists.
---
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
-('SELECT * FROM DERBY_2925_LOB','extout/derby-2925_data.dat', '\t' ,'|','UTF-16','extout/derby-2925_lobs.dat');
-
---
--- Testing SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- where lob file exists.
---
--- Errors should should happen in the 
--- call to SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
--- since extout/derby-2925_lobs.dat already exists.
---
-
-CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE
-('SELECT * FROM DERBY_2925_LOB','extout/derby-2925_data1.dat', '\t' ,'|','UTF-16','extout/derby-2925_lobs.dat');
-
---
--- end test case for derby-2925:

Modified: db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport_app.properties
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport_app.properties?rev=691812&r1=691811&r2=691812&view=diff
==============================================================================
--- db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport_app.properties
(original)
+++ db/derby/code/branches/10.2/java/testing/org/apache/derbyTesting/functionTests/tests/tools/importExport_app.properties
Wed Sep  3 15:39:46 2008
@@ -1,3 +1,3 @@
-supportfiles=testData/ImportExport/EndOfFile.txt
+supportfiles=testData/ImportExport/TwoLineBadEOF.dat
 usedefaults=true
 useextdirs=true



Mime
View raw message