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 |