That's quick. I am using Jul2017 for testing sqlsmith

please roll forward and I'll hunt for the next one.

FYI on rocks006 /export/scratch1/home/mk/ssmonetdb you find the current output of ?160K queries (still running)

grep ERROR output|sort -u gives the list that triggers the one I found. There are a few more to be investigated (after grocery shopping), e.g.

ERROR = !Can not access column ERROR = !can not access index column ERROR = !Can not create object ERROR = !exist operator on type clob missing ERROR = !exist operator on type int missing ERROR = !exist operator on type varchar missing ERROR = !Illegal argument ERROR = !Object not found

On 13/05/2017 11:00, Niels Nes wrote:

Changeset: fea5dccda850 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fea5dccda850 Modified Files: sql/server/rel_select.c Branch: Dec2016 Log Message:

fix for bug 6310, ie properly use the left part of a lateral join, when the left part isn't used in the right part.

diffs (29 lines):

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 @@ -4902,7 +4902,7 @@ rel_query(mvc *sql, sql_rel *rel, symbol sql_rel *fnd = NULL;

for (n = fl->h; n ; n = n->next) {

• 	int lateral = check_is_lateral(n->data.sym);
  

• 	int lateral = check_is_lateral(n->data.sym), lateral_used = 0;
  
  fnd = table_ref(sql, NULL, n->data.sym, 0);
  if (!fnd && (rel || lateral) && sql->session->status != -ERR_AMBIGUOUS) {
  

@@ -4926,6 +4926,7 @@ rel_query(mvc *sql, sql_rel *rel, symbol fnd = table_ref(sql, res, n->data.sym, lateral); if (fnd && is_project(fnd->op)) fnd->exps = list_merge(fnd->exps, pre_exps, (fdup)NULL);

• 			lateral_used = 1;
  	} else {
  		fnd = table_ref(sql, rel, n->data.sym, 0);
  	}
  

@@ -4934,7 +4935,7 @@ rel_query(mvc *sql, sql_rel *rel, symbol

	if (!fnd)
		break;

• 	if (res && !lateral)
  

• 	if (res && !lateral_used)
  	res = rel_crossproduct(sql->sa, res, fnd, op_join);
  else
  	res = fnd;
  

---

checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list