Issue Details (XML | Word | Printable)

Key: DERBY-3194
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Trivial Trivial
Assignee: Dag H. Wanvik
Reporter: Stan Bradbury
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

LOCALIZEDDISPLAY of CURRENT_TIMESTAMP returns only the TIME

Created: 09/Nov/07 06:39 PM   Updated: 24/Jan/08 11:06 PM
Return to search
Component/s: Localization, Tools
Affects Version/s: 10.3.1.4
Fix Version/s: 10.3.3.0, 10.4.1.3

Time Tracking:
Not Specified

File Attachments:
  Size
Text File Licensed for inclusion in ASF works DERBY-3194.diff 2007-11-16 12:47 AM Dag H. Wanvik 0.7 kB

Resolution Date: 19/Nov/07 06:26 PM


 Description  « Hide
In IJ - LOCALIZEDDISPLAY ON causes VALUES CURRENT_TIMESTAMP to display on the TIME

ij> values current_timestamp;
1
--------------------------
2007-11-09 10:37:58.828
1 row selected

ij> localizeddisplay on;
ij> values current_timestamp;
1
---------------
10:38:10 AM PST
1 row selected

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dag H. Wanvik made changes - 16/Nov/07 12:37 AM
Field Original Value New Value
Assignee Dag H. Wanvik [ dagw ]
Dag H. Wanvik added a comment - 16/Nov/07 12:47 AM
Preliminary patch which solves the problem.

The problem is that LocalizedResource#getTimestampAsString uses a time rather than a timestamp formatter.

Running regression tests.

Dag H. Wanvik made changes - 16/Nov/07 12:47 AM
Attachment DERBY-3194.diff [ 12369627 ]
Repository Revision Date User Message
ASF #596389 Mon Nov 19 18:24:55 UTC 2007 dag DERBY-3194 LOCALIZEDDISPLAY of CURRENT_TIMESTAMP returns only the TIME

Patch DERBY-3194.diff.

The problem is that LocalizedResource#getTimestampAsString uses a time
rather than a timestamp formatter.
Files Changed
MODIFY /db/derby/code/trunk/java/tools/org/apache/derby/iapi/tools/i18n/LocalizedResource.java

Dag H. Wanvik added a comment - 19/Nov/07 06:26 PM
Committed as svn 596389. Will port to 10.3 after some days, so
please don't close it yet.

Dag H. Wanvik made changes - 19/Nov/07 06:26 PM
Resolution Fixed [ 1 ]
Fix Version/s 10.4.0.0 [ 12312540 ]
Status Open [ 1 ] Resolved [ 5 ]
Repository Revision Date User Message
ASF #613948 Mon Jan 21 17:34:07 UTC 2008 dag DERBY-3194 LOCALIZEDDISPLAY of CURRENT_TIMESTAMP returns only the TIME

Merged DERBY-3194.diff from trunk as

svn merge -r596388:596389 https://svn.apache.org/repos/asf/db/derby/code/trunk

Tested manually in ij.
Files Changed
MODIFY /db/derby/code/branches/10.3/java/tools/org/apache/derby/iapi/tools/i18n/LocalizedResource.java

Dag H. Wanvik added a comment - 21/Jan/08 05:34 PM
Merged to 10.3 branch as svn 613948, closing.

Dag H. Wanvik added a comment - 21/Jan/08 05:35 PM
Can we close this on now, Stan?

Dag H. Wanvik made changes - 21/Jan/08 05:38 PM
Fix Version/s 10.3.2.2 [ 12312885 ]
Stan Bradbury added a comment - 24/Jan/08 11:06 PM
Catching up on Closing my reported issues. Thanks to Dyre for the workflow reminder today.

Stan Bradbury made changes - 24/Jan/08 11:06 PM
Status Resolved [ 5 ] Closed [ 6 ]