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
Prepare fails when having a parameter in a DSQL statement before a sub query [CORE1156] #1577
Comments
Modified by: Tobias Grimm (tiber)description: The following query does not work (causing error 804 / 335544569): select count(*) from rdb$database where :param < (select count(*) from rdb$database) But this is working: select count(*) from rdb$database where (select count(*) from rdb$database) > :param => The following query does not work (causing error 804 / 335544569): select count(*) from rdb$database where :param < (select count(*) from rdb$database) But this is working: select count(*) from rdb$database where (select count(*) from rdb$database) > :param |
Modified by: Tobias Grimm (tiber)summary: Perpare fails when having a parameter in a DSQL statement before a sub query => Prepare fails when having a parameter in a DSQL statement before a sub query |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 [ 10041 ] |
Modified by: @pcisarVersion: 2.1.0 [ 10041 ] => |
Commented by: @pcisar Fix confirmed for 2.1 Alpha 1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11671 ] => Firebird [ 15355 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Tobias Grimm (tiber)
Is related to QA63
The following query does not work (causing error 804 / 335544569):
select count(*) from rdb$database where :param < (select count(*) from rdb$database)
But this is working:
select count(*) from rdb$database where (select count(*) from rdb$database) > :param
select count(*) from rdb$database where :param < cast ((select count(*) from rdb$database) as integer)
select count(*) from rdb$database where 0 < (select count(*) from rdb$database)
select count(*) from rdb$database where cast (:param as integer) < (select count(*) from rdb$database)
Commits: c9c59e5 6fef59a
The text was updated successfully, but these errors were encountered: