List:General Discussion« Previous MessageNext Message »
From:Daniel Koch Date:March 10 2000 6:22pm
Subject:Problem running ATIS Benchmark on MySQL 3.23.12c
View as plain text  
>Description:

Running ATIS Benchmark for MySQL 3.23.12c in Irix 6.5:

Got error:  when executing select distinct
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
AS time_zone_diff FROM flight,airport AS from_airport,airport AS
to_airport WHERE flight.from_airport=from_airport.airport_code AND
flight.to_airport=to_airport.airport_code GROUP BY
from_airport.time_zone_code,to_airport.time_zone_code,arrival_time,departure_time,time_elapsed

got 0 instead of 21 ***


>How-To-Repeat:

>Fix:


>Submitter-Id: <submitter ID>
>Originator: Daniel Koch
>Organization:
 amcity.com
>MySQL support: none
>Synopsis: 3.23.12c on Irix 6.5 does not complete ATIS benchmark
>Severity: serious
>Priority: low
>Category: mysql
>Class:  sw-bug
>Release: mysql-3.23.12c-alpha (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.0 Distrib 3.23.12c-alpha, for
sgi-irix6.5 on mips
TCX Datakonsult AB, by Monty

Server version  3.23.12c-alpha-log
Protocol version 10
Connection  Localhost via UNIX socket
UNIX socket  /tmp/mysql.sock
Uptime:   4 min 54 sec

Threads: 2  Questions: 5855  Slow queries: 0  Opens: 1445  Flush tables:
1  Open tables: 33
>Environment:
 <machine, os, target, libraries (multiple lines)>
System: IRIX64 woody 6.5 01200532 IP27


Some paths:  /usr/sbin/perl /sbin/make /usr/local/bin/gmake /usr/bin/cc

Compilation info: CC='cc'  CFLAGS=''  CXX='CC'  CXXFLAGS=''  LDFLAGS=''
LIBC:
-r-xr-xr-t    1 root     sys       2332780 Mar  7 16:29 /lib/libc.so.1
lrwxr-xr-x    1 root     sys           19 Oct 25 12:27 /usr/lib/libc.so
-> ../../lib/libc.so.1
lrwxr-xr-x    1 root     sys           19 Oct 25 12:27
/usr/lib/libc.so.1 -> ../../lib/libc.so.1
Configure command: ./configure  --with-pthread
Perl: This is perl, version 5.005_03 built for IP27-irix



Thread
Problem running ATIS Benchmark on MySQL 3.23.12cDaniel Koch10 Mar
  • Problem running ATIS Benchmark on MySQL 3.23.12cMichael Widenius11 Mar