Releases: knex/knex
Releases · knex/knex
2.1.0
2.1.0 - 26 May, 2022
New features:
- Improve bundling experience to safely import dialects while using static paths #5142
- Implement extendable builders #5041
- PostgreSQL: Refresh materialized view concurrently #5166
Bug fixes:
- Use correct paths in package.json browser field #5174
- MariaDB: Fix 'NULL' returned instead of NULL on MariaDB 10.2.6+ #5181
- MySQL: fix hasColumn Error (hasColumn ('a_id') is true, but hasColumn('a_Id') is false) #5148
- MSSQL: Fix .hasTable result when using .withSchema #5176
- Oracle: correctly INSERTS Buffer #4869
Typings:
- Update type definitions for pg connection #5139
2.0.0
1.0.7
1.0.5
1.0.4
1.0.4 - 13 March, 2022
New features:
- Add whereLike functions #5044
Bug fixes:
- Fix orWhereJsonPath clause #5022
- Subquery in on clause missing parenthesis #5049
- Rework Union Wrapping #5030
- Oracle: Fix batch inserts with DEFAULT values with OracleDB #2592 #5037
Typings:
Documentation:
- Website URL changed to https://knex.github.io/documentation/
1.0.3
1.0.3 - 11 February, 2022
Bug fixes:
- Fix error message for missing migration files #4937
- Add withMaterialized and withNotMaterialized to method-constants #5009
- PostgreSQL: Fix whereJsonPath queries #5011
- PostgreSQL: Fix delete joins #5016
- CockroachDB: Fix whereJsonPath queries #5011
- MySQL: Create primary keys in same statement #5017
Typings:
- Fix type definition for getMigration in MigrationSource #4998
- Fix argument type of alter method #4996
Improvements:
- Use async / await syntax in seeds as default #5005
Documentation:
- Add Firebird dialect to ECOSYSTEM.md #5003
1.0.2 - 02 February, 2022
New features:
- Support of MATERIALIZED and NOT MATERIALIZED with WITH/CTE #4940
- Add raw support in onConflict clause #4960
- Alter nullable constraint when alterNullable is set to true #4730
- Add alterType parameter for alter function #4967
- Support string json in json values #4988
- MySQL: add with clause #4508
Bug fixes:
- Fix error message for missing migration files #4937
- Move deferrable to after on update/on delete #4976
- Do not use sys.tables to find if a table exists #2328
- PostgreSQL: Fix Order nulls #4989
- MySQL: Fix collation when renaming column #2666
- SQLite: Same boolean handling in better-sqlite3 as in sqlite3 #4982
Typings:
- WhereILike - fix typo #4941
1.0.1
1.0.0
Breaking changes
- Dropped support for Node 10;
- Replaced unsupported
sqlite3
driver with@vscode/sqlite3
; - Changed data structure from
RETURNING
operation to be consistent withSELECT
; - Changed Migrator to return list of migrations as objects consistently.
New features:
- Support fromRaw #4781
- Support zero precision in timestamp/datetime #4784
- Support whereLike and whereILike #4779
- Add JSDoc (TS flavor) to stub files #4809
- Allow skip binding in limit and offset #4811
- Support creating a new table in the database based on another table #4821
- Accept Raw on onIn joins #4830
- Implement support for custom seed sources #4842
- Add binary uuid option #4836
- ForUpdate array parameter #4882
- Add camel case to timestamps method #4803
- Advanced JSON support #4859
- Add type to TypeScript knexfile #4909
- Checks Constraints Support #4874
- Support creating multiple PKs with increments #4903
- Enable wrapIdentifier for SQLite .hasTable #4915
- MSSQL: Add support for unique constraint #4887
- SQLite: New dialect, using better-sqlite3 driver #4871
- SQLite: Switch to @vscode/sqlite3 #4866
- SQLite: Support createViewOrReplace #4856
- SQLite: Support RETURNING statements for better-sqlite3 driver #4934
- PostgreSQL: Support JOIN and USING syntax for Delete Statement #4800
Bug fixes:
- Fix overzealous warning on use of whereNot with "in" or "between" #4780
- Fix Union all + first syntax error #4799
- Make view columns optional in create view like #4829
- Insert lock row fix during migration #4865
- Fix for createViewOrReplace #4856
- SQLite: Fix foreign key constraints when altering a table #4189
- MySQL: Validate connection fix #4794
- MySQL: Set comment size warning limit to 1024 #4867
Typings:
0.95.14
0.95.12
0.95.12 - 28 October, 2021
New features:
- New dialect: CockroachDB #4742
- New dialect: pg-native #4327
- CockroachDB: add support for upsert #4767
- PostgreSQL: Support SELECT .. FOR NO KEY UPDATE / KEY SHARE row level locking clauses #4755
- PostgreSQL: Add support for 'CASCADE' in PostgreSQL 'DROP SCHEMA' queries #4713
- MySQL: Add storage engine index Type support to index() and unique() schema #4756
- MSSQL: Support table.primary, table.unique variant with options object #4710
- SQLite: Add setNullable support to SQLite #4684
- Add geometry column building #4776
- Add support for creating table copies #1373
- Implement support for views and materialized views #1626
- Implement partial index support #4768
- Support for 'is null' in 'order by' #3667
Bug fixes:
- Fix support for Oracle connections passed via knex.connection() #4757
- Avoid inserting multiple locks if a migration lock already exists #4694