Skip to content

NamedParameterUtils renders collection-parameters without reusing existing bind markers #310

@mp911de

Description

@mp911de

Consider the following query for Postgres:

SELECT * FROM person where name IN (:ids) or lastname IN (:ids)

The expanded form should render into (assuming three items in the bound parameter):

SELECT * FROM person where name IN ($0, $1, $2) or lastname IN ($0, $1, $2)

instead, it renders:

SELECT * FROM person where name IN ($0, $1, $2) or lastname IN ($3, $4, $5)

Original report: pgjdbc/r2dbc-postgresql#252

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions