Skip to content

Error when running parameterized any clause. #2386

@NathanGabrielson

Description

@NathanGabrielson

You get the following error when running a query using any with parameters. Something similar to ... where [column name] = any ( $1)....

query error: ERROR: expected right child to be a DoltgresType but got `*expression.BindVar` (errno 1105) (sqlstate HY000) (SQLSTATE XX000)

I don't believe there's a reliable way to run prepared statements in shells like psql, so a repro & instructions can be found here.

The specific typecast that is failing can be found here. In particular, it seems to me that we need some method of resolving the type of the parameter early on, or cleanly delaying that process.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions