Hi!
>>>>> "Daniel" == Daniel Koch <dkoch@stripped> writes:
>> Description:
Daniel> Running ATIS Benchmark for MySQL 3.23.12c in Irix 6.5:
Daniel> Got error: when executing select distinct
Daniel>
> from_airport.time_zone_code,to_airport.time_zone_code,(FLOOR(arrival_time/100)*60+MOD(arrival_time,100)-FLOOR(departure_time/100)*60-MOD(departure_time,100)-time_elapsed)/60
Daniel> AS time_zone_diff FROM flight,airport AS from_airport,airport AS
Daniel> to_airport WHERE flight.from_airport=from_airport.airport_code AND
Daniel> flight.to_airport=to_airport.airport_code GROUP BY
Daniel>
> from_airport.time_zone_code,to_airport.time_zone_code,arrival_time,departure_time,time_elapsed
Daniel> got 0 instead of 21 ***
This is something that I thought was fixed between MySQL 3.23.11 and
MySQL 3.23.12 :(
I shall check this up before releasing 3.23.13.
Regards,
Monty
