Changeset: 4a86383c06f9 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4a86383c06f9 Modified Files: sql/server/rel_optimizer.c Branch: DVframework Log Message:
pmv: fixed bug. Ranges are correctly translated into compares while insertion into temp table. diffs (16 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --- a/sql/server/rel_optimizer.c +++ b/sql/server/rel_optimizer.c @@ -1520,10 +1520,10 @@ int find_out_pkey_space_for_unavailable_ sprintf(buf, "%s %s > %s AND %s < %s", s, sp->column->base.name, VAL2str(sp->values[0]), sp->column->base.name, VAL2str(sp->values[1])); break; case 13: - sprintf(buf, "%s %s > %s AND %s <= %s", s, sp->column->base.name, VAL2str(sp->values[0]), sp->column->base.name, VAL2str(sp->values[1])); + sprintf(buf, "%s %s >= %s AND %s < %s", s, sp->column->base.name, VAL2str(sp->values[0]), sp->column->base.name, VAL2str(sp->values[1])); break; case 14: - sprintf(buf, "%s %s >= %s AND %s < %s", s, sp->column->base.name, VAL2str(sp->values[0]), sp->column->base.name, VAL2str(sp->values[1])); + sprintf(buf, "%s %s > %s AND %s <= %s", s, sp->column->base.name, VAL2str(sp->values[0]), sp->column->base.name, VAL2str(sp->values[1])); break; case 15: sprintf(buf, "%s %s >= %s AND %s <= %s", s, sp->column->base.name, VAL2str(sp->values[0]), sp->column->base.name, VAL2str(sp->values[1])); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list