Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG]: sqlite __drizzle_migrations id is of "SERIAL" type, which is not a valid type in sqlite #1227

Open
chlorophant opened this issue Sep 15, 2023 · 0 comments
Open

[BUG]: sqlite __drizzle_migrations id is of "SERIAL" type, which is not a valid type in sqlite #1227

chlorophant opened this issue Sep 15, 2023 · 0 comments
Labels
bug Something isn't working db/sqlite drizzle/kit priority Will be worked on next

Comments

@chlorophant
Copy link

What version of drizzle-orm are you using?

0.28.6

What version of drizzle-kit are you using?

0.19.13

Describe the Bug

sqlite __drizzle_migrations id shows that it is of "SERIAL" type, which is not a valid type in sqlite

Some tools which introspect dbs such as atlasgo error due to this

Expected behavior

The migrations table should use a valid sqlite data type

Environment & setup

No response
@chlorophant chlorophant added the bug Something isn't working label Sep 15, 2023
@L-Mario564 L-Mario564 added db/sqlite priority Will be worked on next labels Oct 16, 2024
@dengfuping dengfuping mentioned this issue Dec 9, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working db/sqlite drizzle/kit priority Will be worked on next
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@chlorophant @Angelelz @L-Mario564