generate migration on unchanged column every time #3561
Description
Issue type:
[ ] question
[x] bug report
[ ] feature request
[ ] documentation issue
Database system/driver:
[ ] cordova
[ ] mongodb
[ ] mssql
[x] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo
TypeORM version:
[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)
Steps to reproduce or a small repository showing the problem:
// user.entity.ts
@Column({
default: () => 'CURRENT_TIMESTAMP',
})
lastChangedAt: Date;// 1549098402796-Init.ts
export class Init1549098402796 implements MigrationInterface {
public async up(queryRunner: QueryRunner): Promise<any> {
await queryRunner.query("ALTER TABLE `user` CHANGE `lastChangedAt` `lastChangedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP");
}
public async down(queryRunner: QueryRunner): Promise<any> {
await queryRunner.query("ALTER TABLE `user` CHANGE `lastChangedAt` `lastChangedAt` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP");
}
}-- database dump DDL
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`isEnabled` tinyint(4) NOT NULL DEFAULT '1',
`lastChangedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `IDX_78a916df40e02a9deb1c4b75ed` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci