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: 2011-07-04 23:41:25 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2011-07-29 10:52:42 +0200
Comment 15888
Date: 2011-07-04 23:41:25 +0200
From: @mlkersten
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0) Gecko/20100101 Firefox/5.0
Build Identifier:
Crash during query analysis. Assertion fires.
Reproducible: Always
Steps to Reproduce:
create schema lrbm;
CREATE TABLE lrbm.accident(carid1 integer, carid2 integer, firstMinute integer, lastMinute integer, dir integer, seg integer, pos integer);
CREATE TABLE lrbm.statistics(dir int,seg int,time_minute int,numvehicles int,lav float,toll int,accident int,accidentSeg int);
UPDATE lrbm.statistics
SET toll = 0, accident = 1
WHERE EXISTS(
SELECT acc.seg
FROM lrbm.accident AS acc
WHERE acc.dir = statistics.dir AND
acc.firstMinute + 1 <= statistics.time_minute AND
acc.lastMinute + 1 >= statistics.time_minute AND
(
(
(acc.dir = 0) AND
(acc.seg >= statistics.seg) AND
(acc.seg <= statistics.seg + 4)
)
OR
(
(acc.dir <> 0) AND
(acc.seg <= statistics.seg) AND
(acc.seg >= statistics.seg - 4)
)
)
);
Actual Results:
assertion error in
3 0x00007fffe86157bd in rel_join_add_exp (sa=0x134db48, rel=0x1353dc8, e=0x1353f58) at /ufs/mk/current//package/sql/server/rel_select.c:559
Date: 2011-07-04 23:41:25 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2011-07-29 10:52:42 +0200
Comment 15888
Date: 2011-07-04 23:41:25 +0200
From: @mlkersten
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0) Gecko/20100101 Firefox/5.0
Build Identifier:
Crash during query analysis. Assertion fires.
Reproducible: Always
Steps to Reproduce:
create schema lrbm;
CREATE TABLE lrbm.accident(carid1 integer, carid2 integer, firstMinute integer, lastMinute integer, dir integer, seg integer, pos integer);
CREATE TABLE lrbm.statistics(dir int,seg int,time_minute int,numvehicles int,lav float,toll int,accident int,accidentSeg int);
UPDATE lrbm.statistics
SET toll = 0, accident = 1
WHERE EXISTS(
SELECT acc.seg
FROM lrbm.accident AS acc
WHERE acc.dir = statistics.dir AND
acc.firstMinute + 1 <= statistics.time_minute AND
acc.lastMinute + 1 >= statistics.time_minute AND
(
(
(acc.dir = 0) AND
(acc.seg >= statistics.seg) AND
(acc.seg <= statistics.seg + 4)
)
OR
(
(acc.dir <> 0) AND
(acc.seg <= statistics.seg) AND
(acc.seg >= statistics.seg - 4)
)
)
);
Actual Results:
assertion error in
3 0x00007fffe86157bd in rel_join_add_exp (sa=0x134db48, rel=0x1353dc8, e=0x1353f58) at /ufs/mk/current//package/sql/server/rel_select.c:559
Comment 15900
Date: 2011-07-06 10:10:00 +0200
From: @njnes
improved assert (fixes crash)
Comment 15953
Date: 2011-07-17 14:52:13 +0200
From: @drstmane
Changeset 46246a2dc026 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=46246a2dc026
Changeset description:
Comment 16003
Date: 2011-07-29 10:52:42 +0200
From: @sjoerdmullender
The Apr2011-SP2 bugfix release is out.
The text was updated successfully, but these errors were encountered: