Update of /cvsroot/monetdb/sql/src/benchmarks/ATIS/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv31468/src/benchmarks/ATIS/Tests
Modified Files:
select_group.sql
Log Message:
cleanup some more pre-remap.optimzer code
approved some output of tests
bumped the SQL_VERSION (ie the catalog got changed by romulo)
Index: select_group.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/ATIS/Tests/select_group.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- select_group.sql 23 Nov 2006 15:29:27 -0000 1.9
+++ select_group.sql 17 Apr 2007 12:27:06 -0000 1.10
@@ -22,5 +22,5 @@
select from_airport,to_airport,range_miles,time_elapsed FROM aircraft,flight
WHERE aircraft.aircraft_code=flight.aircraft_code AND to_airport <>
from_airport AND range_miles<>0 AND time_elapsed<>0 GROUP BY
from_airport,to_airport,range_miles,time_elapsed ORDER BY from_airport,
to_airport,range_miles,time_elapsed;
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, city_name, direction;
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, city_name DESC, direction DESC;
- 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;
+ 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,fare_class;
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 <> from_airport AND
stops>0 GROUP BY engines,category,cruising_speed,from_airport,to_airport ORDER
BY engines, from_airport, to_airport, cruising_speed DESC;
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
