Issue Details (XML | Word | Printable)

Key: CORE-3311
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Zotov
Votes: 0
Watchers: 0
Operations

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

Error "data type unknown" while preparing UPDATE/DELETE statements with the parameterized ROWS clause

Created: 20/Jan/11 04:34 AM   Updated: 24/Feb/11 11:24 AM
Component/s: Engine
Affects Version/s: 2.1.0, 2.1.1, 2.1.2, 2.1.3, 3.0 Initial, 2.5.0
Fix Version/s: 2.5.1, 3.0 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
DSQL parameters in the ROWS clause of UPDATE/DELETE statements are not accepted. The same in SELECT statements works fine.

Test case:

create table test (id int);

delete from test rows (:param);
-- or
delete from test rows (?)

Statement failed, SQLSTATE = HY004
Dynamic SQL Error
-SQL error code = -804
-Data type unknown


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.