●Change8

v1.0.0-beta.3

Breaking Changes
📦 drizzle-orm
⚠ 1 breaking✨ 1 features🐛 8 fixes🔧 6 symbols

Summary

This release introduces a mandatory MSSQL snapshot upgrade to version 2 to support SQL expressions in indexes, adds unique constraint support for MySQL index hints, and resolves several critical migration and introspection bugs.

⚠️ Breaking Changes

  • MSSQL snapshot upgraded to version 2. The 'indexes.columns' field format was updated to support sql expressions in index definitions. Users must upgrade their current snapshot when prompted by Drizzle Kit during the next migration generation.

Migration Steps

  1. For MSSQL users: Run 'drizzle-kit generate' and follow the CLI prompt to upgrade the current snapshot to version 2.

✨ New Features

  • MySQL use/force/ignore index now accepts unique constraints.

🐛 Bug Fixes

  • Fixed truncated tables on ALTER COLUMN statements.
  • Fixed incorrect SQL migration generation for policy permission string changes.
  • Fixed PG _text type introspection where it was not recognized as an array.
  • Fixed drizzle-kit pull failure when database includes views not present in 'tablesFilter'.
  • Fixed missing 'type' keyword prefix for AnySQLiteColumn in generated schemas.
  • Fixed drizzle-kit generate failure with 'undefined' is not valid JSON error.
  • Fixed primary key migration failure when changing from one column to another.
  • Fixed operator precedence issues where = and IS NULL were disrespected when using eq and isNull.

🔧 Affected Symbols

index().on()indexes.columnsAnySQLiteColumneqisNulltablesFilter