Follow-up: Bug #3259 should NOT be re-opened, as the test query I had provided for it actually succeeds. I have opened bug #3411 which is very related but not quite the same. Still, am I correct that the changeset mentioned, d0b65a3e8eb6http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d0b65a3e8eb6, approves a MAL plan that replaces the join (good) with crossproducts + selects (bad)? Roberto On Thu, Dec 12, 2013 at 3:45 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

Hello,

I cannot re-open bug 3259, but I believe t should be.

After the bug had been fixed by Niels, it seems to have been re-introduced. The changeset below (after the fix) approves a MAL plan that in fact is the wrong one the original report refers to: the join has again been replaced by a CROSS-PRODUCT followed by inequality selections.

Changeset d0b65a3e8eb6http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d0b65a3e8eb6, made by Stefan Manegold in the MonetDB repo, refers to this bug.

For complete details, see http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d0b65a3e8eb6

Changeset description:

between.Bug-3259: approved new MAL plan after changeset 79e66f677113 http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=79e66f677113