Return-Path: 
 <derby-dev-return-2719-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 10764 invoked from network); 23 Mar 2005 19:05:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 23 Mar 2005 19:05:01 -0000
Received: (qmail 77317 invoked by uid 500); 23 Mar 2005 19:05:00 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 77261 invoked by uid 500); 23 Mar 2005 19:04:59 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-dev-help@db.apache.org>
list-unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 77245 invoked by uid 99); 23 Mar 2005 19:04:58 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (hermes.apache.org: local policy)
Received: from e5.ny.us.ibm.com (HELO e5.ny.us.ibm.com) (32.97.182.145)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 23 Mar 2005 11:04:55 -0800
Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236])
	by e5.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j2NJ4qZk015614
	for <derby-dev@db.apache.org>; Wed, 23 Mar 2005 14:04:52 -0500
Received: from d01av01.pok.ibm.com (d01av01.pok.ibm.com [9.56.224.215])
	by d01relay04.pok.ibm.com (8.12.10/NCO/VER6.6) with ESMTP id j2NJ4qMS217958
	for <derby-dev@db.apache.org>; Wed, 23 Mar 2005 14:04:52 -0500
Received: from d01av01.pok.ibm.com (loopback [127.0.0.1])
	by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j2NJ4pOb019099
	for <derby-dev@db.apache.org>; Wed, 23 Mar 2005 14:04:51 -0500
Received: from [127.0.0.1] (myrna-ibm-lt1.usca.ibm.com [9.72.133.52])
	by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j2NJ4l0o018594
	for <derby-dev@db.apache.org>; Wed, 23 Mar 2005 14:04:50 -0500
Message-ID: <4241BCEE.7090106@Golux.Com>
Date: Wed, 23 Mar 2005 11:01:02 -0800
From: myrna <myrna@Golux.Com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.7.1) Gecko/20040707
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Derby Development <derby-dev@db.apache.org>
Subject: [PATCH] last set of functionTests i18nTest
Content-Type: multipart/mixed;
 boundary="------------030404000602030101020005"
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This is a multi-part message in MIME format.
--------------030404000602030101020005
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Attached is a .diff result for adding the last set of tests from IBM 
Cloudscape for Derby.

Thx,
Myrna

--------------030404000602030101020005
Content-Type: text/plain;
 name="i18n.diff"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline;
 filename="i18n.diff"

