Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ORDER BY Bug

3 posts in Ultralite Last posting was on 2012-04-29 15:54:03.0Z
jason Posted on 2012-04-26 14:09:33.0Z
Sender: 846.4f99562a.1804289383@sybase.com
From: Jason
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: ORDER BY Bug
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f99571d.860.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 26 Apr 2012 07:09:33 -0700
X-Trace: forums-1-dub 1335449373 172.20.134.41 (26 Apr 2012 07:09:33 -0700)
X-Original-Trace: 26 Apr 2012 07:09:33 -0700, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12715
Article PK: 1048583

Ultralite iOS (latest version)

I have the following query:

SELECT DISTINCT CC.ClassCategoryName AS name,
CC.ClassCategoryID AS value
FROM ClassCategory CC INNER JOIN Class C ON
C.ClassCategoryID = CC.ClassCategoryID
WHERE (C.RowStatus = 1)
ORDER BY CC.Ordinal, CC.ClassCategoryName

The results order by "ClassCategoryName", not Ordinal unless
I actually include the "Ordinal" column in the select
result.


Chris Keating [Sybase] Posted on 2012-04-26 17:27:52.0Z
From: "Chris Keating [Sybase]" <keating_nospam@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: ORDER BY Bug
References: <4f99571d.860.1681692777@sybase.com>
In-Reply-To: <4f99571d.860.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f998598@forums-1-dub>
Date: 26 Apr 2012 10:27:52 -0700
X-Trace: forums-1-dub 1335461272 10.22.241.152 (26 Apr 2012 10:27:52 -0700)
X-Original-Trace: 26 Apr 2012 10:27:52 -0700, vip152.sybase.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12716
Article PK: 1048524

Can you open a technical support case or use the "Create Bug Report
Case" using http://case-express.sybase.com with a repro showing the
behaviour.

Thanks

-chris

On 4/26/2012 10:09 AM, Jason wrote:
> Ultralite iOS (latest version)
>
> I have the following query:
>
> SELECT DISTINCT CC.ClassCategoryName AS name,
> CC.ClassCategoryID AS value
> FROM ClassCategory CC INNER JOIN Class C ON
> C.ClassCategoryID = CC.ClassCategoryID
> WHERE (C.RowStatus = 1)
> ORDER BY CC.Ordinal, CC.ClassCategoryName
>
> The results order by "ClassCategoryName", not Ordinal unless
> I actually include the "Ordinal" column in the select
> result.


jason Posted on 2012-04-29 15:54:03.0Z
Sender: 517e.4f9d6307.1804289383@sybase.com
From: Jason
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: ORDER BY Bug
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f9d641b.51a1.1681692777@sybase.com>
References: <4f998598@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 Apr 2012 08:54:03 -0700
X-Trace: forums-1-dub 1335714843 172.20.134.41 (29 Apr 2012 08:54:03 -0700)
X-Original-Trace: 29 Apr 2012 08:54:03 -0700, 172.20.134.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12717
Article PK: 1048525

Just did. Thanks Chris!

> Can you open a technical support case or use the "Create
> Bug Report Case" using http://case-express.sybase.com
> with a repro showing the behaviour.
>
> Thanks
>
> -chris
>
>
> On 4/26/2012 10:09 AM, Jason wrote:
> > Ultralite iOS (latest version)
> >
> > I have the following query:
> >
> > SELECT DISTINCT CC.ClassCategoryName AS name,
> > CC.ClassCategoryID AS value
> > FROM ClassCategory CC INNER JOIN Class C ON
> > C.ClassCategoryID = CC.ClassCategoryID
> > WHERE (C.RowStatus = 1)
> > ORDER BY CC.Ordinal, CC.ClassCategoryName
> >
> > The results order by "ClassCategoryName", not Ordinal
> > unless I actually include the "Ordinal" column in the
> > select result.
>