You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
drizzle-orm@~0.34.0 and drizzle-kit@~0.25.0 are the most recent versions that still work fine on my database, when I run orm-kit pull.
If I update the packages to the next available minor versions drizzle-orm@~0.35.0 and drizzle-kit@~0.26.0 or the latest currently available I end up with this error:
Pulling from ['public'] list of schemas
[⣷] 0 tables fetching
[⣷] 0 columns fetching
[⣷] 0 indexes fetching
[⣷] 0 foreign keys fetching
[⣷] 0 policies fetching
[⣷] 0 check constraints fetching
[⣷] 0 views fetching
SqliteError: no such column: "%3.3f" - should this be a string literal in single-quotes?
at Object.query (/Users/(...)/projects/drizzle-bug/node_modules/drizzle-kit/bin.cjs:79216:53)
at fromDatabase3 (/Users/(...)/projects/drizzle-bug/node_modules/drizzle-kit/bin.cjs:38587:32)
at introspectSqlite (/Users/(...)/projects/drizzle-bug/node_modules/drizzle-kit/bin.cjs:85132:9)
at async Object.handler (/Users/(...)/projects/drizzle-bug/node_modules/drizzle-kit/bin.cjs:92395:9)
at async run (/Users/(...)/projects/drizzle-bug/node_modules/drizzle-kit/bin.cjs:90501:7) {
code: 'SQLITE_ERROR'
}
SCRIPTS FOR REPRODUCING AND TESTING
Run yarn pull to reproduce the error. ❌
Run yarn downgrade to install an older versions of the packages and then yarn pull, the database will be introspected without errors. ✅
Run yarn downgrade:old to install an older version of the packages that still use the old config based on driver rather than dialect and run yarn pull:old to introspect successfully. ✅
Run yarn check-latest to install the latest versions of drizzle orm and kit and run a pull to see if the bug has been fixed in the latest version available. 🔍
WHAT I AM TRYING TO DO
The database contains raw data extracted from Microsoft Flight Simulator 2020 (airports, navigation data and so on..), that I use to run this website: https://msfs.breincorporation.com/.
Currently I manually extract the Airport table and shave off the colums I don't need, I was trying to automate this step with the help of drizzle.
The text was updated successfully, but these errors were encountered:
rainst
changed the title
[BUG]: drizzle-kit pull fails on an SQLite database
[BUG]: SQLite drizzle-kit pull fails since kit@~0.26.0 and orm@~0.35.0
Dec 20, 2024
rainst
changed the title
[BUG]: SQLite drizzle-kit pull fails since kit@~0.26.0 and orm@~0.35.0
[BUG]: SQLite - drizzle-kit pull fails in my project since kit >= 0.26.0 and orm >= 0.35.0
Dec 20, 2024
Report hasn't been filed before.
What version of
drizzle-orm
are you using?0.30.1
What version of
drizzle-kit
are you using?0.38.2
Other packages
better-sqlite3@11.7.0
Describe the Bug
I have uploaded a repository to make it easier to reproduce and test the issue: https://github.com/rainst/drizzle-bug
what follows is the README of that repo:
drizzle-orm@~0.34.0
anddrizzle-kit@~0.25.0
are the most recent versions that still work fine on my database, when I runorm-kit pull
.If I update the packages to the next available minor versions
drizzle-orm@~0.35.0
anddrizzle-kit@~0.26.0
or the latest currently available I end up with this error:SCRIPTS FOR REPRODUCING AND TESTING
Run
yarn pull
to reproduce the error. ❌Run
yarn downgrade
to install an older versions of the packages and thenyarn pull
, the database will be introspected without errors. ✅Run
yarn downgrade:old
to install an older version of the packages that still use the old config based on driver rather than dialect and runyarn pull:old
to introspect successfully. ✅Run
yarn check-latest
to install the latest versions of drizzle orm and kit and run a pull to see if the bug has been fixed in the latest version available. 🔍WHAT I AM TRYING TO DO
The database contains raw data extracted from Microsoft Flight Simulator 2020 (airports, navigation data and so on..), that I use to run this website: https://msfs.breincorporation.com/.
Currently I manually extract the Airport table and shave off the colums I don't need, I was trying to automate this step with the help of drizzle.
The text was updated successfully, but these errors were encountered: