You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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:
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:
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:
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:
Comment 18368
Date: 2013-01-22 09:29:10 +0100
From: @sjoerdmullender
Oct2012-SP3 has been released.
The text was updated successfully, but these errors were encountered: