db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r159081 [1/2] - in incubator/derby/code/trunk/java/testing: ./ org/apache/derbyTesting/functionTests/harness/ org/apache/derbyTesting/functionTests/master/ org/apache/derbyTesting/functionTests/suites/ org/apache/derbyTesting/functionTests/tests/i18n/ org/apache/derbyTesting/functionTests/tests/i18n/data/
Date Sat, 26 Mar 2005 00:48:02 GMT
Author: fuzzylogic
Date: Fri Mar 25 16:47:55 2005
New Revision: 159081

URL: http://svn.apache.org/viewcvs?view=rev&rev=159081
Log:
Contribute internationalization tests to Derby.

Committed for Myrna Van Lunteran <myrna@golux.com>

Added:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties   (with props)
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql   (with props)
Modified:
    incubator/derby/code/trunk/java/testing/README.htm
    incubator/derby/code/trunk/java/testing/build.xml
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties

Modified: incubator/derby/code/trunk/java/testing/README.htm
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/README.htm?view=diff&r1=159080&r2=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/README.htm (original)
+++ incubator/derby/code/trunk/java/testing/README.htm Fri Mar 25 16:47:55 2005
@@ -422,6 +422,12 @@
     <li>takes 5 to 10 minutes<br>
     </li>
   </ul>
+  <li>i18nTest</li>
+  <ul>
+    <li>tests that characters outside simple ascii scope do not result in errors.
+    <li>takes 5 to 10 minutes<br>
+    </li>
+  </ul>
   <li>derbyall</li>
   <ul>
     <li>contains all suites typically run by all developers<br>

Modified: incubator/derby/code/trunk/java/testing/build.xml
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/build.xml?view=diff&r1=159080&r2=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/build.xml (original)
+++ incubator/derby/code/trunk/java/testing/build.xml Fri Mar 25 16:47:55 2005
@@ -51,6 +51,7 @@
     <ant dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/demo"/> 
     <ant dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/derbynet"/> 
     <ant dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/unit"/> 
+    <ant dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n"/> 
     <ant dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/multi/stress"/> 
     <ant dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/master"/> 
     <ant dir="${derby.testing.src.dir}/${derby.testing.suites.dir}"/> 

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java?view=diff&r1=159080&r2=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java Fri Mar 25 16:47:55 2005
@@ -171,6 +171,8 @@
     static boolean isSuiteRun = false;
     static boolean lastTestFailed = false;
 
+    static boolean isI18N = false;
+
     static InputStream isSed = null; // For test_sed.properties // Cliff
 
 	public static void main(String[] args)
@@ -310,6 +312,11 @@
 		
 		String outName = finalOutFile.getPath();
 
+        if (testDirName.startsWith("i18n"))
+        {
+            isI18N=true;
+        }
+
         if (skipsed)
         {
             tmpOutFile.renameTo(finalOutFile);
@@ -320,7 +327,7 @@
                     {
                         Sed sed = new Sed();
                         sed.exec(tmpOutFile,finalOutFile, isSed, 
-                                        NetServer.isClientConnection(framework));
+                                        NetServer.isClientConnection(framework), isI18N);
 		    }
 		    catch (ClassFormatError cfe)
 		    {

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java?view=diff&r1=159080&r2=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java Fri Mar 25 16:47:55 2005
@@ -50,11 +50,11 @@
 	}
 	File src = new File(args[0]);
 	File tgt = new File(args[1]);
-	new Sed().exec(src,tgt,null, false);
+	new Sed().exec(src,tgt,null, false, false);
     }
 
     // The arguments should be the names of the input and output files
-    public void exec(File srcFile, File dstFile, InputStream isSed, boolean isJCC)
+    public void exec(File srcFile, File dstFile, InputStream isSed, boolean isJCC, boolean isI18N)
         throws IOException
     {
         // Vector for storing lines to be deleted
@@ -222,7 +222,7 @@
 			subStrings.addElement("-----");
 		}
 		subStrings.addElement("Directory DBLOCATION/wombat already exists");
