View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001172 | Database Workbench v5 | Firebird Module | public | 2015-02-05 09:33 | 2015-02-20 18:49 |
| Reporter | Wolfgang Rohdewald | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | Firebird 2.5, I86 32, Virtualbox | OS | Windows | OS Version | Windows 7 Pro |
| Product Version | 5.0.8 | ||||
| Fixed in Version | 5.0.10 | ||||
| Summary | 0001172: Some defaults in the drop down list aren't quoted | ||||
| Description | Create a table with one field. From the menu for default value, select NOW. This creates wrong DDL: CREATE TABLE TST ( STAMP TIMESTAMP DEFAULT NOW ); that should be 'NOW'. I suppose the other time literals have the same problem. | ||||
| Tags | No tags attached. | ||||
|
|
Instead of NOW, use CURRENT_TIMESTAMP. Literals should be quoted by the user, I'll make sure the literal in the list has quotes around it, so when selecting it, you don't have to quote it yourself. |
|
|
- NOW - TODAY - YESTERDAY - TOMORROW |
|
|
'NOW' returns the current time, CURRENT_TIMESTAMP returns the time at transaction start. That is why I was changing from CURRENT_TIMESTAMP to 'NOW' |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-02-05 09:33 | Wolfgang Rohdewald | New Issue | |
| 2015-02-05 10:37 | Martijn Tonies | Note Added: 0000348 | |
| 2015-02-05 10:37 | Martijn Tonies | Status | new => closed |
| 2015-02-05 10:37 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2015-02-05 10:37 | Martijn Tonies | Resolution | open => won't fix |
| 2015-02-05 10:41 | Martijn Tonies | Note Added: 0000349 | |
| 2015-02-05 10:41 | Martijn Tonies | Status | closed => assigned |
| 2015-02-05 10:41 | Martijn Tonies | Resolution | won't fix => open |
| 2015-02-05 10:41 | Martijn Tonies | Summary | Table editor: wrong default values => Some defaults in the drop down list aren't quoted |
| 2015-02-05 10:42 | Martijn Tonies | Issue cloned: 0001173 | |
| 2015-02-05 10:48 | Wolfgang Rohdewald | Note Added: 0000350 | |
| 2015-02-05 10:59 | Martijn Tonies | Status | assigned => resolved |
| 2015-02-05 10:59 | Martijn Tonies | Fixed in Version | => 5.0.10 |
| 2015-02-05 10:59 | Martijn Tonies | Resolution | open => fixed |
| 2015-02-20 18:49 | Martijn Tonies | Status | resolved => closed |
