drizzle-team / drizzle-team/drizzle-orm

[BUG]: INSERT & UPDATE queries not working in Custom SQL migration file

Open
#4,747 1 comment 3 reactions 0 assignees View on GitHub
bug
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.31.2

### What version of `drizzle-kit` are you using?

0.22.8

### Other packages

_No response_

### Describe the Bug

Config used:
```
{
schema: "./src/db/schema/*",
out: "./database",
dialect: 'postgresql',
driver: 'aws-data-api',
dbCredentials: {
database: process.env.DB_DATABASE!,
secretArn: process.env.DB_SECRET_ARN!,
resourceArn: process.env.DB_RESOURCE_ARN!
},
schemaFilter: [process.env.DB_TABLE_SCHEMA || 'public'],
migrations: {
table: '__drizzle_migrations', // `__drizzle_migrations` by default
schema: process.env.DB_TABLE_SCHEMA === 'public' ? 'drizzle' : process.env.DB_TABLE_SCHEMA, // used in PostgreSQL only, `drizzle` by default
}
}
```

Hi,

we usually get the following error when running drizzle-kit push, but it executes the queries nonetheless without issues except we now encountered a problem where it won't run INSERT & UPDATE queries. Other queries like ALTER still work.

```
DatabaseErrorException: ERROR: cannot drop schema test because other objects depend on it; Hint: Use DROP ... CASCADE to drop the dependent objects too.; SQLState: 2BP01
at de_DatabaseErrorExceptionRes (/Users/test/WebstormProjects/serverless-backend/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:911:21)
at de_CommandError (/Users/test/WebstormProjects/serverless-backend/node_modules/@aws-sdk/client-rds-data/dist-cjs/index.js:825:19)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async /Users/test/WebstormProjects/serverless-backend/node_modules/@smithy/middleware-serde/dist-cjs/index.js:36:20
at async /Users/test/WebstormProjects/serverless-backend/node_modules/drizzle-kit/bin.cjs:62642:22
at async /Users/test/WebstormProjects/serverless-backend/node_modules/drizzle-kit/bin.cjs:62400:42
at async /Users/test/WebstormProjects/serverless-backend/node_modules/drizzle-kit/bin.cjs:56216:26
at async AwsDataApiPreparedQuery.values (/Users/test/WebstormProjects/serverless-backend/node_modules/src/aws-data-api/pg/session.ts:111:18)
at async AwsDataApiPreparedQuery.execute (/Users/test/WebstormProjects/serverless-backend/node_modules/src/aws-data-api/pg/session.ts:61:18)
at async AwsDataApiPreparedQuery.all (/Users/test/WebstormProjects/serverless-backend/node_modules/src/aws-data-api/pg/session.ts:94:18) {
'$fault': 'client',
'$metadata': {
httpStatusCode: 400,
requestId: '7570b007-6f43-4c19-92fb-924ad9c11e79',
extendedRequestId: undefined,
cfId: undefined,
attempts: 1,
totalRetryDelay: 0
}
}
```

We cannot test if this is fixed in newer versions of drizzle because we cannot update because of the issue mentioned in https://github.com/drizzle-team/drizzle-orm/issues/2982

Kind regards,
Sev

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.