Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

LATERAL crash /.../rel_bin.c:1473: rel2bin_table: Assertion `0' failed. #6613

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant