diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-12-18 05:34:00 +0200 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-12-18 05:34:00 +0200 |
| commit | 20038678cff13261f886b3fdb7e2f04fae1386b5 (patch) | |
| tree | fd9b8b5be51e148f724af20f6edf3f0a36ba06a3 /sql-bench/test-ATIS.sh | |
| parent | 29fabf3a33511005676fca9cc8b818f63cf107f7 (diff) | |
| download | mariadb-git-20038678cff13261f886b3fdb7e2f04fae1386b5.tar.gz | |
Updated benchmarks
Portability fixes.
Fixed bug in mysqlbinlog when detecting binary log version
client/mysqlbinlog.cc:
Fixed bug when detecting binary log version
configure.in:
Portability fix for HPUX
mysql-test/mysql-test-run.sh:
Portability fix
sql-bench/bench-init.pl.sh:
Updated benchmarks
sql-bench/run-all-tests.sh:
Updated benchmarks
sql-bench/server-cfg.sh:
Updated benchmarks
sql-bench/test-ATIS.sh:
Updated benchmarks
sql-bench/test-connect.sh:
Updated benchmarks
Diffstat (limited to 'sql-bench/test-ATIS.sh')
| -rw-r--r-- | sql-bench/test-ATIS.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql-bench/test-ATIS.sh b/sql-bench/test-ATIS.sh index da866f2eb66..ac3d7360198 100644 --- a/sql-bench/test-ATIS.sh +++ b/sql-bench/test-ATIS.sh @@ -224,7 +224,7 @@ print "Retrieving data\n"; "SELECT airport.country_name,state.state_name,city.city_name,airport_service.direction FROM airport_service,state,airport,city WHERE airport_service.city_code=city.city_code AND airport_service.airport_code=airport.airport_code AND state.state_code=airport.state_code AND state.state_code=city.state_code AND airport.state_code=city.state_code AND airport.country_name=city.country_name AND airport.country_name=state.country_name AND city.time_zone_code=airport.time_zone_code GROUP BY airport.country_name,state.state_name,city.city_name,airport_service.direction ORDER BY state_name DESC",11,$limits->{'group_functions'}, "SELECT airport.country_name,state.state_name,city.city_name,airport_service.direction FROM airport_service,state,airport,city WHERE airport_service.city_code=city.city_code AND airport_service.airport_code=airport.airport_code AND state.state_code=airport.state_code AND state.state_code=city.state_code AND airport.state_code=city.state_code AND airport.country_name=city.country_name AND airport.country_name=state.country_name AND city.time_zone_code=airport.time_zone_code GROUP BY airport.country_name,state.state_name,city.city_name,airport_service.direction ORDER BY state_name",11,$limits->{'group_functions'}, "SELECT from_airport,to_airport,fare.fare_class,night,one_way_cost,rnd_trip_cost,class_days FROM compound_class,fare WHERE compound_class.fare_class=fare.fare_class AND one_way_cost <= 825 AND one_way_cost >= 280 AND from_airport='SFO' AND to_airport='DFW' GROUP BY from_airport,to_airport,fare.fare_class,night,one_way_cost,rnd_trip_cost,class_days ORDER BY one_way_cost",10,$limits->{'group_functions'}, - "select engines,category,cruising_speed,from_airport,to_airport FROM aircraft,flight WHERE category='JET' AND ENGINES >= 1 AND aircraft.aircraft_code=flight.aircraft_code AND to_airport NOT LIKE from_airport AND stops>0 GROUP BY engines,category,cruising_speed,from_airport,to_airport ORDER BY engines DESC",29,$limits->{'group_functions'} && $limits->{'like_with_column'}, + "select engines,category,cruising_speed,from_airport,to_airport FROM aircraft,flight WHERE category='JET' AND engines >= 1 AND aircraft.aircraft_code=flight.aircraft_code AND to_airport NOT LIKE from_airport AND stops>0 GROUP BY engines,category,cruising_speed,from_airport,to_airport ORDER BY engines DESC",29,$limits->{'group_functions'} && $limits->{'like_with_column'}, ); @Q=(\@Q1,\@Q2,\@Q21,\@Q3,\@Q4); |