drizzle-team / drizzle-team/drizzle-orm

[BUG]: Expo SQLite migrations error when altering table

Open
#1,861 9 comments 0 reactions 0 assignees View on GitHub
bug db/sqlite driver/expo-sqlite 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.29.3

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

0.20.14

### Describe the Bug

Every time I try to alter the table, the migration fails with an unclear error message

![Screenshot 2024-02-04 at 22 38 56](https://github.com/drizzle-team/drizzle-orm/assets/46083126/0cf447ce-c735-49b0-9ed1-f4a27b3c888d)

### Expected behavior

The migration should work as expected without `DrizzleError`

I'm actually not sure if i'm missing any step, but based on the docs, for schema updates we only need to run `drizzle-kit generate`

### Environment & setup

i have created a repo to reproduce this issues

https://github.com/bryanltobing/expo-sqlite-drizzle-migration-alter-table-issues

How to reproduce:
- The working one is in the main branch
- checkout to [feat/add-description](https://github.com/bryanltobing/expo-sqlite-drizzle-migration-alter-table-issues/tree/feat/add-description) branch to reproduce the error encountered when running the new migration for altering the table.
- npx expo start <- to start the app

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.