>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
