mssql: Column is dropped and recreated in every migration #9399
Description
Issue Description
@column({ type: 'nvarchar', length: 'max' })
value: string;
this code leads to a recreation of the column for every migration.
Expected Behavior
no recreation of the column
Actual Behavior
-
This Code produces the wrong migration output. (Column is dropped an added)
@column({ type: 'nvarchar', length: 'max' })
value: string; -
This Code produces the correct output
@column({ type: 'nvarchar', length: 'MAX' })
value: string;
My Environment
| Dependency | Version |
|---|---|
| Operating System | windows |
| Node.js version | 16.16.0 |
| Typescript version | 4.7.2 |
| TypeORM version | 0.3.10 |
Additional Context
Relevant Database Driver(s)
| DB Type | Reproducible |
|---|---|
aurora-mysql |
no |
aurora-postgres |
no |
better-sqlite3 |
no |
cockroachdb |
no |
cordova |
no |
expo |
no |
mongodb |
no |
mysql |
no |
nativescript |
no |
oracle |
no |
postgres |
no |
react-native |
no |
sap |
no |
spanner |
no |
sqlite |
no |
sqlite-abstract |
no |
sqljs |
no |
sqlserver |
yes |
Are you willing to resolve this issue by submitting a Pull Request?
- ✖️ Yes, I have the time, and I know how to start.
- ✖️ Yes, I have the time, but I don't know how to start. I would need guidance.
- ✖️ No, I don’t have the time, but I can support (using donations) development.
- ✅ No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.