Changeset: 07a6fb005fe7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=07a6fb005fe7
Added Files:
sql/benchmarks/arno/Tests/inserts.options5
sql/benchmarks/arno/Tests/inserts.reqtests
sql/benchmarks/arno/Tests/inserts.sql.src
sql/benchmarks/arno/Tests/inserts.stable.err
sql/benchmarks/arno/Tests/inserts.stable.out
sql/benchmarks/arno/inserts.sql
sql/benchmarks/arno_flt/inserts.flt.sql
Removed Files:
sql/benchmarks/arno/Tests/insert_ATOM.options5
sql/benchmarks/arno/Tests/insert_ATOM.reqtests
sql/benchmarks/arno/Tests/insert_ATOM.sql.src
sql/benchmarks/arno/Tests/insert_ATOM.stable.err
sql/benchmarks/arno/Tests/insert_ATOM.stable.out
sql/benchmarks/arno/Tests/insert_BOND.options5
sql/benchmarks/arno/Tests/insert_BOND.reqtests
sql/benchmarks/arno/Tests/insert_BOND.sql.src
sql/benchmarks/arno/Tests/insert_BOND.stable.err
sql/benchmarks/arno/Tests/insert_BOND.stable.out
sql/benchmarks/arno/Tests/insert_MODEL.reqtests
sql/benchmarks/arno/Tests/insert_MODEL.sql.src
sql/benchmarks/arno/Tests/insert_MODEL.stable.err
sql/benchmarks/arno/Tests/insert_MODEL.stable.out
sql/benchmarks/arno/insert_ATOM.int.sql
sql/benchmarks/arno/insert_BOND.int.sql
sql/benchmarks/arno/insert_MODEL.int.sql
sql/benchmarks/arno_flt/insert_ATOM.flt.sql
sql/benchmarks/arno_flt/insert_BOND.flt.sql
sql/benchmarks/arno_flt/insert_MODEL.flt.sql
sql/test/VOC/VOCcreate_user.sql
sql/test/VOC/VOCdrop.sql
sql/test/VOC/VOCdrop_user.sql
sql/test/VOC/VOCinsert.sql
sql/test/VOC/VOCmanual_examples.sql
sql/test/VOC/VOCquery.sql
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
sql/backends/monet5/sql.c
sql/backends/monet5/sql.h
sql/backends/monet5/sql.mal
sql/benchmarks/ATIS/Tests/load.stable.out
sql/benchmarks/ATIS/load.sql
sql/benchmarks/arno/Tests/01.reqtests
sql/benchmarks/arno/Tests/02.reqtests
sql/benchmarks/arno/Tests/03.reqtests
sql/benchmarks/arno/Tests/04.reqtests
sql/benchmarks/arno/Tests/05.reqtests
sql/benchmarks/arno/Tests/06.reqtests
sql/benchmarks/arno/Tests/07.reqtests
sql/benchmarks/arno/Tests/08.reqtests
sql/benchmarks/arno/Tests/09.reqtests
sql/benchmarks/arno/Tests/10.reqtests
sql/benchmarks/arno/Tests/11.reqtests
sql/benchmarks/arno/Tests/12.reqtests
sql/benchmarks/arno/Tests/13.reqtests
sql/benchmarks/arno/Tests/14.reqtests
sql/benchmarks/arno/Tests/15.reqtests
sql/benchmarks/arno/Tests/16.reqtests
sql/benchmarks/arno/Tests/17.reqtests
sql/benchmarks/arno/Tests/18.reqtests
sql/benchmarks/arno/Tests/19.reqtests
sql/benchmarks/arno/Tests/20.reqtests
sql/benchmarks/arno/Tests/21.reqtests
sql/benchmarks/arno/Tests/22.reqtests
sql/benchmarks/arno/Tests/23.reqtests
sql/benchmarks/arno/Tests/24.reqtests
sql/benchmarks/arno/Tests/25.reqtests
sql/benchmarks/arno/Tests/26.reqtests
sql/benchmarks/arno/Tests/27.reqtests
sql/benchmarks/arno/Tests/28.reqtests
sql/benchmarks/arno/Tests/29.reqtests
sql/benchmarks/arno/Tests/30.reqtests
sql/benchmarks/arno/Tests/31.reqtests
sql/benchmarks/arno/Tests/32.reqtests
sql/benchmarks/arno/Tests/33.reqtests
sql/benchmarks/arno/Tests/34.reqtests
sql/benchmarks/arno/Tests/35.reqtests
sql/benchmarks/arno/Tests/36.reqtests
sql/benchmarks/arno/Tests/37.reqtests
sql/benchmarks/arno/Tests/38.reqtests
sql/benchmarks/arno/Tests/39.reqtests
sql/benchmarks/arno/Tests/40.reqtests
sql/benchmarks/arno/Tests/41.reqtests
sql/benchmarks/arno/Tests/42.reqtests
sql/benchmarks/arno/Tests/43.reqtests
sql/benchmarks/arno/Tests/44.reqtests
sql/benchmarks/arno/Tests/45.reqtests
sql/benchmarks/arno/Tests/46.reqtests
sql/benchmarks/arno/Tests/47.reqtests
sql/benchmarks/arno/Tests/48.reqtests
sql/benchmarks/arno/Tests/49.reqtests
sql/benchmarks/arno/Tests/50.reqtests
sql/benchmarks/arno/Tests/51.reqtests
sql/benchmarks/arno/Tests/52.reqtests
sql/benchmarks/arno/Tests/53.reqtests
sql/benchmarks/arno/Tests/54.reqtests
sql/benchmarks/arno/Tests/55.reqtests
sql/benchmarks/arno/Tests/56.reqtests
sql/benchmarks/arno/Tests/57.reqtests
sql/benchmarks/arno/Tests/58.reqtests
sql/benchmarks/arno/Tests/59.reqtests
sql/benchmarks/arno/Tests/60.reqtests
sql/benchmarks/arno/Tests/61.reqtests
sql/benchmarks/arno/Tests/62.reqtests
sql/benchmarks/arno/Tests/63.reqtests
sql/benchmarks/arno/Tests/64.reqtests
sql/benchmarks/arno/Tests/65.reqtests
sql/benchmarks/arno/Tests/66.reqtests
sql/benchmarks/arno/Tests/67.reqtests
sql/benchmarks/arno/Tests/68.reqtests
sql/benchmarks/arno/Tests/69.reqtests
sql/benchmarks/arno/Tests/70.reqtests
sql/benchmarks/arno/Tests/71.reqtests
sql/benchmarks/arno/Tests/72.reqtests
sql/benchmarks/arno/Tests/73.reqtests
sql/benchmarks/arno/Tests/74.reqtests
sql/benchmarks/arno/Tests/75.reqtests
sql/benchmarks/arno/Tests/76.reqtests
sql/benchmarks/arno/Tests/77.reqtests
sql/benchmarks/arno/Tests/78.reqtests
sql/benchmarks/arno/Tests/79.reqtests
sql/benchmarks/arno/Tests/80.reqtests
sql/benchmarks/arno/Tests/81.reqtests
sql/benchmarks/arno/Tests/82.reqtests
sql/benchmarks/arno/Tests/83.reqtests
sql/benchmarks/arno/Tests/84.reqtests
sql/benchmarks/arno/Tests/85.reqtests
sql/benchmarks/arno/Tests/86.reqtests
sql/benchmarks/arno/Tests/87.reqtests
sql/benchmarks/arno/Tests/88.reqtests
sql/benchmarks/arno/Tests/89.reqtests
sql/benchmarks/arno/Tests/90.reqtests
sql/benchmarks/arno/Tests/91.reqtests
sql/benchmarks/arno/Tests/All
sql/benchmarks/arno/Tests/check1.reqtests
sql/benchmarks/arno/Tests/create.stable.out
sql/benchmarks/arno/Tests/queries_depth2.reqtests
sql/benchmarks/arno/run.all
sql/benchmarks/arno_flt/Tests/init.SQL.bat
sql/benchmarks/arno_flt/Tests/init.SQL.sh
sql/benchmarks/arno_flt/Tests/init.stable.out
sql/benchmarks/arno_flt/doCreateDB
sql/benchmarks/arno_flt/run.all
sql/benchmarks/moa/Tests/load.stable.out
sql/benchmarks/moa/load1.sql
sql/server/rel_optimizer.c
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.sql
sql/test/VOC/Tests/VOC.SQL.py
sql/test/VOC/Tests/VOC.stable.out
sql/test/VOC/Tests/double_is_null.Bug-3116.sql
sql/test/VOC/Tests/median.Bug-3096.sql
sql/test/VOC/VOCschema.sql
Branch: default
Log Message:
Merge with Nov2019
diffs (truncated from 261934 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -11804,7 +11804,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ",
"DELTAsub2;", "Return a single bat of selected delta." ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ",
"DELTAsub;", "Return a single bat of selected delta." ]
[ "sql", "subnull", "command sql.subnull(l:bat[:any_1],
gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLnil_grp;", "if
any value in l is nil with in a group return true for that group, else false"
]
-[ "sql", "subzero_or_one", "inline function
sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid],
no_nil:bit):bat[:any_1];", "", "" ]
+[ "sql", "subzero_or_one", "command
sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid],
no_nil:bit):bat[:any_1] ", "SQLsubzero_or_one;", "" ]
[ "sql", "sum", "pattern sql.sum(b:bte, s:lng, e:lng):lng ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:dbl, s:lng, e:lng):dbl ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:flt, s:lng, e:lng):dbl ",
"SQLsum;", "return the sum of groups" ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -16216,7 +16216,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ",
"DELTAsub2;", "Return a single bat of selected delta." ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ",
"DELTAsub;", "Return a single bat of selected delta." ]
[ "sql", "subnull", "command sql.subnull(l:bat[:any_1],
gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLnil_grp;", "if
any value in l is nil with in a group return true for that group, else false"
]
-[ "sql", "subzero_or_one", "inline function
sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid],
no_nil:bit):bat[:any_1];", "", "" ]
+[ "sql", "subzero_or_one", "command
sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid],
no_nil:bit):bat[:any_1] ", "SQLsubzero_or_one;", "" ]
[ "sql", "sum", "pattern sql.sum(b:bte, s:lng, e:lng):hge ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:bte, s:lng, e:lng):lng ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:dbl, s:lng, e:lng):dbl ",
"SQLsum;", "return the sum of groups" ]
diff --git a/sql/backends/monet5/sql.c b/sql/backends/monet5/sql.c
--- a/sql/backends/monet5/sql.c
+++ b/sql/backends/monet5/sql.c
@@ -3507,6 +3507,41 @@ zero_or_one(ptr ret, const bat *bid)
}
str
+SQLsubzero_or_one(bat *ret, const bat *bid, const bat *gid, const bat *eid,
bit *no_nil)
+{
+ gdk_return r;
+ BAT *ng = NULL, *h = NULL, *g, *b;
+
+ (void)no_nil;
+ (void)eid;
+
+ g = gid ? BATdescriptor(*gid) : NULL;
+ if (g == NULL) {
+ if (g)
+ BBPunfix(g->batCacheid);
+ throw(MAL, "sql.subzero_or_one", SQLSTATE(HY002)
RUNTIME_OBJECT_MISSING);
+ }
+
+ if ((r = BATgroup(&ng, NULL, &h, g, NULL, NULL, NULL, NULL)) ==
GDK_SUCCEED) {
+ lng max = 0;
+
+ if (ng)
+ BBPunfix(ng->batCacheid);
+ BATmax(h, &max);
+ BBPunfix(h->batCacheid);
+ if (max != lng_nil && max > 1)
+ throw(SQL, "assert", SQLSTATE(M0M29) "zero_or_one:
cardinality violation, scalar expression expected");
+
+ }
+ BBPunfix(g->batCacheid);
+ if (r == GDK_SUCCEED) {
+ b = bid ? BATdescriptor(*bid) : NULL;
+ BBPkeepref(*ret = b->batCacheid);
+ }
+ return MAL_SUCCEED;
+}
+
+str
SQLall(ptr ret, const bat *bid)
{
BAT *b;
diff --git a/sql/backends/monet5/sql.h b/sql/backends/monet5/sql.h
--- a/sql/backends/monet5/sql.h
+++ b/sql/backends/monet5/sql.h
@@ -115,6 +115,7 @@ sql5_export str mvc_bat_restart_seq(Clie
sql5_export str zero_or_one_error(ptr ret, const bat *bid, const bit *err );
sql5_export str zero_or_one_error_bat(ptr ret, const bat *bid, const bat *err
);
sql5_export str zero_or_one(ptr ret, const bat *bid);
+sql5_export str SQLsubzero_or_one(bat *ret, const bat *b, const bat *gp, const
bat *gpe, bit *no_nil);
sql5_export str SQLall(ptr ret, const bat *bid);
sql5_export str SQLall_grp(bat *ret, const bat *l, const bat *gp, const bat
*gpe, bit *no_nil);
sql5_export str SQLnil(bit *ret, const bat *bid);
diff --git a/sql/backends/monet5/sql.mal b/sql/backends/monet5/sql.mal
--- a/sql/backends/monet5/sql.mal
+++ b/sql/backends/monet5/sql.mal
@@ -374,16 +374,8 @@ command zero_or_one( col:bat[:any_1], er
address zero_or_one_error_bat
comment "if col contains exactly one value return this. Incase of more raise
an exception if err is true else return nil";
-inline function sql.subzero_or_one( b:bat[:any_1], gp:bat[:oid],
gpe:bat[:oid], no_nil:bit) :bat[:any_1];
- (g,e,h) := group.group(gp);
- m := aggr.max(h);
- c0 := calc.isnil(m);
- c01 := calc.not(c0);
- c1 := calc.>(m,1:lng);
- c11 := calc.and(c01,c1);
- sql.assert(c11, "zero_or_one: cardinality violation, scalar expression
expected");
- return zero_or_one := b;
-end sql.subzero_or_one;
+command subzero_or_one( b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid],
no_nil:bit) :bat[:any_1]
+address SQLsubzero_or_one;
command all( col:bat[:any_1]) :any_1
address SQLall
diff --git a/sql/benchmarks/ATIS/Tests/load.stable.out
b/sql/benchmarks/ATIS/Tests/load.stable.out
--- a/sql/benchmarks/ATIS/Tests/load.stable.out
+++ b/sql/benchmarks/ATIS/Tests/load.stable.out
@@ -23,19577 +23,502 @@ stdout of test 'load` in directory 'sql/
# clients.quit();
#end main;
-
-# 10:33:58 >
-# 10:33:58 > Mtimeout -timeout 180 MapiClient --language=sql -u monetdb -P
monetdb --host=pictor --port=58607 < load.sql
-# 10:33:58 >
+#START TRANSACTION;
+#create table aircraft (aircraft_code char(3) NOT NULL,aircraft_type char(64)
NOT NULL,engines decimal(1) NOT NULL,category char(10) NOT NULL,wide_body
char(3) NOT NULL,wing_span float(6,2) NOT NULL,length1 float(6,2) NOT
NULL,weight integer NOT NULL,capacity decimal(3) NOT NULL,pay_load integer NOT
NULL,cruising_speed decimal(5) NOT NULL,range_miles decimal(5) NOT
NULL,pressurized char(3) NOT NULL,PRIMARY KEY (aircraft_code));
+#create table airline (airline_code char(2) NOT NULL,airline_name char(64) NOT
NULL,notes char(38) NOT NULL,PRIMARY KEY (airline_code));
+#create table airport (airport_code char(3) NOT NULL,airport_name char(40) NOT
NULL,location char(36) NOT NULL,state_code char(2) NOT NULL,country_name
char(25) NOT NULL,time_zone_code char(3) NOT NULL,PRIMARY KEY (airport_code));
+#create table airport_service (city_code char(4) NOT NULL,airport_code char(3)
NOT NULL,miles_distant float(4,1) NOT NULL,direction char(3) NOT
NULL,minutes_distant decimal(3) NOT NULL,PRIMARY KEY (city_code, airport_code));
+#create table city (city_code char(4) NOT NULL,city_name char(25) NOT
NULL,state_code char(2) NOT NULL,country_name char(25) NOT NULL,time_zone_code
char(3) NOT NULL,PRIMARY KEY (city_code));
+#create table class_of_service (class_code char(2) NOT NULL,rank decimal(2)
NOT NULL,class_description char(80) NOT NULL,PRIMARY KEY (class_code));
+#create table code_description (code char(5) NOT NULL,description char(110)
NOT NULL,PRIMARY KEY (code));
+#create table compound_class (fare_class char(3) NOT NULL,base_class char(2)
NOT NULL,class_type char(10) NOT NULL,premium char(3) NOT NULL,economy char(3)
NOT NULL,discounted char(3) NOT NULL,night char(3) NOT NULL,season_fare char(4)
NOT NULL,class_days char(7) NOT NULL,PRIMARY KEY (fare_class));
+#create table connect_leg (connect_code integer NOT NULL,leg_number decimal(1)
NOT NULL,flight_code integer NOT NULL,PRIMARY KEY (connect_code, leg_number,
flight_code));
+#create table fconnection (connect_code integer NOT NULL,from_airport char(3)
NOT NULL,to_airport char(3) NOT NULL,departure_time decimal(4) NOT
NULL,arrival_time decimal(4) NOT NULL,flight_days char(7) NOT NULL,stops
decimal(1) NOT NULL,connections decimal(1) NOT NULL,time_elapsed decimal(4) NOT
NULL,PRIMARY KEY (connect_code));
+#create table day_name (day_code decimal(1) NOT NULL,day_name char(9) NOT
NULL,PRIMARY KEY (day_code));
+#create table dual_carrier (main_airline char(2) NOT NULL,dual_airline char(2)
NOT NULL,low_flight decimal(4) NOT NULL,high_flight decimal(4) NOT
NULL,fconnection_name char(64) NOT NULL,PRIMARY KEY (main_airline,
dual_airline, low_flight));
+#create table fare (fare_code char(8) NOT NULL,from_airport char(3) NOT
NULL,to_airport char(3) NOT NULL,fare_class char(3) NOT NULL,fare_airline
char(2) NOT NULL,restrict_code char(5) NOT NULL,one_way_cost float(7,2) NOT
NULL,rnd_trip_cost float(8,2) NOT NULL,PRIMARY KEY (fare_code));
+#create table flight (flight_code integer NOT NULL,flight_days char(7) NOT
NULL,from_airport char(3) NOT NULL,to_airport char(3) NOT NULL,departure_time
decimal(4) NOT NULL,arrival_time decimal(4) NOT NULL,airline_code char(2) NOT
NULL,flight_number decimal(4) NOT NULL,class_string char(8) NOT
NULL,aircraft_code char(3) NOT NULL,meal_code char(7) NOT NULL,stops decimal(1)
NOT NULL,dual_carrier char(1) NOT NULL,time_elapsed decimal(4) NOT NULL,PRIMARY
KEY (flight_code));
+#create table flight_class (flight_code integer NOT NULL,fare_class char(3)
NOT NULL,PRIMARY KEY (flight_code, fare_class));
+#create table flight_day (day_mask char(7) NOT NULL,day_code decimal(1) NOT
NULL,day_name char(9) NOT NULL,PRIMARY KEY (day_mask, day_code));
+#create table flight_fare (flight_code integer NOT NULL,fare_code char(8) NOT
NULL,PRIMARY KEY (flight_code, fare_code));
+#create table food_service (meal_code char(4) NOT NULL,meal_number decimal(1)
NOT NULL,meal_class char(10) NOT NULL,meal_description char(10) NOT
NULL,PRIMARY KEY (meal_code, meal_number, meal_class));
+#create table ground_service (city_code char(4) NOT NULL,airport_code char(3)
NOT NULL,transport_code char(1) NOT NULL,ground_fare float(6,2) NOT
NULL,PRIMARY KEY (city_code, airport_code, transport_code));
+#create table time_interval (period char(20) NOT NULL,begin_time decimal(4)
NOT NULL,end_time decimal(4) NOT NULL,PRIMARY KEY (period, begin_time));
+#create table month_name (month_number decimal(2) NOT NULL,month_name char(9)
NOT NULL,PRIMARY KEY (month_number));
+#create table restrict_carrier (restrict_code char(5) NOT NULL,airline_code
char(2) NOT NULL,PRIMARY KEY (restrict_code, airline_code));
+#create table restrict_class (restrict_code char(5) NOT NULL,ex_fare_class
char(12) NOT NULL,PRIMARY KEY (restrict_code, ex_fare_class));
+#create table restriction (restrict_code char(5) NOT NULL,application char(80)
NOT NULL,no_discounts char(80) NOT NULL,reserve_ticket decimal(3) NOT
NULL,stopovers char(1) NOT NULL,return_min decimal(3) NOT NULL,return_max
decimal(3) NOT NULL,PRIMARY KEY (restrict_code));
+#create table state (state_code char(2) NOT NULL,state_name char(25) NOT
NULL,country_name char(25) NOT NULL,PRIMARY KEY (state_code));
+#create table stop1 (flight_code integer NOT NULL,stop_number decimal(1) NOT
NULL,stop_flight integer NOT NULL,PRIMARY KEY (flight_code, stop_number));
+#create table time_zone (time_zone_code char(3) NOT NULL,time_zone_name
char(32) NOT NULL,PRIMARY KEY (time_zone_code, time_zone_name));
+#create table transport (transport_code char(1) NOT NULL,transport_desc
char(32) NOT NULL,PRIMARY KEY (transport_code));
+#COPY 135 RECORDS INTO "sys"."aircraft" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"ATR" "AEROSPATIALE/AERITALIA (ALL SERIES)" 2 "TURBOPROP" "NO"
80.58 73.83 32446 49 10603 277 0 "YES"
+#"SSC" "AEROSPATIALE-BRITISH AEROSPACE (BAC) CONCORDE" 4 "JET" "NO"
83.83 203.75 400000 128 25000 1400 3800 "YES"
+#"CRV" "AEROSPATIALE CARAVELLE (ALL SERIES)" 2 "JET" "NO" 112.5
118.83 127870 140 29100 512 2150 "YES"
+#"ND2" "AEROSPATIALE N 262/FRAKES MOHAWK 298" 2 "TURBOPROP" "NO"
71.83 63.25 23370 27 5810 240 500 "YES"
+#"NDH" "AEROSPATIALE SA 365 DAUPHIN 2" 1 "HELICOPTER" "NO" 0
43.5 6615 14 0 196 423 "NO"
+[ 135 ]
+#COPY 314 RECORDS INTO "sys"."airline" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"AA" "AMERICAN AIRLINES" ""
+#"AC" "AIR CANADA" ""
+#"AD" "EXEC EXPRESS II,INC." ""
+#"AF" "AIR FRANCE" ""
+#"AG" "ATLANTIC AIRWAYS LIMITED" ""
+#"AM" "AEROMEXICO - AEROVIAS DE MEXICO S.A. DE C.V." ""
+#"AP" "ASPEN AIRWAYS,INC." ""
+#"AQ" "ALOHA AIRLINES INC." ""
+#"AR" "AEROLINEAS ARGENTINAS" ""
+#"AS" "ALASKA AIRLINES" ""
+#"AT" "ROYAL AIR MAROC" ""
+#"AV" "AVIANCA" ""
+#"AY" "FINNAIR" ""
+#"AZ" "ALITALIA" ""
+#"BA" "BRITISH AIRWAYS" ""
+#"BE" "ENTERPRISE AIRLINES,INC." ""
+[ 314 ]
+#COPY 9 RECORDS INTO "sys"."airport" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"ATL" "WILLIAM B. HARTSFIELD" "ATLANTA,GEORGIA" "GA" "USA" "EST"
+#"BOS" "LOGAN INTERNATIONAL" "BOSTON,MASSACHUSETTS" "MA" "USA" "EST"
+#"BWI" "BALTIMORE/WASHINGTON INTERNATIONAL" "BALTIMORE,MARYLAND" "MD"
"USA" "EST"
+#"DEN" "STAPLETON INTERNATIONAL" "DENVER,COLORADO" "CO" "USA"
"MST"
+#"DFW" "DALLAS/FORT WORTH INTERNATIONAL" "DALLAS/FT. WORTH,TEXAS"
"TX" "USA" "CST"
+#"OAK" "METROPOLITAN OAKLAND INTERNATIONAL" "OAKLAND,CALIFORNIA" "CA"
"USA" "PST"
+[ 9 ]
+#COPY 14 RECORDS INTO "sys"."airport_service" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"MATL" "ATL" 9 "S" 45
+#"BBOS" "BOS" 3 "NE" 30
+#"DDFW" "DFW" 13 "NW" 70
+#"FDFW" "DFW" 17 "E" 55
+#"DDEN" "DEN" 6.5 "NE" 30
+#"PPHL" "PHL" 7 "SW" 35
+#"PPIT" "PIT" 17 "W" 55
+#"OOAK" "OAK" 10 "SE" 15
+#"OOAK" "SFO" 24 "SW" 60
+#"SSFO" "SFO" 8 "SE" 30
+#"SSFO" "OAK" 18 "SE" 60
+#"WWAS" "BWI" 32 "NE" 50
+#"BBWI" "BWI" 10 "S" 25
+#"" "" 0 "" 0
+[ 14 ]
+#COPY 11 RECORDS INTO "sys"."city" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#"MATL" "ATLANTA" "GA" "USA" "EST"
+#"BBOS" "BOSTON" "MA" "USA" "EST"
+#"DDFW" "DALLAS" "TX" "USA" "CST"
+#"FDFW" "FORT WORTH" "TX" "USA" "CST"
+#"DDEN" "DENVER" "CO" "USA" "MST"
+#"PPHL" "PHILADELPHIA" "PA" "USA" "EST"
+#"PPIT" "PITTSBURGH" "PA" "USA" "EST"
+#"SSFO" "SAN FRANCISCO" "CA" "USA" "PST"
+#"OOAK" "OAKLAND" "CA" "USA" "PST"
+#"WWAS" "WASHINGTON" "DC" "USA" "EST"
+#"BBWI" "BALTIMORE" "MD" "USA" "EST"
+[ 11 ]
+#COPY 27 RECORDS INTO "sys"."class_of_service" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"R" 1 "SUPERSONIC AIRCRAFT"
+#"P" 2 "FIRST CLASS PREMIUM"
+#"F" 3 "FIRST CLASS"
+#"A" 4 "FIRST CLASS DISCOUNTED"
+#"J" 5 "BUSINESS CLASS PREMIUM"
+#"C" 6 "BUSINESS CLASS"
+#"D" 7 "BUSINESS CLASS DISCOUNTED"
+#"S" 8 "STANDARD CLASS"
+#"W" 9 "COACH ECONOMY CLASS PREMIUM"
+#"FN" 10 "FIRST CLASS NIGHT SERVICE"
+#"Y" 11 "COACH ECONOMY CLASS"
+#"CN" 12 "BUSINESS CLASS NIGHT SERVICE"
+#"YN" 13 "COACH ECONOMY CLASS NIGHT SERVICE"
+#"B" 14 "COACH ECONOMY CLASS DISCOUNTED"
+[ 27 ]
+#COPY 15 RECORDS INTO "sys"."code_description" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"-" "A DASH IN A DAY CODE POSITION INDICATES NON-OPERATION ON THAT DAY"
+#"AP" "ADVANCE PURCHASE EXCURSION FARE"
+#"CAD" "CANADIAN DOLLARS"
+#"EX" "EXCURSION FARE"
+#"H" "HIGHEST LEVEL OF FARE HAVING MORE THAN ONE SEASONAL LEVEL"
+#"J" "THIRD LEVEL OF FARE HAVING MORE THAN THREE SEASONAL LEVELS"
+#"K" "SECOND LEVEL OF A FARE HAVING MORE THAN TWO SEASONAL LEVELS"
+#"L" "LOWEST LEVEL OF FARE HAVING MORE THAN ONE SEASONAL LEVEL"
+#"MEP" "MEXICAN PESOS"
+[ 15 ]
+#COPY 149 RECORDS INTO "sys"."compound_class" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"A" "A" "FIRST" "NO" "NO" "YES" "NO" "NONE" "1234567"
+#"AH" "A" "FIRST" "NO" "NO" "YES" "NO" "HIGH" "1234567"
+#"AJ" "A" "FIRST" "NO" "NO" "YES" "NO" "MID" "1234567"
+#"AL" "A" "FIRST" "NO" "NO" "YES" "NO" "LOW" "1234567"
+#"B" "B" "COACH" "NO" "YES" "YES" "NO" "NONE" "1234567"
+#"BH" "B" "COACH" "NO" "YES" "YES" "NO" "HIGH" "1234567"
+#"BHW" "B" "COACH" "NO" "YES" "YES" "NO" "HIGH" "-----67"
+#"BHX" "B" "COACH" "NO" "YES" "YES" "NO" "HIGH" "12345--"
+[ 149 ]
+#COPY 351 RECORDS INTO "sys"."connect_leg" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#305276 1 106231
+#305276 2 137225
+#305277 1 106237
+#305277 2 137231
+#305280 1 106247
+#305280 2 137237
+#305416 1 112030
+#305416 1 112031
+#305416 2 112773
+#305424 1 112033
+#305424 2 112784
+#305429 1 112040
+#305429 2 112793
+#305429 2 112794
+#305435 1 112046
+#305435 2 112806
+#305436 1 112051
+#305436 2 112808
+#306026 1 133430
+#306026 2 111891
+#306031 1 133432
+#306031 2 111896
+#306304 1 144155
+#306304 2 112766
+#306307 1 144143
+#306307 2 111891
+#306309 1 144158
+[ 351 ]
+#COPY 164 RECORDS INTO "sys"."fconnection" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#312733 "ATL" "BOS" 740 1127 "1234567" 0 1
227
+#312734 "ATL" "BOS" 1200 1548 "1234567" 0 1
228
+#312737 "ATL" "BOS" 1650 2053 "1234567" 0 1
243
+#333051 "ATL" "DEN" 630 910 "1234567" 0 1
280
+#333054 "ATL" "DEN" 1000 1245 "1234567" 0 1
285
+#333059 "ATL" "DEN" 1319 1554 "1234567" 0 1
275
+#333067 "ATL" "DEN" 2029 2320 "1234567" 0 1
291
+#393490 "ATL" "OAK" 1000 1339 "1234567" 0 1
399
+#420730 "ATL" "SFO" 630 955 "1234567" 0 1
385
+#420735 "ATL" "SFO" 1000 1325 "1234567" 0 1
385
+[ 164 ]
+#COPY 7 RECORDS INTO "sys"."day_name" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#1 "MONDAY"
+#2 "TUESDAY"
+#3 "WEDNESDAY"
+#4 "THURSDAY"
+#5 "FRIDAY"
+#6 "SATURDAY"
+#7 "SUNDAY"
+[ 7 ]
+#COPY 114 RECORDS INTO "sys"."dual_carrier" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
+#"AA" "AA" 3000 5799 "AMERICAN EAGLE"
+#"AC" "RJ" 1001 1010 "AIR CANADA"
+#"AC" "CS" 1100 1199 "AIR CANADA"
+#"AC" "GX" 1200 1499 "AIR CANADA"
+#"AC" "ZX" 1500 1799 "AIR CANADA"
+#"AC" "QK" 1800 1899 "AIR CANADA"
+#"AC" "3J" 1900 1949 "AIR CANADA"
+#"AC" "3J" 1977 1981 "AIR CANADA"
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
