Drizzle Team•6mo ago

Push error: This statement does not return data. Use run() instead

I just updated drizzle-kit to versions 0.23.0 and when I try to execute drizzle-kit push I get the following error:

TypeError: This statement does not return data. Use run() instead
    at Object.query (.../node_modules/drizzle-kit/bin.cjs:121780:54)
    at sqlitePush (.../node_modules/drizzle-kit/bin.cjs:124445:23)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async _Command.<anonymous> (.../node_modules/drizzle-kit/bin.cjs:131629:7)

TypeError: This statement does not return data. Use run() instead
    at Object.query (.../node_modules/drizzle-kit/bin.cjs:121780:54)
    at sqlitePush (.../node_modules/drizzle-kit/bin.cjs:124445:23)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async _Command.<anonymous> (.../node_modules/drizzle-kit/bin.cjs:131629:7)

When using 0.22.0 it works without errors. Am I doing something wrong? For the db I use sqlite with better-sqlite-3. Here's the config:

import { env } from "@/env";
import { type Config } from "drizzle-kit";

export default {
  schema: "./src/db/schema.ts",
  dialect: "sqlite",
  dbCredentials: {
    url: env.server.SQLITE_FILE,
  },
  verbose: true,
  strict: true,
} satisfies Config;

import { env } from "@/env";
import { type Config } from "drizzle-kit";

export default {
  schema: "./src/db/schema.ts",
  dialect: "sqlite",
  dbCredentials: {
    url: env.server.SQLITE_FILE,
  },
  verbose: true,
  strict: true,
} satisfies Config;

7 Replies

josh•6mo ago

Experiencing the same, I've created an issue: https://github.com/drizzle-team/drizzle-kit-mirror/issues/500

GitHub

[SQLite] Cannot push schema changes with drizzle-kit 0.23.0 · Iss...

I get the following error when trying to push schema changes (drizzle-kit push) TypeError: This statement does not return data. Use run() instead at Object.query (/**/node_modules/.pnpm/drizzle-k...