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, 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 d0b65a3e8eb6, made by Stefan Manegold <Stefan.Manegold@cwi.nl> 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