transaction not working for better-sqlite3

await db.transaction(async (tx) => {
    await tx.update(users).set({ name: "test" }).where(eq(users.id, 1));
    await tx.rollback()
  });

await db.transaction(async (tx) => {
    await tx.update(users).set({ name: "test" }).where(eq(users.id, 1));
    await tx.rollback()
  });