Index: java/testing/README.htm
===================================================================
--- java/testing/README.htm	(revision 158815)
+++ java/testing/README.htm	(working copy)
@@ -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>
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties	(revision 0)
@@ -0,0 +1,24 @@
+#
+# This is the default system properties file for SQL and JAVA tests.
+#
+# *** DO NOT PUT PROPERTIES FOR THE DERBY SYSTEM IN THIS FILE.  
+# *** THEY BELONG IN default_derby.properties.
+#
+# This file will get handed to the test on the command line in a -p <filename>
+# argument.
+#
+# This causes ij to load the driver and make an
+# initial connection to the database.
+#
+# The .java test has to call util.getPropertyArg and util.startJBMS
+# to process the property file.  See any of the .java tests for this code.
+#
+# If you want to alter these to use a different driver, connect to a different
+# database, or to not be used, override this file by creating
+# a file <testname>_app.properties to be used instead of this file.
+#
+database=jdbc:derby:wombat;create=true
+derby.optimizer.noTimeout=true
+
+ij.showNoConnectionsAtStart=true
+ij.showNoCountForSelect=true

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql	(revision 0)
@@ -0,0 +1,78 @@
+--
+--
+-- URL locale handling
+--
+
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+create procedure checkRDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkRDefaultLocale';
+-- this current database was created with the default locale
+call checkDatabaseLoc('en_US');
+call checkRDefaultLoc();
+
+disconnect;
+
+-- create a Swiss database
+connect 'jdbc:derby:swissdb;create=true;territory=fr_CH';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('fr_CH');
+disconnect;
+connect 'jdbc:derby:swissdb;shutdown=true';
+
+-- check it is still Swiss when we re-boot
+connect 'jdbc:derby:swissdb';
+call checkDatabaseLoc('fr_CH');
+disconnect;
+connect 'jdbc:derby:swissdb;shutdown=true';
+
+
+-- Locale automatically converts the components to the correct case
+-- create a Hindi in India database (hi_IN)
+connect 'jdbc:derby:hindi;create=true;territory=HI_in';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('hi_IN');
+disconnect;
+connect 'jdbc:derby:hindi;shutdown=true';
+
+
+-- now try one with a variant
+-- create a English in Israel database for JavaOS en_IL_JavaOS
+connect 'jdbc:derby:Israel;create=true;territory=en_IL_JavaOS';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('en_IL_JavaOS');
+disconnect;
+connect 'jdbc:derby:Israel;shutdown=true';
+
+-- now try with just a language - we support this
+-- as some vms do.
+connect 'jdbc:derby:bacon;create=true;territory=da';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('da');
+disconnect;
+connect 'jdbc:derby:bacon;shutdown=true';
+connect 'jdbc:derby:bacon';
+call checkDatabaseLoc('da');
+disconnect;
+connect 'jdbc:derby:bacon;shutdown=true';
+
+
+--
+-- some negative tests
+--
+connect 'jdbc:derby:fail1;create=true;territory=';
+-- database will not have been created so this connection will fail
+connect 'jdbc:derby:fail1;shutdown=true';
+
+connect 'jdbc:derby:fail3;create=true;territory=en_';
+connect 'jdbc:derby:fail4;create=true;territory=en_d';
+connect 'jdbc:derby:fail5;create=true;territory=en_US_';
+connect 'jdbc:derby:fail6;create=true;territory=en-US';
+
+-- try using a database name with trailing blanks
+-- beetle 4653
+connect 'jdbc:derby:trailblank;create=true';
+connect 'jdbc:derby:trailblank';
+connect 'jdbc:derby:trailblank     ';
+connect 'jdbc:derby:trailblank      ;shutdown=true';
+
+
+connect 'jdbc:derby:;shutdown=true';

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java	(revision 0)
@@ -0,0 +1,79 @@
+/*
+
+   Derby - Class org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale
+
+   Copyright 2000, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+   Licensed under the Apache License, Version 2.0 (the "License");
+   you may not use this file except in compliance with the License.
+   You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+   Unless required by applicable law or agreed to in writing, software
+   distributed under the License is distributed on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+   See the License for the specific language governing permissions and
+   limitations under the License.
+
+ */
+
+package org.apache.derbyTesting.functionTests.tests.i18n;
+
+import java.util.Locale;
+
+import java.sql.DriverManager;
+import java.sql.Connection;
+import java.sql.SQLException;
+
+public class DefaultLocale { 
+
+	static String savedLocale;
+
+	static {
+		savedLocale=java.util.Locale.getDefault().toString();
+		Locale.setDefault(new Locale("rr", "TT"));
+	}
+
+
+	// used in messageLocale test
+	public static void checkDefaultLocale() throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		String defLocale = java.util.Locale.getDefault().toString();
+		//System.out.println(defLocale);
+		if (!defLocale.equals("rr_TT"))
+			throw new SQLException("wrong_locale");
+	}
+
+	// used in urlLocale test
+	public static void checkRDefaultLocale() throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		System.out.println(savedLocale);
+		if (!savedLocale.equals("en_US"))
+			throw new SQLException("wrong_locale");
+	}
+
+	// used in messageLocale test
+	public static void checkDatabaseLocale(String Locale) throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		String dbLocale = org.apache.derby.iapi.db.Factory.getDatabaseOfConnection().getLocale().toString();
+		//System.out.println(dbLocale + "-");
+		//System.out.println(Locale + "-");
+		if (!dbLocale.toUpperCase().equals(Locale.toUpperCase().trim()))
+			throw new SQLException("wrong locale");
+	}
+
+	// used in messageLocale test
+	public static void setDefaultLocale(String Locale, String Code) throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		java.util.Locale.setDefault(new java.util.Locale(Locale.trim(),Code.trim()));
+	}
+
+
+
+
+}

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties	(revision 0)
@@ -0,0 +1,4 @@
+runwithj9=false
+supportfiles=tests/i18n/data/jap_EUC_JP.dat,tests/i18n/data/jap_EUC_JP.ctrl,tests/i18n/data/jap_SJIS.ctrl
+usedefaults=true
+useextdirs=true

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties	(revision 0)
@@ -0,0 +1,4 @@
+usedefaults=true
+ij.unicodeEscape=on
+derby.ui.locale=es_AR
+derby.ui.codeset=EUC_JP

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql	(revision 0)
@@ -0,0 +1,26 @@
+drop table T1_EUC_JP;
+-- table for data in EUC_JP encoding
+create table T1_EUC_JP (	jnum int,
+				jtime time,
+				jstring char(200) );
+
+-- import data in EUC_JP encoding 
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'T1_EUC_JP' ,
+	 		          'extin/jap_EUC_JP.dat' , 
+				  null, null, 'EUC_JP', 0) ;
+
+-- export to file with EUC_JP encoding 
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE('APP', 'T1_EUC_JP' ,
+	 		          'extinout/jap_EUC_JP.dump' , 
+				  null, null, 'EUC_JP') ;
+
+-- export to file with SJIS encoding	
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE('APP', 'T1_EUC_JP' ,
+	 		          'extinout/jap_SJIS.dump' , 
+				  null, null, 'SJIS') ;
+
+-- convert from EUC_JP to unicode with native2ascii
+! 'native2ascii -encoding EUC_JP extinout/jap_EUC_JP.dump';
+
+-- convert from SJIS to unicode with native2ascii
+! 'native2ascii -encoding SJIS extinout/jap_SJIS.dump';

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties	(revision 0)
@@ -0,0 +1 @@
+database=jdbc:derby:trdb;create=true;territory=tr_TR

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql	(revision 0)
@@ -0,0 +1,28 @@
+drop table localtab;
+create table localtab(	ndec decimal(5,3), 
+							ndatec date , 
+							ntimec time , 
+							ncharc varchar(500));
+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');
+insert into localtab values(32.432, date('2000-05-18'),'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
+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');
+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');
+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');
+insert into localtab values(94.999, date('2000-07-30'),'15:32:30','On-Line\u30e2\u30fc\u30c9');
+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...');
+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');
+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');
+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');
+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');
+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');
+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');
+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');
+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');
+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');
+
+-- display in non localized format
+select * from localtab;
+
+-- display in localized format
+LOCALIZEDDISPLAY ON;
+select * from localtab;

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties	(revision 0)
@@ -0,0 +1,4 @@
+supportfiles=tests/i18n/data/jap_EUC_JP.ctrl
+usedefaults=true
+derby.ui.codeset=EUC_JP
+useextdirs=true

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql	(revision 0)
@@ -0,0 +1,9 @@
+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;
+
+ values FMTUNICODE(UCASE('i'));
+ values FMTUNICODE(UCASE('I'));
+ values FMTUNICODE(LCASE('i'));
+ values FMTUNICODE(LCASE('I'));

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql	(revision 0)
@@ -0,0 +1,22 @@
+drop table jtest;
+create table jtest(jint integer, jtime time, jvarchar varchar(255));
+UNICODEESCAPE ON;
+insert into jtest values(1,'15:32:06','\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002');
+insert into jtest values(2,'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
+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');
+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');
+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');
+insert into jtest values(6,'15:32:30','On-Line\u30e2\u30fc\u30c9');
+insert into jtest values(7,'15:32:31','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...');
+insert into jtest values(8,'15:33:22','\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+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');
+insert into jtest values(10,'15:33:40','\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+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');
+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');
+insert into jtest values(13,'15:34:29','\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+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');
+insert into jtest values(15,'15:35:35','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into jtest values(16,'15:39:10','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79d2\u3067\u3057\u305f');
+select * from jtest;
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'jtest' , 'extout/jtest.unl' , 
+                                    null, null,'EUC_JP') ;

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml	(revision 0)
@@ -0,0 +1,90 @@
+<?xml version="1.0"?>
+
+<!-- ==================================================================== -->
+<!--                       Derby build file                          -->
+<!-- ==================================================================== -->
+
+<project default="FTOtestsubdir" basedir="../../../../../../../.." >
+
+<!-- ==================================================================== -->
+<!--                           Set properties                             -->
+<!-- ==================================================================== -->
+
+  <!-- User settings -->
+  <property file="${user.home}/ant.properties"/>
+
+  <!-- Set property lib dir -->
+  <property name="properties.dir" value="tools/ant/properties" />
+
+  <!-- Significant dirs -->
+  <property file="${properties.dir}/dirs.properties"/>
+  <property file="${properties.dir}/derbytesting.properties"/>
+
+  <!-- Compiler settings -->
+  <property file="${properties.dir}/sane${sanity}.properties"/>
+  <property file="${properties.dir}/defaultcompiler.properties"/>
+  <property file="${properties.dir}/${build.compiler}.properties"/>
+
+  <!-- Parser properties -->
+  <!--property file="${properties.dir}/parser.properties"/-->
+
+  <!-- Compile-time classpath properties files -->
+  <property file="${properties.dir}/extrapath.properties"/>
+  <property file="${properties.dir}/compilepath.properties"/>
+
+  <!-- Release and Version info -->
+  <property file="${properties.dir}/release.properties"/>
+
+  <!-- derby testing specific properties files -->
+  <property file="${ant.home}/properties/derbytesting.properties"/>
+  <property file="${user.home}/properties/derbytesting.properties"/>
+  <property name="this.dir" value="${derby.testing.functest.dir}/tests/i18n"/>
+
+<!--             ============ Begin Targets ==============                -->
+ 
+  <target name="FTOtestsubdir" depends="compile,copyfiles"/>
+
+  <!-- mkdir / init target should not be necessary, just here for reference... -->
+  <target name="init">
+    <mkdir dir="${out.dir}/${derby.testing.functest.dir}/tests/i18n"/>
+  </target>
+
+  <target name="compile">
+    <javac
+      bootclasspath="${empty}"
+      nowarn="on"
+      debug="${debug}"
+      depend="${depend}"
+      deprecation="${deprecation}"
+      optimize="${optimize}"
+      proceed="${proceed}"
+      verbose="${verbose}" 
+      srcdir="${derby.testing.src.dir}"
+      destdir="${out.dir}">
+      <classpath>
+        <!--pathelement location="${oro}"/-->
+        <pathelement path="${compile.classpath}"/>
+      </classpath>
+      <include name="${this.dir}/*.java"/>
+    </javac>
+  </target>
+
+
+  <target name="copyfiles">
+    <copy todir="${out.dir}/${derby.testing.functest.dir}/tests/i18n">
+      <fileset dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n" 
+        includesfile="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n/copyfiles.ant"/>  
+    </copy>
+    <copy todir="${out.dir}/${derby.testing.functest.dir}/tests/i18n/data">
+      <fileset dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n/data" 
+        includesfile="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n/data/copyfiles.ant"/>  
+    </copy>
+  </target> 
+
+
+<!--             ============= End Targets ==============                -->
+
+<!--             ============= End Project ==============                -->
+
+</project>
+

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties	(revision 0)
@@ -0,0 +1,3 @@
+#
+# No default driver or connection
+fake=ij seems to need one property set

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql	(revision 0)
@@ -0,0 +1,81 @@
+-- THIS TEST WILL NOT WORK WITH THE .jar files
+-- It uses a dummy message_qq_PP_testOnly.properties that exists
+-- only in the codeline
+--
+-- Message locale handling
+--
+--;
+
+-- load a fake driver that is really a piece of
+-- code that sets the default locale;
+driver 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale';
+
+--
+-- create a databse in this default locale, should
+-- get english messages, as there are no messages
+-- for rr_TT;
+connect 'jdbc:derby:wombat;create=true';
+
+-- make sure the database is clean
+drop procedure checkDefaultLoc;
+create procedure checkDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDefaultLocale';
+drop procedure checkDatabaseLoc;
+create procedure checkDatabaseLoc(in locale char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+drop procedure setDefaultDELoc;
+create procedure setDefaultLoc(in locale char(10), in code char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.setDefaultLocale';
+drop table t1;
+drop table t2;
+
+call checkDefaultLoc();
+call checkDatabaseLoc('rr_TT');
+
+-- expect an error
+create table t1 oops (i int primary key);
+-- setup for
+create table t2 (i int);
+create index i2_a on t2(i);
+-- expect a warning
+create index i2_b on t2(i);
+-- another error
+drop table t3;
+
+-- set the default locale to German;
+--call java.util.Locale::setDefault(new java.util.Locale('de', 'DE'));
+call setDefaultLoc('de','DE');
+
+disconnect;
+
+-- create a database with a locale that has a small
+-- number of messages. Missing ones will default to
+-- the locale of the default locale i.e. German;
+connect 'jdbc:derby:testdb;create=true;territory=qq_PP_testOnly';
+
+-- error (in qq_PP messages);
+-- create table t1 (i longe);
+create table t1 oops (i int primary key);
+
+-- warning (in qq_PP messages);
+-- create table t2 (i java.lang.Object);
+create table t2 (i int);
+create index i2_a on t2(i);
+create index i2_b on t2(i);
+
+-- from default locale (German);
+drop table t3;
+
+-- should be in German;
+disconnect;
+connect 'jdbc:derby:;shutdown=true';
+
+-- Now, all Enlish messages;
+connect 'jdbc:derby:enTest;create=true;territory=en_US';
+
+-- create table t1 (i longe);
+create table t1 oops (i int primary key);
+-- create table t2 (i java.lang.Object);
+create table t2 (i int);
+create index i2_a on t2(i);
+create index i2_b on t2(i);
+drop table t3;
+disconnect;
+

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties	(revision 0)
@@ -0,0 +1,7 @@
+# statement cache size of 20 is the default, do not add this property
+# to this file.  If your test wants to do consistency checking that
+# requires an empty cache, add a special .properties file, see
+# inbetween.properties for an example.
+#
+# derby.language.statementCacheSize=20
+derby.infolog.append=true

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties	(revision 0)
@@ -0,0 +1,2 @@
+database=jdbc:derby:wombat;create=true;territory=es_MX;unicode=true
+useextdirs=true

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties	(revision 0)
@@ -0,0 +1,3 @@
+usedefaults=true
+derby.ui.codeset=Cp850
+derby.ui.locale=de_DE

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties	(revision 0)
@@ -0,0 +1,4 @@
+supportfiles=tests/i18n/data/Tab1_fr.ctrl,tests/i18n/data/Tab1_il.ctrl,tests/i18n/data/Tab1_jp.ctrl
+usedefaults=true
+derby.ui.locale=en_US
+useextdirs=true

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql	(revision 0)
@@ -0,0 +1,48 @@
+connect 'jdbc:derby:detest;create=true;' as M�nchen;
+
+drop table deta;
+create table detab ( dc1 decimal(5,3), dc3 date, dc2 char(200) );
+insert into detab values(1.123,date('2000-01-25'),'Zuviele Programme gefunden. Versuchen Sie es erneut.');
+insert into detab values(2.123,date('2000-02-24'),'Nur Teile der Entwicklungsdatenbank gefunden.');
+insert into detab values(3.123,date('2000-03-23'),'Mehr als eine Instanz der Tabelle %s in Entwicklungsdatenbank gefunden.');
+insert into detab values(4.123,date('2000-04-22'),'Mehr als einen Runner-Datensatz f?r dieses Programm gefunden.');
+insert into detab values(5.123,date('2000-05-21'),'Es kann nur eine BEFORE- oder AFTER INPUT/CONSTRUCT-Klausel in einer ');
+insert into detab values(6.123,date('2000-06-20'),'INPUT-/CONSTRUCT-Anweisung erscheinen.');
+insert into detab values(7.123,date('2000-07-19'),'Die Funktion %s kann nur in einer INPUT- oder CONSTRUCT-Anweisung ');
+insert into detab values(8.123,date('2000-08-18'),'Fglpc, der Pcode-Kompiler, ist nicht in Ihrem Pfad vorhanden.');
+insert into detab values(9.123,date('2000-09-17'),'Kann Runner %s nicht finden.');
+insert into detab values(10.123,date('2000-10-16'),'I/O-Fehler beim Laufen von fglc: %s.');
+insert into detab values(11.123,date('2000-11-15'),'I/O-Fehler beim Ausf?hren von fglc.');
+insert into detab values(12.123,date('2000-12-14'),'Kann Datei %s nicht �ffnen, um den Wert einer TEXT-Variable zu lesen.');
+insert into detab values(13.123,date('2000-01-13'),'Der angegebene WORDWRAP RIGHT MARGIN-Wert liegt au�erhalb des Bereichs.'); 
+insert into detab values(14.123,date('2000-02-12'),'als oder gleich dem Wert des rechten Reportrands sein.');
+insert into detab values(15.123,date('2000-03-11'),'4GL unterst?tzt nicht die Ausgabe einer Blob-Variable.');
+insert into detab values(16.123,date('2000-04-10'),'Die HELP- und ATTRIBUTE-Klauseln k�nnen jeweils nur einmal definiert werden.');
+insert into detab values(17.123,date('2000-05-09'),'Ein Feld des INTERVAL-Kennzeichners liegt au�erhalb des Bereichs.'); 
+insert into detab values(18.123,date('2000-06-08'),'Der Bereich geht von YEAR TO MONTH und von DAY TO FRACTION.');
+insert into detab values(19.123,date('2000-07-07'),'Das Anlegen von Indizes ist hier nicht erlaubt.');
+insert into detab values(20.123,date('2000-08-06'),'Hier wird die Eingabe des Spaltennamen erwartet.');
+insert into detab values(21.123,date('2000-09-05'),'Hier wird die Eingabe des Tabellennamen erwartet.');
+insert into detab values(22.123,date('2000-10-04'),'Der eigentliche Spaltenname kann hier nicht angegeben werden.'); 
+insert into detab values(23.123,date('2000-11-03'),'Die maximale Gr��e f?r Varchar mu� zwischen 1 und 255 liegen.');
+insert into detab values(24.123,date('2000-12-02'),'Kann keine tempor�re Datei %s anlegen, um eine Blob-Variable aufzunehmen.');
+insert into detab values(25.123,date('2000-11-01'),'Symbol %s mu� ein SQL-Datenbank-Elementname sein - entweder ein ');
+insert into detab values(26.123,date('2000-10-28'),'Datenbankname, ein Tabellenname oder ein Spaltenname.');
+insert into detab values(27.123,date('2000-09-29'),'DATETIME-Einheiten k�nnen nur YEAR, MONTH, DAY, HOUR, MINUTE,'); 
+insert into detab values(28.123,date('2000-08-30'),'Eingeklammerte Genauigkeit von FRACTION mu� zwischen 1 und 5 liegen.');
+insert into detab values(29.123,date('2000-07-31'),'F?r andere Zeiteinheiten kann keine Genauigkeit definiert werden.');
+insert into detab values(30.123,date('2000-06-25'),'Das Startfeld von DATETIME oder INTERVAL-Kennzeichnern mu� in der ');
+insert into detab values(31.123,date('2000-05-25'),'Zeitliste vor dem Endfeld stehen.');
+insert into detab values(32.123,date('2000-04-25'),'Entladen in Datei %s mi�lungen.');
+insert into detab values(33.123,date('2000-03-25'),'Laden aus Datei %s mi�lungen.');
+insert into detab values(34.123,date('2000-02-25'),'Das Programm kann eine DISPLAY ARRAY-Anweisung an dieser Stelle nicht'); 
+insert into detab values(35.123,date('2000-01-25'),'beenden, weil es sich nicht in einer DISPLAY ARRAY-Anweisung befindet.');
+insert into detab values(36.123,date('2000-02-25'),'Das Programm kann eine INPUT-Anweisung an dieser Stelle nicht beenden,'); 
+insert into detab values(37.123,date('2000-04-25'),'weil es sich nicht in einer INPUT-Anweisung befindet.');
+insert into detab values(38.123,date('2000-05-25'),'Konnte Datei %s nicht �ffnen.');
+insert into detab values(39.123,date('2000-07-25'),'Name des Eigent?mers %s hat die L�nge von 8 Zeichen ?berschritten.');
+insert into detab values(40.123,date('2000-09-25'),'Fehler bei der Speicherzuordnung.');
+insert into detab values(41.123,date('2000-05-25'),'Unter dem angegebenen Namen wurde kein lauff�higes 4GL-Programm gefunden.');
+LOCALIZEDDISPLAY ON;
+show connections;
+select * from detab;

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql	(revision 0)
@@ -0,0 +1,2 @@
+--run the import/export negative tests in locale ES 
+run resource  '/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql';

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl	(revision 0)
@@ -0,0 +1,12 @@
+#Import/Export Properties
+#Wed Feb 23 15:51:10 GMT+02:00 2000
+ColumnDefinition=True
+DataCodeset=UTF8
+Format=ASCII_DELIMITED
+RecordSeparator=CR-LF
+Null=NULL
+Version=1
+FieldStartDelimiter="
+FieldSeparator=Comma
+DataLocale=fr_FR
+FieldEndDelimiter="
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl	(revision 0)
@@ -0,0 +1,7 @@
+#Import/Export Properties
+#Wed Oct 21 13:18:48 PDT 1998
+DataCodeset=EUC_JP
+RecordSeparator=CR-LF
+FieldStartDelimiter="
+FieldSeparator=Comma
+FieldEndDelimiter="
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl	(revision 0)
@@ -0,0 +1,12 @@
+#Import/Export Properties
+#Wed Feb 23 15:51:10 GMT+02:00 2000
+ColumnDefinition=True
+DataCodeset=UTF8
+Format=ASCII_DELIMITED
+RecordSeparator=CR-LF
+Null=NULL
+Version=1
+FieldStartDelimiter="
+FieldSeparator=Comma
+DataLocale=ja_JP
+FieldEndDelimiter="
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl	(revision 0)
@@ -0,0 +1,7 @@
+#Import/Export Properties
+#Wed Oct 21 13:18:48 PDT 1998
+DataCodeset=SJIS
+RecordSeparator=CR-LF
+FieldStartDelimiter="
+FieldSeparator=Comma
+FieldEndDelimiter="
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat	(revision 0)
@@ -0,0 +1,16 @@
+"1","15:32:06","���٥�ȥ��顼�बͭ���Ǥ���"
+"2","15:32:10","DR:DRAUTO��0 (Off)�Ǥ���"
+"3","15:32:28","INFORMIX-OnLine����������졢�ǥ������ν��������λ���ޤ�����"
+"4","15:32:29","�����å��ݥ���Ȥ���λ���ޤ���:��³���֤� 0�äǤ���"
+"5","15:32:29","���٤Ƥ�DB�ΰ�Υǡ��������åפϸ��ߥ��դˤʤäƤ��ޤ���"
+"6","15:32:30","On-Line�⡼��"
+"7","15:32:31","sysmaster�ǡ����١����������Ǥ�..."
+"8","15:33:22","�������� 1����λ���ޤ�����"
+"9","15:33:23","�꥿���󥳡��� 1���ᤷ�ƥץ���������λ���ޤ���:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 �������� 1����λ���ޤ����� ����"
+"10","15:33:40","�������� 2����λ���ޤ�����"
+"11","15:33:41","�꥿���󥳡��� 1���ᤷ�ƥץ���������λ���ޤ���:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 �������� 2����λ���ޤ����� ����"
+"12","15:33:43","�����å��ݥ���Ȥ���λ���ޤ���:��³���֤� 2�äǤ���"
+"13","15:34:29","�������� 3����λ���ޤ�����"
+"14","15:34:30","�꥿���󥳡��� 1���ᤷ�ƥץ���������λ���ޤ���:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 �������� 3����λ���ޤ����� ����"
+"15","15:35:35","sysmaster�ǡ����١����κ����ϴ�λ���ޤ�����"
+"16","15:39:10","�����å��ݥ���Ȥ���λ���ޤ���:��³���֤� 8�äǤ���"
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant	(revision 0)
@@ -0,0 +1,6 @@
+Tab1_fr.ctrl
+Tab1_il.ctrl
+Tab1_jp.ctrl
+jap_EUC_JP.ctrl
+jap_EUC_JP.dat
+jap_SJIS.ctrl
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl	(revision 0)
@@ -0,0 +1,12 @@
+#Import/Export Properties
+#Wed Feb 23 15:51:10 GMT+02:00 2000
+ColumnDefinition=True
+DataCodeset=UTF8
+Format=ASCII_DELIMITED
+RecordSeparator=CR-LF
+Null=NULL
+Version=1
+FieldStartDelimiter="
+FieldSeparator=Comma
+DataLocale=iw_IL
+FieldEndDelimiter="
Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql	(revision 0)
@@ -0,0 +1,32 @@
+drop table tab1;
+create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
+insert into tab1 values(12.345, date('2000-05-25'),  'test row 1');
+insert into tab1 values(32.432, date('2000-01-14'),  'test row 2');
+insert into tab1 values(54.846, date('2000-08-21'),  'test row 3');
+insert into tab1 values(98.214, date('2000-12-08'),  'test row 4');
+insert into tab1 values(77.406, date('2000-10-19'),  'test row 5');
+insert into tab1 values(50.395, date('2000-11-29'),  'test row 6');
+
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , 
+                                    null, null, 'UTF8') ;
+
+-- localized display is off
+select * from tab1;
+
+LOCALIZEDDISPLAY ON;
+select * from tab1;
+
+drop table tab1;
+create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
+
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , 
+                                    null, null, 'UTF8', 0) ;
+
+
+-- localized display is off
+LOCALIZEDDISPLAY OFF;
+select * from tab1;
+
+LOCALIZEDDISPLAY ON;
+select * from tab1;
+

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant	(revision 0)
@@ -0,0 +1,19 @@
+I18NImportExport.sql
+I18NImportExport_app.properties
+JapanCodeConversion.sql
+JapanCodeConversion_app.properties
+LocalizedConnectionAttribute.sql
+LocalizedConnectionAttribute_app.properties
+LocalizedDisplay.sql
+LocalizedDisplay_app.properties
+UnicodeEscape_JP.sql
+UnicodeEscape_JP_app.properties
+caseI_tr_TR.sql
+caseI_tr_TR_app.properties
+default_app.properties
+default_derby.properties
+iepnegativetests_ES.sql
+iepnegativetests_ES_app.properties
+messageLocale.sql
+messageLocale_app.properties
+urlLocale.sql

Property changes on: java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java	(revision 158815)
+++ java/testing/org/apache/derbyTesting/functionTests/harness/RunTest.java	(working copy)
@@ -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)
 		    {
Index: java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java	(revision 158815)
+++ java/testing/org/apache/derbyTesting/functionTests/harness/Sed.java	(working copy)
@@ -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,7 +268,15 @@
 		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;
         Perl5Compiler pcompiler;
@@ -402,6 +410,47 @@
                 }
             }
 