-		doWork(srcFile, dstFile, null, deleteLines, searchStrings, subStrings, isSed);
+		doWork(srcFile, dstFile, null, deleteLines, searchStrings, subStrings, isSed, isI18N);
 
 	}
 	// This just does JCC changes on the output master file
@@ -268,6 +268,14 @@
 		Vector searchStrings, Vector subStrings, InputStream isSed)
         throws IOException
 	{
+		doWork(srcFile, dstFile, is, deleteLines, searchStrings, subStrings, isSed, false);
+	}
+		
+
+	private void doWork(File srcFile, File dstFile, InputStream is, Vector deleteLines, 
+		Vector searchStrings, Vector subStrings, InputStream isSed, boolean isI18N)
+        throws IOException
+	{
 		
         boolean lineDeleted = false;
         PatternMatcher matcher;
@@ -401,6 +409,47 @@
                     lineDeleted = true;
                 }
             }
+
+            // Now determine if & if so, replace, any non-ascii characters
+            // We do this because non-ascii characters in .sql files will
+            // result in different characters depending on encoding, and
+            // encoding may be different on different os's
+            if (isI18N)
+            {
+                boolean hasNonAscii = false;
+                // check for any characters in the control range
+                for (int si = 0; si < str.length(); si++)
+                {
+                    char c = str.charAt(si);
+                    if (c < (char) 0x20 || c >= (char) 0x7f)
+                    {
+                        hasNonAscii = true;
+                        break;
+                    }
+                }
+
+                if (hasNonAscii)
+                {
+                    StringBuffer sb = new StringBuffer();
+                    for (int si = 0; si < str.length(); si++)
+                    {
+                        char c = str.charAt(si);
+                        if (c < (char) 0x20 || c >= (char) 0x7f)
+                        {
+                            sb.append(' ');
+                            // Encoded Character:> ... <
+                            sb.append("EnC:>");
+                            sb.append((int) str.charAt(si));
+                            sb.append("< ");
+                        }
+			else
+                            sb.append(c);
+                    }
+                    str = sb.toString();
+                }
+            }
+
+
 
             // Determine if this line should be deleted for delete pattern match
             if ( lineDeleted == false )

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,68 @@
+ij> drop table tab1;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TAB1' because it does not exist.
+ij> create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
+0 rows inserted/updated/deleted
+ij> insert into tab1 values(12.345, date('2000-05-25'),  'test row 1');
+1 row inserted/updated/deleted
+ij> insert into tab1 values(32.432, date('2000-01-14'),  'test row 2');
+1 row inserted/updated/deleted
+ij> insert into tab1 values(54.846, date('2000-08-21'),  'test row 3');
+1 row inserted/updated/deleted
+ij> insert into tab1 values(98.214, date('2000-12-08'),  'test row 4');
+1 row inserted/updated/deleted
+ij> insert into tab1 values(77.406, date('2000-10-19'),  'test row 5');
+1 row inserted/updated/deleted
+ij> insert into tab1 values(50.395, date('2000-11-29'),  'test row 6');
+1 row inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , 
+                                    null, null, 'UTF8') ;
+0 rows inserted/updated/deleted
+ij> -- localized display is off
+select * from tab1;
+C1      |C2        |C3                  
+----------------------------------------
+12.345  |2000-05-25|test row 1          
+32.432  |2000-01-14|test row 2          
+54.846  |2000-08-21|test row 3          
+98.214  |2000-12-08|test row 4          
+77.406  |2000-10-19|test row 5          
+50.395  |2000-11-29|test row 6          
+ij> LOCALIZEDDISPLAY ON;
+ij> select * from tab1;
+C1      |C2                |C3                  
+------------------------------------------------
+12.345  |May 25, 2000      |test row 1          
+32.432  |January 14, 2000  |test row 2          
+54.846  |August 21, 2000   |test row 3          
+98.214  |December 8, 2000  |test row 4          
+77.406  |October 19, 2000  |test row 5          
+50.395  |November 29, 2000 |test row 6          
+ij> drop table tab1;
+0 rows inserted/updated/deleted
+ij> create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
+0 rows inserted/updated/deleted
+ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , 
+                                    null, null, 'UTF8', 0) ;
+0 rows inserted/updated/deleted
+ij> -- localized display is off
+LOCALIZEDDISPLAY OFF;
+ij> select * from tab1;
+C1      |C2        |C3                  
+----------------------------------------
+12.345  |2000-05-25|test row 1          
+32.432  |2000-01-14|test row 2          
+54.846  |2000-08-21|test row 3          
+98.214  |2000-12-08|test row 4          
+77.406  |2000-10-19|test row 5          
+50.395  |2000-11-29|test row 6          
+ij> LOCALIZEDDISPLAY ON;
+ij> select * from tab1;
+C1      |C2                |C3                  
+------------------------------------------------
+12.345  |May 25, 2000      |test row 1          
+32.432  |January 14, 2000  |test row 2          
+54.846  |August 21, 2000   |test row 3          
+98.214  |December 8, 2000  |test row 4          
+77.406  |October 19, 2000  |test row 5          
+50.395  |November 29, 2000 |test row 6          
+ij> 

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

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,59 @@
+ij> drop table T1_EUC_JP;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1_EUC_JP' because it does not exist.
+ij> -- table for data in EUC_JP encoding
+create table T1_EUC_JP ( EnC:>9< jnum int,
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< jtime time,
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< jstring char(200) );
+0 rows inserted/updated/deleted
+ij> -- import data in EUC_JP encoding 
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'T1_EUC_JP' ,
+ EnC:>9<   EnC:>9<  EnC:>9<           'extin/jap_EUC_JP.dat' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<   null, null, 'EUC_JP', 0) ;
+0 rows inserted/updated/deleted
+ij> -- export to file with EUC_JP encoding 
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE('APP', 'T1_EUC_JP' ,
+ EnC:>9<   EnC:>9<  EnC:>9<           'extinout/jap_EUC_JP.dump' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<   null, null, 'EUC_JP') ;
+0 rows inserted/updated/deleted
+ij> -- export to file with SJIS encoding EnC:>9< 
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE('APP', 'T1_EUC_JP' ,
+ EnC:>9<   EnC:>9<  EnC:>9<           'extinout/jap_SJIS.dump' , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<   null, null, 'SJIS') ;
+0 rows inserted/updated/deleted
+ij> -- convert from EUC_JP to unicode with native2ascii
+! 'native2ascii -encoding EUC_JP extinout/jap_EUC_JP.dump';
+1,"15:32:06","\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                                                                                                                                                                          "
+2,"15:32:10","DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                                                                                                                    "
+3,"15:32:28","INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                  "
+4,"15:32:29","\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f                                                                                                                                                                             "
+5,"15:32:29","\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002                                                                                                                                                                           "
+6,"15:32:30","On-Line\u30e2\u30fc\u30c9                                                                                                                                                                                              "
+7,"15:32:31","sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                                                                                                                                                                "
+8,"15:33:22","\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                                          "
+9,"15:33:23","\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406                                                                                   "
+10,"15:33:40","\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                                          "
+11,"15:33:41","\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406                                                                                   "
+12,"15:33:43","\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f                                                                                                                                                                             "
+13,"15:34:29","\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                                          "
+14,"15:34:30","\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406                                                                                   "
+15,"15:35:35","sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                              "
+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                                                                                                                                                                             "
+ij> -- convert from SJIS to unicode with native2ascii
+! 'native2ascii -encoding SJIS extinout/jap_SJIS.dump';
+1,"15:32:06","\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                                                                                                                                                                          "
+2,"15:32:10","DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                                                                                                                    "
+3,"15:32:28","INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                  "
+4,"15:32:29","\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f                                                                                                                                                                             "
+5,"15:32:29","\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002                                                                                                                                                                           "
+6,"15:32:30","On-Line\u30e2\u30fc\u30c9                                                                                                                                                                                              "
+7,"15:32:31","sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                                                                                                                                                                "
+8,"15:33:22","\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                                          "
+9,"15:33:23","\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406                                                                                   "
+10,"15:33:40","\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                                          "
+11,"15:33:41","\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406                                                                                   "
+12,"15:33:43","\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f                                                                                                                                                                             "
+13,"15:34:29","\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                                          "
+14,"15:34:30","\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406                                                                                   "
+15,"15:35:35","sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                                                                                                                                              "
+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                                                                                                                                                                             "
+ij> 

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

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,138 @@
+IJ Version 10.1
+ij> connect 'jdbc:derby:detest;create=true;' as M EnC:>65533< nchen;
+ij(M EnC:>353< NCHEN)> drop table deta;
+FEHLER 42Y55: 'DROP TABLE' cannot be performed on 'DETA' because it does not exist.
+ij(M EnC:>353< NCHEN)> create table detab ( dc1 decimal(5,3), dc3 date, dc2 char(200) );
+0 Zeilen eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(1.123,date('2000-01-25'),'Zuviele Programme gefunden. Versuchen Sie es erneut.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(2.123,date('2000-02-24'),'Nur Teile der Entwicklungsdatenbank gefunden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(3.123,date('2000-03-23'),'Mehr als eine Instanz der Tabelle %s in Entwicklungsdatenbank gefunden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(4.123,date('2000-04-22'),'Mehr als einen Runner-Datensatz f?r dieses Programm gefunden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(5.123,date('2000-05-21'),'Es kann nur eine BEFORE- oder AFTER INPUT/CONSTRUCT-Klausel in einer ');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(6.123,date('2000-06-20'),'INPUT-/CONSTRUCT-Anweisung erscheinen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(7.123,date('2000-07-19'),'Die Funktion %s kann nur in einer INPUT- oder CONSTRUCT-Anweisung ');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(8.123,date('2000-08-18'),'Fglpc, der Pcode-Kompiler, ist nicht in Ihrem Pfad vorhanden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(9.123,date('2000-09-17'),'Kann Runner %s nicht finden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(10.123,date('2000-10-16'),'I/O-Fehler beim Laufen von fglc: %s.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(11.123,date('2000-11-15'),'I/O-Fehler beim Ausf?hren von fglc.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(12.123,date('2000-12-14'),'Kann Datei %s nicht  EnC:>8221< ffnen, um den Wert einer TEXT-Variable zu lesen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(13.123,date('2000-01-13'),'Der angegebene WORDWRAP RIGHT MARGIN-Wert liegt au EnC:>225< erhalb des Bereichs.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(14.123,date('2000-02-12'),'als oder gleich dem Wert des rechten Reportrands sein.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(15.123,date('2000-03-11'),'4GL unterst?tzt nicht die Ausgabe einer Blob-Variable.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(16.123,date('2000-04-10'),'Die HELP- und ATTRIBUTE-Klauseln k EnC:>8221< nnen jeweils nur einmal definiert werden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(17.123,date('2000-05-09'),'Ein Feld des INTERVAL-Kennzeichners liegt au EnC:>225< erhalb des Bereichs.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(18.123,date('2000-06-08'),'Der Bereich geht von YEAR TO MONTH und von DAY TO FRACTION.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(19.123,date('2000-07-07'),'Das Anlegen von Indizes ist hier nicht erlaubt.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(20.123,date('2000-08-06'),'Hier wird die Eingabe des Spaltennamen erwartet.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(21.123,date('2000-09-05'),'Hier wird die Eingabe des Tabellennamen erwartet.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(22.123,date('2000-10-04'),'Der eigentliche Spaltenname kann hier nicht angegeben werden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(23.123,date('2000-11-03'),'Die maximale Gr EnC:>8221<  EnC:>225< e f?r Varchar mu EnC:>225<  zwischen 1 und 255 liegen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(24.123,date('2000-12-02'),'Kann keine tempor EnC:>8222< re Datei %s anlegen, um eine Blob-Variable aufzunehmen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(25.123,date('2000-11-01'),'Symbol %s mu EnC:>225<  ein SQL-Datenbank-Elementname sein - entweder ein ');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(26.123,date('2000-10-28'),'Datenbankname, ein Tabellenname oder ein Spaltenname.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(27.123,date('2000-09-29'),'DATETIME-Einheiten k EnC:>8221< nnen nur YEAR, MONTH, DAY, HOUR, MINUTE,');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(28.123,date('2000-08-30'),'Eingeklammerte Genauigkeit von FRACTION mu EnC:>225<  zwischen 1 und 5 liegen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(29.123,date('2000-07-31'),'F?r andere Zeiteinheiten kann keine Genauigkeit definiert werden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(30.123,date('2000-06-25'),'Das Startfeld von DATETIME oder INTERVAL-Kennzeichnern mu EnC:>225<  in der ');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(31.123,date('2000-05-25'),'Zeitliste vor dem Endfeld stehen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(32.123,date('2000-04-25'),'Entladen in Datei %s mi EnC:>225< lungen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(33.123,date('2000-03-25'),'Laden aus Datei %s mi EnC:>225< lungen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(34.123,date('2000-02-25'),'Das Programm kann eine DISPLAY ARRAY-Anweisung an dieser Stelle nicht');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(35.123,date('2000-01-25'),'beenden, weil es sich nicht in einer DISPLAY ARRAY-Anweisung befindet.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(36.123,date('2000-02-25'),'Das Programm kann eine INPUT-Anweisung an dieser Stelle nicht beenden,');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(37.123,date('2000-04-25'),'weil es sich nicht in einer INPUT-Anweisung befindet.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(38.123,date('2000-05-25'),'Konnte Datei %s nicht  EnC:>8221< ffnen.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(39.123,date('2000-07-25'),'Name des Eigent?mers %s hat die L EnC:>8222< nge von 8 Zeichen ?berschritten.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(40.123,date('2000-09-25'),'Fehler bei der Speicherzuordnung.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> insert into detab values(41.123,date('2000-05-25'),'Unter dem angegebenen Namen wurde kein lauff EnC:>8222< higes 4GL-Programm gefunden.');
+1 Zeile eingef EnC:>65533< gt/aktualisiert/gel EnC:>8221< scht
+ij(M EnC:>353< NCHEN)> LOCALIZEDDISPLAY ON;
+ij(M EnC:>353< NCHEN)> show connections;
+CONNECTION0 -  EnC:>9< jdbc:derby:wombat
+M EnC:>353< NCHEN* -  EnC:>9< jdbc:derby:detest
+* = aktuelle Verbindung
+ij(M EnC:>353< NCHEN)> select * from detab;
+DC1     |DC3               |DC2                                                                                                                             
+------------------------------------------------------------------------------------------------------------------------------------------------------------
+1,123   |25. Januar 2000   |Zuviele Programme gefunden. Versuchen Sie es erneut.                                                                           &
+2,123   |24. Februar 2000  |Nur Teile der Entwicklungsdatenbank gefunden.                                                                                  &
+3,123   |23. M EnC:>8222< rz 2000     |Mehr als eine Instanz der Tabelle %s in Entwicklungsdatenbank gefunden.                                                        &
+4,123   |22. April 2000    |Mehr als einen Runner-Datensatz f?r dieses Programm gefunden.                                                                  &
+5,123   |21. Mai 2000      |Es kann nur eine BEFORE- oder AFTER INPUT/CONSTRUCT-Klausel in einer                                                           &
+6,123   |20. Juni 2000     |INPUT-/CONSTRUCT-Anweisung erscheinen.                                                                                         &
+7,123   |19. Juli 2000     |Die Funktion %s kann nur in einer INPUT- oder CONSTRUCT-Anweisung                                                              &
+8,123   |18. August 2000   |Fglpc, der Pcode-Kompiler, ist nicht in Ihrem Pfad vorhanden.                                                                  &
+9,123   |17. September 2000|Kann Runner %s nicht finden.                                                                                                   &
+10,123  |16. Oktober 2000  |I/O-Fehler beim Laufen von fglc: %s.                                                                                           &
+11,123  |15. November 2000 |I/O-Fehler beim Ausf?hren von fglc.                                                                                            &
+12,123  |14. Dezember 2000 |Kann Datei %s nicht  EnC:>8221< ffnen, um den Wert einer TEXT-Variable zu lesen.                                                          &
+13,123  |13. Januar 2000   |Der angegebene WORDWRAP RIGHT MARGIN-Wert liegt au EnC:>225< erhalb des Bereichs.                                                        &
+14,123  |12. Februar 2000  |als oder gleich dem Wert des rechten Reportrands sein.                                                                         &
+15,123  |11. M EnC:>8222< rz 2000     |4GL unterst?tzt nicht die Ausgabe einer Blob-Variable.                                                                         &
+16,123  |10. April 2000    |Die HELP- und ATTRIBUTE-Klauseln k EnC:>8221< nnen jeweils nur einmal definiert werden.                                                   &
+17,123  |9. Mai 2000       |Ein Feld des INTERVAL-Kennzeichners liegt au EnC:>225< erhalb des Bereichs.                                                              &
+18,123  |8. Juni 2000      |Der Bereich geht von YEAR TO MONTH und von DAY TO FRACTION.                                                                    &
+19,123  |7. Juli 2000      |Das Anlegen von Indizes ist hier nicht erlaubt.                                                                                &
+20,123  |6. August 2000    |Hier wird die Eingabe des Spaltennamen erwartet.                                                                               &
+21,123  |5. September 2000 |Hier wird die Eingabe des Tabellennamen erwartet.                                                                              &
+22,123  |4. Oktober 2000   |Der eigentliche Spaltenname kann hier nicht angegeben werden.                                                                  &
+23,123  |3. November 2000  |Die maximale Gr EnC:>8221<  EnC:>225< e f?r Varchar mu EnC:>225<  zwischen 1 und 255 liegen.                                                                  &
+24,123  |2. Dezember 2000  |Kann keine tempor EnC:>8222< re Datei %s anlegen, um eine Blob-Variable aufzunehmen.                                                      &
+25,123  |1. November 2000  |Symbol %s mu EnC:>225<  ein SQL-Datenbank-Elementname sein - entweder ein                                                                &
+26,123  |28. Oktober 2000  |Datenbankname, ein Tabellenname oder ein Spaltenname.                                                                          &
+27,123  |29. September 2000|DATETIME-Einheiten k EnC:>8221< nnen nur YEAR, MONTH, DAY, HOUR, MINUTE,                                                                  &
+28,123  |30. August 2000   |Eingeklammerte Genauigkeit von FRACTION mu EnC:>225<  zwischen 1 und 5 liegen.                                                           &
+29,123  |31. Juli 2000     |F?r andere Zeiteinheiten kann keine Genauigkeit definiert werden.                                                              &
+30,123  |25. Juni 2000     |Das Startfeld von DATETIME oder INTERVAL-Kennzeichnern mu EnC:>225<  in der                                                              &
+31,123  |25. Mai 2000      |Zeitliste vor dem Endfeld stehen.                                                                                              &
+32,123  |25. April 2000    |Entladen in Datei %s mi EnC:>225< lungen.                                                                                                &
+33,123  |25. M EnC:>8222< rz 2000     |Laden aus Datei %s mi EnC:>225< lungen.                                                                                                  &
+34,123  |25. Februar 2000  |Das Programm kann eine DISPLAY ARRAY-Anweisung an dieser Stelle nicht                                                          &
+35,123  |25. Januar 2000   |beenden, weil es sich nicht in einer DISPLAY ARRAY-Anweisung befindet.                                                         &
+36,123  |25. Februar 2000  |Das Programm kann eine INPUT-Anweisung an dieser Stelle nicht beenden,                                                         &
+37,123  |25. April 2000    |weil es sich nicht in einer INPUT-Anweisung befindet.                                                                          &
+38,123  |25. Mai 2000      |Konnte Datei %s nicht  EnC:>8221< ffnen.                                                                                                  &
+39,123  |25. Juli 2000     |Name des Eigent?mers %s hat die L EnC:>8222< nge von 8 Zeichen ?berschritten.                                                             &
+40,123  |25. September 2000|Fehler bei der Speicherzuordnung.                                                                                              &
+41,123  |25. Mai 2000      |Unter dem angegebenen Namen wurde kein lauff EnC:>8222< higes 4GL-Programm gefunden.                                                      &
+ij(M EnC:>353< NCHEN)> 

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

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,80 @@
+ij versi EnC:>65533<  EnC:>171<  EnC:>209< n 10.1
+ij> drop table localtab;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'LOCALTAB' because it does not exist.
+ij> create table localtab( EnC:>9< ndec decimal(5,3), 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< ndatec date , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< ntimec time , 
+ EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9<  EnC:>9< ncharc varchar(500));
+0 filas insertadas/actualizadas/suprimidas
+ij> insert into localtab values(12.345, date('2000-05-25'),'15:30:15','\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(32.432, date('2000-05-18'),'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(54.846, date('2000-01-28'),'15:32:28','INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(39.003, date('2000-11-11'),'15:32:29','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(79.406, date('2000-06-05'),'15:32:29','\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(94.999, date('2000-07-30'),'15:32:30','On-Line\u30e2\u30fc\u30c9');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(18.849, date('2000-10-22'),'15:32:31','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(35.444, date('2000-02-29'),'15:33:22','\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(84.391, date('2000-01-21'),'15:33:23','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(56.664, date('2000-04-16'),'15:33:40','\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(22.393, date('2000-03-01'),'15:33;42','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+ERROR 22007: The syntax of the string representation of a datetime value is incorrect.
+ij> insert into localtab values(90.007, date('2000-11-27'),'15:33:43','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(30.496, date('2000-04-03'),'15:34:29','\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(66.295, date('2000-10-15'),'15:34:30','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(54.332, date('2000-09-01'),'15:35:35','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 fila insertada/actualizada/suprimida
+ij> insert into localtab values(11.105, date('2000-07-09'),'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');
+1 fila insertada/actualizada/suprimida
+ij> -- display in non localized format
+select * from localtab;
+NDEC    |NDATEC    |NTIMEC  |NCHARC                                                                                                                          
+-------------------------------------------------------------------------------------------------------------------------------------------------------------
+12.345  |2000-05-25|15:30:15|\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                            
+32.432  |2000-05-18|15:32:10|DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                        
+54.846  |2000-01-28|15:32:28|INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u30&
+39.003  |2000-11-11|15:32:29|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79&
+79.406  |2000-06-05|15:32:29|\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306&
+94.999  |2000-07-30|15:32:30|On-Line\u30e2\u30fc\u30c9                                                                                                       
+18.849  |2000-10-22|15:32:31|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                            
+35.444  |2000-02-29|15:33:22|\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+84.391  |2000-01-21|15:33:23|\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
+56.664  |2000-04-16|15:33:40|\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+90.007  |2000-11-27|15:33:43|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79&
+30.496  |2000-04-03|15:34:29|\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+66.295  |2000-10-15|15:34:30|\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
+54.332  |2000-09-01|15:35:35|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                 
+11.105  |2000-07-09|15:39:10|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79&
+ij> -- display in localized format
+LOCALIZEDDISPLAY ON;
+ij> select * from localtab;
+NDEC    |NDATEC                  |NTIMEC            |NCHARC                                                                                                                          
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+12,345  |25 de mayo de 2000      |15:30:15 PST      |\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                            
+32,432  |18 de mayo de 2000      |15:32:10 PST      |DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                        
+54,846  |28 de enero de 2000     |15:32:28 PST      |INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u30&
+39,003  |11 de noviembre de 2000 |15:32:29 PST      |\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79&
+79,406  |5 de junio de 2000      |15:32:29 PST      |\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306&
+94,999  |30 de julio de 2000     |15:32:30 PST      |On-Line\u30e2\u30fc\u30c9                                                                                                       
+18,849  |22 de octubre de 2000   |15:32:31 PST      |sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                            
+35,444  |29 de febrero de 2000   |15:33:22 PST      |\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+84,391  |21 de enero de 2000     |15:33:23 PST      |\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
+56,664  |16 de abril de 2000     |15:33:40 PST      |\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+90,007  |27 de noviembre de 2000 |15:33:43 PST      |\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79&
+30,496  |3 de abril de 2000      |15:34:29 PST      |\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+66,295  |15 de octubre de 2000   |15:34:30 PST      |\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u305&
+54,332  |1 de septiembre de 2000 |15:35:35 PST      |sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                 
+11,105  |9 de julio de 2000      |15:39:10 PST      |\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79&
+ij> 

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

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,57 @@
+ij> drop table jtest;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'JTEST' because it does not exist.
+ij> create table jtest(jint integer, jtime time, jvarchar varchar(255));
+0 rows inserted/updated/deleted
+ij> UNICODEESCAPE ON;
+ij> insert into jtest values(1,'15:32:06','\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(2,'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(3,'15:32:28','INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(4,'15:32:29','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f');
+1 row inserted/updated/deleted
+ij> insert into jtest values(5,'15:32:29','\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(6,'15:32:30','On-Line\u30e2\u30fc\u30c9');
+1 row inserted/updated/deleted
+ij> insert into jtest values(7,'15:32:31','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...');
+1 row inserted/updated/deleted
+ij> insert into jtest values(8,'15:33:22','\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(9,'15:33:23','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u30&' to length 255.
+ij> insert into jtest values(10,'15:33:40','\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(11,'15:33:41','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u30&' to length 255.
+ij> insert into jtest values(12,'15:33:43','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f');
+1 row inserted/updated/deleted
+ij> insert into jtest values(13,'15:34:29','\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+1 row inserted/updated/deleted
+ij> insert into jtest values(14,'15:34:30','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u30&' to length 255.
+ij> 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');
+1 row inserted/updated/deleted
+ij> 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');
+1 row inserted/updated/deleted
+ij> select * from jtest;
+JINT       |JTIME   |JVARCHAR                                                                                                                        
+-----------------------------------------------------------------------------------------------------------------------------------------------------
+1          |15:32:06|\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002                                            
+2          |15:32:10|DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002                                                                                        
+3          |15:32:28|INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u30&
+4          |15:32:29|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79&
+5          |15:32:29|\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306&
+6          |15:32:30|On-Line\u30e2\u30fc\u30c9                                                                                                       
+7          |15:32:31|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...                                            
+8          |15:33:22|\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+10         |15:33:40|\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+12         |15:33:43|\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79&
+13         |15:34:29|\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                                                      
+15         |15:35:35|sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002                 
+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\u79&
+ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'jtest' , 'extout/jtest.unl' , 
+                                    null, null,'EUC_JP') ;
+0 rows inserted/updated/deleted
+ij> 

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

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,28 @@
+CONNECTION0* -  EnC:>9< jdbc:derby:trdb
+* = current connection
+ij> create function FMTUNICODE(P1 VARCHAR(100)) RETURNS VARCHAR(300)
+EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.Formatters.format'
+NO SQL
+LANGUAGE JAVA PARAMETER STYLE JAVA;
+0 rows inserted/updated/deleted
+ij> values FMTUNICODE(UCASE('i'));
+1                                                                                                                               
+--------------------------------------------------------------------------------------------------------------------------------
+\u0130                                                                                                                          
+1 row selected
+ij> values FMTUNICODE(UCASE('I'));
+1                                                                                                                               
+--------------------------------------------------------------------------------------------------------------------------------
+I                                                                                                                               
+1 row selected
+ij> values FMTUNICODE(LCASE('i'));
+1                                                                                                                               
+--------------------------------------------------------------------------------------------------------------------------------
+i                                                                                                                               
+1 row selected
+ij> values FMTUNICODE(LCASE('I'));
+1                                                                                                                               
+--------------------------------------------------------------------------------------------------------------------------------
+\u0131                                                                                                                          
+1 row selected
+ij> 

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

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

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



Mime
View raw message