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
Date: 2012-05-29 10:46:01 +0200
From: Inho Kim <<georgios.kim>>
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2012-06-19 11:20:37 +0200
Comment 17295
Date: 2012-05-29 10:46:01 +0200
From: Inho Kim <<georgios.kim>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5
Build Identifier: MonetDB v11.9.5
mserver5 crashed if join condition has two column and incorrect order..
select * from test1 a, test2 b where a.id = b.id and a.seq = b.seq; => OK
select * from test1 a, test2 b where a.id = b.id and b.seq = a.seq; => crash
Reproducible: Always
Steps to Reproduce:
1.create table test1 ( id int, seq int, name varchar(20));
2.create table test2 ( id int, seq int, name varchar(20));
3.select * from test1 a, test2 b where a.id = b.id and b.seq = a.seq;
I'm unable to reproduce this crash with Apr2012/Jul2012 or tip
Comment 17301
Date: 2012-05-30 04:24:11 +0200
From: Inho Kim <<georgios.kim>>
sorry for wrong example..
Please check out following example..
create table test1 ( id int, seq int, name varchar(20), primary key (id, seq));
create table test2 ( id int not null, seq int not null, name varchar(20));
select * from test1 a, test2 b where a.id = b.id and b.seq = a.seq;
Date: 2012-05-29 10:46:01 +0200
From: Inho Kim <<georgios.kim>>
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2012-06-19 11:20:37 +0200
Comment 17295
Date: 2012-05-29 10:46:01 +0200
From: Inho Kim <<georgios.kim>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5
Build Identifier: MonetDB v11.9.5
mserver5 crashed if join condition has two column and incorrect order..
select * from test1 a, test2 b where a.id = b.id and a.seq = b.seq; => OK
select * from test1 a, test2 b where a.id = b.id and b.seq = a.seq; => crash
Reproducible: Always
Steps to Reproduce:
1.create table test1 ( id int, seq int, name varchar(20));
2.create table test2 ( id int, seq int, name varchar(20));
3.select * from test1 a, test2 b where a.id = b.id and b.seq = a.seq;
Actual Results:
mserver5 crashed..
Comment 17299
Date: 2012-05-29 17:43:56 +0200
From: @njnes
I'm unable to reproduce this crash with Apr2012/Jul2012 or tip
Comment 17301
Date: 2012-05-30 04:24:11 +0200
From: Inho Kim <<georgios.kim>>
sorry for wrong example..
Please check out following example..
create table test1 ( id int, seq int, name varchar(20), primary key (id, seq));
create table test2 ( id int not null, seq int not null, name varchar(20));
select * from test1 a, test2 b where a.id = b.id and b.seq = a.seq;
Comment 17302
Date: 2012-05-30 09:25:22 +0200
From: @njnes
Changeset 0f98dc926be5 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=0f98dc926be5
Changeset description:
Comment 17303
Date: 2012-05-30 09:28:29 +0200
From: @njnes
indeed this example crashes (asserts). Fixed, in case the hash join fails fall back to normal join.
The text was updated successfully, but these errors were encountered: