Return-Path: 
 <torque-dev-return-4532-apmail-db-torque-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-dev-archive@www.apache.org
Received: (qmail 44074 invoked from network); 23 Sep 2004 10:24:19 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 23 Sep 2004 10:24:19 -0000
Received: (qmail 91703 invoked by uid 500); 23 Sep 2004 10:24:17 -0000
Delivered-To: apmail-db-torque-dev-archive@db.apache.org
Received: (qmail 91683 invoked by uid 500); 23 Sep 2004 10:24:17 -0000
Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-dev-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-dev-subscribe@db.apache.org>
List-Help: <mailto:torque-dev-help@db.apache.org>
List-Post: <mailto:torque-dev@db.apache.org>
List-Id: "Apache Torque Developers List" <torque-dev.db.apache.org>
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Delivered-To: mailing list torque-dev@db.apache.org
Received: (qmail 91666 invoked by uid 99); 23 Sep 2004 10:24:17 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [194.175.229.106] (HELO mail.seitenbau.net) (194.175.229.106)
  by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 23 Sep 2004 03:24:16 -0700
Received: from [195.127.188.18] (helo=www.seitenbau.net)
	by mail.seitenbau.net with esmtp (Exim 4.30)
	id 1CAQlo-0008MD-Kk
	for torque-dev@db.apache.org; Thu, 23 Sep 2004 12:24:13 +0200
In-Reply-To: <414E0137.7040804@numerixtechnology.de>
Subject: RE: case sensitive ORDER BY
To: "Apache Torque Developers List" <torque-dev@db.apache.org>
X-Mailer: Lotus Notes Release 6.0 September 26, 2002
Message-ID: 
 <OF08975AB9.06D5E6A9-ONC1256F18.00387A79-C1256F18.003925F7@seitenbau.net>
From: Thomas Fischer <Fischer@seitenbau.net>
Date: Thu, 23 Sep 2004 12:24:11 +0200
X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21,
 2004) at
 23.09.2004 12:24:12 PM
MIME-Version: 1.0
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable
X-Scan-Signature: e8c7a9be8eee67fb4af9bbbbd4c4b2b0
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N





Hi Tarlika,

I did not look at the code, but in Torque 3.1.1-rc2, Henning has comple=
tely
rewritten the handling of order by, so this might be incorporated in th=
e
latest Release Candidate. If this is the case, you could get the releva=
nt
code from there and put it into you modified BasePeer.
I plan to incorporate these changes and the suggestions by Scott in my
patch, but as I do have little time during the next weeks, this could w=
ell
take till the middle of October.

    Thomas

T E Schmitz <mailreg@numerixtechnology.de> schrieb am 19.09.2004 23:59:=
19:

> Hello,
>
> I am using Torque 3.1 with PostgreSQL 7.4.
>
> I noticed that the generated ORDER BY clause is always case insensiti=
ve.
> Regardless of Criteria.setIgnoreCase(), for Strings the ORDER BY clau=
se
> always uses UPPER(<col>). I had a look at
> BasePeer.processOrderBy(), which always calls
> db.ignoreCaseInOrderBy(orderByColumn) for Strings.
>
> Is this intended?
> How can a case sensitive ORDER Bbe produced?
>
> (processOrderBy() was introduced by Thomas Fischer for the outer join=

> patch but this particular piece of code is identical to the original =
in
> createQuery())
>
> --
>
>
> Regards/Gru=DF,
>
> Tarlika Elisabeth Schmitz
>
> ---------------------------------------------------------------------=

> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>=



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org