View Issue Details

IDProjectCategoryView StatusLast Update
0001172Database Workbench v5Firebird Modulepublic2015-02-20 18:49
ReporterWolfgang Rohdewald Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformFirebird 2.5, I86 32, VirtualboxOSWindowsOS VersionWindows 7 Pro
Product Version5.0.8 
Fixed in Version5.0.10 
Summary0001172: Some defaults in the drop down list aren't quoted
DescriptionCreate 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.
TagsNo tags attached.

Activities

Martijn Tonies

2015-02-05 10:37

administrator   ~0000348

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.

Martijn Tonies

2015-02-05 10:41

administrator   ~0000349

- NOW
- TODAY
- YESTERDAY
- TOMORROW

Wolfgang Rohdewald

2015-02-05 10:48

reporter   ~0000350

'NOW' returns the current time, CURRENT_TIMESTAMP returns the time at transaction start. That is why I was changing from CURRENT_TIMESTAMP to 'NOW'

Issue History

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