All Versions
202
Latest Version
Avg Release Cycle
25 days
Latest Release
596 days ago

Changelog History
Page 10

  • v0.14.6 Changes

    April 12, 2018

    🐛 Bug fixes:

    • ⏪ Restored functionality of query event #2566 (#2549)

  • v0.14.5 Changes

    April 08, 2018

    🐛 Bug fixes:

    • 🛠 Fix wrapping returning column on oracledb #2554

    🆕 New Features:

    • 👌 Support passing DB schema name for migrations #2499 #2559
    • ➕ add clearOrder method #2360 #2553
    • ➕ Added knexTxId to query events and debug calls #2476
    • 👌 Support multi-column whereIn with query #1390
    • ➕ Added error if chaining update/insert/etc with first() #2506
    • Checks for an empty, undefined or null object on transacting #2494
    • countDistinct with multiple columns #2449

    ✅ Test / internal changes:

    • ➕ Added npm run test:oracledb command that runs oracledb tests in docker #2491
    • 🐳 Runnin mssql tests in docker #2496
    • ⚡️ Update dependencies #2561

  • v0.14.4 Changes

    February 19, 2018

    🐛 Bug fixes:

    • 🛠 containsUndefined only validate plain objects. Fixes #1898 (#2468)
    • ➕ Add warning when using .returning() in sqlite3. Fixes #1660 (#2471)
    • ⚡️ Throw an error if .update() results in an empty sql (#2472)
    • ✂ Removed unnecessary createTableIfNotExist and replaced with createTable (#2473)

    🆕 New Features:

    • 👍 Allow calling lock procedures (such as forUpdate) outside of transaction. Fixes #2403. (#2475)
    • ➕ Added test and documentation for Event 'start' (#2488)

    ✅ Test / internal changes:

    • ➕ Added stress test, which uses TCP proxy to simulate flaky connection #2460
    • ✂ Removed old docker tests, new stress test setup (#2474)
    • Removed unused property __cid on the base client (#2481)
    • 🔄 Changed rm to rimraf in 'npm run dev' (#2483)
    • 🔄 Changed babel preset and use latest node as target when running dev (#2484)

  • v0.14.3 Changes

    February 08, 2018

    🐛 Bug fixes:

    • 👉 Use tarn as pool instead of generic-pool which has been given various problems #2450
    • 🛠 Fixed mysql issue where add columns failed if using both after and collate #2432
    • 📜 CLI sets exit-code 1 if the command supplied was not parseable #2358
    • Set toNative() to be not enumerable #2388
    • 🛠 Use wrapIdentifier in columnInfo. fixes #2402 #2405
    • 🛠 Fixed a bug when using .returning (OUTPUT) in an update query with joins in MSSQL #2399
    • 👍 Better error message when running migrations fail before even starting run migrations #2373
    • Read oracle's UV_THREADPOOL_SIZE env variable correctly #2372
    • ➕ Added decimal variable precision / scale support #2353

    🆕 New Features:

    • ➕ Added queryContext to schema and query builders #2314
    • ➕ Added redshift dialect #2233
    • ➕ Added warning when one uses .createTableIfNotExist and deprecated it from docs #2458

    ✅ Test / internal changes:

    • ⚡️ Update dependencies and fix ESLint warnings accordingly #2433
    • ✅ Disable oracledb tests from non LTS nodes #2407
    • ⚡️ Update dependencies #2422

  • v0.14.2 Changes

    November 24, 2017

    🐛 Bug fixes:

    • 🛠 Fix sqlite3 truncate method to work again #2348

  • v0.14.1 Changes

    November 19, 2017

    🐛 Bug fixes:

    • 🛠 Fix support for multiple schema names in in postgres searchPath #2340
    • 🛠 Fix create new connection to pass errors to query instead of retry loop #2336
    • 🛠 Fix recognition of connections closed by server #2341

  • v0.14.0 Changes

    November 06, 2017

    💥 Breaking Changes:

    • ✂ Remove sorting of statements from update queries #2171
    • ⚡️ Updated allowed operator list with some missing operators and make all to lower case #2239
    • 👉 Use node-mssql 4.0.0 #2029
    • 👌 Support for enum columns to SQlite3 dialect #2055
    • 👍 Better identifier quoting in Sqlite3 #2087
    • Migration Errors - Display filename of of failed migration #2272

    Other Features:

    • Post processing hook for query result #2261
    • 🏗 Build native SQL where binding parameters are dialect specific #2237
    • 🔧 Configuration option to allow override identifier wrapping #2217
    • Implemented select syntax: select({ alias: 'column' }) #2227
    • 👍 Allows to filter seeds and migrations by extensions #2168
    • ✅ Reconnecting after database server disconnect/reconnect + tests #2017
    • ✂ Removed filering from allowed configuration settings of mysql2 #2040
    • 👍 Allow raw expressions in query builder aggregate methods #2257
    • Throw error on non-string table comment #2126
    • 👌 Support for mysql stream query options #2301

    🐛 Bug fixes:

    • 👍 Allow update queries and passing query builder to with statements #2298
    • 🛠 Fix escape table name in SQLite columnInfo call #2281
    • Preventing containsUndefined from going to recursion loop #1711
    • 🛠 Fix error caused by call to knex.migrate.currentVersion #2123
    • ⬆️ Upgraded generic-pool to 3.1.7 (did resolve some memory issues) #2208
    • 👍 Allow using NOT ILIKE operator #2195
    • 🛠 Fix postgres searchPath to be case-sensitive #2172
    • 🛠 Fix drop of multiple columns in sqlite3 #2107
    • 🛠 Fix adding multiple columns in Oracle #2115
    • 👉 Use selected schema when dropping indices in Postgres. #2105
    • 🛠 Fix hasTable for MySQL to not do partial matches #2097
    • 🛠 Fix setting autoTransaction in batchInsert #2113
    • 🛠 Fix connection error propagation when streaming #2199
    • 🛠 Fix comments not being applied to increments columns #2243
    • 🛠 Fix mssql wrong binding order of queries that combine a limit with select raw or update #2066
    • 🛠 Fixed mysql alter table attributes order #2062

    ✅ Test / internal changes:

    • ⚡️ Update each out-of-date dependency according to david-dm.org #2297
    • ⚡️ Update v8flags to version 3.0.0 #2288
    • ⚡️ Update interpret version #2283
    • 🛠 Fix debug output typo #2187
    • 👷 Docker CI tests #2164
    • ✅ Unit test for right/rightOuterJoin combination #2117
    • ✅ Unit test for fullOuterJoin #2118
    • ✅ Unit tests for table comment #2098
    • ✅ Test referencing non-existent column with sqlite3 #2104
    • ✅ Unit test for renaming column in postgresql #2099
    • ✅ Unit test for cross-join #2102
    • 🛠 Fix incorrect parameter name #2068

  • v0.13.0 Changes

    April 29, 2017

    💥 Breaking Changes:

    • Multiple concurrent migration runners blocks instead of throwing error when possible #1962
    • 🛠 Fixed transaction promise mutation issue #1991

    Other Changes:

    • 👍 Allow passing version of connected db in configuration file #1993
    • 🛠 Bugfixes on batchInsert and transactions for mysql/maria #1992
    • ➕ Add fetchAsString optional parameter to oracledb dialect #1998
    • 🛠 fix: escapeObject parameter order for Postgres dialect. #2003

  • v0.12.9 Changes

    March 23, 2017
    • 🛠 Fixed unhandled exception in batchInsert when the rows to be inserted resulted in duplicate key violation #1880

  • v0.12.8 Changes

    March 15, 2017
    • ➕ Added clearSelect and clearWhere to query builder #1912
    • Properly close Postgres query streams on error #1935
    • Transactions should never reject with undefined #1970
    • Clear acquireConnectionTimeout if an error occurs when acquiring a connection #1973