Skip to content

Positional parameters in prepared statement does not adjust positional orders in "FROM first" syntax #13585

@ajzo90

Description

@ajzo90

What happens?

Expecting positional parameters to work with "FROM first" syntax.

To Reproduce

prepare fromFirst as from (select ? fromV) select ? selectV,*;
execute fromFirst('from', 'sel');
┌─────────┬─────────┐
│ selectV │  fromV  │
│ varchar │ varchar │
├─────────┼─────────┤
│ from    │ sel     │
└─────────┴─────────┘

OS:

osx arm64

DuckDB Version:

v1.0.1-dev3969

DuckDB Client:

CLI

Full Name:

Christian Persson

Affiliation:

Sift Lab

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a nightly build

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

  • Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

  • Yes, I have

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions