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

AV when preparing a query with IN list that contains both literals and sub-query #8087

Closed
hvlad opened this issue Apr 17, 2024 · 2 comments
Closed

Comments

@hvlad
Copy link
Member

hvlad commented Apr 17, 2024

Test case:

SELECT *
  FROM RDB$RELATIONS R
 WHERE R.RDB$RELATION_ID IN (1, (SELECT D.RDB$RELATION_ID FROM RDB$DATABASE D))
@hmoffatt
Copy link

I have this query crashing Firebird 5.0.0 when running embedded (I haven't tried with a server yet), on both Windows x86 and x64 and Linux x64.

select X.*
from A_INTREC X
where X.LEVEL_DEF_NUM in (14088,14089,11826,11920,12012,12097,12174,12246,12310,12365,12407,12440,12460,12476,12490,12501,12511,12518,12523) 
order by 1

This has gone away with the latest 5.0.1 snapshot, but I can't find an exact issue filed here that matches my case. Do you think it is this bug?

@hmoffatt
Copy link

This has gone away with the latest 5.0.1 snapshot, but I can't find an exact issue filed here that matches my case. Do you think it is this bug?

No, my issue was #8026

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

No branches or pull requests

3 participants