× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2012-12-07T01:20:48Z  · last modified 2012-12-10T18:38:12Z

File Options - Results Format - Greenplum - TIMESTAMP, INT4, MONEY format changes not seen in Query Grid Results


Dev
Fun Fun
funfun
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component App - Options
Version 13.0

 

Let me know if I am "jumping the gun" on reporting bugs for the Results Format, as I don't know if it's been worked on for the new databases.
 
Version: 13.0-dev-46
Build #: 30465
Build Date: 2012-Dec-06 09:02:41 AM
 
Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10
Memory: Max=891,092,992;  Total=322,568,192;  Free=84,590,368;  CPUs=8
 
Using a Greenplum connection, I couldn't get the Results Format to change the format of any of the results I could generate, including TIMESTAMP, INT4,  INT8, MONEY, DATE. There may be others, but my simple tables didn't have data to check.
 
 

1. ensure that your table has the TIMESTAMP datatype in a column.

2. ensure that your table is populated with TIMESTAMP data in that column.

3. execute a query on the table to generate results, and ensure the TIMESTAMP format is the default.

3. In File > Options > Results Formta > Greenplum  change the format of TIMESTAMP to yyyy.MM.dd G 'at' HH:mm:ss z

4. Right click on the table and choose "Script to New Window As ... > Select *"

5. execute the query. The results format for the TIMESTAMP datatype has not changed.

6. compare with PostgreSQL 8.2, the format changes following the change in Results Format Options.

 

See attached screenshots.

 

2 attachments

Issue #8039

Closed
Fixed
Resolved 2012-12-08T02:20:07Z
 
 
Completion
No due date
Fixed Build trunk/30528
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017