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

mserver5: rel_optimizer.c:5444: rel_push_project_up: Assertion `e' failed. #6077

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


Copy link

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

Date: 2016-10-13 13:35:44 +0200
From: Bo Tang <>
To: SQL devs <>
Version: 11.23.13 (Jun2016-SP2)
CC: @njnes, @drstmane

Last updated: 2016-12-21 13:08:02 +0100

Comment 24507

Date: 2016-10-13 13:35:44 +0200
From: Bo Tang <>

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

sqlsmith triggered the following assertion:

rel_optimizer.c:5444: rel_push_project_up: Assertion `e' failed.

Reproducible: Always

Steps to Reproduce:

  1. start mserver5 with database "tpch-1" (i.e., tpch dataset with scale factor 1)
  2. run the above query

Actual Results:

mserver5 aborted

Comment 24508

Date: 2016-10-13 13:38:05 +0200
From: Bo Tang <>

Created attachment 477
the query triggered "rel_optimizer.c:5444: rel_push_project_up: Assertion `e' failed."

Attached file: bug-3.sql (application/sql, 1844 bytes)
Description: the query triggered "rel_optimizer.c:5444: rel_push_project_up: Assertion `e' failed."

Comment 24523

Date: 2016-10-17 14:54:31 +0200
From: @drstmane

To reproduce the assertion, only the TPC-H schema is requires, no TPC-H data is required.

Comment 24545

Date: 2016-10-19 14:22:14 +0200
From: MonetDB Mercurial Repository <>

Changeset ce980adad65b made by Niels Nes in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=ce980adad65b

Changeset description:

fixed bugs 6078, 6077 and 6076
All related to naming a table producing function.

Comment 24548

Date: 2016-10-19 14:23:02 +0200
From: @njnes

fixed in Jun2016

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

Successfully merging a pull request may close this issue.

None yet
1 participant