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

BUG when there is more than one field/filter in the having clause #7278

Closed
djxandytche opened this issue Mar 29, 2022 · 0 comments
Closed

BUG when there is more than one field/filter in the having clause #7278

djxandytche opened this issue Mar 29, 2022 · 0 comments
Labels
bug
Milestone

Comments

@djxandytche
Copy link

@djxandytche djxandytche commented Mar 29, 2022

Describe the bug
There is a BUG when there is more than one field/filter in the having clause.

To Reproduce
To reproduce the problem, simply execute an SQL similar to the one shown in the example below:
select
tablefield1
from
tabletest1
group by
tablefield1
having
count(tablefield2) > 1
and count(tablefield) > 1 -- The error occurs in this second filter. If you remove this second filter, then it works correctly.

Expected behavior
Execute the query correctly.

Screenshots
This is the error that occurs:
image
And if I remove the second filter, then it works correctly:
image

Software versions
MonetDB version number: 11.43.9
OS and version: Windows 10
Installed from release package or self-installed and compiled: release package

@PedroTadim PedroTadim added the bug label Mar 30, 2022
@PedroTadim PedroTadim added this to the NEXTRELEASE milestone Mar 30, 2022
monetdb-team pushed a commit that referenced this issue Mar 30, 2022
…gate, look for possible select relations generated by having clauses
@sjoerdmullender sjoerdmullender removed this from the NEXTRELEASE milestone Apr 8, 2022
@sjoerdmullender sjoerdmullender added this to the Jan2022-SP2 milestone Apr 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug
Projects
None yet
Development

No branches or pull requests

3 participants