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
EVL_expr: invalid operation (232) [CORE2872] #3256
Comments
Modified by: Smirnoff Serg (wildsery)description: Execution of the following select cause the exception select 1 from rdb$database Statement failed, SQLCODE = -902 => Execution of the following select cause the exception select 1 from rdb$database Not using 'ALL' or 'IN' operators in this query cause the proper pasring error: |
Commented by: @asfernandes Duplicates CORE2829. |
Modified by: @asfernandes |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Done successfully Test Details: NB: fixed on 3.0 and above, 2.5.x still produces bugcheck. |
Submitted by: Smirnoff Serg (wildsery)
Duplicates CORE2829
Execution of the following select cause the exception
select 1 from rdb$database
where count(*) >= all (select count(*) from rdb$database)
---
Statement failed, SQLCODE = -902
internal gds software consistency check (EVL_expr: invalid operation (232), file: evl.cpp line: 1164)
Not using 'ALL' or 'IN' operators in this query cause the proper pasring error:
select 1 from rdb$database
where count(*) = (select count(*) from rdb$database)
---
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Cannot use an aggregate function in a WHERE clause, use HAVING instead.
====== Test Details ======
NB: fixed on 3.0 and above, 2.5.x still produces bugcheck.
The text was updated successfully, but these errors were encountered: