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

EVL_expr: invalid operation (232) [CORE2872] #3256

Closed
firebird-automations opened this issue Feb 17, 2010 · 7 comments
Closed

EVL_expr: invalid operation (232) [CORE2872] #3256

firebird-automations opened this issue Feb 17, 2010 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: Smirnoff Serg (wildsery)

description: 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)

=>

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Duplicates CORE2829.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue duplicates CORE2829 [ CORE2829 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: 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.

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

1 participant