Issue Details (XML | Word | Printable)

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

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: 01/Jun/15 05:55 PM
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

Issue Links:

QA Status: Done successfully

 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   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.