Bugs item #2906649, was opened at 2009-12-01 09:55 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2906649&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Fabian (mr-meltdown) Assigned to: Niels Nes (nielsnes) Summary: SQL: timestampz width reported to narrow Initial Comment: The server reports the width of a timestamp column to narrow: sql>select now(); +----------------------------+ | current_timestamp | +============================+ | 2009-12-01 | : 09:51:10.000000+00:00 : +----------------------------+ 1 tuple sql>\fraw sql>select now(); % . # table_name % current_timestamp # name % timestamptz # type % 26 # length [ 2009-12-01 09:52:06.000000+00:00 ] sql> 26 is indeed too narrow, causing mclient to wrap the column needlessly. The actual length is 32, it seems the timezone isn't counted. The following demonstrates that the length is just wrong for timestamp with time zone fields: sql>select cast(now() as timestamp with time zone); +----------------------------+ | current_timestamp | +============================+ | 2009-12-01 | : 09:55:00.000000+00:00 : +----------------------------+ 1 tuple sql>select cast(now() as timestamp); +----------------------------+ | current_timestamp | +============================+ | 2009-12-01 09:55:05.000000 | +----------------------------+ 1 tuple sql> ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2010-01-17 12:51 Message: fixed in stable. Info on timezone is now correctly passed to the export_length function. No test needed as the timestamp.sql test allready covers this ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2906649&group_id=56967 ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