+            // 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 )
             {
Index: java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out	(revision 0)
@@ -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> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/caseI_tr_TR.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out	(revision 0)
@@ -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> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/iepnegativetests_ES.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out	(revision 0)
@@ -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)> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/LocalizedConnectionAttribute.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out	(revision 0)
@@ -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> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/JapanCodeConversion.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out	(revision 0)
@@ -0,0 +1,97 @@
+ij> -- THIS TEST WILL NOT WORK WITH THE .jar files
+-- It uses a dummy message_qq_PP_testOnly.properties that exists
+-- only in the codeline
+--
+-- Message locale handling
+--
+--;
+-- load a fake driver that is really a piece of
+-- code that sets the default locale;
+driver 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale';
+ij> --
+-- create a databse in this default locale, should
+-- get english messages, as there are no messages
+-- for rr_TT;
+connect 'jdbc:derby:wombat;create=true';
+ij> -- make sure the database is clean
+drop procedure checkDefaultLoc;
+ERROR 42Y55: 'DROP PROCEDURE' cannot be performed on 'CHECKDEFAULTLOC' because it does not exist.
+ij> create procedure checkDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDefaultLocale';
+0 rows inserted/updated/deleted
+ij> drop procedure checkDatabaseLoc;
+ERROR 42Y55: 'DROP PROCEDURE' cannot be performed on 'CHECKDATABASELOC' because it does not exist.
+ij> create procedure checkDatabaseLoc(in locale char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> drop procedure setDefaultDELoc;
+ERROR 42Y55: 'DROP PROCEDURE' cannot be performed on 'SETDEFAULTDELOC' because it does not exist.
+ij> create procedure setDefaultLoc(in locale char(10), in code char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.setDefaultLocale';
+0 rows inserted/updated/deleted
+ij> drop table t1;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.
+ij> drop table t2;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T2' because it does not exist.
+ij> call checkDefaultLoc();
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('rr_TT');
+0 rows inserted/updated/deleted
+ij> -- expect an error
+create table t1 oops (i int primary key);
+ERROR 42X01: Syntax error: Encountered "oops" at line 2, column 17.
+ij> -- setup for
+create table t2 (i int);
+0 rows inserted/updated/deleted
+ij> create index i2_a on t2(i);
+0 rows inserted/updated/deleted
+ij> -- expect a warning
+create index i2_b on t2(i);
+0 rows inserted/updated/deleted
+WARNING 01504: The new index is a duplicate of an existing index: I2_A.
+ij> -- another error
+drop table t3;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T3' because it does not exist.
+ij> -- set the default locale to German;
+--call java.util.Locale::setDefault(new java.util.Locale('de', 'DE'));
+call setDefaultLoc('de','DE');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> -- create a database with a locale that has a small
+-- number of messages. Missing ones will default to
+-- the locale of the default locale i.e. German;
+connect 'jdbc:derby:testdb;create=true;territory=qq_PP_testOnly';
+ij> -- error (in qq_PP messages);
+-- create table t1 (i longe);
+create table t1 oops (i int primary key);
+ERROR 42X01: Error of syntax: Encountered "oops" at line 3, column 17.
+ij> -- warning (in qq_PP messages);
+-- create table t2 (i java.lang.Object);
+create table t2 (i int);
+0 rows inserted/updated/deleted
+ij> create index i2_a on t2(i);
+0 rows inserted/updated/deleted
+ij> create index i2_b on t2(i);
+0 rows inserted/updated/deleted
+WARNING 01504: Der neue Index ist ein Duplikat eines vorhandenen Indexes: I2_A.
+ij> -- from default locale (German);
+drop table t3;
+ERROR 42Y55: 'DROP TABLE' kann nicht f EnC:>252< r 'T3' ausgef EnC:>252< hrt werden, da dieses Objekt nicht vorhanden ist.
+ij> -- should be in German;
+disconnect;
+ij> connect 'jdbc:derby:;shutdown=true';
+ERROR XJ015: Das Derby-System wird heruntergefahren.
+ij> -- Now, all Enlish messages;
+connect 'jdbc:derby:enTest;create=true;territory=en_US';
+ij> -- create table t1 (i longe);
+create table t1 oops (i int primary key);
+ERROR 42X01: Syntax error: Encountered "oops" at line 2, column 17.
+ij> -- create table t2 (i java.lang.Object);
+create table t2 (i int);
+0 rows inserted/updated/deleted
+ij> create index i2_a on t2(i);
+0 rows inserted/updated/deleted
+ij> create index i2_b on t2(i);
+0 rows inserted/updated/deleted
+WARNING 01504: The new index is a duplicate of an existing index: I2_A.
+ij> drop table t3;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T3' because it does not exist.
+ij> disconnect;
+ij> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out	(revision 0)
@@ -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> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/UnicodeEscape_JP.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out	(revision 0)
@@ -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> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/I18NImportExport.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out	(revision 0)
@@ -0,0 +1,103 @@
+ij> --
+--
+-- URL locale handling
+--
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> create procedure checkRDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkRDefaultLocale';
+0 rows inserted/updated/deleted
+ij> -- this current database was created with the default locale
+call checkDatabaseLoc('en_US');
+0 rows inserted/updated/deleted
+ij> call checkRDefaultLoc();
+en_US
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> -- create a Swiss database
+connect 'jdbc:derby:swissdb;create=true;territory=fr_CH';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('fr_CH');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:swissdb;shutdown=true';
+ERROR 08006: Arr EnC:>234< t de la base de donn EnC:>233< es 'swissdb'.
+ij> -- check it is still Swiss when we re-boot
+connect 'jdbc:derby:swissdb';
+ij> call checkDatabaseLoc('fr_CH');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:swissdb;shutdown=true';
+ERROR 08006: Arr EnC:>234< t de la base de donn EnC:>233< es 'swissdb'.
+ij> -- Locale automatically converts the components to the correct case
+-- create a Hindi in India database (hi_IN)
+connect 'jdbc:derby:hindi;create=true;territory=HI_in';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('hi_IN');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:hindi;shutdown=true';
+ERROR 08006: Database 'hindi' shutdown.
+ij> -- now try one with a variant
+-- create a English in Israel database for JavaOS en_IL_JavaOS
+connect 'jdbc:derby:Israel;create=true;territory=en_IL_JavaOS';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('en_IL_JavaOS');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:Israel;shutdown=true';
+ERROR 08006: Database 'Israel' shutdown.
+ij> -- now try with just a language - we support this
+-- as some vms do.
+connect 'jdbc:derby:bacon;create=true;territory=da';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('da');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:bacon;shutdown=true';
+ERROR 08006: Database 'bacon' shutdown.
+ij> connect 'jdbc:derby:bacon';
+ij> call checkDatabaseLoc('da');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:bacon;shutdown=true';
+ERROR 08006: Database 'bacon' shutdown.
+ij> --
+-- some negative tests
+--
+connect 'jdbc:derby:fail1;create=true;territory=';
+ERROR XJ041: Failed to create database 'fail1', see the next exception for details.
+ERROR XBM0X: Supplied territory description '' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> -- database will not have been created so this connection will fail
+connect 'jdbc:derby:fail1;shutdown=true';
+ERROR XJ004: Database 'fail1' not found.
+ij> connect 'jdbc:derby:fail3;create=true;territory=en_';
+ERROR XJ041: Failed to create database 'fail3', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en_' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> connect 'jdbc:derby:fail4;create=true;territory=en_d';
+ERROR XJ041: Failed to create database 'fail4', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en_d' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> connect 'jdbc:derby:fail5;create=true;territory=en_US_';
+ERROR XJ041: Failed to create database 'fail5', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en_US_' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> connect 'jdbc:derby:fail6;create=true;territory=en-US';
+ERROR XJ041: Failed to create database 'fail6', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en-US' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> -- try using a database name with trailing blanks
+-- beetle 4653
+connect 'jdbc:derby:trailblank;create=true';
+ij> connect 'jdbc:derby:trailblank';
+ij(CONNECTION1)> connect 'jdbc:derby:trailblank     ';
+ij(CONNECTION2)> connect 'jdbc:derby:trailblank      ;shutdown=true';
+ERROR 08006: Database 'trailblank' shutdown.
+ij(CONNECTION2)> connect 'jdbc:derby:;shutdown=true';
+ERROR XJ015: Derby system shutdown.
+ij(CONNECTION2)> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out	(revision 0)
@@ -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> 

Property changes on: java/testing/org/apache/derbyTesting/functionTests/master/LocalizedDisplay.out
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall	(revision 0)
+++ java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall	(revision 0)
@@ -0,0 +1,9 @@
+i18n/JapanCodeConversion.sql
+i18n/UnicodeEscape_JP.sql
+i18n/I18NImportExport.sql
+i18n/LocalizedDisplay.sql
+i18n/LocalizedConnectionAttribute.sql
+i18n/urlLocale.sql
+i18n/messageLocale.sql
+i18n/caseI_tr_TR.sql
+i18n/iepnegativetests_ES.sql

Property changes on: java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall
___________________________________________________________________
Name: svn:eol-style
   + native

Index: java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties	(revision 158815)
+++ java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties	(working copy)
@@ -1,3 +1,3 @@
-suites=derbylang derbynetmats storeall xa derbytools jdbc20 jdk14 jdbcapi encryptionAll nist demo multi unit
+suites=derbylang derbynetmats storeall xa derbytools jdbc20 jdk14 jdbcapi encryptionAll nist demo multi unit i18nTest
 derby.debug.true=enableBtreeConsistencyCheck
 derby.stream.error.logSeverityLevel=0
Index: java/testing/build.xml
===================================================================
--- java/testing/build.xml	(revision 158815)
+++ java/testing/build.xml	(working copy)
@@ -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}"/> 

--------------030404000602030101020005--