Bugs item #2906649, was opened at 2009-12-01 10:55 Message generated for change (Tracker Item Submitted) made by mr-meltdown 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: Open Resolution: None 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> ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2906649&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
