List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 11 2000 11:55am
Subject:Problem running ATIS Benchmark on MySQL 3.23.12c
View as plain text  
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
Thread
Problem running ATIS Benchmark on MySQL 3.23.12cDaniel Koch10 Mar
  • Problem running ATIS Benchmark on MySQL 3.23.12cMichael Widenius11 Mar