Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 71509 invoked from network); 9 Feb 2009 03:48:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Feb 2009 03:48:52 -0000 Received: (qmail 41466 invoked by uid 500); 9 Feb 2009 03:48:51 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 41442 invoked by uid 500); 9 Feb 2009 03:48:51 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 41433 invoked by uid 99); 9 Feb 2009 03:48:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 08 Feb 2009 19:48:51 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [68.142.207.73] (HELO web31810.mail.mud.yahoo.com) (68.142.207.73) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 09 Feb 2009 03:48:42 +0000 Received: (qmail 53674 invoked by uid 60001); 9 Feb 2009 03:48:20 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1234151300; bh=FfCJ27rd9jnSLlg1BPPRoIySGR6PSFTsPK765ZlOfz8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=MwhQu9DNzRqEyc2ig00x4Vdkb+Cdrsv26+EGlIg96DVKu12ZcQnE11j6AJGg53pL8LyQ0bSBiGz6Kt9r1hO9ml8WeH3vpRI2sqjIllTy6z/gQZ75fggXSagHPamQC5PakCg3Sp/DGy5BX+zIPAuBa3ZajpUkaesVo6Dhc83VeOo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=t2SgPE/mo53Fc0chNcBgM2Xsr6qT0RUF84s1oLlvRowwIYWFwQU58J8PGkLx5aZsDhaMEFL2xE3o4UrKHCY0ER9I4bST6YL+bZIMX8bdvJnjVLBfzijyG/BrDtbrGLJqAJXNUZQppPMN6I9pSDhLLiTryepOUPLTMnK+UpWbDOc=; Message-ID: <735342.53540.qm@web31810.mail.mud.yahoo.com> X-YMail-OSG: _OaUL1YVM1nhwoWCxPQ4NhaOcvrT2xOQYzMrISYPX3GzDLOLGCHMAncfcvzjBxz6ByQ5xWXU2SGRcb1x0078O.K99jFTw9GOivRVFWWBfxhgJYTIWo.e9vPNbFBdUglgHM_Uw50CAW7KvVQNzM_puYez6sxj4XRvw7YCOkIz4lNNYL3zHrYfvYcAVSmo5Gv8FWzyXKkK8kP6BwrFl0KPbsYuoknxtdzj Received: from [64.81.244.91] by web31810.mail.mud.yahoo.com via HTTP; Sun, 08 Feb 2009 19:48:20 PST X-Mailer: YahooMailRC/1277.18 YahooMailWebService/0.7.289.1 References: <912926.51984.qm@web31809.mail.mud.yahoo.com> <498E185E.9080800@amberpoint.com> <546176.24827.qm@web31809.mail.mud.yahoo.com> <498EDC51.8070905@Sun.COM> Date: Sun, 8 Feb 2009 19:48:20 -0800 (PST) From: Geoff hendrey Subject: Re: 10.4.2.1 doesn't solve ORDER BY problem To: Derby Discussion In-Reply-To: <498EDC51.8070905@Sun.COM> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-619390684-1234151300=:53540" X-Virus-Checked: Checked by ClamAV on apache.org --0-619390684-1234151300=:53540 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Indeed. Built from the branches/10.4 and the problem appears resolved. than= ks! Derby guys came through again, on a weekend.=0A=0A -geoff=0A=E2=80=9CHo= w many legs does a dog have if you call the tail a leg? Four. Calling a tai= l a leg doesn't make it a leg.=E2=80=9D =0A=E2=80=93 A. Lincoln=0A=0A=0A=0A= =0A=0A________________________________=0AFrom: Kristian Waagan =0ATo: Derby Discussion =0ASent: Sun= day, February 8, 2009 5:21:21 AM=0ASubject: Re: 10.4.2.1 doesn't solve ORDE= R BY problem=0A=0AGeoff hendrey wrote:=0A> I built from source, and also ra= n the sysinfo command on the 10.4.2.1 jar that I got from sun. Both yield i= dentical information, indicating "10.4.2.1" is the build. See output below = from running sysinfo against the sun downloaded jars.=0A=0AHi Geoff,=0A=0AL= ooking at the information, I see that Java DB 10.4.2.1 was built from revis= ion 706043 and that the fix for DERBY-3997 went into the repository for the= 10.4 branch as 731599. This means the fix is not included in Java DB 10.4.= 2.1.=0A=0A=0A-- Kristian=0A=0A> =0A> =0A> /Users/geoffreyhendrey/Desktop/ja= vadb > java -jar lib/derbyrun.jar sysinfo=0A> ------------------ Java Infor= mation ------------------=0A> Java Version: 1.6.0_05=0A> Java Vendor: = Apple Inc.=0A> Java home: /System/Library/Frameworks/JavaVM.framewo= rk/Versions/1.6.0/Home=0A> Java classpath: lib/derbyrun.jar=0A> OS name: = Mac OS X=0A> OS architecture: x86_64=0A> OS version: 10.5.4=0A>= Java user name: geoffreyhendrey=0A> Java user home: /Users/geoffreyhendr= ey=0A> Java user dir: /Users/geoffreyhendrey/Desktop/javadb=0A> java.spec= ification.name: Java Platform API Specification=0A> java.specification.vers= ion: 1.6=0A> --------- Derby Information --------=0A> JRE - JDBC: Java SE 6= - JDBC 4.0=0A> [/Users/geoffreyhendrey/Desktop/javadb/lib/derby.jar] 10.4.= 2.1 - (706043)=0A> [/Users/geoffreyhendrey/Desktop/javadb/lib/derbytools.ja= r] 10.4.2.1 - (706043)=0A> [/Users/geoffreyhendrey/Desktop/javadb/lib/derby= net.jar] 10.4.2.1 - (706043)=0A> [/Users/geoffreyhendrey/Desktop/javadb/lib= /derbyclient.jar] 10.4.2.1 - (706043)=0A> ---------------------------------= ---------------------=0A> ----------------- Locale Information ------------= -----=0A> Current Locale : [English/United States [en_US]]=0A> Found suppo= rt for locale: [cs]=0A> version: 10.4.2.1 - (706043)=0A> Found support= for locale: [de_DE]=0A> version: 10.4.2.1 - (706043)=0A> Found suppor= t for locale: [es]=0A> version: 10.4.2.1 - (706043)=0A> Found support = for locale: [fr]=0A> version: 10.4.2.1 - (706043)=0A> Found support fo= r locale: [hu]=0A> version: 10.4.2.1 - (706043)=0A> Found support for = locale: [it]=0A> version: 10.4.2.1 - (706043)=0A> Found support for lo= cale: [ja_JP]=0A> version: 10.4.2.1 - (706043)=0A> Found support for l= ocale: [ko_KR]=0A> version: 10.4.2.1 - (706043)=0A> Found support for = locale: [pl]=0A> version: 10.4.2.1 - (706043)=0A> Found support for lo= cale: [pt_BR]=0A> version: 10.4.2.1 - (706043)=0A> Found support for l= ocale: [ru]=0A> version: 10.4.2.1 - (706043)=0A> Found support for loc= ale: [zh_CN]=0A> version: 10.4.2.1 - (706043)=0A> Found support for lo= cale: [zh_TW]=0A> version: 10.4.2.1 - (706043)=0A> -------------------= -----------------------------------=0A> =0A> -geoff=0A> =E2=80=9CHow many = legs does a dog have if you call the tail a leg? Four. Calling a tail a leg= doesn't make it a leg.=E2=80=9D=0A> =E2=80=93 A. Lincoln=0A> =0A> =0A> ---= ---------------------------------------------------------------------=0A> *= From:* Bryan Pendleton =0A> *To:* Derby Discussi= on =0A> *Sent:* Saturday, February 7, 2009 3:25:1= 8 PM=0A> *Subject:* Re: 10.4.2.1 doesn't solve ORDER BY problem=0A> =0A> > = regarding Jira Issue: https://issues.apache.org/jira/browse/DERBY-3997=0A> = =0A> Hi Geoff,=0A> =0A> You can download the Derby 10.4 source from subvers= ion and build it yourself.=0A> Then you can be sure that you have exactly t= he fixes that you need.=0A> =0A> Here's more information about how to build= Derby from source.=0A> =0A> If you have trouble, people on the derby-dev l= ist are always glad to help.=0A> =0A> thanks,=0A> =0A> bryan=0A> --0-619390684-1234151300=:53540 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Indeed. Built from the branches/10.4 and the problem appears= resolved. thanks! Derby guys came through again, on a weekend.
&nb= sp;
-geoff
=E2=80=9CHow many legs does a dog hav= e if you call the tail a leg? Four. Calling a tail a leg doesn't make it a = leg.=E2=80=9D
=E2=80= =93 A. Lincoln



