Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <AANLkTimXyYi=GwMAtrrHWqDNis=oPes3-tm6WBpK-3_5@mail.gmail.com>
References: <AANLkTimXyYi=GwMAtrrHWqDNis=oPes3-tm6WBpK-3_5@mail.gmail.com>
From: Michael Gentry <mgentry@masslight.net>
Date: Fri, 6 Aug 2010 08:35:06 -0400
Message-ID: <AANLkTinqM1ag6BiyuR5NbJ9Np7taP4OQE0MzBkDvu6Mo@mail.gmail.com>
Subject: Re: Strange insertion of UPPER when Ordering by TIMESTAMP in SQL
	Server
To: user@cayenne.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Just curious, did you use SortOrder.DESCENDING_INSENSITIVE?

mrg


On Fri, Aug 6, 2010 at 12:10 AM, Gary Jarrel <garyjarrel@gmail.com> wrote:
> Hi All
>
> Using SQL Server I have a table with a DATETIME column. When I run a
> Cayenne Query with an Oder By clause in Descending Mode, the resulting
> SQL looks something like:
>
> SELECT UPPER(t0.date_created)
> FROM product t0
> ORDER BY UPPER(t0.date_created) DESC
>
> In the Modeler these columns show up as TIMESTAMP
>
> Is there a reason a UPPER is being used, it seems like it's trying to
> do a case insensitive ordering on a non character based column.
>
> Thank you
>
> Gary
>