From: Thomas Booms EDV
Date: March 25 1999 4:50pm
Subject: Problem with order by
List-Archive: http://lists.mysql.com/mysql/965
Message-Id: <36FA695E.5FC4B756@booms-edv.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

I have a Database with some travels (about 1,500,000 ).
The table looks so:

organizer text,
startpoint text,
destination text,
startdate date,
enddate date,
hotelcode text,
placingcode text,
boarding text,
price double,
hotelname text,
hotelresidence text,
stars text,
time int,
journeytype text,
persons int


Now I want to compare all Providers and get the cheapest.

Here's the query:

select distinct startdate, enddate, boarding, min(price), hotelname,
hotelresidence, stars, hotelcode, time from table group by startdate,
enddate, hotelname, hotelresidence order by price

The result is not fully sorted by the price !
It looks like some groups which are sorted and not the whole list is
sorted.

Am I wrong with the query or is it a bug in MySQL ?

Yours Thomas Booms