From: Kr= istian Waagan <Kristian.Waagan@Sun.COM>
To: Derby Discussion <derby-user@db.apache.org>
Sent: Sunday, February 8, 2009 5:21:21 AM
Subject: Re: 10.4.2.1 doesn't solv= e ORDER BY problem

=0AGeoff hendrey wrote:
> I built fr= om source, and also ran the sysinfo command on the 10.4.2.1 jar that I got = from sun. Both yield identical information, indicating "10.4.2.1" is the bu= ild. See output below from running sysinfo against the sun downloaded jars.=

Hi Geoff,

Looking at the information, I see that Java DB 10.= 4.2.1 was built from revision 706043 and that the fix for DERBY-3997 went i= nto the repository for the 10.4 branch as 731599. This means the fix is not= included in Java DB 10.4.2.1.


-- Kristian

>
> =
> /Users/geoffreyhendrey/Desktop/javadb > java -jar lib/derbyrun.= jar sysinfo
> ------------------ Java Information ------------------<= br>> Java Version:    1.6.0_05
> Java Vendor:  &nbs= p; Apple Inc.
> Java home:      /System/Library/Fram= eworks/JavaVM.framework/Versions/1.6.0/Home
> Java classpath:  l= ib/derbyrun.jar
> OS name:        Mac OS X
> OS architecture: x86_64=
> OS version:      10.5.4
> Java user name:&nbs= p; geoffreyhendrey
> Java user home:  /Users/geoffreyhendrey
= > Java user dir:  /Users/geoffreyhendrey/Desktop/javadb
> java.specificati= on.name: Java Platform API Specification
> java.specification.ver= sion: 1.6
> --------- Derby Information --------
> JRE - JDBC: = Java SE 6 - JDBC 4.0
> [/Users/geoffreyhendrey/Desktop/javadb/lib/der= by.jar] 10.4.2.1 - (706043)
> [/Users/geoffreyhendrey/Desktop/javadb/= lib/derbytools.jar] 10.4.2.1 - (706043)
> [/Users/geoffreyhendrey/Des= ktop/javadb/lib/derbynet.jar] 10.4.2.1 - (706043)
> [/Users/geoffreyh= endrey/Desktop/javadb/lib/derbyclient.jar] 10.4.2.1 - (706043)
> ----= --------------------------------------------------
> ----------------- Locale Information -----------------
> Current Loc= ale :  [English/United States [en_US]]
> Found support for local= e: [cs]
>      version: 10.4.2.1 - (706043)
> Fo= und support for locale: [de_DE]
>      version: 10.4.2= .1 - (706043)
> Found support for locale: [es]
>    &= nbsp; version: 10.4.2.1 - (706043)
> Found support for locale: [fr]>      version: 10.4.2.1 - (706043)
> Found suppo= rt for locale: [hu]
>      version: 10.4.2.1 - (706043= )
> Found support for locale: [it]
>      versio= n: 10.4.2.1 - (706043)
> Found support for locale: [ja_JP]
>&nb= sp;     version: 10.4.2.1 - (706043)
> Found support for lo= cale: [ko_KR]
>      version: 10.4.2.1 - (706043)
&= gt; Found support for locale: [pl]
>      version: 10.4.2.1 - (706043)
> Found support for locale: [pt_BR]
= >      version: 10.4.2.1 - (706043)
> Found support= for locale: [ru]
>      version: 10.4.2.1 - (706043)<= br>> Found support for locale: [zh_CN]
>      versi= on: 10.4.2.1 - (706043)
> Found support for locale: [zh_TW]
>&n= bsp;     version: 10.4.2.1 - (706043)
> -------------------= -----------------------------------
>
>  -geoff
> = =E2=80=9CHow many legs does a dog have if you call the tail a leg? Four. Ca= lling a tail a leg doesn't make it a leg.=E2=80=9D
> =E2=80=93 A. Lin= coln
>
>
> --------------------------------------------= ----------------------------
> *From:* Bryan Pendleton <bpendleton@amberpoint.com>
> *To:* Derby Discussion <<= a ymailto=3D"mailto:derby-user@db.apache.org" href=3D"mailto:derby-user@db.a= pache.org">derby-user@db.apache.org>
> *Sent:* Saturday, Febru= ary 7, 2009 3:25:18 PM
> *Subject:* Re: 10.4.2.1 doesn't solve ORDER = BY problem
>
> > regarding Jira Issue: https://issues.a= pache.org/jira/browse/DERBY-3997
>
> Hi Geoff,
> > You can download the Derby 10.4 source from subversion and build it y= ourself.
> Then you can be sure that you have exactly the fixes that = you need.
>
> Here's more information about how to build Derby= from source.
>
> If you have trouble, people on the derby-dev= list are always glad to help.
>
> thanks,
>
> br= yan
>

--0-619390684-1234151300=:53540--