Date: 2018-06-14 01:46:38 +0200
From: @skinkie
To: SQL devs <>
Version: 11.29.7 (Mar2018-SP1)
CC: @njnes

Last updated: 2019-11-28 10:00:05 +0100

Comment 26484

Date: 2018-06-14 01:46:38 +0200
From: @skinkie

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.39 Safari/537.36
Build Identifier:

From MonetDB-users.

with Mar2018 & Mar2018-SP1 and this script:

drop table if exists segments;
create table segments (meter int, distance int, speed int);
insert into segments values (1,1,1),(9,9,9);
select * from segments;

I get:
SELECT t.meter, s.distance, s.speed FROM segments AS s, LATERAL generate_series(s.meter, s.meter+s.distance+1) AS t(meter);
->
SELECT: no such column 't.meter'

SELECT * FROM segments AS s, LATERAL generate_series(s.meter, s.meter+s.distance+1) ;
->
mserver5: /ufs/manegold/_/Monet/preview/source/MonetDB/sql/backends/monet5/rel_bin.c:1473: rel2bin_table: Assertion `0' failed.
Aborted (core dumped)

SELECT t.* , s.distance, s.speed FROM segments AS s, LATERAL generate_series(s.meter, s.meter+s.distance+1) AS t(meter);
->
mserver5: /ufs/manegold/_/Monet/preview/source/MonetDB/sql/backends/monet5/rel_bin.c:1473: rel2bin_table: Assertion `0' failed.
Aborted (core dumped)

Reproducible: Always

Comment 26708

Date: 2018-12-03 12:22:23 +0100
From: MonetDB Mercurial Repository <>

Changeset 19359e42134b made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=19359e42134b

Changeset description:

Added test for bug #6613.

Comment 26984

Date: 2019-05-01 13:01:24 +0200
From: @njnes

fixed in default, where the subquery implementation is renewed