Changeset: b97bdefb749d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b97bdefb749d Modified Files: sql/backends/monet5/rel_bin.c Branch: delete_in_vlist Log Message:
Reduce the value list to unique values. diffs (16 lines): diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c --- a/sql/backends/monet5/rel_bin.c +++ b/sql/backends/monet5/rel_bin.c @@ -326,6 +326,12 @@ handle_in_exps(backend *be, sql_exp *ce, cmp = cmp_equal; s = value_list(be, nl, left); + stmt* groupby = stmt_group(be, s, NULL, NULL, NULL, 1); + + ext = stmt_result(be, groupby, 1); + + s = stmt_project(be, ext, s); + if (sel) { s = stmt_join_foo(be, c, s, sel, in, cmp); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list