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  

Running ATIS Benchmark for MySQL 3.23.12c in Irix 6.5:

Got error:  when executing select distinct
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

got 0 instead of 21 ***



>Submitter-Id: <submitter ID>
>Originator: Daniel Koch
>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
 <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=''
-r-xr-xr-t    1 root     sys       2332780 Mar  7 16:29 /lib/
lrwxr-xr-x    1 root     sys           19 Oct 25 12:27 /usr/lib/
-> ../../lib/
lrwxr-xr-x    1 root     sys           19 Oct 25 12:27
/usr/lib/ -> ../../lib/
Configure command: ./configure  --with-pthread
Perl: This is perl, version 5.005_03 built for IP27-irix

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