SQL Anywhere ultralite - distinct + order by problems on 3193

Author

distinct + order by problems on 3193

rr12

2005-10-27, 7:41 am

Using both ul.net and ulisql I have a strange condition where rows are
skipped incorrectly.

Here's my select statement...

SELECT DISTINCT m.pt_no, m.p_fname,m.p_lname, m.tel, m.master_key, a.doa
FROM master m LEFT OUTER JOIN appt a ON m.master_key = a.master_key ORDER BY
m.pt_no

If the first column listed after DISTINCT is the same as the first column
listed after ORDER BY and that column contains duplicate entries (not a key)
then only one of the items appears in the result set.

If I simply make the first ORDER BY column different then the first column
listed then it works fine.

When I try this command on dbisql it returns the proper result set.

Am I missing something? This seems like a bug to me.

rr12

Greg Fenton

2005-10-27, 7:41 am

rr12 wrote:
>
> If I simply make the first ORDER BY column different then the first column
> listed then it works fine.
>

I suggest creating a simple repro of this situation and submitting it
either via iAnywhere Technical Support or via CaseXpress
(http://case-express.sybase.com/).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links