Feature Requests item #1397758, was opened at 2006-01-05 14:03 Message generated for change (Settings changed) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1397758&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: None >Group: None Status: Open Priority: 3 Private: No Submitted By: Sjoerd Mullender (sjoerd) Assigned to: Niels Nes (nielsnes) Summary: SQL: no interval seconds precision in INTERVAL SECOND Initial Comment: In interval types, the most significant part has a leading precision, and if seconds are part of the interval, it also has a seconds precision (number of digits in the fraction). This means that an interval of just second can have both: INTERVAL SECOND(p,q) with p the interval leading precision and q the interval seconds precision. MonetDB/SQL only allows a single value here (presumably the leading precision, but I'm not sure about that). ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-11-22 22:18 Message: moving to feature requests. This requires that we move to 'decimal' types for intervals. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-17 10:58 Message: Related [ 1357338 ] SQL: EXTRACT returns wrong answer for SECOND https://sourceforge.net/tracker/index.php?func=detail&aid=1357338&group_id=56967&atid=482468 has been closed with "won't fix". What about this one? Also "won't fix"? Or should we rather turn both into a feature request? ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2007-01-17 18:45 Message: Logged In: YES user_id=1498628 Originator: NO Niels, WHy this bug is not closed? Regards, Romulo ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2006-01-15 09:57 Message: Logged In: YES user_id=963970 This is more like a feature request. It will at least not be included in the next release. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2006-01-05 14:14 Message: Logged In: YES user_id=963970 This bug seems to be related to bug #1357338. The SECONDS in an interval should be of double type to be able to represent fractions of seconds. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1397758&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
