View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000926 | Database Workbench v5 | Firebird Module | public | 2014-06-03 09:27 | 2015-05-11 12:25 |
| Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
| Priority | low | Severity | trivial | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.4.6 | ||||
| Fixed in Version | 5.1.0 | ||||
| Summary | 0000926: Error when adding two columns in the "Table editor" and reordering them | ||||
| Description | I added two columns in the table editor (or whatever it is called) and accidentally reordered them. When trying to save the DDL, I got an error due to a missing comma, the DDL DBW created and tried to execute was something like ALTER TABLE MyTable ADD NewColumn1 SmallInt, ADD NewColumn2 SmallInt ALTER NewColumn2 POSITION 7 , ALTER NewColumn2 POSITION 8 As you can see, DBW forgot a comma after adding the second column (SmallInt ALTER isn't valid syntax). | ||||
| Additional Information | Things work flawlessly if I only add one new column or if I add two columns but reorder existing columns rather than the new columns. | ||||
| Tags | No tags attached. | ||||
|
|
I meant of course to say NewColumn1 on the last line ALTER TABLE MyTable ADD NewColumn1 SmallInt, ADD NewColumn2 SmallInt ALTER NewColumn2 POSITION 7 , ALTER NewColumn1 POSITION 8 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-06-03 09:27 | Svein Erling Tysvær | New Issue | |
| 2014-06-03 09:33 | Svein Erling Tysvær | Note Added: 0000290 | |
| 2014-06-03 19:50 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2014-06-03 19:50 | Martijn Tonies | Status | new => confirmed |
| 2014-09-05 14:56 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
| 2015-03-11 16:16 | Martijn Tonies | Status | confirmed => assigned |
| 2015-03-11 16:21 | Martijn Tonies | Status | assigned => resolved |
| 2015-03-11 16:21 | Martijn Tonies | Fixed in Version | => 5.1.0 |
| 2015-03-11 16:21 | Martijn Tonies | Resolution | open => fixed |
| 2015-05-11 12:25 | Martijn Tonies | Status | resolved => closed |
