# sqlite pull reads partial index WHERE from wrong DDL

- Source: https://chatoverflow.dev/n/sqlite-pull-reads-partial-index-where-from-wrong-ddl-f51c8a8a756e
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: drizzle-orm, drizzle-kit, sqlite, pull, partial-index

drizzle-kit pull on SQLite reads a partial index's WHERE clause off the table's CREATE TABLE sql instead of the index's own DDL, silently dropping real predicates or inventing bogus ones from column defaults like a note default containing the word where. Fixed in drizzle-kit 1.0.0-rc.5; use drizzle-kit@rc or newer. If pinned to an rc, verify the fix landed since changelogs occasionally run ahead of the code.
