exp_bin: Assertion `0' failed

[monetdb-team]

Date: 2012-12-14 16:43:57 +0100
From: @yzchang
To: SQL devs <>
Version: 11.13.5 (Oct2012-SP1)
CC: @njnes

Last updated: 2013-01-22 09:29:10 +0100

Comment 18252

Date: 2012-12-14 16:43:57 +0100
From: @yzchang

The minimal query to trigger this assertion is:

create table t (id int, x int, y int);
select * from t as t1, t as t2 where power((t1.x - t2.x),2) < power((t1.y - t2.y),2);

The assertion is triggered by the WHERE condition. The problem seems to start in rel_bin.c:554, where 't1.x' is supposed to be found, but it isn't. All subsequent exp_bin returns NULL.

Comment 18254

Date: 2012-12-15 12:02:25 +0100
From: @yzchang

Changeset 93cabca63147 made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=93cabca63147

Changeset description:

Added test for Bug #3209

Comment 18255

Date: 2012-12-15 12:29:38 +0100
From: @njnes

Changeset 8650dce52dd8 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=8650dce52dd8

Changeset description:

fixed bug #3209, ie first crossproduct if the join expression consists
of functions (these should have been pushed down, whenever possible).

Comment 18256

Date: 2012-12-15 12:33:50 +0100
From: @njnes

fixed by first doing a crossproduct, when the join expression has functions

Comment 18257

Date: 2012-12-15 14:08:52 +0100
From: @njnes

Changeset 2f659fd4dff9 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=2f659fd4dff9

Changeset description:

fix for bug #3209

Comment 18260

Date: 2012-12-17 23:24:38 +0100
From: @njnes

Changeset 4bbf60a4e03a made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=4bbf60a4e03a

Changeset description:

missing part of fix for bug #3209 (no propagation need, is allready in Feb2013 and up)

Comment 18368

Date: 2013-01-22 09:29:10 +0100
From: @sjoerdmullender

Oct2012-SP3 has been released.