Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of garyjarrel@gmail.com designates
 209.85.210.43 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=XEHliM9FvOKxzJiHaE7E7YZYeb+rTc542Vw0/sGIgyBdmxoJh51MFyORHGExeaPRW1
         17k2TQqtFXvssWF2o8l1obsFOxyN30k3l3wxgmUUGJlXS9DvMVMQ6uTVQBCxP9sMAtLG
         sM7ttkBJh5I3es6vKgVY7zioY/+IVn6Vd3Sv8=
MIME-Version: 1.0
Date: Fri, 6 Aug 2010 14:10:45 +1000
Message-ID: <AANLkTimXyYi=GwMAtrrHWqDNis=oPes3-tm6WBpK-3_5@mail.gmail.com>
Subject: Strange insertion of UPPER when Ordering by TIMESTAMP in SQL Server
From: Gary Jarrel <garyjarrel@gmail.com>
To: user@cayenne.apache.org
Content-Type: text/plain; charset=ISO-8859-1

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