typeorm

Bug Fixes

• add deprecated WhereExpression alias for WhereExpressionBuilder (#7980) (76e7ed9)
• always generate migrations with template string literals (#7971) (e9c2af6)
• use js rather than ts in all browser package manifests (#7982) (0d90bcd)
• use nvarchar/ntext during transit for SQLServer queries (#7933) (62d7976)

Features

• add postgres connection option applicationName (#7989) (d365acc)

Bug Fixes

• entity to be Partial<Entity> | undefined in UpdateEvent (#7783) (f033045)
• actually return a working ReadStream from SQL Server query runner (#7893) (e80985f)
• added version check before dropping materialized views to keep backward compatibility (#7716) (29f1f86)
• allow for string id in mongo.findByIds call (#7838) (4b45ae1)
• better support of relation-based properties in where clauses (#7805) (3221c50)
• Buffer in primary columns causes bugs with relations (#7952) (37e08a7), closes #4060
• capacitor does not correctly set journal mode (#7873) (5f20eb7)
• Capacitor driver PRAGMA requests failing on Android (#7728) (9620a26)
• condition is optional in SelectQueryBuilder joins (#7888) (2deaa0e)
• correctly handle mongo replica set driver option (#7908) (9212df4)
• correctly load yml in ConnectionOptionsYmlReader (#7743) (57f9254)
• craft oracle connectString as a descriptor with SID (#7878) (b05d093)
• delete operation in MongoDB impact all matched documents (#7811) (0fbae53), closes #7809
• Do not add NULL/NOT NULL for stored columns (#7708) (3c33e9f), closes #7698
• do OBJECT_ID lookup for column constraint instead of name in mssql (#7916) (fa8c1b0)
• drop pool.autostart from mssql options because it's unused (#7877) (0d21a4d)
• drop SAP statement after prepare per Hana client docs (#7748) (8ca05b1)
• eager relation respects children relations (#5685) (e7e887a)
• enable returning additional columns with MSSQL (#7864) (e1db48d)
• entity object undefined in afterUpdate subscriber (#7724) (d25304d)
• find operation in MongoDB do not include nullable values from documents (#7820) (98c13cf), closes #7760
• fix table loading when schemas are used (3a106a3)
• foreign keys in SAP were loading from the wrong table (#7914) (4777a79)
• handle postgres default when tableColumn.default is not string (#7816) (0463855)
• handle snake case of ABcD which should become a_bc_d (#7883) (eb680f9)
• improve query for MSSQL to fetch foreign keys and tables (#7935) (f6af01a)
• make OracleQueryRunner createDatabase if-not-exists not fail (f5a80ef)
• only pass data from SaveOptions during that query (#7886) (1de2e13)
• oracle cannot support DB in table identifiers (#7954) (8c60d91)
• pass table to namingstrategy when we can instead of table name (#7925) (140002d)
• prevent modification of the FindOptions.relations (#7887) (a2fcad6)
• prevent reuse of broken connections in postgres pool (#7792) (5cf368a)
• prevent transactions in the Cordova driver (#7771) (fc4133c)
• properly escape oracle table paths (#7917) (7e8687c)
• regression when making join conditions undefined-able (#7892) (b0c1cc6)
• restored buildColumnAlias for backward compatibility (#7706) (36ceefa)
• return correct DeleteResult and UpdateResult for mongo (#7884) (7a646a2)
• support fully qualified schema in createSchema (#7934) (94edd12)
• support table names between schemas in oracle (#7951) (aa45b93)
• typing so SelectQueryBuilder.getRawOne may return undefined (#7863) (36e5a0c), closes #7449
• typo prevented us from pulling the schema correctly in some cases (c7f2db8)
• update operation in MongoDB impact all matched documents (#7803) (052014c), closes #7788
• use correct query for cross-database mssql identity check (#7911) (7869fb1)
• use fully qualified and escaped table names for oracle (#7857) (2b90725), closes #7779
• use ObjectLiteral in UpdateEvent rather than Entity (#7910) (78fbc14)
• use only table name in constraint naming strategy (5dc777f)

Features

• add retryWrites to allowed mongo extra options (#7869) (dcdaaca)
• add capacitor driver options for encryption & version (#7868) (a2bd94b)
• add connection option entitySkipConstructor (f43d561)
• add ObjectLiteral typing to andWhere / orWhere (#7786) (525381d)
• add parseTableName to Driver interface (#7956) (cffbf43)
• add path, database, and schema to Table (#7913) (444e38b)
• add property for database and schema in views (#7953) (4c5bbd9)
• add referenced database & schema to TableForeignKey (fff6b11)
• add writeConcern option as a possible extras for mongodb (#7801) (90894c7)
• consistent parsing and escaping of table names in QueryRunners (bd9e767)
• implement OracleQueryRunner.hasDatabase (128b982)
• make parameter to getTables optional (#7901) (ba86602)
• make postgres extensions install optional (#7725) (92b96a5), closes #7662
• publicly export Transaction*Event types (#7949) (2436a66), closes /github.com/typeorm/typeorm/blob/master/src/subscriber/EntitySubscriberInterface.ts#L12
• set enableArithAbort for SQLServerDriver (#7894) (1f64da2)
• support absolute path in migration:generate (#7720) (b690c27)
• use char(36) for uuid representation in mysql (#7853) (063aafa)
• use column length from driver when creating columns (#7858) (b107ad9)

Bug Fixes

• restored buildColumnAlias for backward compatibility (#7706) (36ceefa)

Bug Fixes

• @Unique constraint is not created with specified name (beea2e1)
• MATERIALIZED VIEW is treated as a regular VIEW which causes issues on sync (#7592) (f85f436)
• added error handler for slave connections in MySQL and AuroraDataApi drivers (#7641) (882a740)
• call listeners for array embeddeds in MongoDB (#4260) (2dc355b)
• closing pool incorrectly works on Postgres (#7596) (1310c97), closes #6958 #6958 #6958
• column name with empty spaces causes bug in Index/Unique decorators #7534 (a3a6e06)
• correctly strip type conversion in postgres for default values (#7681) (069b8b6), closes #1532 #7647 #5132
• datetime functions in column "default" leads to unnecessary queries during synchronization (#7517) (03f3285), closes #3991 #3991 #2737 #2737 #6412 #4281 #4658 #3991 #2333 #7381 #4658 #3991 #3991 #3991 #3991
• default schema defined in entity/connection leads to unnecessary queries during schema sync (#7575) (7eb0327), closes #7276 #7276
• do a deep comparison to see if the default value has changed for json types in Postgres (#7650) (a471c1b)
• Incorrect migration generated when multiple views are updated in a single migration (#7587) (0b103dd), closes #7586
• issues with custom enum name in Postgres (#7661) (ad0262a), closes #7614 #7541 #7647 #6540
• mongodb connectionURL parse options (#7560) (b2ac41a)
• mongodb typings for Cursor (#7526) (daf3991)
• only first \0 is removed in comments, only first \ is escaped etc. (#7532) (36b14cb)
• pass ManyToMany onUpdate option to foreign key metadata (#5714) (198d2c5), closes #4980
• Postgres identifier exceeds limit on eager relations (#7508) (#7509) (e4ec429)
• remove enableExtension for slave connections in Postgres (#7693) (620aac9), closes #7691
• replaced deprecated insert method with insertOne for MongoDriver in MigrationExecutor. (#7594) (83fed60)
• resolve issue when enum that has functions is used in entity (#7653) (dba327d), closes #7651
• Silent failure in createDatabase and dropDatabase with Postgres (#7590) (974d2d4), closes #6867
• STI types on children in joins (#3160) (60a6c5d)
• use host if hostReplicaSet is not provided in MongoDriver (#7559) (9b6d7bc)
• use migrationsTransactionMode while running migration from cli (#7576) (7953ebb)
• use most specific matching relation type (#2967) (ee3c00a)

Features

• add orphanedRowAction option to EntitySchemaRelationOptions (#7625) (a8eb49a), closes #7417
• add set datatype support for aurora-data-api (#7665) (b6c1836)
• add support for specifying ioredis cache with a URL (#7689) (e017f9b), closes #7631
• add tree entities update and delete logic (#7156) (9c8a3fb), closes #7155
• added Capacitor driver (#7695) (0f7a778)
• cache option to ignore errors (#7630) (5fde0ea), closes #926
• define class properties for QueryFailedError to allow users to access a typed error (#7529) (b43dcba)
• support MAX_EXECUTION_TIME for MySQL driver. (#7638) (0564c34)

Bug Fixes

• aurora-data-api get correct increment primary key for multiple entities inserted (#7434) (fc8af5f), closes #7385
• aurora-data-api return number of affected rows in UpdatedResult and DeleteResult (#7433) (46aba1d), closes #7386
• RelationLoader load with existing queryRunner (#7471) (2dcb493), closes #5338
• Array type default value should not generate SQL commands without change (#7409) (7f06e44)
• correctly get referenceColumn value in getEntityValueMap (#7005) (7fe723b), closes #7002
• don't transform json(b) column value when computing update changes (#6929) (6be54d4)
• empty entity when query with nested relations (#7450) (9abf727), closes #7041 #7041 #7041
• fixed all known enum issues (#7419) (724d80b), closes #5371 #6471 #7217 #6047 #7283 #5871 #5729 #5478 #5882 #5275 #2233 #5648 #4897 #6376 #6115
• improve EntityManager.save() return type (#7391) (66fbfda)
• Only first single quote in comments is escaped (#7514) (e1e9423)
• performance issues of RelationId. (#7318) (01a215a), closes #5691
• rename a sequence related to generated primary key when a table is renamed (#5406) (25b457f)
• resolve issue building tree entities with embeded primary column (#7416) (dc81814), closes #7415
• wrong migration generation when column default value is set to null #6950 (#7356) (5a3f9ff)

Features

• add check and dry-run to migration generate (#7275) (d6df200), closes #3037 #6978
• add option for installing package using CLI (#6889) (3d876c6)
• Add support for Access Token Authentication for SQL Server Driver (mssql) (#7477) (e639772)
• added socketPath support for replicas in MySQL driver (#7459) (8d7afaf)
• allow to pass the given table name as string in RelationDecorators (#7448) (4dbb10e)
• implement "FOR UPDATE OF" for postgres driver (#7040) (fde9f07)
• introduced a new configuration option "formatOptions.castParameters" to delegate the prepare/hydrate parameters to the driver which will result in casting the parameters to their respective column type (#7483) (7793b3f)
• output Javascript Migrations instead of TypeScript (#7294) (b97cc4f)

Bug Fixes

• append condition to STI child entity join (#7339) (68bb82e)
• avoid regex lookbehind for compatibility (#7270) (063d27f), closes #7026
• cache from ENV - add ioredis support (#7332) (5e2117c)
• datetime2 rounding in mssql (#7264) (4711a71), closes #3202
• escape columns in InsertQueryBuilder.orUpdate (#6316) (ab56e07)
• incorrect postgres uuid type in PrimaryGeneratedColumnType (#7298) (2758502)
• MariaDB VIRTUAL + [NOT NULL|NULL] error (#7022) (82f2b75), closes #2691
• reject nullable primary key columns (#7001) (cdace6e)
• resolve issue with find with relations returns soft-deleted entities (#7296) (d7cb338), closes #6265
• save does not return id, save does not return generated (#7336) (01a6aee)

Features

• enable explicitly inserting IDENTITY values into mssql (#6199) (4abbd46), closes #2199
• export all errors (#7006) (56300d8)
• option to disable foreign keys creation (#7277) (cb17b95), closes #3120 #3120
• support maxdecimaldigits option by geometry type (#7166) (d749008)
• useUTC connection option for oracle and postgres (#7295) (e06a442)

BREAKING CHANGES

• passing ColumnOptions to @PrimaryColumn does not function anymore. One must use PrimaryColumnOptions instead.
• minor breaking change on "conflict*" options - column names used are now automatically escaped.

Bug Fixes

• add missing "comment" field to QB clone method (#7205) (f019771), closes #7203
• avoid early release of PostgresQueryRunner (#7109) (#7185) (9abe007)
• Error when sorting by an embedded entity while using join and skip/take (#7082) (d27dd2a), closes #7079
• Fix CLI query command TypeError (#7043) (b35397e)
• get length attribute of postgres array columns (#7239) (eb82f78), closes #6990
• handle overlapping property / database names in querybuilder (#7042) (b518fa1), closes #7030
• improve stack traces when using persist executor (#7218) (0dfe5b8)
• order should allow only model fields, not methods (#7188) (0194193), closes #7178
• resolve migration for UpdateDateColumn without ON UPDATE clause (#7057) (ddd8cbc), closes #6995
• resolves Postgres sequence identifier length error (#7115) (568ef35), closes #7106
• return 'null' (instead of 'undefined') on lazy relations that have no results (#7146) (#7147) (9b278c9)
• support MongoDB DNS seed list connection (#7136) (f730bb9), closes #3347 #3133
• data-api: Fixed how data api driver uses and reuses a client (#6869) (6ce65fb)
• use default import of yargs for --help (#6986) (6ef8ffe)

Features

• add NOWAIT and SKIP LOCKED lock support for MySQL (#7236) (9407507), closes #6530
• closure table custom naming (#7120) (bcd998b)
• JavaScript file migrations output (#7253) (ce9cb87)
• relations: Orphaned row action (#7105) (efc2837)

Bug Fixes

• allow falsey discriminator values (#6973) (f3ba242), closes #3891
• allow for complex jsonb primary key columns (#6834) (f95e9d8), closes #6833
• Allows valid non-object JSON to be retrieved in simple-json columns (#6574) (0aedf43), closes #5501
• Cannot read property 'hasMetadata' of undefined (#5659) (0280cdc), closes #3685
• check if the connection is closed before executing a query. This prevents SQLITE_MISUSE errors (https://sqlite.org/rescode.html#misuse) originating from sqlite itself (#6975) (5f6bbec)
• check mysql constraint schema on join (#6851) (d2b914d), closes #6169 #6169
• correct reading of custom ormconfig.env files (#6922) (a09fb7f)
• explicitly define query command's param (#6899) (4475d80), closes #6896
• findRoots should get the defined primary key column (#6982) (f2ba901), closes #6948 #6948
• Fix Mongodb delete by ObjectId. Closes #6552 (#6553) (e37eb1e)
• fixes the typescript errors in EntityCreateCommand & SubscriberCreateCommand (#6824) (0221a93)
• handle count multiple PK & edge cases more gracefully (#6870) (4abfb34), closes #5989 #5314 #4550
• Handle undefined querysets in QueryCommand (#6910) (6f285dc), closes #6612
• handle Undefined values in driver URL options (#6925) (6fa2df5)
• ILike operator generally available for any driver (#6945) (37f0d8f)
• Only check for discriminator conflicts on STI entities (#2985) (06903d1), closes #2984
• postgresql connection URL can use an UNIX Socket (#2614) (#6042) (21c4166)
• prevent create-type commands edge-case TypeErrors (#6836) (08ec0a8), closes #6831
• redundant migration with decimal default (#6879) (6ff67f7), closes #6140 #5407
• remove @DiscriminatorValue from error message (#5256) (2bf15ca), closes #5255
• resolves issue proto-less object validation (#6884) (e08d9c6), closes #2065
• return null for nullable RelationId() column (#6848) (7147a0d), closes #6815
• subscribers should use the subscribersDir (5ef9450)
• support changing comments in MySQL columns (#6903) (c5143aa)
• support combination of many-to-one/cacade/composte PK (#6417) (9a0497b)
• support empty IN clause across all dialects (#6887) (9635080), closes #4865 #2195
• support multiple row insert on oracle (#6927) (a5eb946), closes #2434
• sync the typeorm-model-shim (#6891) (c72e48b), closes #6288 #5920
• TreeRepository based entities primary column supports custom name. (#6942) (7ec1b75)
• use require in ReactNativeDriver (#6814) (1a6383c), closes #6811
• use correct type for MongoQueryRunner.databaseConnection (#6906) (da70b40), closes #6453
• use pg ^8 in init command (6ed9906)
• wrong FK loaded in multi-database environment (#6828) (c060f95), closes #6168

Features

• add ability for escaping for Raw() find operator (#6850) (91b85bf)
• add absolute path support to other CLI commands (#6807) (d9a76e9)
• Add SelectQueryBuilder.getOneOrFail() (#6885) (920e781), closes #6246
• backport ilike from next (#6862) (c8bf81e)
• Exit with code 1 on empty migration:generate (#6978) (8244ea1)
• schema synchronization for partitioned tables with PostgreSQL 12+ (#6780) (990442e)
• support autoEncryption option for MongoDB (#6865) (b22c27f)
• Support column comments in Postgres and CockroachDB (#6902) (bc623a4), closes #3360
• support ESM in ormconfig js & ts (#6853) (7ebca2b), closes #5003
• support query comments in the query builder (#6892) (84c18a9), closes #3643
• transactional events in subscriber interface + "transaction" option in FindOptions (#6996) (0e4b239)

Performance Improvements

• Improve MySQL LoadTables Performance (#6886) (0f0e0b6), closes #6800
• Improve replacePropertyNames (#4760) (d86671c)

Bug Fixes

• FindManyOptions order in parameter typing is important (51608ae)
• lock Typescript to 3.6.0 (#6810) (7f7e4d5), closes #6809 #6805

Bug Fixes

• add dummy for FileLogger, ConnectionOptionsReaders, and update gulpfile (#6763) (180fbd4)
• backport FindOperator return types (#6717) (2b37808)
• coerce port to number in ConnectionOptionsEnvReader (#6786) (55fbb69), closes #6781
• count() method for multiple primary keys for cockroachdb (#6745) (dfe8259)
• enforce name argument of migration generate command (#2719) (#6690) (dfcb2db), closes #4798 #4805 #4798 #4805
• ensure browser builds don't include any non-browser modules (#6743) (c714867), closes #6739
• hdb-pool is not namespaced under @sap (#6700) (9583430), closes #6697
• migration:generate issue with onUpdate using mariadb 10.4 (#6714) (6e28322)
• prevent multiple release listeners in PostgresQueryRunner (#6708) (208cf6b), closes #6699
• prevent wrong returned entity in ReturningResultsEntityUpdator (#6440) (c1c8e88)
• resolve issues ora-00972:identifier is too long (#6751) (b55a417), closes #5067 #5067
• sql.js v1.2+ don't support undefined parameters (#6698) (ea59b8d), closes #5720

Features

• add option to pass postgres server notices to client logger (#6215) (5084e47), closes #2216
• backport SQLite Busy handler & WAL mode enable (#6588) (7a52f18)
• Beautify generated SQL for migrations (#6685) (370442c), closes #4415
• create EntityTarget and use instead of EntitySchema / ObjectType / etc (#6701) (8b68f40)

Reverts

• Revert "fix: properly override database url properties (#6247)" (#6802) (45b980c), closes #6247 #6802

Bug Fixes

• @JoinTable does not respect inverseJoinColumns referenced column width (#6444) (f642a9e), closes #6442
• add missing schema for OracleDriver (#6673) (8b8bc35)
• change InsertQueryBuilder.values() with an empty array into a no-op (#6584) (9d2df28), closes #3111
• Child entities not being saved correctly with cascade actions (#6219) (16a2d80)
• correctly parse connection URI with query params (#6390) (54a3a15), closes #6389
• decorators should implement the official TypeScript interface (#6398) (c23c888), closes #5922
• DeepPartial with any and {[k: string]: any} (#6581) (8d90d40), closes #6580 #6580
• exporting missing load event (#6396) (c6336aa)
• get correct insert ids for multiple entities inserted (#6668) (ef2011d), closes #2131 #5973 #2131
• getPendingMigrations isn't properly working (#6372) (7c0da1c)
• handle 'error' events from pool connection (#6262) (ae3cf0e)
• insert IN(null) instead of IN() when In([]) empty array for mysqlDriver (#6237) (6f6bdbd)
• make only a single SELECT to get inserted default and generated values of multiple entities (#6669) (4fc4a1b), closes #6266 #6266
• Migration issues with scale & precision in sqlite/sql.js (#6638) (0397e44), closes #6636
• mysql migration: make sure the indices sql which left-join be the same database (#6426) (906d97f)
• pass ids_ to alias builder to prevent length overflow (#6624) (cf3ad62)
• pass formatOptions to Data API Client, fix extensions (#6404) (9abab82), closes #1
• Query builder makes query with joins, without limit for inherited entities (#6402) (874e573), closes #6399
• remove unnecessary optionality from Raw operator's columnAlias argument (#6321) (0d99b46)
• resolve missing decorators on shim (#6354) (8e2d97d), closes #6093
• revert fix handle URL objects as column field values (#6145) (e073e02)
• SqlQueryRunner.hasColumn was not working (#6146) (a595fed), closes #5718
• support multiple JoinColumns in EntitySchema (#6397) (298a3b9), closes #5444
• Unnecessary migrations for fulltext indices (#6634) (c81b405), closes #6633
• unnecessary migrations for unsigned numeric types (#6632) (7ddaf23), closes #2943 /github.com/typeorm/typeorm/pull/6632#pullrequestreview-480932808
• update query deep partial TypeScript definition (#6085) (23110d1)

Features

• add AWS configurationOptions to aurora-postgres connector (#6106) (203f51d)
• add better-sqlite3 driver (#6224) (2241451)
• add postgres connection timeout option (#6160) (0072149)
• FileLogger accepts custom file path (#6642) (c99ba40), closes #4410
• implement postgres ltree (#6480) (43a7386), closes #4193
• support absolute paths in migrationsDir for the CLI (#6660) (2b5f139)
• support cjs extension for ormconfig (#6285) (6eeb03a)

Bug Fixes

• 'in' clause case for ORACLE (#5345) (8977365)
• calling EntityManager.insert() with an empty array of entities (#5745) (f8c52f3), closes #5734 #5734 #5734
• columns with transformer should be normalized for update (#5700) (4ef6b65), closes #2703
• escape column comment in mysql driver (#6056) (5fc802d)
• expo sqlite driver disconnect() (#6027) (61d59ca)
• HANA - SSL options, column delta detection mechanism (#5938) (2fd0a8a)
• handle URL objects as column field values (#5771) (50a0641), closes #5762 #5762
• insert and update query builder to handle mssql geometry column correctly (#5947) (87cc6f4)
• migrations being generated for FK even if there are no changes (#5869) (416e419)
• multiple assignments to same column on UPDATE #2651 (#5598) (334e17e)
• prevent TypeError when calling bind function with sql.js 1.2.X (#5789) (c6cbddc)
• prototype pollution issue (#6096) (db9d0fa)
• provide a default empty array for parameters. (#5677) (9e8a8cf)
• redundant undefined parameters are not generated in migration files anymore (#5690) (d5cde49)
• replacing instanceof Array checks to Array.isArray because instanceof Array seems to be problematic on some platforms (#5606) (b99b4ad)
• respect database from connection urls (#5640) (ed75d59), closes #2096
• sha.js import (#5728) (8c3f48a)
• Unknown fields are stripped from WHERE clause (issue #3416) (#5603) (215f106)
• update dependency mkdirp to 1.x (#5748) (edeb561)
• update Entity decorator return type to ClassDecorator (#5776) (7d8a1ca)
• use an empty string enum as the type of a primary key column (#6063) (8e0d817), closes #3874
• use correct typings for the result of getUpsertedIds() (#5878) (2ab88c2)
• wrong table name parameter when not using default schema (#5801) (327144a)

Features

• add FOR NO KEY UPDATE lock mode for postgresql (#5971) (360122f)
• add name option to view column (#5962) (3cfcc50), closes #5708
• Add soft remove and recover methods to entity (#5854) (9d2b8e0)
• added support for NOWAIT & SKIP LOCKED in Postgres (#5927) (2c90e1c)
• Aurora Data API - Postgres Support (#5651) (e584297)
• aurora Data API - Support for AWS configuration options through aurora driver (#5754) (1829f96)
• create-column, update-column, version-column column kinds now support user specified values (#5867) (5a2eb30), closes #3271
• names of extra columns for specific tree types moved to NamingStrategy (#5737) (ec3be41)
• PG allow providing a function for password (#5673) (265d1ae)
• update cli migration up and down from any to void (#5630) (76e165d)
• UpdateResult returns affected rows in mysql (#5628) (17f2fff), closes #1308

Performance Improvements

• An optimized version of EntityMetadata#compareIds() for the common case (#5419) (a9bdb37)

Bug Fixes

• .synchronize() drops json column on mariadb (#5391) (e3c78c1), closes typeorm/typeorm#3636
• (base-entity) set create return type to T[] (#5400) (ceff897)
• add the enableArithAbort option to the sql server connection option typings (#5526) (d19dbc6)
• bug when default value in mssql were not updated if previous default was already set (9fc8329)
• change OrmUtils.mergeDeep to not merge RegExp objects (#5182) (0f51836), closes #3534
• fk on update should not use attributes of on delete (2baa934)
• load typeorm-aurora-data-api-driver correctly when using webpack (#4788) (#5302) (9da0d34)
• not to make typeorm generate alter query on geometry column when that column was not changed (#5525) (ee57557)
• Oracle sql expression for date column (#5305) (40e9d3a), closes #4452 #4452
• refactoring instance of with Array.isArray() (#5539) (1e1595e)
• Return NULL when normalize default null value (#5517) (1826b75), closes #5509
• SAP HANA driver fixes (#5445) (87b161f)
• update foreign keys when table name changes (#5482) (7157cb3)
• use OUTPUT INTO on SqlServer for returning columns (#5361) (6bac3ca), closes #5160 #5160
• use sha.js instead of crypto for hash calculation (#5270) (b380a7f)

Features

• Add basic support for custom cache providers (#5309) (6c6bde7)
• add fulltext parser option (#5380) (dd73395)

Bug Fixes

• use a prefix on SelectQueryBuilder internal parameters (#5178) (cacb08b), closes #5174 #5174

Features

• hash aliases to avoid conflicts (#5227) (edc8e6d)
• implement driver options for NativeScript (#5217) (3e58426)
• SAP Hana support (#5246) (ec90341)
• speed ​​up id search in buildChildrenEntityTree (#5202) (2e628c3)

BREAKING CHANGES

• aliases for very long relation names may be replaced with hashed strings. Fix: avoid collisions by using longest possible hash. Retain more entropy by not using only 8 characters of hashed aliases.

Bug Fixes

• allow expireAfterSeconds 0 in Index decorator (close #5004) (#5005) (d05467c)
• do not mutate connection options (#5078) (1047989)
• mysql driver query streaming (#5036) (aff2f56)
• remove consrc usage (postgres,cockroachdb) (#4333) (ce7cb16), closes #4332
• repo for app-root-path in lock file (#5052) (f0fd192)
• resolve MySQL unique index check when bigNumberStrings is false (#4822) (d205574), closes #2737
• resolve sorting bug for several mongo vesions with typeorm migration (#5121) (cb771a1), closes #5115
• throwing error on duplicate migration names #4701 (#4704) (3e4dc9f)
• unescaped column name in order clause of "migrations" (#5108) (c0c8566)
• upgrade app-root-path (#5023) (7f87f0c)

Features

• add distinct on() support for postgres (#4954) (1293065)
• add migrations transaction option to connection options (#5147) (fb60688), closes #4629 #4629
• asynchronous ormconfig support (#5048) (f9fdaee), closes #4149
• export Migration Execution API from main package (fixes #4880) (#4892) (8f4f908)
• support spatial types of MySQL 8+ (#4794) (231dadf), closes #3702

Bug Fixes

• ensure distinct property is respected cloning query builder (#4843) (ea17094), closes #4842
• aurora: apply mysql query fixes to aurora (#4779) (ee61c51)
• allow EntitySchema to be passed to EntityRepository (#4884) (652a20e)
• better timestamp comparison (#4769) (0a13e6a)
• broken database option when using replication, changes introduced by #4753 (#4826) (df5479b)
• check for version of MariaDB before extracting COLUMN_DEFAULT (#4783) (c30b485)
• connection Reuse is broken in a Lambda environment: (#4804) (7962036)
• FindOptionUtils export (#4746) (4a62b1c), closes #4745
• loading of aurora-data-api driver (#4765) (fbb8947)
• postgres: postgres query runner to create materialized view (#4877) (d744966)
• migrations run in reverse order for mongodb (#4702) (2f27581)
• mongodb Cursor.forEach types (#4759) (fccbe3e)
• Slack invite URL (#4836) (149af26)

Features

• add name to MigrationInterface (fixes #3933 and fixes #2549) (#4873) (4a73fde)
• add new transaction mode to wrap each migration in transaction (#4629) (848fb1f)
• add option to Column to specify the complete enumName (#4824) (d967180)
• add support for cube array for PostgreSQL (#4848) (154a441)
• implements Sqlite 'WITHOUT ROWID' table modifier (#4688) (c1342ad), closes #3330

Bug Fixes

• "database" option error in driver when use "url" option for connection (690e6f5)
• "hstore injection" & properly handle NULL, empty string, backslashes & quotes in hstore key/value pairs (#4720) (3abe5b9)
• add SaveOptions and RemoveOptions into ActiveRecord (#4318) (a6d7ba2)
• apostrophe in Postgres enum strings breaks query (#4631) (445c740)
• change PrimaryColumn decorator to clone passed options (#4571) (3cf470d), closes #4570
• createQueryBuilder relation remove works only if using ID (#2632) (#4734) (1d73a90)
• resolve issue with conversion string to simple-json (#4476) (d1594f5), closes #4440
• sqlite connections don't ignore the schema property (#4599) (d8f1c81)
• the excessive stack depth comparing types FindConditions<?> and FindConditions<?> problem (#4470) (7a0beed)
• views generating broken Migrations (#4726) (c52b3d2), closes #4123

Features

• add set datatype support for MySQL/MariaDB (#4538) (19e2179), closes #2779
• add materialized View support for Postgres (#4478) (dacac83), closes #4317 #3996
• add mongodb useUnifiedTopology config parameter (#4684) (92e4270)
• add multi-dimensional cube support for PostgreSQL (#4378) (b6d6278)
• add options to input init config for sql.js (#4560) (5c311ed)
• add postgres pool error handler (#4474) (a925be9)
• add referenced table metadata to NamingStrategy to resolve foreign key name (#4274) (0094f61), closes #3847 #1355
• add support for ON CONFLICT for cockroach (#4518) (db8074a), closes #4513
• Added support for DISTINCT queries (#4109) (39a8e34)
• Aurora Data API (#4375) (c321562)
• export additional schema builder classes (#4325) (e589fda)
• log files loaded from glob patterns (#4346) (e12479e), closes #4162
• UpdateResult returns affected rows in postgresql (#4432) (7808bba), closes #1308

Bug fixes

• fixed loadRelationCountAndMap when entities' primary keys are strings (#3946)
• fixed QueryExpressionMap not cloning all values correctly (#4156)
• fixed transform embeddeds with no columns but with nested embeddeds (mongodb) (#4131)
• fixed the getMany() result being droped randomly bug when using the buffer as primary key. (#4220)

Features

• adds typeorm migration:show command (#4173)
• deprecate column readonly option in favor of update and insert options (#4035)
• support sql.js v1.0 (#4104)
• added support for orUpdate in SQLlite (#4097)
• added support for dirty_read (NOLOCK) in SQLServer (#4133)
• extend afterLoad() subscriber interface to take LoadEvent (issue #4185)
• relation decorators (e.g. @OneToMany) now also accept string instead of typeFunction, which prevents circular dependency issues in the frontend/browser (issue #4190)
• added support for metadata reflection in typeorm-class-transformer-shim.js (issue #4219)
• added sqlJsConfig to input config when initializing sql.js (issue #4559)

Bug fixes

• fixed transform embeddeds with boolean values (mongodb) (#3900)
• fixed issue with schema inheritance in STI pattern (#3957)
• revert changes from #3814 (#3828)
• fix performance issue when inserting into raw tables with QueryBuilder (#3931)
• sqlite date hydration is susceptible to corruption (#3949)
• fixed mongodb uniques, support 3 ways to define uniques (#3986)
• fixed mongodb TTL index (#4044)

Features

• added deferrable options for foreign keys (postgres) (#2191)
• added View entity implementation (#1024). Read more at View entities
• added multiple value transformer support (#4007)

Bug fixes

• removed unused parameters from insert, update, delete methods (#3888)
• fixed: migration generator produces duplicated changes (#1960)
• fixed: unique constraint not created on embedded entity field (#3142)
• fixed: FK columns have wrong length when PrimaryGeneratedColumn('uuid') is used (#3604)
• fixed: column option unique sqlite error (#3803)
• fixed: 'uuid' in PrimaryGeneratedColumn causes Many-to-Many Relationship to Fail (#3151)
• fixed: sync enums on schema sync (#3694)
• fixed: changes in enum type is not reflected when generating migration (in definition file) (#3244)
• fixed: migration will keep create and drop indexes if index name is the same across tables (#3379)

Features

• added lock option in FindOptions

Bug fixes

• fixed bug in connection.dropDatabase method (#1414)
• fixed "deep relations" not loaded/mapped due to the built-in max length of Postgres (#3118)
• updated all dependencies
• fixed types issue from #3725
• removed sql-function-support (() => syntax) in parameters to prevent security considerations
• fix sync schema issue with postgres enum in case capital letters in entity name (#3536)

Features

• added uuidExtension option to Postgres connection options, which allows TypeORM to use the newer pgcrypto extension to generate UUIDs

Bug fixes

• fixed migration issue with postgres numeric enum type - change queries are not generated if enum is not modified (#3587)
• fixed mongodb entity listeners in optional embeddeds (#3450)
• fixes returning invalid delete result
• reverted lazy loading properties not enumerable feature to fix related bugs

Features

• added CockroachDB support
• added browser entry point to package.json (3583)
• replaced backend-only drivers by dummy driver in browser builds
• added useLocalForage option to Sql.js connection options, which enables asynchronous load and save operations of the datatbase from the indexedDB (#3554)
• added simple-enum column type (#1414)

Bug Fixes

• fixed undefined object id field in case property name is _id (3517)
• allow to use mongodb index options in Index decorator (#3592)
• fixed entity embeddeds indices in mongodb (#3585)
• fixed json/jsonb column data types comparison (#3496)
• fixed increment/decrement value of embedded entity (#3182)
• fixed missing call transformer.from() in case column is NULL (#3395)
• fixed signatures of update/insert methods, some find* methods in repositories, entity managers, BaseEntity and QueryBuilders
• handle embedded documents through multiple levels in mongodb (#3551)
• fixed hanging connections in mssql driver (#3327)

Features

• Injection 2nd parameter(options) of constructor to ioredis/cluster is now possible(#3538)

Bug Fixes

• fixed mongodb entity listeners and subscribers (#1527)
• fixed connection options builder - paramters parsed from url are assigned on top of options (#3442)
• fixed issue with logical operator precedence in QueryBuilder whereInIds (#2103)
• fixed missing isolationLevel in Connection.transaction() method (#3363)
• fixed broken findOne method with custom join column name
• fixed issue with uuid in mysql (#3374)
• fixed missing export of Exclusion decorator
• fixed ignored extra options in mongodb driver (#3403, #1741)
• fixed signature of root getRepository function to accept EntitySchema<Entity> (#3402)
• fixed false undefined connection options passed into mongodb client (#3366)
• fixed ER_DUP_FIELDNAME with simple find (#3350)

Features

• added tslib to reduce package size (#3457, #3458)
• queries are simplified in findByIds and whereInIds for simple entities with single primary key (#3431)
• added ioredis and ioredis-cluster cache support (#3289,#3364)
• added LessThanOrEqual and MoreThanOrEqual find options (#3373)
• improve support of string, numeric and heterogeneous enums in postgres and mysql (#3414)
• default value of enum array in postgres is now possible define as typescript array (#3414)

@Column({
    type: "enum",
    enum: StringEnum,
    array: true,
    default: [StringEnum.ADMIN]
})
stringEnums: StringEnum[];

Breaking changes

• UpdateQueryBuilder now throw error if update values are not provided or unknown property is passed into .set() method (#2849,#3324)

• hot fix for mysql schema sync bug

• allowed caching options from environment variable (#3321)
• more accurate type for postgres ssl parameters
• added support for ON UPDATE CASCADE relations for mysql
• repository.save returns union type
• added reuse of lazy relationships
• added ability to disable prefixes for embedded columns
• migrations can be tested
• migration run returns array of successful migrations
• added debug ENV option
• added support for postgres exclusion constraints
• bug fixes
• documentation updates
• fixed issue with mysql primary generated uuid ER_TOO_LONG_KEY (#1139)