Prepared queries do not pass parameters correctly

Open
#2,192 2 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 11 days

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
48/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
rust, sqlite
Domain
databases

Research direction

Start by running the Rust reproducer against an in-memory database and verify the bound values for both prepared INSERT executions. Trace the prepared-query parameter binding and compare the first and second calls. Done means the second insert stores id 2 and name Jane Doe without a uniqueness error.

Written by the indexing model from the issue text.

Description

A reproducing example:

use libsql::Builder;

#[tokio::main]
async fn main() {
    let database = Builder::new_local(":memory:").build().await.unwrap();
    let connection = database.connect().unwrap();
    connection
        .execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)", ())
        .await
        .unwrap();
    let insert_user = connection
        .prepare("INSERT INTO users (id, name) VALUES (?,?)")
        .await
        .unwrap();

    insert_user.execute((1, "John Doe")).await.unwrap();
    insert_user.execute((2, "Jane Doe")).await.unwrap(); // Error: UNIQUE constraint failed: users.id
}

If removing the unique constraint, and querying the table, one can also see, that the second insert statement indeed inserts using a 1 for the id.

Dominant language
C
Stars
17.3k
Forks
562
Avg merge
10d 15h
Merged PRs (30d)
1

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from tursodatabase/libsql

All issues in tursodatabase/libsql

Similar issues

More C issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.