drizzle-team / drizzle-team/drizzle-orm

[BUG] [Kit] Field length for MySQL

Open
#3,038 8 comments 2 reactions 0 assignees View on GitHub
bug db/mariadb db/mysql priority
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

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

0.33.0

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

0.24.2

### Describe the Bug

I'm trying to migrate from skeema to drizzle and seem to be stuck on a few issues. This is one that I've not been able to find an existing issue for. When I try to push, I get dozens or more of these 'errors'
```
· You're about to change customersTotal column type from int(11) to int with 6381 items
· You're about to change emailResponsesMTD column type from int(11) to int with 6381 items
· You're about to change emailResponsesNinety column type from int(11) to int with 6381 items
· You're about to change emailResponsesOtherMTD column type from int(11) to int with 6381 items
· You're about to change emailResponsesOtherNinety column type from int(11) to int with 6381 items
· You're about to change emailTotal column type from int(11) to int with 6381 items
· You're about to change inspectionResponsesMTD column type from int(11) to int with 6381 items
· You're about to change inspectionResponsesNinety column type from int(11) to int with 6381 items
· You're about to change inspectionResponsesOtherMTD column type from int(11) to int with 6381 items
· You're about to change inspectionResponsesOtherNinety column type from int(11) to int with 6381 items
```

Honestly, I don't care at all what the length of the fields are, but at least with (mariadb) mysql, field length seems to be required and returned when kit checks the schema.

### Expected behavior

When I don't specify the length in my `schema.ts` file, I wouldn't expect it to care about what the database field length is returning.

### Environment & setup

_No response_

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.