Named parameter values are passed in wrong order on query execution

Description

For example, the following query:

causes the following error on execution:

This happens because actual parameter values are passed in wrong order, not following parameter's positions (?1, ?2...), leading to type mismatch.

This bug may occur not only when IN predicate is used, but in any query with multiple named parameters. As a result, it may cause type conversion exception, or wrong return result – if all values match types, but are misordered.

Environment

None

Assignee

Unassigned

Reporter

Aliaksandr Salauyou

Labels

None

Feedback Requested

None

Feedback Requested By

None

backPortable

None

Suitable for new contributors

None

Pull Request

None

backportDecision

None

backportReEvaluate

None

Components

Priority

Minor
Configure