Changeset: fd8e396457b2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fd8e396457b2
Modified Files:
sql/server/rel_select.c
testing/Mtest.py.in
Branch: default
Log Message:
Merge with Aug2024 branch.
diffs (truncated from 4769 to 300 lines):
diff --git a/sql/backends/monet5/vaults/csv/csv.c
b/sql/backends/monet5/vaults/csv/csv.c
--- a/sql/backends/monet5/vaults/csv/csv.c
+++ b/sql/backends/monet5/vaults/csv/csv.c
@@ -452,12 +452,12 @@ csv_relation(mvc *sql, sql_subfunc *f, c
list_append(res_exps, ne);
} else {
GDKfree(types);
- throw(SQL, SQLSTATE(42000), "csv" "type %s not
found\n", st);
+ return sa_message(sql->sa, "csv" "type %s not
found\n", st);
}
} else {
/* shouldn't be possible, we fallback to strings */
GDKfree(types);
- throw(SQL, SQLSTATE(42000), "csv" "type unknown\n");
+ return sa_message(sql->sa, "csv" "type unknown\n");
}
}
GDKfree(types);
@@ -472,7 +472,7 @@ csv_relation(mvc *sql, sql_subfunc *f, c
r->extra_tsep = extra_tsep;
r->has_header = has_header;
f->sname = (char*)r; /* pass schema++ */
- return MAL_SUCCEED;
+ return NULL;
}
static void *
@@ -484,7 +484,6 @@ csv_load(void *BE, sql_subfunc *f, char
sql_table *t = NULL;
if (mvc_create_table( &t, be->mvc, be->mvc->session->tr->tmp/* misuse
tmp schema */, f->tname /*gettable name*/, tt_table, false, SQL_DECLARED_TABLE,
0, 0, false) != LOG_OK)
- //throw(SQL, SQLSTATE(42000), "csv" RUNTIME_FILE_NOT_FOUND);
/* alloc error */
return NULL;
@@ -495,7 +494,6 @@ csv_load(void *BE, sql_subfunc *f, char
sql_column *c = NULL;
if (!tp || mvc_create_column(&c, be->mvc, t, name, tp) !=
LOG_OK) {
- //throw(SQL, SQLSTATE(42000), "csv" RUNTIME_LOAD_ERROR);
return NULL;
}
}
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -1702,14 +1702,12 @@ push_join_exp(mvc *sql, sql_rel *rel, sq
static sql_rel *
rel_select_push_filter_exp_down(mvc *sql, sql_rel *rel, sql_exp *e, list *l,
list *r, int ff)
{
- sql_exp *ll, *rr;
+ sql_exp *ll;
if (exps_card(r) <= CARD_ATOM && (exps_are_atoms(r) ||
exps_have_freevar(sql, r) || exps_have_freevar(sql, l))) {
if (exps_card(l) == exps_card(r) || rel->processed) /* bin
compare op */
return rel_select(sql->sa, rel, e);
if ((ll = exps_find_one_multi_exp(l)))
return push_select_exp(sql, rel, e, ll, ff);
- } else if ((ll = exps_find_one_multi_exp(l)) && (rr =
exps_find_one_multi_exp(r))) { /* join */
- return push_join_exp(sql, rel, e, ll, rr, NULL, ff);
}
if (is_outerjoin(rel->op))
return rel_select(sql->sa, rel, e);
diff --git a/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
b/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
--- a/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
+++ b/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
@@ -1,33 +1,3 @@
-stdout of test 'mclient-lsql-D` in directory 'sql/test/BugTracker-2009` itself:
-
-
-# 21:51:00 >
-# 21:51:00 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=38418 --set
xrpc_port=47399 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
-# 21:51:00 >
-
-# MonetDB server v5.12.0, based on kernel v1.30.0
-# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
-# Visit http://monetdb.cwi.nl/ for further information
-# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:38418/
-# MonetDB/SQL module v2.30.1 loaded
-
-#function user.main():void;
-# clients.quit();
-#end main;
-
-
-# 21:51:00 >
-# 21:51:00 > ./mclient-lsql-D.SQL.sh mclient-lsql-D
-# 21:51:00 >
-
-
-# 21:51:00 >
-# 21:51:00 > Mtimeout -timeout 60 mclient -lsql -umonetdb -Pmonetdb
--host=alf --port=38418 -D < /dev/null
-# 21:51:00 >
-
START TRANSACTION;
SET SCHEMA "sys";
CREATE TABLE "sys"."table_a" (
@@ -58,8 +28,3 @@ ALTER TABLE "sys"."table_c" ADD CONSTRAI
ALTER TABLE "sys"."table_c" ADD CONSTRAINT "fk_table_c_table_d_id" FOREIGN KEY
("table_d_id") REFERENCES "sys"."table_b" ("table_b_id");
ALTER TABLE "sys"."table_d" ADD CONSTRAINT "fk_table_d_table_a_id" FOREIGN KEY
("table_a_id") REFERENCES "sys"."table_a" ("table_a_id");
COMMIT;
-
-# 21:51:00 >
-# 21:51:00 > Done.
-# 21:51:00 >
-
diff --git
a/sql/test/BugTracker-2019/Tests/msqldump-mapi-cache.Bug-6777.stable.out
b/sql/test/BugTracker-2019/Tests/msqldump-mapi-cache.Bug-6777.stable.out
--- a/sql/test/BugTracker-2019/Tests/msqldump-mapi-cache.Bug-6777.stable.out
+++ b/sql/test/BugTracker-2019/Tests/msqldump-mapi-cache.Bug-6777.stable.out
@@ -1,523 +1,3 @@
-stdout of test 'msqldump-mapi-cache.Bug-6777` in directory
'sql/test/BugTracker-2019` itself:
-
-
-# 10:39:12 >
-# 10:39:12 > "/usr/bin/python3" "msqldump-mapi-cache.Bug-6777.py"
"msqldump-mapi-cache.Bug-6777"
-# 10:39:12 >
-
-#start transaction;
-#create table dbgen_version
-#(
-# dv_version varchar(16),
-# dv_create_date date,
-# dv_create_time time,
-# dv_cmdline_args varchar(200)
-#);
-#create table customer_address
-#(
-# ca_address_sk integer not null,
-# ca_address_id char(16) not null,
-# ca_street_number char(10),
-# ca_street_name varchar(60),
-# ca_street_type char(15),
-# ca_suite_number char(10),
-# ca_city varchar(60),
-# ca_county varchar(30),
-# ca_state char(2),
-# ca_zip char(10),
-# ca_country varchar(20),
-# ca_gmt_offset decimal(5,2),
-# ca_location_type char(20),
-# primary key (ca_address_sk)
-#);
-#create table customer_demographics
-#(
-# cd_demo_sk integer not null,
-# cd_gender char(1),
-# cd_marital_status char(1),
-# cd_education_status char(20),
-# cd_purchase_estimate integer,
-# cd_credit_rating char(10),
-# cd_dep_count integer,
-# cd_dep_employed_count integer,
-# cd_dep_college_count integer,
-# primary key (cd_demo_sk)
-#);
-#create table date_dim
-#(
-# d_date_sk integer not null,
-# d_date_id char(16) not null,
-# d_date date,
-# d_month_seq integer,
-# d_week_seq integer,
-# d_quarter_seq integer,
-# d_year integer,
-# d_dow integer,
-# d_moy integer,
-# d_dom integer,
-# d_qoy integer,
-# d_fy_year integer,
-# d_fy_quarter_seq integer,
-# d_fy_week_seq integer,
-# d_day_name char(9),
-# d_quarter_name char(6),
-# d_holiday char(1),
-# d_weekend char(1),
-# d_following_holiday char(1),
-# d_first_dom integer,
-# d_last_dom integer,
-# d_same_day_ly integer,
-# d_same_day_lq integer,
-#create table warehouse
-#(
-# w_warehouse_sk integer not null,
-# w_warehouse_id char(16) not null,
-# w_warehouse_name varchar(20),
-# w_warehouse_sq_ft integer,
-# w_street_number char(10),
-# w_street_name varchar(60),
-# w_street_type char(15),
-# w_suite_number char(10),
-# w_city varchar(60),
-# w_county varchar(30),
-# w_state char(2),
-# w_zip char(10),
-# w_country varchar(20),
-# w_gmt_offset decimal(5,2),
-# primary key (w_warehouse_sk)
-#);
-#create table ship_mode
-#(
-# sm_ship_mode_sk integer not null,
-# sm_ship_mode_id char(16) not null,
-# sm_type char(30),
-# sm_code char(10),
-# sm_carrier char(20),
-# sm_contract char(20),
-# primary key (sm_ship_mode_sk)
-#);
-#create table time_dim
-#(
-# t_time_sk integer not null,
-# t_time_id char(16) not null,
-# t_time integer,
-# t_hour integer,
-# t_minute integer,
-# t_second integer,
-# t_am_pm char(2),
-# t_shift char(20),
-# t_sub_shift char(20),
-# t_meal_time char(20),
-# primary key (t_time_sk)
-#);
-#create table reason
-#(
-# r_reason_sk integer not null,
-# r_reason_id char(16) not null,
-# r_reason_desc char(100),
-# primary key (r_reason_sk)
-#);
-#create table income_band
-#(
-# ib_income_band_sk integer not null,
-# ib_lower_bound integer,
-# ib_upper_bound integer,
-# primary key (ib_income_band_sk)
-#);
-#create table item
-#(
-# i_item_sk integer not null,
-# i_item_id char(16) not null,
-# i_rec_start_date date,
-# i_rec_end_date date,
-# i_item_desc varchar(200),
-# i_current_price decimal(7,2),
-# i_wholesale_cost decimal(7,2),
-# i_brand_id integer,
-# i_brand char(50),
-# i_class_id integer,
-# i_class char(50),
-# i_category_id integer,
-# i_category char(50),
-# i_manufact_id integer,
-# i_manufact char(50),
-# i_size char(20),
-# i_formulation char(20),
-# i_color char(20),
-# i_units char(10),
-# i_container char(10),
-# i_manager_id integer,
-#create table store
-#(
-# s_store_sk integer not null,
-# s_store_id char(16) not null,
-# s_rec_start_date date,
-# s_rec_end_date date,
-# s_closed_date_sk integer,
-# s_store_name varchar(50),
-# s_number_employees integer,
-# s_floor_space integer,
-# s_hours char(20),
-# s_manager varchar(40),
-# s_market_id integer,
-# s_geography_class varchar(100),
-# s_market_desc varchar(100),
-# s_market_manager varchar(40),
-# s_division_id integer,
-# s_division_name varchar(50),
-# s_company_id integer,
-# s_company_name varchar(50),
-# s_street_number varchar(10),
-#create table call_center
-#(
-# cc_call_center_sk integer not null,
-# cc_call_center_id char(16) not null,
-# cc_rec_start_date date,
-# cc_rec_end_date date,
-# cc_closed_date_sk integer,
-# cc_open_date_sk integer,
-# cc_name varchar(50),
-# cc_class varchar(50),
-# cc_employees integer,
-# cc_sq_ft integer,
-# cc_hours char(20),
-# cc_manager varchar(40),
-# cc_mkt_id integer,
-# cc_mkt_class char(50),
-# cc_mkt_desc varchar(100),
-# cc_market_manager varchar(40),
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
