0000148: sorting by price not always working

ID	Project	Category	View Status	Date Submitted	Last Update

0000148	OXID eShop (all versions)	3.1. Design, GUI, UX	public	2008-09-18 15:15	2008-09-19 10:52

Reporter	birute_meilutyte	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	resolved	Resolution	won't fix

Summary	0000148: sorting by price not always working
Description	sorting by price not always working correctly. see attached img. to reproduce this behavior, use selenium demodata.
Tags	No tags attached.
Attached Files	sorting_by_price.PNG (41,460 bytes) sorting_by_price.PNG (41,460 bytes)

Theme
Browser	All
PHP Version	5.2.6
Database Version	5.0.33

arvydas_vapsva 2008-09-19 10:50 reporter ~0000097	there is no bug, just selenium tests must execute following SQL: UPDATE oxarticles SET oxarticles.oxvarminprice= (select min(art.oxprice) as varminprice from (select * from oxarticles) as art where art.oxparentid = oxarticles.oxid or ( art.oxid = oxarticles.oxid and art.oxparentid = '')); (at the end of SQL)

arvydas_vapsva 2008-09-19 10:52 reporter ~0000098	not a bug, see comments