Issue Details (XML | Word | Printable)

Key: CORE-1156
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Tobias Grimm
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Prepare fails when having a parameter in a DSQL statement before a sub query

Created: 06/Mar/07 07:18 AM   Updated: 11/Jul/07 09:43 PM
Component/s: API / Client Library, Engine
Affects Version/s: 2.0.0, 2.0.1
Fix Version/s: 2.1 Alpha 1, 2.0.2

Time Tracking:
Not Specified

Environment: WinXP, .NETProvider, FBEmbedded
Issue Links:
Relate
 


 Description  « Hide
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)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 21/Apr/07 12:58 PM
Fix confirmed for 2.1 Alpha 1. Test added.

Pavel Cisar added a comment - 26/Apr/07 11:42 AM
Reopened to update ticket information.