Crash in query analysis

[monetdb-team]

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:

added test for bug #2831

Comment 16003

Date: 2011-07-29 10:52:42 +0200
From: @sjoerdmullender

The Apr2011-SP2 bugfix release is out.