SQLException on sorting by Price in Product item

[Irina]

Hello ,

when I select a Product item in Product menu and sort them by Price I get next error:
(org.apache.torque.TorqueException) - java.sql.SQLException: ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

I can specify full error message if you need.

Thanks,
Irina

[julie]

Can you reproduce it on our online demo or after a default installation ?

[Irina]

Sorry I forgot to add that tis is reproduced in administration part.
Yes the error reproduced for default installation also.

Regards,
Irina

[trevor]

I can't reproduce it when I sort the products in the admin app by price. What database are you using?

[Irina]

We are using MSSQL 2008 RC2.

[Irina]

Hi Trevor,

do you have any idea why this error has happened? Will you suggest me something?

Regards,
Irina

[kate]

It's a problem when using MS SQL Server but has been fixed in the next release (v5.5.0.0).