Bugs item #1774217, was opened at 2007-08-14 19:24 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1774217&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 2.18 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Colin Foss (cgfoss) Assigned to: Niels Nes (nielsnes) Summary: SQL: order by timestampz column with limit crash Initial Comment: Using Order by on a timestampz column and using limit NNN will crash MonetDB5, SQL 2.18. e.g. --------------------------------------- create table t1 ( tr_time timestamp(3) with time zone ) ; insert into t1 select * from ( select timestamp with time zone '2005-04-12 06:30-07:00' as tr_time union select timestamp with time zone '2005-04-12 07:30-07:00' as tr_time union select timestamp with time zone '2005-04-12 05:30-07:00' as tr_time union select timestamp with time zone '2005-04-12 05:35-07:00' as tr_time union select timestamp with time zone '2005-04-12 07:15-07:00' as tr_time ) as foo ; -- this will crash server select tr_time from t1 order by tr_time limit 3 ; --------------------------------------- Here is my environment (it would be nice to have a utility to gather everything needed): uname -a : Linux 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux g++ --version: 3.4.6 20060404 (Red Hat 3.4.6-8) autoconf --version: 2.59 automake --version: 1.9.2 libtool --version: 1.5.6 (1.1220.2.95 2004/04/11 05:50:42) last src compiled 2007/08/02 at 13:26 PDT. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2007-08-16 21:43 Message: Logged In: YES user_id=43556 Originator: NO Fixed in the m4/5 pqueue module. This didn't properly external types, ie > type_str. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1774217&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
