You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2005/03/26 01:48:02 UTC
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/
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 <my...@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