View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001505 | Database Comparer VCL | General | public | 2019-04-01 22:29 | 2019-04-18 19:44 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | reopened | ||
| Product Version | 7.0.0.1674 | ||||
| Target Version | 7.0.0.1674 | Fixed in Version | 7.0.0.1677 | ||
| Summary | 0001505: Table Column Not Null is not changed to Null for Firebird 3.0 | ||||
| Description | The comparer doesn't create a script for changing the table Column Not Null -> to Null for Firebird 3.0. The DBComparer.IBServerOptions.IBCompareOptions.AllowDataTypeConversion option doesn't take effect. | ||||
| Tags | No tags attached. | ||||
|
|
Wrong script syntax: The DBComparer produces the incorrect script: ALTER TABLE ... ALTER ... SET NULL; The valid script is: ALTER TABLE ... ALTER ... DROP NOT NULL; Firebird syntax says: ALTER TABLE t1 ALTER c1 { DROP | SET } [NOT] NULL; http://www.firebirdfaq.org/faq103/ |
|
|
fixed |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-04-01 22:29 | shirokov | New Issue | |
| 2019-04-01 22:29 | shirokov | Status | new => assigned |
| 2019-04-01 22:29 | shirokov | Assigned To | => barry |
| 2019-04-04 20:08 | barry | Status | assigned => resolved |
| 2019-04-04 20:08 | barry | Resolution | open => fixed |
| 2019-04-04 20:08 | barry | Fixed in Version | => 7.0.0.1677 |
| 2019-04-08 14:45 | shirokov | Status | resolved => feedback |
| 2019-04-08 14:45 | shirokov | Resolution | fixed => reopened |
| 2019-04-08 14:45 | shirokov | Note Added: 0004055 | |
| 2019-04-08 19:50 | barry | Note Added: 0004056 | |
| 2019-04-08 19:50 | barry | Status | feedback => resolved |
| 2019-04-18 19:44 | barry | Status | resolved => closed |
